Configuring Upstream and Downstream Recovery Appliance
This task creates host specific files for backups, loads the scripts on their respective hosts, and verifies the credentials.
- On a host of the upstream Recovery Appliance, create the
backup_database_rahadr1.rman
text file with the following content.{ allocate channel rahadr1_sbt_1 device type sbt format '%d_%U' PARMS="SBT_LIBRARY=/u01/app/oracle/product/12.2.0.1/dbhome_1/lib/libra.so, ENV=(RA_WALLET='location=file:/u01/app/oracle/product/12.2.0.1/dbhome_1/dbs/zdlra credential_alias=dr_rahadr1')"; allocate channel rahadr1_sbt_2 device type sbt format '%d_%U' PARMS="SBT_LIBRARY=/u01/app/oracle/product/12.2.0.1/dbhome_1/lib/libra.so, ENV=(RA_WALLET='location=file:/u01/app/oracle/product/12.2.0.1/dbhome_1/dbs/zdlra credential_alias=dr_rahadr1')"; backup tag '&1' cumulative incremental level 1 filesperset 1 section size 64g database plus archivelog not backed up filesperset 32 delete input; }
- On a host of the downstream Recovery Appliance, create the
backup_database_rahadr2.rman
text file with the following content.{ allocate channel rahadr2_sbt_1 device type sbt format '%d_%U' PARMS="SBT_LIBRARY=/u01/app/oracle/product/12.2.0.1/dbhome_1/lib/libra.so, ENV=(RA_WALLET='location=file:/u01/app/oracle/product/12.2.0.1/dbhome_1/dbs/zdlra credential_alias=dr_rahadr2')"; allocate channel rahadr1_sbt_2 device type sbt format '%d_%U' PARMS="SBT_LIBRARY=/u01/app/oracle/product/12.2.0.1/dbhome_1/lib/libra.so, ENV=(RA_WALLET='location=file:/u01/app/oracle/product/12.2.0.1/dbhome_1/dbs/zdlra credential_alias=dr_rahadr2')"; backup tag '&1' cumulative incremental level 1 filesperset 1 section size 64g database plus archivelog not backed up filesperset 32 delete input; }
- Ensure the script on RAHADR1 does not exist by trying to delete it first. Then load the HADR1 script into the RAHADR1 Recovery Appliance.
$ rman target / catalog /@dr_rahadr1 RMAN> delete script backup_database; RMAN> create script backup_database from file '/home/oracle/backup_database_rahadr1.rman';
- Ensure the script on RAHADR2 does not exist by trying to delete it first. Then load the HADR2 script into the RAHADR2 Recovery Appliance.
$ rman target / catalog /@dr_rahadr2 RMAN> delete script backup_database; RMAN> create script backup_database from file '/home/oracle/backup_database_rahadr2.rman';
- Verify credentials have access to the database.
$ rman target / catalog /@dr_rahadr RMAN> print script backup_database; printing stored script: backup_database { allocate channel rahadr1_sbt_1 device type sbt format '%d_%U' PARMS="SBT_LIBRARY=/u01/app/oracle/product/12.2.0.1/dbhome_1/lib/libra.so, ENV=(RA_WALLET='location=file:/u01/app/oracle/product/12.2.0.1/dbhome_1/dbs/zdlra credential_alias=dr_rahadr1')"; allocate channel rahadr1_sbt_2 device type sbt format '%d_%U' PARMS="SBT_LIBRARY=/u01/app/oracle/product/12.2.0.1/dbhome_1/lib/libra.so, ENV=(RA_WALLET='location=file:/u01/app/oracle/product/12.2.0.1/dbhome_1/dbs/zdlra credential_alias=dr_rahadr1')"; backup tag '&1' cumulative incremental level 1 filesperset 1 section size 64g database plus archivelog not backed up filesperset 32 delete input; }