Installgen
Features and Benefits
Installgen
Demo Available for download...
Bookmark This Page
#!/bin/sh
# program: prod1_rman_archivelog_backup_job.sh (renamed from 85_prod1_rman_archivelog_backup_job_1.sh)
# features: This shell script backs up archivelog files via RMAN
# and removes the archivelog files from the archivelog
# directory. This script is useful for situations
# in which the nightly full database RMAN backup
# will not occur soon enough to prevent the archivelog
# directory from filling up.
#
# Notes: The RMAN max i/o rate is set to a default of 1500K/sec.
# This value should be tuned by the DBA to reduce the
# impact on the server if the standby database is going
# to be opened for Read Only usage.
#
# Script Sequence#: 85
# Used By: run every 4 hours via oracle UNIX account CRON job - on standby server
# Usage:
# ******** RMAN Backup of Archivelogs Every 4 Hours ********
# 02 0,4,8,12,16,20 * * 0-6 /opt/server_scripts/prod1_rman_archivelog_backup_job.sh
#
# Copyright 2002 by .com Solutions Inc.
#
# --------------- Revision History ---------------
# Date By Changes
# 01-20-2002 dsimpson Initial Release
# 04-17-2002 dsimpson Added use of oem sid domain.
# 05-27-2002 dsimpson Updated for Solaris - converted
# to shell script.
# This output file was created by Installgen version 1.38 on Sun Nov 10 14:20:50 2002. By .com Solutions Inc. www.dotcomsolutionsinc.net
# define globally used paths/variables
ORACLE_BASE=/u01/v901
ORACLE_HOME=/u01/v901
ORACLE_OWNER=oracle
ORACLE_OWNER_PATH=/export/oracle
ORACLE_GROUP=dba
ORACLE_HOME=/u01/v901
ORACLE_SID=prod1
LD_LIBRARY_PATH=/u01/v901/lib:/u01/v901/lib64:/usr/dt/lib
CLASSPATH=$ORACLE_HOME/jdbc/lib/classes111.zip
ORAENV_ASK=NO
TNS_ADMIN=$ORACLE_HOME/network/admin
PATH=/usr/sbin/:/bin:/usr/bin:/usr/ccs/bin:/usr/ucb/bin:/usr/ucb:/usr/openwin/bin:/usr/dt/bin:/usr/local/bin:/opt/bin:/usr/opt/SUNWmd/sbin:/usr/platform/sun4u/sbin:/opt/sfw/bin:.:/usr/local/sbin:/u01/v901/bin
TERM=vt100
NLS_LANG=AMERICAN_AMERICA.US7ASCII
export ORACLE_OWNER ORACLE_OWNER_PATH ORACLE_GROUP ORACLE_HOME ORACLE_SID ORA_BDUMP_DIR LD_LIBRARY_PATH PATH ORAENV_ASK TNS_ADMIN TERM NLS_LANG
# start the rman backup
$ORACLE_HOME/bin/rman 'target /'<< EOF
run {
allocate channel ch1 type Disk rate 1500K maxpiecesize = 1900M;
backup archivelog all
delete all input
format '/archive/%d_archivelog_%s_%p.bak'
tag 'prod1_archivelog_4hr';
}
quit
EOF
