Database backup Bash shell script for Oracle's Recovery Appliance (ZDLRA) & Reporting database refresh script
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
LICENSE
README.md
change_rman_config.rcv
check_tape.sql
clone_CSPRD.rcv
dbowner.sql
get_scn.sql
list_backup.rcv
refresh_rpt.bsh
run_backup.bsh
run_fbackup.rcv
run_ibackup.rcv
to_tape.bsh
to_tape_tierI.sql
to_tape_tierII.sql
zdlra.bsh
zdlra1.sql

README.md

Database backup Bash shell script for Oracle's Recovery Appliance (ZDLRA) & Reporting database refresh script

These scripts were tested in an Oracle PeopleSoft environment running Oracle RAC/ASM 12c on Solaris 11 (Oracle SuperCluster T5-8) and a ZDLRA X5 system.

Steps to implement:

Run zdlra.sql to add the protected database. From RMAN, register the database with the recovery appliance catalog. If the database will be backed up using an incremental level 1 strategy utilizing real-time redo, change the redo transport user to the virtual private catalog owner.

Run zdlra.bsh to update the RMAN configuration.

Replace the following references in the scripts with the appropriate values: <appliance admin> <passwd> <zdlra catalog database> <ra cluster SCAN> <virtual private catalog owner> <PeopleSoft database> <protection policy>

Create a clone_<PeopleSoft database>.rcv file for each database as per the clone_CSPRD.rcv example.

Run run_backup.bsh. The first parameter is the database instance. Specify tape as a second command line parameter to automatically schedule a Copy-To-Tape job once the backup completes.

Run refresh_rpt.bsh to refresh a reporting database. The first parameter is the database instance.