oraback.conf

oracle数据库备份脚本

#
# Rcs_ID="$RCSfile: oraback.conf,v $"
# Rcs_ID="$Revision: 1.1 $ $Date: 1998/04/15 05:29:14 $"
#

############################################################################
############################################################################
#This file must have at least one line for each host, and that is the
#master configuration line. It begins with `hostname`.master, and
#has several fields that specify various configuration values:
#
#Field 1.  `hostname`.master (Says this is the main config line)
#Field 2.  Put the word "skip" in this field to skip backups for one night
#Field 3.  Three letter abbreviation for the day of the week cold backups
#          will run (e.g. Fri, Sat, Sun)
#Field 4.  The hour of the day that cold backups will run
#Field 4.  The hour of the day hot backups will run
#Field 5.  If backing up to tape-put a non-rewinding device file here.
#          (If backing up to disk, leave blank.)
#Field 6.  List of id's, separated by a '|' that are allowed run this script
#Field 7.  Number of datafiles that are to be copied simultaneously
#          (This field only applies if backing up to disk.)
#Field 8.  Name of directory where backups will be sent.  Even if backing
#          up to tape, still need a directory for some files such as
#          redologs, controlfiles, etc.
#Field 9.  Set to 'Y' if you want datafiles compressed as they are backed up
#Field 10. SMTP mail address of who should receive any error messages
#          (Can specify multiple IDs separated by a comma.)
#
#Example:
#
#elvis.master::Sun:2300:1700::oracle|curtis:5:/backups:Y:oracle@elvis
#
#Field 1.  Says this is the main config line for the system called elvis
#Field 2.  If field is blank, means backups will run
#Field 3.  Says that cold backups are to run on Sunday
#Field 4.  Cold backups will run at 2300
#Field 4.  Hot backups will run at 1700
#Field 5.  Is blank, means we're backing up to a directory, not a tape
#Field 6.  oracle or curtis can run the script
#Field 7.  The script is to copy 5 datafiles simultaneously
#Field 8.  Backups will be sent to /backups
#Field 9.  Datafiles will be compressed as they are written to /backups
#Field 10. It is mail any messages to oracle@elvis

############################################################################
############################################################################


############################################################################
#This script assumes that all instances are running archiving, and all
#instances want hot backups.  You can specify a custom line for each
#instance that doesn't meet that criteria.
#
#There are five fields:
#
#Field 1: hostname with the custome instance
#Field 2: ORACLE_SID of custom instance
#Field 3: Set to NOARCHIVELOG if you know that the instance is not running
#         in ARCHIVELOG mode, and that's ok.  If you set just this field
#         the instance will only be backed up on cold backup days
#Field 4: Set to offline if you want the instance that is in NOARCHIVELOG
#         mode to be shutdown for a cold backup every time the script is run 
#Field 5: Set to 'nohotbackup' if instance IS running in ARCHIVELOG mode,
#         but you do not want it to receive hot backups.
#         (Field 5 and Fields 3&4 are mutually exclusive.)
#
#Examples:
#
#elvis:dev1:NOARCHIVELOG
#
#The above line says that instance dev1 on elvis is in no archive log mode
#It will only get backed up when the script is doing cold backups
#
#elvis:dev2:NOARCHIVELOG:offline
#
#The above line says that instance dev2 on elvis is in no archive log mode
#But the extra "offline" word specifies to shut this instance down any
#time the script is run to do an offline backup
#
#elvis:dev3:::nohotbackup
#
#The above line says that there are to be nohotbackups performed on instance
#dev3 even if it "qualifies" for them otherwise (i.e. running in 
#ARCHIVELOG mode)