<<Back to Oracle DataGuard Main Page
How to Use RMAN Recovery Catalog in a Data Guard Configuration
If you decided to use recovery catalog, both databases must use the same recovery catalog.
You just need to register the current Primary database into recovery catalog and perform backup from either Primary (Site A) or Standby (Site B) while connecting to Recovery catalog. Resync the controlfile with catalog to make backup (taken at Site A ) available at Site B and vice-versa
That's said let us see how to do that and what RMAN configuration parameter we must use
Step1> Connect to rman catalog and primary database
rman target sys/xxxx@Primary_DB catalog rman/xxxx@CAT_DB
Step2> Register the database in Recovery catalog
RMAN> register database;
Step3> Configure Connect Identifier for Primary and Standby database
RMAN> configure db_unique_name ORCL1PP connect identifier 'ORCL1PP.oracle.com';
RMAN> configure db_unique_name ORCL1PS connect identifier 'ORCL1PS.oracle.com';
Step4> optionally you can specify deletion policy for archivelog
RMAN> configure archivelog deletion policy to applied on standby;
RMAN> configure archivelog deletion policy to applied on all standby;
RMAN> configure archivelog deletion policy to shipped on standby;
RMAN> configure archivelog deletion policy to shipped on all standby;
The commands above themselves explains what will they do. If I want not to delete the achivelog until it is applied at Standby database I will use below policy
RMAN> configure archivelog deletion policy to applied on standby;
Comments
Post a Comment