Question: I have a HADR setup - Primary and Standby. Backup is always done on the primary database. However, because of a weid timing scenario that we have, we are wondering if there is a downside to taking a backup of the HADR STANDBY database and use this backup to restore to the primary if we run into a problem upgrading the PRIMARY?
Stated another way, we do not have time to do a backup on the primary when a upgrade project begins. At the very time we begin the upgrade, HADR is deactivated and the primary is immediately available for upgrade with no backup take. However, while the upgrade is going on the primary, we want to take a backup of the secondary (STANDBY) and potentially use this STANBY backup to restore the PRIMARY if something awry during upgrade.
Is there any downside to this plan?
Your thoughts, comments and experience in this matter will be highly appreciated.