|
-
I want to schedule a full online backup everyday, here's what I have:
This is the backup script(cmdfile) created as a txt file for Rman to run:
run {
allocate channel t1 type disk;
set maxcorrupt for datafile 1,2,3,5,6,7,8 to 0;
backup
FULL
tag FULL_DEV4
format 'c:\mnt\ora_backup\DEV4\df_t%t_s%s_p%p'
database;
copy current controlfile to 'c:\mnt\ora_backup\dev4\CONTROL_t%t.ctl';
sql 'alter system archive log current';
backup
format 'c:\mnt\ora_backup\dev4\al_t%t_s%s_p%p'
(archivelog all delete input);
release channel t1;
}
and this is the command which works perfectly from dos prompt but when I run it as a rman.cmd or rman.bat file doesn't work:
rman nocatalog target sys/change_on_install @c:\mnt\ora_backup\scripts\bkpdev4.txt log=c:\mnt\ora_backup\scripts\bkpdev4.log
I have no clue why it doesn't run as a bat file or when I schedule it from the schedule task manager.
Please help!!
KN
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|