| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: UNIX root backup/SAN disk image vs. Oracle Hot Backups
"Ibrahim DOGAN" <idogan_tech_at_yahoo.com> wrote in message
news:6bf58828.0409010559.5ccd70bb_at_posting.google.com...
> Can UNIX root backup or SAN disk image backup be reliable as Oracle
> database backup?
>
> I don't know internals about root backup or disk images but it sounds
> like you may end up with inconsistent control file/datafiles when you
> load them back .
>
> is there anybody out there who knows how root backup/disk image works
> and can tell whether they can replace Oracle hot backups?
The concept is developed to reduce the downtime for a cold backup. A SAN disk image (EMC calls it Business Contingency Volume --BCV) is an identical synchronized copy of your live filesystem at a point in time. The connection between the two is broken off, and the live filesystem goes along doing its thing, while the BCV is static.
Consider the steps of a normal cold backup:
1. Shut down Oracle normally
2. Start backing up all relevant files.
2b. (Wait until backup finishes...)
3. Start Oracle
Step 2 can take considerable time. May not be good for application availability. Enter the BCV/Snapshot/Image functionality.
1. Shut down Oracle normally 2. Sync the live fs with the clone. This step should be reasonably quick. 3. Break the connection 4. Start Oracle 5. Continue to back up the cloned fs in peace and quiet. Additionally, ifthe live FS gets trashed, you can snapshot back to the state it had at step 2.
I think you are worried about the internal consistency of the files on the cloned image. That is correct, the snapshot must be of a cold database. This is no different than backing up the original files from their original location. You only get the ability to do a cold backup in "no time" seen from the Database or application.
>
> Thanks a bunch
> i.d.
All the usual disclaimers apply...
Foz
Received on Wed Sep 01 2004 - 17:14:56 CDT
 |
 |