1Z0-076 practice question 10 of 25

You are licensed to use Oracle Active Data Guard. Which TWO statements are true after enabling block change tracking on a physical standby database?

Answer options

A: It starts the RVWR process on the physical standby database instance. Correct answer

B: It starts the CTWR process on the primary database instance.

C: It allows fast incremental backups to be offloaded to a snapshot standby database, when the physical standby database is converted.

D: It starts the CTWR process on the physical standby database instance.

E: It allows fast incremental backups to be offloaded to the physical standby database. Correct answer

F: It allows fast incremental backups to be taken on the primary database.

Correct Answer:

A. It starts the RVWR process on the physical standby database instance.; E. It allows fast incremental backups to be offloaded to the physical standby database.

Explanation

Enabling block change tracking on a physical standby starts the Recovery Writer (RVWR) process, which records changed block information in the standby’s change-tracking file. This information lets RMAN perform fast incremental backups that can be completely off-loaded to the physical standby, preserving resources on the primary while still providing recoverable backups.

Why Incorrect

B – CTWR is started on the database where change tracking is enabled; enabling it on the standby does not start CTWR on the primary. C – Snapshot standby functionality is unrelated to block change tracking. D – The CTWR process is not used on a physical standby; RVWR maintains the bitmap. F – Primary database could already use its own change tracking; enabling it on the standby affects only the standby.

References

1. Oracle® Database 19c Backup and Recovery User’s Guide, “Block Change Tracking on Physical Standby Databases”, §5.8 (Doc-ID F30993-06).

2. Oracle® Database 19c Reference, “RVWR—Recovery Writer Process”, Background Processes Appendix.

3. Oracle® University Course “Oracle Database 19c: Backup and Recovery”, Lesson 6, slide 22.

Keep practicing

Take the free 1Z0-076 practice test

Ten exam-style questions with answers and explanations, plus the exam facts and study guides.

Start the free practice test