QUESTION 436
You want to make sure that your database backup does not exceed 10 hours in length. What command would you issue that would meet this condition?
A. backup database plus archivelog;
ivlog until time 10:00; B. backup database plus arch
C. backup database plus archivelog timeout 10:00; D. backup database plus archivelog duration 10:00; E. backup database plus archivelog timeout 10:00;
Answer: D Section: (none)
QUESTION 437
You have lost all your RMAN backup set pieces due to a disk failure. Unfortunately, you have an automated cross-check script that also does a delete expired backupset command. You have restored all the backup set pieces from tape. What command would you use to get those backup set pieces registered in the recovery catalog and the control file of the database again?
A. register database B. recover catalog C. load backupset D. synch metadata E. catalog start with
Answer: E Section: (none)
QUESTION 438
You run the following commands:
RMAN> list expired backup; RMAN> delete expired backup;
What will happen to the backup set pieces associated with the backups that appear in the list expired backup command?
A. They will be renamed.
B. Nothing will happen to them. The backup set pieces do not exist.
C. They will be deleted immediately since they are not in the flash recovery area.
D. You will need to manually remove the physical files listed in the output of the commands. E. They will become hidden files and removed 10 days later.
Answer: B Section: (none)
QUESTION 439
Why would you run the delete obsolete command? (Choose all that apply.)
A. To remove missing backup set pieces physically from disk
B. To remove metadata related to backup set pieces in the control file and the recovery catalog
C. To mark as deleted records in the control file and the recovery catalog associated with obsolete backup sets D. To delete backup set pieces associated with backups that are no longer needed due to retention criteria E. To remove old versions of RMAN backups
Answer: CD Section: (none)
QUESTION 440
What does it mean if a backup is expired?
A. The backup set has exceeded the retention criteria set in RMAN and is eligible for removal. B. The backup set has one or more invalid blocks in it and is not usable for recovery. C. The backup set contains one or more tablespaces no longer in the database. D. The backup set contains one or more missing backup set pieces.
E. The backup set is from a previous version of RMAN and was not upgraded.
Answer: D Section: (none)
QUESTION 441
If a backup set is expired, what can you do to correct the problem?
A. Change the retention criteria.
B. Make the lost backup set pieces available to RMAN again.
C. Run the crosscheck command to correct the location for the backup set piece contained in the metadata. D. Nothing. The backup set piece is lost forever. E. Call Oracle support, their assistance is required.
Answer: B Section: (none)
QUESTION 442
How long will this backup be allowed to run?
Backup as compressed backupset duration 2:00 minimize load database ;
A. 2 minutes B. 2 hours C. 2 days
D. The command will generate an error.
E. This backup is not constrained by any time limitation.
Answer: B Section: (none)
QUESTION 443
What is the impact of the following backup if it exceeds the duration allowance? (Choose all that apply.)Backup as compressed backupset duration 2:00 partial minimize load database ;
A. The entire backup will fail. It will not be usable for recovery.
B. The entire backup will fail, but any datafile successfully backed up will be usable for recovery. C. If this backup fails, subsequent backups will prioritize datafiles not backed up.
D. If this backup fails, an error will be raised and any other commands will not be executed. E. If this backup fails, no error will be raised and any other commands will be executed.
Answer: B Section: (none)
Explanation/Reference:
QUESTION 444
In what view are you likely to see the following output?
SID SERIAL# EVENT SECONDS_IN_WAIT 121 269 RMAN backup & recovery I/O 2
129 415 SQL*Net message from client 63 130 270 SQL*Net message from client
A. V$SESSION_EVENT B. V$SESSION C. V$WAITS D. V$WAITSTAT E. V$SYSSTAT
Answer: B Section: (none)
QUESTION 445
What view might you use to try to determine how long a particular backup will take?
A. V$SESSION_EVENT B. V$SESSION C. V$WAITS D. V$WAITSTAT
E. V$SESSION_LONGOPS
Answer: E Section: (none)
QUESTION 446
What is the impact of the results of the output of the following command?
RMAN> report unrecoverable database;
Report of files that need backup due to unrecoverable operations File Type of Backup Required Name
4 full or incremental C:\\ORACLE\\ORADATA\\ORCL\\USERS01.DBF
A. There are no backup sets with any backups of the users01.dbf datafile.
B. The users01.dbf datafile has had unrecoverable operations occur in it. It will need to be backed up
or some data loss is possible during a recovery.
C. The users01.dbf datafile is corrupted.
D. The users01.dbf datafile backup exceeds the retention criteria. E. The last backup of the users01.dbf datafile failed and must be rerun.
Answer: D Section: (none)
QUESTION 447
What does the output on this report indicate?
RMAN> report need backup;
RMAN retention policy will be applied to the command RMAN retention policy is set to redundancy 1 Report of files with less than 1 redundant backups File #bkps Name
5 0 C:\\ORACLE\\ORADATA\\ORCL\\MY_DATA_01.DBF
A. The my_data_01.dbf datafile is corrupted and needs to be restored.
B. The my_data_01.dbf datafile has not yet been backed up. This report does not imply that the data in the
datafile can not be recovered.
C. The my_data_01.dbf datafile has not yet been backed up. This report implies that the data in the datafile
can not be recovered.
D. The my_data_01.dbf datafile no longer meets the retention criteria for backups. E. Datafile 5 is missing.
Answer: B Section: (none)
Explanation/Reference:
QUESTION 448
What does the minimize load database parameter mean when backing up a database?
A. RMAN will attempt to make the backup run as fast as possible without any IO limitations. B. RMAN will automatically restrict the number of channels in use to one.
C. RMAN will spread the backup IO over the total duration stated in the backup command.
D. RMAN will skip any datafile that currently is involved in an IO operation. RMAN will retry backing up
the datafile later and an error will be raised at the end of the backup if the datafile cannot be backed up.