Home » Infrastructure » Unix » How do I run backup schedule with RMAN?
How do I run backup schedule with RMAN? [message #286522] Fri, 07 December 2007 20:23 Go to next message
trantuananh24hg
Messages: 588
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Hi all!

I wrote some RMAN scripts to backup incremental daily, however, I did not know to configure them corresponding to Unix, especially, at the midnight, one of them execute backup. I often execute manually, it make me sadly.

Would you like to instruct me?

Thank you very much!
Re: How do I run backup schedule with RMAN? [message #286534 is a reply to message #286522] Fri, 07 December 2007 22:47 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Issue the following from a O/S command prompt:
man crontab

or consider using DBMS_SCHEDULER.
Re: How do I run backup schedule with RMAN? [message #286785 is a reply to message #286534] Mon, 10 December 2007 02:16 Go to previous messageGo to next message
trantuananh24hg
Messages: 588
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Thank you for your advice!

I tried to learn DBMS_SCHEDULER, however, I need more time to understand it.

Would you like to give me some example to install one OS script schedule call to RMAN script? (or any site illustrate those steps)

Example with RMAN backup full

create script '/u02/rman_scripts/backup_full.rcv'{
backup database plus archivelog;
delete noprompt obsolete;
}


Thank you very much!
Re: How do I run backup schedule with RMAN? [message #286797 is a reply to message #286785] Mon, 10 December 2007 02:43 Go to previous messageGo to next message
Michel Cadot
Messages: 57611
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
RMAN "create script" command has no relation with an OS script, it is a RMAN script stored in the recovery catalog.

Regards
Michel
Re: How do I run backup schedule with RMAN? [message #286823 is a reply to message #286797] Mon, 10 December 2007 03:17 Go to previous messageGo to next message
trantuananh24hg
Messages: 588
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Thank you, Michel!

So, would you like to advice me for my strategy backup (using RMAN):

- Once 3 days backup incremental (to Tape)
- Using Recovery Window of 7 days to backup full (to Tape)
- Using OS script to copy datafile (to Disk) at the end of week, remove them when the Rman backup pieces is marked as obsolete.

I am wondering about my strategy.

Thank you!
Re: How do I run backup schedule with RMAN? [message #286892 is a reply to message #286823] Mon, 10 December 2007 06:38 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

For windows
1. Create CMD file for rman backup script.
In script you can mention obsolete backup statments.
check oracle documentation for more details.

2. Schedule your cmd script through windows scheduler or you can also use DBMS_SCHEDULER package.

For linux
1. Create shell scipt for rman backup
In script you can use all require backup strategy parameter
use documentation for more details.

2. Schedule your shell scirpt through crontab or you can also use DBMS_SCHEDULER package.

Suggestion:

1. Always store backup on both side tape with disk.

2. You don't worry for obsolete backup just configure rman script then oracle will remove periodically obsolete backup for you.

3. Always test your backup procedure through DATABASE RECOVERY.
Previous Topic: How to find out where oracle is installed?
Next Topic: Oracle 9i Alert.log
Goto Forum:
  


Current Time: Sat Apr 19 01:25:23 CDT 2014

Total time taken to generate the page: 0.09754 seconds