| rman backups scheduling in unix [message #74444] |
Fri, 10 December 2004 06:38  |
shyam_kk
Messages: 9
Registered: August 2004
|
Junior Member |
|
|
hi frnds
I want to schedule rman backups in crontab(solaris).Can anybody help how to put oracle environemnt variables and provides sample script to
do a rman backup
with regards
shyam
|
|
|
|
| Re: rman backups scheduling in unix [message #74451 is a reply to message #74444] |
Mon, 13 December 2004 05:00  |
croK
Messages: 170
Registered: April 2002
|
Senior Member |
|
|
I have developed a graphical tool for reporting backups done with RMAN and i'm looking for people to test this tool.
Let me know if you are interested and will let you know how to proceed.
Thank you.
By the way, this is my cron file in solaris:
export HOME=/oracle/app/oracle/product/8.1.6
ORACLE_SID=SID1 ; export ORACLE_SID
ORACLE_HOME=/oracle/app/oracle/product/8.1.6; export ORACLE_HOME
ORACLE_OWNER=oracle
export HOME=$ORACLE_HOME
PATH=.:$PATH:$HOME/bin:/etc:/usr/sbin:/opt/SUNWspro/bin:/usr/ccs/bin
export PATH
export NLS_LANG=American_America.we8iso8859p1
export NLS_DATE_FORMAT='DD-MM-YYYY:HH24:MI:SS'
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
DATE=`date '+%d-%m-%y:%H:%M:%S'`
/exports/scripts/rman_sid1.sh /exports/scripts/bk_sid1_full.rcv /exports/scripts/bk_sid1_full${DATE}
Where rman_sid1.sh is like:
rman target user/pwd@alias_target rcvcat rman/rman@alias_catalog cmdfile=$1 log = $2
And bk_sid1_full.rcv is like:
run {
shutdown immediate;
startup mount pfile=/exports/RMAN_sid1/initsid1.ora;
allocate channel d1 type disk;
allocate channel d2 type disk;
allocate channel d3 type disk;
allocate channel d4 type disk;
backup
filesperset 5
format '/oradata6/bk_%d_%s_%p'
database;
release channel d1;
release channel d2;
release channel d3;
release channel d4;
resync catalog;
sql 'alter database open';
}
Hope this help.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
