OCP Backup, Recovery & Data Guard 3

Question 1

Which Data Guard protection mode allows the primary to continue even if the standby is unavailable?

Accepted Answer

Maximum Performance

Answer

Maximum Performance allows the primary to continue operations even if no standby database is reachable, prioritizing availability over data protection.

Question 2

What is a 'fast-start failover' in Oracle Data Guard Broker?

Accepted Answer

Automatic failover initiated by the observer without DBA intervention

Answer

Fast-start failover (FSFO) uses an observer process to automatically promote a standby when the primary becomes unavailable, without DBA action.

Question 3

After an incomplete recovery, which command must be used to open the database?

Accepted Answer

ALTER DATABASE OPEN RESETLOGS

Answer

After incomplete recovery, RESETLOGS is mandatory to reset the log sequence and establish a new incarnation of the database.

Question 4

Which background process is responsible for shipping redo logs from primary to standby in Oracle Data Guard?

Accepted Answer

LNSn

Answer

The Log Network Service (LNSn) process on the primary reads and ships redo data to the Remote File Server (RFS) process on the standby.

Question 5

In RMAN, what is the difference between an IMAGE COPY and a BACKUPSET?

Accepted Answer

Image copies are exact byte-for-byte replicas of datafiles; backupsets are RMAN-proprietary format

Answer

An image copy is an exact duplicate of a datafile usable by Oracle directly, while a backupset is RMAN's proprietary multiplexed format.

(OCP) Oracle Certified Professional Practice Test

(OCP) Oracle Certified Professional Practice Test

OCP Backup, Recovery & Data Guard 3