asked on

RMAN- backup schedule

Hello Experts,

I am implementing an automated rman backup procedure for an Oracle database. Say I want to perform a full backup every monday. How do one schedule it? Through dbms_job system or operating system scheduler? Which one is preferred

Assume I am using the following command to backup the database.
backup database format 'c:\rman_backups\%d_%t';

Can someone tell how do I schedule it using windows task scheduler and dbms_job system?
Is there a way to get email notification everytime a backup completes or the log of error when it fails.
I can use "rman cmdfile logfile" to run the commands in cmdfile. But how do I have the contents of logfile emailed to me?

What are the best practices?
Thanks much,
IIT

iit

ASKER

Some more information:

I can put commands such as this in a command file:

run
      allocate channel t1 type `SBT_TAPE`
      parms `ENV=(NSR_SERVER=jupiter.legato.com)`;
      backup
      filesperset 6
      (database format `test-%s_%p`);
      }

and the rman command to execute the cmd file in a batch file and then give the batch file as input to the schduler.
rman80 target internal/oracle rcvcat rman/rman@mars \
      cmdfile `f:\orant\scripts\rmanscript`2>&1 >rmanlog
      savegrp -O -l full -c Oracle8-server-name -c NetWorker-server-name

This way for every kind of backup to be scheduled i have to create two scripts. I am thinking this becomes aproblem to manage and assuming there might be a better way to deal with it... using dbms_job system or so...

thanks in advance for your help!!

iit

ASKER

I have done little more research on performing automated backups using Enterprise Manager,

I found the chapter Managing Backup and Recovery in Oracle Enterprise Manager Administrator's Guide Release 9.2.0 guide very useful. It looks like I have to run OMS to use the backup and recovery. I have to study more about OMS, advantages/disadvantages complexity etc. I am handling just a couple of small databases. So I have to figure out which method is good for my case.

Thanks in advance for any pointers!!

ASKER CERTIFIED SOLUTION

andertst

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

iit

ASKER

Thank you anderst for your comments.

>>That is probably why I would recommend using DBMS_JOB.
Can we run rman scripts using dbms_job? My understanding is that I have to configure Oracle Management Server to run it. I heard it is technically possible to run rman scripts using dbms_job using java stored procedures (dont't know how). Please tell me if my understanding is incorrect.

Thanks again!