Which two are true about the use of RMAN recovery catalogs when offloading backups to a physical standby database?
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
A,E
B is indeed incorrect
You can only register a target database with a DBID that is unique within the recovery catalog. Databases with the same name are permitted if the DBID values are different. The database that you are registering must not be a standby database.
oracle@primserver:~$ rman target=sys/oracle@stdby1 catalog=rman/cat@rcat
Recovery Manager: Release 11.2.0.4.0 – Production on Sat May 13 15:07:58 2017
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: PRIM (DBID=4196290583, not open)
connected to recovery catalog database
RMAN> register database;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of register command at 05/13/2017 15:08:02
RMAN-01005: Mounted control file type must be CURRENT to register the database
RMAN> exit
B & C are not working (see post from Wim J) and D is totally nonsense (far sync do affect redo transport, not backup), A & E are left and should be correct.
B, C, D are totally incorrect.
A is correct.
That leaves A, which I have not tested
That leaves E, which I have not tested
Hi did anyone here sit for this exam recently ? Please let me know if Q’s are still valid.
Correct Ans: A, E
Far sync has nothing to do in the RMAN backup/restore.
From 12c DG manual:
If physical standby database backups are to be usable for restore jobs at the primary site, you must be connected to the recovery catalog when backing up the standby database OR ***you must resynchronize the physical standby database shortly after the backup***. This step is necessary because there is no way for the primary database to know about the standby backups unless the backup records are stored in the recovery catalog.
Read “A” carefully, ** they may still be used ***, so if you resync the physical standby right after the RMAN backup then you can still recover the primary using physical standby backups.