Oracle Database 12c: RAC and Grid Infrastructure Administration — Question 30
Which two are true about the use of RMAN recovery catalogs when offloading backups to a physical standby database?
Answer options
- A. It backups that are offloaded to a physical standby database are taken when not connected to a recovery catalog, then they may still be used for restoration on the primary database.
- B. The physical standby database may be used to register the database in the recovery catalog, if the primary is not registered.
- C. The primary and physical standby databases must be registered separately in the recovery catalog, if a far sync instance is used to route redo to the physical standby database.
- D. It is not necessary to use a recovery catalog unless a far sync instance is used to route redo to the physical standby database.
- E. Primary and physical standby database may use different virtual recovery catalogs in the same physical recovery catalog.
Correct answer: D, E
Explanation
The correct answer is D, E because a recovery catalog is not mandatory unless a far sync instance is involved, which simplifies backup management. Additionally, D and E highlight that the databases can operate with separate virtual catalogs, allowing for flexibility, while A, B, and C provide incorrect conditions regarding registration and backup usability.