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

Backup, Recovery & Data Guard 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 & Data Guard flashcards as text

  1. An Oracle database experiences a media failure on a non-critical tablespace while the database is open. What is the correct recovery sequence?

    Answer: Take tablespace offline, restore datafile, recover datafile, bring tablespace online

    For non-SYSTEM tablespaces, you can take only the affected tablespace offline, perform restore and recovery, then bring it back online without shutting down.

  2. What is the role of the MRP (Managed Recovery Process) on a physical standby database?

    Answer: Applies archived redo logs to the standby datafiles

    MRP (Media Recovery Process) reads standby redo logs and archived logs and applies them to the standby's datafiles to keep it synchronized.

  3. Which command registers a foreign archived log with RMAN after restoring it from another source?

    Answer: CATALOG ARCHIVELOG

    CATALOG ARCHIVELOG (or CATALOG START WITH for directories) adds existing archived log files to the RMAN repository.

  4. In Oracle Data Guard, what is a 'switchover' operation?

    Answer: Planned role transition where primary becomes standby and standby becomes primary

    A switchover is a planned, graceful role reversal between primary and standby with no data loss, unlike a failover which is unplanned.

  5. Which RMAN feature allows backing up directly to Oracle Cloud Object Storage?

    Answer: SBT (System Backup to Tape) channel with OCI library

    RMAN uses SBT (System Backup to Tape) channels configured with the Oracle Cloud Infrastructure library to stream backups to object storage.

  6. What happens to the online redo logs during an RMAN backup of a database in ARCHIVELOG mode?

    Answer: RMAN forces a log switch and archives current redo before backup

    RMAN issues an ALTER SYSTEM ARCHIVE LOG CURRENT to archive the current redo before taking the datafile backup, ensuring recovery completeness.

  7. Which Data Guard configuration parameter controls the maximum number of seconds the primary will wait for standby acknowledgment in SYNC mode before timing out?

    Answer: LOG_ARCHIVE_DEST_n NET_TIMEOUT

    The NET_TIMEOUT attribute on LOG_ARCHIVE_DEST_n defines how many seconds the LNSn process waits for a network acknowledgment before retrying.

How this page was made: written with AI tools and published by Nathan Beja, founder of Practice Test Geeks, who is responsible for its content. Exam facts are checked against the official sources listed below. Not reviewed by a subject-matter expert. Editorial policy

Sources & references

Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy

  1. oracle.com — Test dates, score release, retake policy · verified Oct 2026
  2. mylearn.oracle.com — Test delivery, exam format, passing score, time limit · verified Oct 2026