Backup & Recovery Flashcards

What does the RMAN command CROSSCHECK BACKUP do?

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.

Which initialization parameter must be set to enable Oracle Managed Files (OMF) for archive logs?

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.

During incomplete recovery, after restoring datafiles to an earlier SCN, which command finalizes the database and resets the redo log sequence?

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.

Which RMAN feature automatically determines the best set of backups to use for a restore operation?

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.

A DBA needs to recover a dropped table without restoring the entire database. Which Oracle feature is most appropriate?

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.

Which parameter controls the maximum size of the Fast Recovery Area?

Answer: DB_RECOVERY_FILE_DEST_SIZE

DB_RECOVERY_FILE_DEST_SIZE sets the disk quota for the Fast Recovery Area in bytes.

Which RMAN command removes backup records from the repository that no longer have corresponding physical files?

Answer: DELETE EXPIRED BACKUP

DELETE EXPIRED BACKUP removes repository records for backups already marked EXPIRED by a prior CROSSCHECK.