| shikhu |
Posted: Jul 23, 2007 07:58:28 AM |
Total Post: 67
Joined: Jul, 2006
|
Hi All,
I want to write the scripts on Unix platform to take the backup of my database everynight at 9:00 p.m. automatically.
plz. help me out.
- shikha |
|
|
 DreamzZ |
| Posted: Jul 23, 2007 03:01:34 PM |  |
|
Total Post: 23
Joined: Jul, 2007
|
CREATE FILE yourscript.sh
rman target system/manager catalog rman/rman@rcat log $EVNT_ORABACKUP/mlog.f << rman_exit
run { execute script evnt_backup_whole; }>>>>>its a script name all ready saved in recovery catalog
exit
rman_exit
create script evnt_backup_whole
{
allocate channel ch1 type disk format '$EVNT_ORABACKUP/%U.bck';
allocate channel ch2 type disk format '$EVNT_ORABACKUP/%U.bck';
allocate channel ch3 type disk format '$EVNT_ORABACKUP/%U.bck';
allocate channel ch4 type disk format '$EVNT_ORABACKUP/%U.bck';
allocate channel ch5 type disk format '$EVNT_ORABACKUP/%U.bck';
set limit channel ch1 kbytes 2024800;
set limit channel ch2 kbytes 2024800;
set limit channel ch3 kbytes 2024800;
set limit channel ch4 kbytes 2024800;
set limit channel ch5 kbytes 2024800;
backup database;
sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';
backup archivelog all format '$EVNT_ORABACKUP/al_%U.bck';
backup current controlfile
tag = cf1
format '$EVNT_ORABACKUP/cf_%U.bck';
}
now make entry for your this file in cron job.
|
|
|
|
|
| Mohammed Taj |
| Posted: Jul 29, 2007 10:16:37 AM | |
|
Total Post: 746
Joined: Jul, 2007
|
Hi,
Hotbackup
http://dbataj.blogspot.com/2007/03/hotbackuplinuxusermanagedbackup.html
Coldbackup
http://dbataj.blogspot.com/2007/03/coldbackuplinuxscript.html
Logical Backup
http://dbataj.blogspot.com/2006/12/export-backup.html
Regards
Taj
http://dbataj.blogspot.com
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
