Hello,
I have a little confusion about which kind of backup I can set on my Data Guard env for Oracle 12.2 and Physical standby.
I think on two options:
- Set backup on both side: Primary and Standby based on recommendation:
"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."
This option takes more storage, but we will have two backups so data will be more secure.
2. Set backup only on primary side
In case of restore, Restore will be primary side and based on primary will be created standby side.
This option is a minimum in backup policy for Data Guard environment and it can be enough.
What You recommend about backup policy for Data Guard with physical standby?
Best Regards,
Zaneta.