OCP Backup & Recovery 3 — Questions and Answers
Question 1: What does the RMAN command CROSSCHECK BACKUP do?
- Verifies that backup files in the repository still exist on disk or tape (Correct answer)
- Validates the internal consistency of backup blocks
- Compares two backup sets for differences
- Removes expired backup records from the catalog
Correct answer: Verifies that backup files in the repository still exist on disk or tape
CROSSCHECK BACKUP reconciles the RMAN repository with actual backup files, marking missing files as EXPIRED.
Question 2: Which initialization parameter must be set to enable Oracle Managed Files (OMF) for archive logs?
- DB_RECOVERY_FILE_DEST (Correct answer)
- LOG_ARCHIVE_DEST_1
- ARCHIVE_LOG_DEST
- DB_FILE_DEST
Correct answer: DB_RECOVERY_FILE_DEST
DB_RECOVERY_FILE_DEST specifies the Fast Recovery Area location, which enables OMF-style management of archive logs and backups.
Question 3: During incomplete recovery, after restoring datafiles to an earlier SCN, which command finalizes the database and resets the redo log sequence?
- ALTER DATABASE OPEN RESETLOGS (Correct answer)
- ALTER DATABASE OPEN NORESETLOGS
- RECOVER DATABASE COMPLETE
- ALTER DATABASE ACTIVATE STANDBY
Correct answer: ALTER DATABASE OPEN RESETLOGS
OPEN RESETLOGS must be used after incomplete (point-in-time) recovery to reset the online redo log sequence and open the database.
Question 4: Which RMAN feature automatically determines the best set of backups to use for a restore operation?
- Backup optimization (Correct answer)
- Auto-selection algorithm
- Restore optimization
- Backup retention policy
Correct answer: Backup optimization
RMAN backup optimization skips backing up files when an identical, valid backup already exists, and auto-selects the optimal backup set during restore.
Question 5: A DBA needs to recover a dropped table without restoring the entire database. Which Oracle feature is most appropriate?
- Flashback Table
- Flashback Drop using Recycle Bin (Correct answer)
- RMAN table recovery
- Data Pump import
Correct answer: Flashback Drop using Recycle Bin
Flashback Drop recovers a dropped table from the Recycle Bin using FLASHBACK TABLE ... TO BEFORE DROP without restoring the database.
Question 6: Which parameter controls the maximum size of the Fast Recovery Area?
- DB_RECOVERY_FILE_DEST_SIZE (Correct answer)
- FRA_MAX_SIZE
- RECOVERY_AREA_SIZE
- DB_RECOVERY_DEST_SIZE
Correct answer: DB_RECOVERY_FILE_DEST_SIZE
DB_RECOVERY_FILE_DEST_SIZE sets the disk quota for the Fast Recovery Area in bytes.
Question 7: Which RMAN command removes backup records from the repository that no longer have corresponding physical files?
- DELETE EXPIRED BACKUP (Correct answer)
- CROSSCHECK BACKUP
- REMOVE EXPIRED BACKUP
- PURGE BACKUP
Correct answer: DELETE EXPIRED BACKUP
DELETE EXPIRED BACKUP removes repository records for backups already marked EXPIRED by a prior CROSSCHECK.
OCP Backup & Recovery 3
What does the RMAN command CROSSCHECK BACKUP do?