Linux OS Backup with Oracle DB Installed
Hi Gurus,
I currently have an Oracle Linux machine with Oracle 11g Database installed. I am currently trying to come up with a backup strategy. For the DB, I have already set up RMAN backups, data pump exports and Archive log backups (using Flash Recovery Area).
My question is regarding the Linux OS backup. I plan to write a script to carry out the OS level backup (which will just run a tar), however, not sure if I need to include the Oracle database folder as well.
1. The reason I don't want to include the Oracle database folder is that when the tar command runs, and if Oracle is up and running, this might cause an issue as log files may be getting updated during that time, so the backup script will take a long time to complete (The DB will always be up and running, as I do not plan to do a 'cold backup' scenario)
2. As per point 1, if I don't include the oracle database folder, then, while restoring to a new server, I'll need to re-install the Oracle DB and then restore the DB using RMAN
So essentially, the above becomes a 3 point restore - restore the OS, re-install DB and restore DB backup using RMAN.
What I would like to achieve using the OS level backup script is upon restoring the OS backup, the OS and DB are in place and I just need to restore the DB.
To achieve that, what folders should I backup OR this is not achievable?
The Oracle DB is not using ASM.
Thanks to all those who respond, in advance.
Regards.
Edited by: 984677 on Jan 28, 2013 7:22 PM
Edited by: 984677 on Jan 30, 2013 10:41 PM