Which three types of backups taken in which situations may be used to perform restore operations to a logical standby database in a Data Guard environment?
A.
backups of data files taken on the primary database if connected to the recovery catalog where the logical standby database is registered
B.
backups of data files taken on the standby database if connected to the recovery catalog where the logical standby database is registered
C.
backups of control files taken on the primary database if connected to the recovery catalog where the logical standby database is registered
D.
backups of data files taken on the logical standby database, if not connected to a recovery catalog
E.
backups of control files taken on the logical standby database if not connected to a recovery catalog
Explanation:
An RMAN recovery catalog is required so that backups taken on one database server can be restored to another database server. It is not sufficient to use only the
control file as the RMAN repository because the primary database will have no knowledge of backups taken on the standby database.
Note: RMAN uses a recovery catalog to track filenames for all database files in a Data Guard environment. A recovery catalog is a database schema used by
RMAN to store metadata about one or more Oracle databases. The catalog also records where the online redo logs, standby redo logs, tempfiles, archived redo
logs, backup sets, and image copies are created.https://docs.oracle.com/database/121/SBYDB/rman.htm#SBYDB4853
BDE. Backups of primary datafiles canNOT be used to recover the LOGICAL standby.
B,D,E
agree, BDE
Of course B,D,E!
I think it is D, E, and (A)
B. backups of data files taken on the **standby database** if connected to the recovery catalog where the logical standby database is registered. Question is which standby. It could be some other standby not the same logical standby.
A. backups of data files taken on the primary database if connected to the recovery catalog where the logical standby database is registered. POSSIBLY RECREATE ENTIRE LOGICAL….
B, D and E agree!