| How do I run backup schedule with RMAN? [message #286522] |
Fri, 07 December 2007 20:23  |
trantuananh24hg
Messages: 744
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 #286785 is a reply to message #286534] |
Mon, 10 December 2007 02:16  |
trantuananh24hg
Messages: 744
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 #286823 is a reply to message #286797] |
Mon, 10 December 2007 03:17 |
trantuananh24hg
Messages: 744
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 |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
