Database Reference
In-Depth Information
28 set echo on;
29 show all;
30 crosscheck backup;
31 crosscheck copy;
32 configure controlfile autobackup on;
33 configure controlfile autobackup format for device type disk to
'/u01/O12C/rman/O12C_ctl_%F.bk';
34 configure retention policy to redundancy 1;
35 configure device type disk parallelism 2;
36 configure channel 1 device type disk format '/u01/O12C/rman/O12C_%U.bk';
37 configure channel 2 device type disk format '/u02/O12C/rman/O12C_%U.bk';
38 backup as compressed backupset incremental level=0 database plus archivelog;
39 delete noprompt obsolete;
40 EOF
41 #----------------------------------------------
42 if [ $? -ne 0 ]; then
43 echo "RMAN problem..."
44 echo "Check RMAN backups" | $MAILX -s "RMAN issue: $ORACLE_SID on $BOX" $MAIL_LIST
45 else
46 echo "RMAN ran okay..."
47 fi
48 #----------------------------------------------
49 if [ -f $LOCKFILE ]; then
50 rm $LOCKFILE
51 fi
52 #----------------------------------------------
53 date
54 exit 0
Table 4-2.
Implementation of Architectural Decisions
Decision Point
Implementation in Script
Line Number in Script
1. Running the RMAN client remotely
or locally
Running script locally on the database
server
Line 26, connecting locally (not a
network connection)
Using
SYS
to connect
Line 27, starting
rman
connecting
with forward slash (
/
)
2. Specifying the backup user
3. Using online or offline backups
Online backup
N/A. Database is assumed to be
up during the backup
LOG_ARCHIVE_DEST_N
and
LOG_ARCHIVE_
FORMAT
initialization parameters
set outside the script in a database
parameter file
4. Setting the archive redo log
destination and file format
N/A; set outside the script
Using the
CONFIGURE
command directly
in the script
5. Configuring the RMAN backup
location and file format
Lines 33-37
(
continued
)
