As we use RMAN to backup and restore the database in Simple scenarios. We can use it in Data Guard Environment same way.
Even we can use Physical Standby database backup to restore the Primary database and to recover the Primary database. But with some consideration as follow :
- The recovery catalog is required when using RMAN in a Data Guard configuration for physical standby databases.
- We can only use Physical Standby backup for the Primary database, But we can not use the Logical Standby Database for the Primary database.
According to Oracle MAA[Maximum Availability Architectute], best practices recommend that backup should be taken to Primary and Standby Database both side to
- Reduce Mean Time to Recover[MTTR].
- Handle outages at both sides
- Avoid introducing new site practices during switchover and failover
We have read offloading backup to Standby Database as the benefit of Data Guard many times.
Let us see how.
Database Backups and Archive logs backups taken at Physical standby Database are fully interchangeable at Primary Database. Means by just simply Restore Database command we can restore a backup taken by Physical Standby Database to Restore Primary Database.
Controlfile backups taken at Physical Standby Database is not interchangeable with a Primary database.
Recovery catalog should be used for Primary and Physical standby database and both databases must use the same recovery catalog.
It is not necessary to Register a Standby database. We can simply use a backup command to a backup database by connecting to a recovery catalog.
Restrictions and Usage Notes
- Recover catalog must be used for Physical Standby database backup If we are taking Physical Standby database backup to use it for Primary database and we must resynchronize physical standby database immediately after backup. As there is no other way for the primary database to know about Physical standby database backup unless backups are stored in the recovery catalog.
- We can not take non-RMAN backup of standby controlfile or image-copy backup of controlfile.
- While taking backup from physical standby database backup we must connect the physical standby database with RMAN target key work and not the auxiliary keyword.
In next article, we will see Using the RMAN Recovery Catalog in a Data Guard Configuration.
Stay tuned for More articles on Oracle DataGuard
Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Telegram Channel : https://t.me/helporacle
Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/
Joel Perez’s LinkedIn: Joel Perez’s Profile
LinkedIn Group: Oracle Cloud DBAAS
Facebook Page: OracleHelp