-
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
-
-
running the batch jobs
Originally Posted by davey23uk
well what happened
ok the dbms_scheduler is only available in 10g
can we do the same task by using dbms_job.submit available in 9i or earlier releases
I want to schedule to run .bat file by dbms_job but i didn't find the solution yet
can u plzzz help me in this regard?
-
DBMS_JOB cannot run external excutable file and can schedule only database internal procedures.
-
Originally Posted by Thomasps
DBMS_JOB cannot run external excutable file and can schedule only database internal procedures.
How can we do the that task?
-
-
schedule it freom the os scheduler
-
I can only assume you don't like the answer I gave you on my forum:
http://www.oracle-base.com/forums/vi...p?t=7130#11224
Or perhaps you didn't read it, since you've posted the same question to many Oracle forums!
Tim...
-
I will ban him if he post again duplicates and stuff
-
Apologizer
Originally Posted by pando
I will ban him if he post again duplicates and stuff
Respected Sir, I am really very sorry for ur inconvenience.
i have posted the same question on different forums to find the best solution but it is creating a some trouble then i'll avoid for the next time
Sorry Again Sir
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
|