Which three are true concerning restoring of RMAN backups to primary and physical standby databases in a Data Guard environment?
A.
Backups of data files taken on the primary database may be restored on a physical standby database.
B.
Backups of control files taken on the primary database may not be restored and used on a physical standby database.
C.
Backups of SPFILEs taken on a physical standby database may not be restored on the primary database.
D.
Backups of control files taken on a physical standby database may be restored on the primary database.
E.
Backups of data files taken on a physical standby database may be restored on a pnmary database.
F.
Backups of SPFILEs taken on the primary database may not be restored and used on a physical standby database.
A,D,E
agree, ADE
ADE
hmm… something is wrong, since i count 4 correct answers… but i think it’s a mistake of this site and the real test has only 3 correct answers.
Here my conclusions in detail:
A: correct its the default way of creating a standby database
B: incorrect you need a standby controlfile for the standby database
C: correct spfiles are different on each database (i.e. db_unique_name)
D: incorrect for a primary database you must restore a regular/primary controlfile (or do a failover afterwards)
E: correct its even recommended by oracle to save some resources on the primary
F: correct see C
I agree.
Actually, I don’t agree!!!
Correct: A, C, D, E ,F
Reference (Education Manual, 15-4):
“Backups of data files and archived redo logs are fully interchangeable”
“Backups of standby controlfiles and nonstandby controlfiles are interchangeable “
“SPFILE backups are not interchangeable”
“Primary and standby databases must use the same recovery catalog”
“It is not necessary register the standby database”
Reference: https://docs.oracle.com/database/121/SBYDB/rman.htm#SBYDB4848
I will go for A,D, E
A C D E
https://docs.oracle.com/database/121/SBYDB/rman.htm#SBYDB4848
A C D E F
Reference (Education Manual, 15-4):
Offloading Backups to a Physical Standby
• Backups of data files and archived redo logs are fully interchangeable.
• Backups of standby control files anI nonstandby control files are interchangeable.
• SPFILE backups are not interchangeable
• Primary and standby databases must use the same recovery catalog.
. It is not necessary to register the standby database.
https://docs.oracle.com/database/121/SBYDB/rman.htm#SBYDB4848
12.1.1 Interchangeability of Backups in an Oracle Data Guard Environment
RMAN commands use the recovery catalog metadata to behave transparently across different physical databases in the Oracle Data Guard environment. For example, you can back up a tablespace on a physical standby database and restore and recover it on the primary database. Similarly, you can back up a tablespace on a primary database and restore and recover it on a physical standby database.
Note: Backups of logical standby databases are not usable at the primary database.
Backups of standby control files and nonstandby control files are interchangeable. For example, you can restore a standby control file on a primary database and a primary control file on a physical standby database. This interchangeability means that you can offload control file backups to one database in an Oracle Data Guard environment. RMAN automatically updates the filenames for database files during restore and recovery at the databases.
C, F, E
Here is no mention of Recovery Catalog. You need to use Recovery catalog if you want to offload the backups to physical standby.
In 12c you can recover Primary from Standby datafile over the network thru RMAN so “E” seems to be correct.
I will go with A,C,E,F
Maybe C or F should have said “…may be restored…”