OCP Backup & Recovery 3

Question 1

What does the RMAN command CROSSCHECK BACKUP do?

Accepted Answer

Verifies that backup files in the repository still exist on disk or tape

Answer

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?

Accepted Answer

DB_RECOVERY_FILE_DEST

Answer

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?

Accepted Answer

ALTER DATABASE OPEN RESETLOGS

Answer

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?

Accepted Answer

Backup optimization

Answer

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?

Accepted Answer

Flashback Drop using Recycle Bin

Answer

Flashback Drop recovers a dropped table from the Recycle Bin using FLASHBACK TABLE ... TO BEFORE DROP without restoring the database.

(OCP) Oracle Certified Professional Practice Test

(OCP) Oracle Certified Professional Practice Test

OCP Backup & Recovery 3