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

Thread: rman

Hybrid View

  1. #1
    Join Date
    Dec 2002
    Posts
    89

    rman

    i would like to automate following command to run every fri at 4.00p.m


    rman catalog rman/test@rman target internal/oracle@test_p
    run {
    execute script full_backup;
    }

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    You have two choices here, you can either run it as an OS job (Cron or AT) or you can run it as an OEM job.

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #3
    Join Date
    Dec 2002
    Posts
    89
    we are having win2000 after installing terminal service at command is not working.does anybody know to set up a job using toad tool.

  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by jovery
    You have two choices here, you can either run it as an OS job (Cron or AT) or you can run it as an OEM job.

    Regards
    I do that using the 3rd (and best choice): PL/SQL and DBMS_JOB.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

  5. #5
    Join Date
    Dec 2001
    Posts
    320
    Originally posted by julian
    I do that using the 3rd (and best choice): PL/SQL and DBMS_JOB.
    Hi Julian,
    Why do you say that using DBMS_JOB is better than running an OEM Job?

    Cheers.

  6. #6
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by hany
    Hi Julian,
    Why do you say that using DBMS_JOB is better than running an OEM Job?

    Cheers.
    I prefer it. I am not an OEM fan.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

  7. #7
    Join Date
    Dec 2002
    Posts
    89
    Julian,
    Can you please tell me how you schedule a job using dbms_job to run once in a week.
    rman catalog rman/test@rman target internal/oracle@test_p
    run {
    execute script full_backup;
    }

  8. #8
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    You need to write a java programme that can do a os callout and then the DBMS_JOB would call this java programme which in turn will excute your..RMAN commands...Using OEM's JOb scheudling facilites would be the easisest way to to this..unless your familar with Java..

    For this kind of job my order of preference would be

    1)AT or Cron utility
    2)OEM Job
    3)DBMS_JOB

    I would not use DBMS_JOB for this kind of thing..I am waiting to reason out with Julian on why he would prefer dbms_jobs..because using DBMS_JOB would make it unnecessarily complex..for this kind of a Job..and besides if you write a Nt batch script or unix shell script that wraps around this rman script it will also be very very easy when scheduled through AT/cron..

    regards
    Hrishy
    Last edited by hrishy; 12-24-2002 at 01:53 AM.

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