Scheduling of RMAN Backup Scripts stored in recovery catalog
Can anybody please provide me regarding
How can we schedule the RMAN backup scripts stored in recovery catalog by using dbms_scheduler
I have read a forum regarding this issue stated below
I had a job as below
--------------------------------------------------------------------------------
BEGIN
dbms_scheduler.create_job(job_name => 'sys.whole_db_backup',
job_type => 'executable',
job_action => 'F:\whole_db_backup.bat',
start_date => to_date('2006-08-05 00:00:00',
'yyyy-mm-dd hh24:mi:ss'),
repeat_interval => 'freq=daily;interval=7',
enabled => TRUE);
END;
--------------------------------------------------------------------------------
and my whole_db_backup.bat as below
rman target xxx/xxx@mydb catalog xxx/xxx@catadb script 'whole_db_backup' log F:\rman_backup\rman_output.log
i adopt the same procedure but i was unable to do so
can u please tell me where i did it wrong and if u have another way then please provide it to me
thanx in advance
