Home » RDBMS Server » Backup & Recovery » Scheduling of RMAN Backup Script Stored in Recovery Catalog
Scheduling of RMAN Backup Script Stored in Recovery Catalog [message #195744] Mon, 02 October 2006 02:01 Go to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member

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
Re: Scheduling of RMAN Backup Script Stored in Recovery Catalog [message #195754 is a reply to message #195744] Mon, 02 October 2006 02:59 Go to previous message
linyumin
Messages: 13
Registered: August 2006
Location: Taiwan Taipei
Junior Member

M.Shakeel Azeem wrote on Mon, 02 October 2006 15:01


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



unable to do so??
Could you show more detail??
Maybe you can execute the batch file using operating system's scheduler~~because I think db's scheduler about executing batch file has problems sometimes~~

Previous Topic: RMAN backup&dbms_scheduler
Next Topic: RMAN backup command
Goto Forum:
  


Current Time: Sun Dec 04 06:49:55 CST 2016

Total time taken to generate the page: 0.16874 seconds