Home » RDBMS Server » Backup & Recovery » automatic scheduling of RMAN backups
automatic scheduling of RMAN backups [message #74410] Mon, 06 December 2004 22:20 Go to next message
satish
Messages: 112
Registered: September 2000
Senior Member
 Hi,

   Can we schedule RMAN backups to occur automatically..every day. Can i write KSH script as similar to cold & hot backups

thanks

satish
Re: automatic scheduling of RMAN backups [message #74412 is a reply to message #74410] Tue, 07 December 2004 00:35 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Ofcourse Yes.
Re: automatic scheduling of RMAN backups [message #74438 is a reply to message #74410] Thu, 09 December 2004 09:02 Go to previous message
croK
Messages: 170
Registered: April 2002
Senior Member
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.
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.
Previous Topic: RMAN Report from catalog
Next Topic: RMAN
Goto Forum:
  


Current Time: Thu Mar 28 10:31:41 CDT 2024