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
iitAsked:
Who is Participating?
 
andertstConnect With a Mentor Commented:
I'm not a big fan of Windows for Oracle databases.  I realize it will work perfectly well for some uses, just not my favorite.  That is probably why I would recommend using DBMS_JOB.  Also, that will prevent you from having cases where the host is running and the database is not where the backup runs.

But, since you said "full backup", I just have to mention that if it is a "closed db backup" I don't know if scheduling it inside the db is a good idea.  I would stick with an incremental level 0 (which is a full backup) as long as you are in archivelog mode.

Stephen
0
 
iitAuthor Commented:
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!!
0
 
iitAuthor Commented:
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!!
0
 
iitAuthor Commented:
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!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.