OCP Backup & Recovery 2 — Questions and Answers
Question 1: Which RMAN command is used to validate a backup without actually restoring it?
- RESTORE DATABASE VALIDATE (Correct answer)
- VALIDATE BACKUPSET
- CROSSCHECK BACKUP
- RESTORE VALIDATE
Correct answer: RESTORE DATABASE VALIDATE
RESTORE DATABASE VALIDATE checks whether RMAN has the necessary backups to restore the database without actually writing any files.
Question 2: What happens to a tablespace that is taken offline with the NORMAL option before a backup?
- A checkpoint is issued and the tablespace needs no recovery when brought back online (Correct answer)
- The tablespace is dropped from the backup
- Oracle requires an immediate media recovery
- The tablespace datafiles are deleted from disk
Correct answer: A checkpoint is issued and the tablespace needs no recovery when brought back online
OFFLINE NORMAL forces a checkpoint so the datafiles are consistent and no recovery is required when the tablespace is brought back online.
Question 3: In RMAN, which retention policy setting ensures backups are kept until they are no longer needed to recover the database to any point in the last 7 days?
- CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS (Correct answer)
- CONFIGURE RETENTION POLICY TO REDUNDANCY 7
- CONFIGURE RETENTION POLICY TO WINDOW 7
- SET RETENTION POLICY DAYS=7
Correct answer: CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS
RECOVERY WINDOW OF N DAYS keeps backups needed to restore the database to any point within the last N days.
Question 4: Which view shows the status of RMAN backup jobs currently running?
- V$RMAN_STATUS
- V$BACKUP_JOB
- V$SESSION_LONGOPS (Correct answer)
- V$RMAN_JOBS
Correct answer: V$SESSION_LONGOPS
V$SESSION_LONGOPS tracks long-running operations including RMAN backup and restore jobs, showing estimated time remaining.
Question 5: What is the purpose of the RMAN CATALOG command when used with a recovery catalog?
- Registers an RMAN backup file not previously known to the catalog (Correct answer)
- Creates the recovery catalog schema
- Lists all backups stored in the catalog
- Drops old catalog records
Correct answer: Registers an RMAN backup file not previously known to the catalog
CATALOG registers backup files or copies with the recovery catalog so RMAN is aware of them for future restore operations.
Question 6: When using Data Recovery Advisor, which command displays a list of known failures in the database?
- LIST FAILURE (Correct answer)
- SHOW FAILURE
- REPORT FAILURE
- DESCRIBE FAILURE
Correct answer: LIST FAILURE
LIST FAILURE in RMAN displays all currently open failures detected by the Data Recovery Advisor.
Question 7: Which backup type copies only data blocks that have changed since the most recent backup of any type?
- Incremental cumulative
- Incremental differential (Correct answer)
- Full backup
- Archivelog backup
Correct answer: Incremental differential
An incremental differential backup captures only blocks changed since the most recent backup at any level, making it smaller but requiring more backups during restore.
OCP Backup & Recovery 2
Which RMAN command is used to validate a backup without actually restoring it?