Simple RMAN Scripts For 9i RAC

This page displays some Simple RMAN Scripts For 9i RAC. Documentation about the RMAN utility may be found here: http://download-west.oracle.com/docs/cd/B10501_01/server.920/a97202/toc.htm I start the discussion by simply linking the first script below: rmanDB.sh Notice that the above script pulls in its environment variables from a file named /.BIKLE That file is linked below: .BIKLE A screen dump related to rmanDB.sh is displayed below: rmanDB.sh Screen Dump Notice that the above script only backs up the Database. I wrote another script to backup the archived redolog files: rmanArchlog.sh A screen dump related to rmanArchlog.sh is displayed below: rmanArchlog.sh Screen Dump One thing which sets a RAC database apart from a single instance database is that archived redolog files become created on more than one node. So, in order for me to back all the archived redologs for this particular configuration, I copied the script to the second node in the cluster and ran it (with no modifications at all). A second screen dump related to rmanArchlog.sh is displayed below: rmanArchlog.sh Screen Dump #2 Next, I ran a script to backup the control file. That script and a corresponding screen dump are displayed below: rmanCtl.sh rmanCtl.sh Screen Dump According to the documentation, I may backup the spfile. I did that; the script and a corresponding screen dump are displayed below: rmanSpfile.sh rmanSpfile-sd.txt Next, I put together a shell script which wrapped all of the above shell scripts. It is displayed below: rmanBIKLE.sh

Dan Bikle