Databases Reference
In-Depth Information
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 17-2.
Implementation of Architectural Decisions
Decision Point
Implementation in Script
Line Number in Script
Running the RMAN client
remotely or locally
Running script locally on the database
server
Line 26, connecting locally (not a
network connection)
Specifying the backup user
Using
SYS
to connect
Line 27, starting
rman
connecting
with forward slash (
/
)
Using online or offline backups
Online backup
N/A. Database is assumed to be
up during the backup
Setting the archive redo log
destination and file format
LOG_ARCHIVE_DEST_N
and
LOG_ARCHIVE_
FORMAT
initialization parameters set outside
the script in a database parameter file
N/A; set outside the script
Configuring the RMAN backup
location and file format
Using the
CONFIGURE
command directly in
the script
Lines 33-37
Setting the autobackup of the
control file
Enabled in the script
Line 32
Specifying the location of the
autobackup of the control file
Placed in the same directory as the
backups
Line 33
Backing up archive redo logs
Backing up with the rest of the database;
specifically, using the
PLUS ARCHIVELOG
clause
Line 38
Determining the location for the
snapshot control file
Using the default location
N/A
Line 26, connecting as
nocatalog
Using a recovery catalog
Not using
Lines 35-37,
device type disk
Using a media manager
Not using
(
continued
)
