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.