| vishu |
Posted: May 14, 2008 12:21:50 AM |
Total Post: 16
Joined: Apr, 2008
|
Please give me guidline about which backup strategy is good to automate
backup of oracle 10g 24x7 database.
Thanks in advance
|
|
|
 GOPU |
| Posted: May 14, 2008 12:35:49 AM |  |
|
Total Post: 268
Joined: Apr, 2008
|
You can choose a backup strategy based on your production environment,your oraganization and the size of your database.
If the database size is small,you can go for export backups,Other wise you can i am suggesting you to go for RMAN backups.
|
|
|
|
|
| Murtuja |
| Posted: May 14, 2008 12:55:14 AM | |
|
Total Post: 843
Joined: Jan, 2006
|
Hi,
RMAN backups are the best for production DB.You can use very nice features of RMAN like compression,corruption detection.
In Development/test database you can take export depending on DB size.
|
|
|
|
|
| Murtuja |
| Posted: May 14, 2008 12:58:17 AM | |
|
Total Post: 843
Joined: Jan, 2006
|
In Oracle 10g Enterprise Edition have Incrementally Updated Backups
( block traking ) in RMAN.
Read this link for more information
http://www.oracle-base.com/articles/10g/RMANEnhancements10g.php#incrementally_updated_backups
|
|
|
|
|
| vishu |
| Posted: May 14, 2008 07:27:16 AM | |
|
Total Post: 16
Joined: Apr, 2008
|
But can you tell me how to automate backup using RMAN for
24X7 medium size production database
|
|
|
|
|
| dbavinod |
| Posted: May 14, 2008 07:39:34 AM | |
|
Total Post: 90
Joined: Sep, 2006
|
RMAN is more integrated with OEM.or use DBMS_JOBS
|
|
|
|
|
| GOPU |
| Posted: May 14, 2008 07:46:36 AM | |
|
Total Post: 268
Joined: Apr, 2008
|
vishu,
you can automate the backup based on your requirement.
you can implement the rman and you can make the scripts for the rman backups and you can schedule it...for example monday and wednesday you can take incremental and in the weekend you can take the full backup.based on this you make the script and schedule it.
|
|
|
|
|
| Murtuja |
| Posted: May 14, 2008 10:51:14 AM | |
|
Total Post: 843
Joined: Jan, 2006
|
Hi
You can automate RMAN backup using shell script and sql script.
You have to write one sql file like below
delete noprompt obsolete;
crosscheck archivelog all;
delete noprompt expired archivelog all;
resync catalog;
backup database;
exit;
Now call this sql script from shell script
|
|
|
|
|
| vishu |
| Posted: May 16, 2008 12:54:34 AM | |
|
Total Post: 16
Joined: Apr, 2008
|
Can you tell me how to schedule sql script?
Either using Database or using Operating System?
Im using Windows 2003 server operating system
|
|
|
|
|
| GOPU |
| Posted: May 16, 2008 12:58:54 AM | |
|
Total Post: 268
Joined: Apr, 2008
|
IF you made a batch file you can schedule it in the Operating system.
In windows 2003 server scheduler option is there.
|
|
|
|
|
| GOPU |
| Posted: May 16, 2008 12:59:10 AM | |
|
Total Post: 268
Joined: Apr, 2008
|
IF you made a batch file you can schedule it in the Operating system.
In windows 2003 server scheduler option is there.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
