Practice Test Geeks(OCP) Oracle Certified Professional Practice Test
← All OCP Flashcard Decks

Backup & Recovery Flashcards

7 cards from real OCP practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.

Read the first 7 Backup & Recovery flashcards as text

  1. What is the primary advantage of using a recovery catalog over using the RMAN control file as the repository?

    Answer: The recovery catalog stores a longer backup history and supports scripting

    A recovery catalog retains a longer backup history (not limited by CONTROL_FILE_RECORD_KEEP_TIME) and supports stored RMAN scripts.

  2. Which RMAN command generates a report showing datafiles that have not been backed up within a specified number of days?

    Answer: REPORT NEED BACKUP DAYS

    REPORT NEED BACKUP DAYS n lists datafiles whose most recent backup is older than n days, helping identify gaps in backup coverage.

  3. During a restore operation, RMAN attempts to restore from the most recent backup first. What option forces RMAN to use a backup from a specific point in time?

    Answer: SET UNTIL TIME

    SET UNTIL TIME (or UNTIL SCN/SEQUENCE) in a RUN block instructs RMAN to choose backups valid up to that point for both RESTORE and RECOVER.

  4. Which background process is responsible for writing dirty buffers to datafiles and also signals the completion needed for a checkpoint?

    Answer: DBWR

    DBWR (Database Writer) writes modified buffers from the buffer cache to datafiles, and CKPT updates file headers to record checkpoint progress.

  5. What is the effect of setting RMAN's BACKUP OPTIMIZATION to ON?

    Answer: RMAN skips backing up files that already have an identical valid backup within the retention window

    With optimization ON, RMAN skips files (including archived logs) that have already been backed up and are still within the retention policy.

  6. Which command registers a new database with an existing RMAN recovery catalog?

    Answer: REGISTER DATABASE

    REGISTER DATABASE registers the target database's metadata (DBID, name) with the recovery catalog so RMAN can track its backups.

  7. In Oracle, which type of tablespace backup does NOT require the tablespace to be placed in backup mode when using RMAN?

    Answer: Any tablespace — RMAN never requires hot backup mode

    RMAN does not require BEGIN BACKUP / END BACKUP (hot backup mode) for any tablespace because it uses block-change tracking and split-block detection internally.