Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: UNIX root backup/SAN disk image vs. Oracle Hot Backups

Re: UNIX root backup/SAN disk image vs. Oracle Hot Backups

From: Joel Garry <joel-garry_at_home.com>
Date: 1 Sep 2004 16:53:47 -0700
Message-ID: <91884734.0409011553.151f5671@posting.google.com>


idogan_tech_at_yahoo.com (Ibrahim DOGAN) 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?
>
> Thanks a bunch
> i.d.

As Sybrand sort-of intimated, they must work together. So, it depends how fast your mirroring works. The general idea is to [triple-]mirror, put all tablespaces into backup mode, break [extra] mirror, take out of backup mode, and copy the image at your leisure.

Backup mode causes much more writing to logs (look up "fractured blocks" in the Oracle docs), so that's why RMAN is better versus copying one tablespace at a time over a period of time, it has a much lower impact on log writing. Image copies moot that, if they are fast enough. Some configurations take a long time to resilver the mirror, so, it depends, on transaction load, hardware, requirements, data size, etc.

Of course, RMAN has a lot of other benefits that might outweigh a naive site-specific mirroring strategy.

jg

--
@home.com is bogus.
Well, shiver me slartibartfast!
http://news.bbc.co.uk/1/hi/entertainment/tv_and_radio/3615046.stm
Received on Wed Sep 01 2004 - 18:53:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US