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
On 2004-09-01, Howard J. Rogers <hjr_at_dizwell.com> wrote:
> Frank Foss wrote:
>
>>
>> "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.
[deletia]
>
> I've nothing much to add except that if you're going to break a mirror in
> order to grab a backup, you don't actually have to shut the database down
> but can instead use the suspend (and resume) statements.
Why not just put all the tablespaces in backup mode? If you break a mirror and get yourself an inconsistent database, it should be much the same as any other inconsistent copy of the database you've created with more conventional methods.
[deletia]
-- vi isn't easy to use. ||| / | \ vi is easy to REPLACE.Received on Fri Sep 17 2004 - 16:53:43 CDT