Database Reference
In-Depth Information
CONFIGURE MAXSETSIZE clear;
CONFIGURE ENCRYPTION FOR DATABASE clear;
CONFIGURE ENCRYPTION ALGORITHM clear;
CONFIGURE COMPRESSION ALGORITHM clear;
CONFIGURE RMAN OUTPUT clear; # 12c
CONFIGURE ARCHIVELOG DELETION POLICY clear;
CONFIGURE SNAPSHOT CONTROLFILE NAME clear;
Depending on what you've set (and the version of your database), you may need to set additional configurations.
Segueing from Decision to Action
Now that you have a good understanding of what types of decisions you should make before implementing RMAN, it's
instructional to view a script that implements some of these components. I mainly work with Linux/Unix servers. In
these environments, I use shell scripts to automate the RMAN backups. These shell scripts are automated through a
scheduling utility such as
cron
.
This section contains a typical shell script for RMAN backups. The shell script has line numbers in the output for
reference in the discussion of the architectural decisions I made when writing the script. (If you copy the script, take
out the line numbers before running it.)
Following is the script. Table
4-2
details every RMAN architectural decision point covered in this chapter, how
it's implemented (or not) in the shell script, and the corresponding line number in the shell script. The script doesn't
cover every aspect of how to use RMAN. If you use the script, be sure to modify it to meet the requirements and RMAN
standards for your own environment:
1 #!/bin/bash
2 #----------------------------------------------
3 PRG=`basename $0`
4 USAGE="Usage: ${PRG}"
5 if [ $# -gt 0 ]; then
6 echo "${USAGE}"
7 exit 1
8 fi
9 export ORACLE_SID=O12C
10 export ORACLE_HOME=/orahome/app/oracle/product/12.1.0.1/db_1
11 export PATH=$PATH:$ORACLE_HOME/bin
12 BOX=`uname -a | awk '{print$2}'`
13 MAILX='/bin/mailx'
14 MAIL_LIST='dkuhn@gmail.com'
15 export NLS_DATE_FORMAT='dd-mon-yyyy hh24:mi:ss'
16 date
17 #----------------------------------------------
18 LOCKFILE=/tmp/$PRG.lock
19 if [ -f $LOCKFILE ]; then
20 echo "lock file exists, exiting..."
21 exit 1
22 else
23 echo "DO NOT REMOVE, $LOCKFILE" > $LOCKFILE
24 fi
25 #----------------------------------------------
26 rman nocatalog <<EOF
27 connect target /
