These questions are based on 1Z0-045 – Oracle Database 10g DBA New Features for Oracle8i OCPs.
Objective: Backup and Recovery
Sub-Objective: Describe new RMAN reliability features. Block media recovery (BMR), Trial Recovery
Single Answer, Multiple Choice
You want to identify all backup files or copies that are outside the recovery window of two days.
Which RMAN command should you execute?
- REPORT OBSOLETE 2 DAYS;
- REPORT OBSOLETE SINCE 2 DAYS;
- REPORT OBSOLETE RECOVERY 2 DAYS;
- REPORT OBSOLETE RECOVERY WINDOW OF 2 DAYS;
D. REPORT OBSOLETE RECOVERY WINDOW OF 2 DAYS;
To identify all backup files or copies that are outside the recovery window of two days, use:
REPORT OBSOLETE RECOVERY WINDOW OF 2 DAYS;
When this command executes, RMAN will generate a report of all data file and archive log backups or file copies that are in a backup older than the recovery window specified.
All of the other options are syntactically incorrect and will generate errors when executed.
Obsolete files are different from expired files. RMAN only flags a backup as expired when it performs a cross-check and determines that a file is missing or not found. Obsolete files may remain intact but are simply too old to be used in recovery, based on your retention policy. Obsolete files remain until you issue the DELETE OBSOLETE command.
1. Oracle9i: New Features for Administrators – Backup and Recovery
2. Oracle9i: New Features Backup, Recovery, and Tuning TBT – Unit 1, Lesson 5, Topic 3: Backup and Restore Enhancements