OCP Backup, Recovery & Data Guard 3 — Questions and Answers
Question 1: Which Data Guard protection mode allows the primary to continue even if the standby is unavailable?
- Maximum Protection
- Maximum Availability
- Maximum Performance (Correct answer)
- Maximum Durability
Correct answer: Maximum Performance
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?
- Manual failover completed in under 30 seconds
- Automatic failover initiated by the observer without DBA intervention (Correct answer)
- Failover triggered by a pre-written shell script
- Switchover initiated from the standby site
Correct answer: Automatic failover initiated by the observer without DBA intervention
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?
- ALTER DATABASE OPEN
- ALTER DATABASE OPEN NORESETLOGS
- ALTER DATABASE OPEN RESETLOGS (Correct answer)
- ALTER DATABASE OPEN RECOVER
Correct answer: ALTER DATABASE OPEN RESETLOGS
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?
- LGWR
- ARCn
- LNSn (Correct answer)
- DMON
Correct answer: LNSn
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?
- Image copies are compressed; backupsets are not
- Image copies are exact byte-for-byte replicas of datafiles; backupsets are RMAN-proprietary format (Correct answer)
- Backupsets store data in the original OS format; image copies are compressed
- Image copies require a recovery catalog; backupsets do not
Correct answer: Image copies are exact byte-for-byte replicas of datafiles; backupsets are RMAN-proprietary format
An image copy is an exact duplicate of a datafile usable by Oracle directly, while a backupset is RMAN's proprietary multiplexed format.
Question 6: Which parameter in the standby redo log determines how many standby redo log groups are recommended?
- At least the same number as online redo logs
- One more group per thread than online redo logs (Correct answer)
- Twice the number of online redo logs
- Equal to the number of archive log destinations
Correct answer: One more group per thread than online redo logs
Oracle recommends having at least one more standby redo log group per thread than the number of online redo log groups on the primary.
Question 7: What does RMAN's BLOCK CHANGE TRACKING feature improve?
- Full backup performance by skipping read-only files
- Incremental backup performance by recording changed blocks since the last backup (Correct answer)
- Archive log generation speed
- CROSSCHECK performance across all backup sets
Correct answer: Incremental backup performance by recording changed blocks since the last backup
Block change tracking records which blocks have changed since the last backup in a tracking file, allowing incremental backups to skip unchanged blocks.
OCP Backup, Recovery & Data Guard 3
Which Data Guard protection mode allows the primary to continue even if the standby is unavailable?