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