| Scheduling of RMAN Backup Script Stored in Recovery Catalog [message #195744] |
Mon, 02 October 2006 02:01  |
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  |
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~~
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
