OCP Backup, Recovery & Data Guard 2

Question 1

Which RMAN command is used to validate a backup without actually restoring it?

Accepted Answer

RESTORE DATABASE VALIDATE

Answer

RESTORE DATABASE VALIDATE checks whether backups exist and are usable without writing any data files.

Question 2

In Data Guard, which log shipping mode guarantees zero data loss in the event of a primary failure?

Accepted Answer

SYNC

Answer

SYNC (synchronous) mode ensures every redo is hardened on the standby before the primary commits, guaranteeing zero data loss.

Question 3

What is the purpose of the RMAN CROSSCHECK command?

Accepted Answer

Compares RMAN catalog records against actual backup files

Answer

CROSSCHECK synchronizes the RMAN repository metadata with the actual state of backup files on disk or tape.

Question 4

A Data Guard standby database is in MOUNTED state. Which command activates it as a primary after a failover?

Accepted Answer

ALTER DATABASE ACTIVATE STANDBY DATABASE

Answer

ALTER DATABASE ACTIVATE STANDBY DATABASE converts the physical standby to a primary and opens it with RESETLOGS.

Question 5

Which RMAN retention policy ensures that backups needed to recover the database to any point in the last 7 days are retained?

Accepted Answer

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS

Answer

RECOVERY WINDOW OF n DAYS retains all backups necessary to perform point-in-time recovery within that window.

(OCP) Oracle Certified Professional Practice Test