MAA Gold Backup Configuration with ZDLRA Backup Anywhere Replication and Backup and Redo Continuity

Configuration: Data Guard primary and standby databases configured to send backups and (optionally) redo to different Recovery Appliances that are configured for Backup Anywhere Replication, but with backups and redo only actually being sent by one of the databases to its respective Recovery Appliance, and with the primary and standby databases each configured with an alternate Recovery Appliance (backup and redo continuity)

Backups scheduled from primary database:


MAA Gold Backup Configuration with ZDLRA Backup Anywhere Replication and Backup and Redo Continuity - from primary

Backups scheduled from standby database:


MAA Gold Backup Configuration with ZDLRA Backup Anywhere Replication and Backup and Redo Continuity - from standby

MktingDB and MktingStby are the primary and standby RAC databases respectively in a Data Guard configuration, onboarded with a pair of Recovery Appliances Boston_ZDLRA and NY_ZDLRA using a replicating protection policy. Backup Anywhere replication is set up for this database's protection policy between Boston_ZDLRA and NY_ZDLRA. Configure these databases to back up to their respective Recovery Appliance using a common vpc user vpcuser1. A global named credential DB_SYSDBA_USER is specified for the databases and target-specific named credential specified for each host, DB_BOSHOST_CRED and DB_NYHOST_CRED. The -ship_redo_from_standby argument is not used, so redo shipping will be set up from the primary database MktingDB to its Recovery Appliance Boston_ZDLRA.

Since backup and recovery continuity is required, the input file also lists the alternate Recovery Appliances Concord_ZDLRA and Hudson_ZDLRA for the primary and standby databases, respectively. Backup Anywhere replication is set up for this database's protection policy between Boston_ZDLRA and Concord_ZDLRA and between NY_ZDLRA and Hudson_ZDLRA.

EMCLI Command:

emcli configure_db_ha
          -configureBackupToRA -backup_config="GOLD_WITH_REP" -input_file="target_list:
          /tmp/dblist" -br_continuity

The content of /tmp/dblist file:

target.0.target_name="MktingDB"
target.0.target_type="rac_database"
target.0.ra_target_name="Boston_ZDLRA"
target.0.ra_vpc_username="vpcuser1"
target.0.db_cred="DB_SYSDBA_USER"
target.0.db_host_cred="DB_BOSHOST_CRED"
target.0.alternate_ra.0.target_name="Concord_ZDLRA"
target.1.target_name="MktingStby"
target.1.target_type="rac_database"
target.1.ra_target_name="NY_ZDLRA"
target.1.ra_vpc_username="vpcuser1"
target.1.db_cred="DB_SYSDBA_USER"
target.1.db_host_cred="DB_NYHOST_CRED"
target.1.alternate_ra.0.target_name="Hudson_ZDLRA"