Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle database mirroring questions
"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message
news:aj6gav0p8u66eol2ed5g17qfv4glomtf3v_at_4ax.com...
> On 24 Apr 2003 05:52:03 -0700, sonyantony_at_hotmail.com (Sony Antony)
> wrote:
>
> >We have been looking at the database redundancy problem from a high
> >level point of view, for the purpose of architecturing our distributed
> >application. I m not an expert in Oracle. So I decided to ask them
> >here before deciding on any particular solution.
> >
> >1. Does Oracle provide any database replication/mirroring mechanisms,
> >so that there will be a warm backup database to take over, if the
> >main/primary crashes. If it does what will be the performance hit (
> >cpu usage ) on the primary because this duplication mechanism is
> >running in the background.
> >
>
> Standby database in 8i, dataguard in 9i. Ships redolog (changed
> bytes). Performance hit should be neglicible.
I'd say that the likely performance hit would depend on 1) how stressed your redo system already is and 2) if you are going for the zero dataloss/manadatory redo destination option in which case loss of a link has a certain 'performance impact'. :(
-- Niall Litchfield Oracle DBA Audit Commission UKReceived on Tue Apr 29 2003 - 10:31:26 CDT