rman

[kpate]

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;
}

[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

[kpate]

we are having win2000 after installing terminal service at command is not working.does anybody know to set up a job using toad tool.

[julian]

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.

[hany]

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.

[julian]

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.

[kpate]

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;
}

[hrishy]

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