A. The data file backup is done with multiple channels
B. The data files is in the read-write mode after being backed up in the read only mode
C. The backup was taken after the data files was taken offline-normal or is in the read only mode
D. The data file backup complies with the back retention policy and the backup duplexing feature
第1题:
You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN). Identify two scenarios is which you must have a recovery catalog.()
A. To store the backup information of multiple database
B. To restrict the amount of space that is used by the backups
C. To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.
D. To list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.
第2题:
Examinethefollowingcommandusedtoperformincrementallevel0backup:RMAN>BACKUPINCREMENTALLEVEL0DATABASE;Toenabletheblockchangetracking,aftertheincrementallevel0backupyouissuedthefollowingcommand:SQL>ALTERDATABASEENABLEBLOCKCHANGETRACKINGUSINGFILE’/mydir/rman_change_track.f’;Toperformincrementallevel1cumulativebackup,youissuedthefollowingcommand:RMAN>BACKUPINCREMENTALLEVEL1CUMULATIVEDATABASE;Whichtwostatementsaretrueintheabovesituation?()
A.Theblockchangetrackingdatawillbeusedonlyfromthenextincremental0backup.
B.Theincrementalbackupwillusechangetrackingdataforaccomplishingthebackup.
C.Theincrementalbackupwillnotusechangetrackingdataforaccomplishingthebackup.
D.Theblocktrackfilewillscanalltheblocksandcreatebitmapforalltheblocksbackedupinthelevel0backup.
第3题:
A. Provide a password for the encryption
B. Set up an Oracle wallet for the encryption
C. No setup is required as it is a default encryption method
D. Both Oracle wallet and password must be set up for the encryption
第4题:
Examine the following command used to perform incremental level 0 backup:RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE;To enable the block change tracking, after the incremental level 0 backup you issued the following command:SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USINGFILE ‘/mydir/rman_change_track.f‘;To perform incremental level 1 cumulative backup, you issued the following command:RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;Which two statements are true in the above situation?()
A. The block change tracking data will be used only from the next incremental 0 backup.
B. The incremental backup will use change tracking data for accomplishing the backup.
C. The incremental backup will not use change tracking data for accomplishing the backup.
D. The block track file will scan all the blocks and create bitmap for all the blocks backed up in the level 0 backup.
第5题:
Whenrunningthetablespacepoint-in-timecommandrecovertablespaceusersuntiltime,,10/06/2008:22:42:00auxiliarydestination,,c:\oracle\auxiliary;youreceivethefollowingerror:RMAN-00571:===========================================================RMAN-00569:===============ERRORMESSAGESTACKFOLLOWS===============RMAN-00571:===========================================================RMAN-03002:failureofrecovercommandat10/08/200816:00:30RMAN-20202:TablespacenotfoundintherecoverycatalogRMAN-06019:couldnottranslatetablespacename"USERS"Whatisthelikelycauseoftheerror?()
A.ThedatabaseisinARCHIVELOGmode.
B.Thereisnotacurrentbackupofthedatabaseavailable.
C.TheUSERStablespacehasdependentobjectsinothertablespacesandcannotbeapartofaTSPITRalone.
D.TheUSERStablespaceisnoteligibleforTSPITRbecauseithasinvalidobjects.
E.Therecovertablespacecommandisincorrectandgeneratestheerror.
第6题:
A.ItisaSQLscript.
B.ItisaPL/SQLfile.
C.Itisanoperatingsystem(OS)file.
D.ItisaRecoveryManager(RMAN)script