DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: Scheduling of RMAN Backup Scripts stored in recovery catalog

  1. #1
    Join Date
    Sep 2006
    Posts
    114

    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

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    well what happened

  3. #3
    Join Date
    Sep 2006
    Posts
    114

    running the batch jobs

    Quote 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?

  4. #4
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    DBMS_JOB cannot run external excutable file and can schedule only database internal procedures.
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  5. #5
    Join Date
    Sep 2006
    Posts
    114
    Quote 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?

  6. #6
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    What task?
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  7. #7
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    schedule it freom the os scheduler

  8. #8
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    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...
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: oracle-base.com
    My blog: oracle-base.com/blog

  9. #9
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    I will ban him if he post again duplicates and stuff

  10. #10
    Join Date
    Sep 2006
    Posts
    114

    Apologizer

    Quote 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
  •  


Click Here to Expand Forum to Full Width