Re: ORACLE 10GR2 data guard real time apply did NOT work??

From: David Barbour <david.barbour1_at_gmail.com>
Date: Mon, 5 Jan 2009 12:06:19 -0500
Message-ID: <69eafc3f0901050906i2ea91f7ata1132c5facbad680_at_mail.gmail.com>

Alex's question is still valid. Here's the example from the Data Guard Concepts manual of how your primary needs to be configured (chicago is the primary, boston is the standby):

DB_NAME=chicago
DB_UNIQUE_NAME=chicago
LOG_ARCHIVE_CONFIG='DG_CONFIG=(chicago,boston)' CONTROL_FILES='/arch1/chicago/control1.ctl', '/arch2/chicago/control2.ctl' LOG_ARCHIVE_DEST_1=
'LOCATION=/arch1/chicago/
VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
DB_UNIQUE_NAME=chicago'
LOG_ARCHIVE_DEST_2=
'SERVICE=boston LGWR ASYNC
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=boston'
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE You need to have configured standby redo logs as well.

What does the alert log on the primary show you?

On Mon, Jan 5, 2009 at 11:01 AM, dba1 mcc <mccdba1_at_yahoo.com> wrote:

> "Archive log" transfer from Primary DB to standby DB is correct. BUT "real
> time apply" use "log file", not archive log.
>
>
>
> --- On Mon, 1/5/09, Alex Fatkulin <afatkulin_at_gmail.com> wrote:
>
> > From: Alex Fatkulin <afatkulin_at_gmail.com>
> > Subject: Re: ORACLE 10GR2 data guard real time apply did NOT work??
> > To: mccdba1_at_yahoo.com
> > Cc: "oracle-l" <oracle-l_at_freelists.org>
> > Date: Monday, January 5, 2009, 10:53 AM
> > What's your log dest setup on primary?
> >
> > On Mon, Jan 5, 2009 at 10:24 AM, dba1 mcc
> > <mccdba1_at_yahoo.com> wrote:
> > > We have ORACLE 10.2.0.4 on two Redhat LINUX. I tried
> > to setup "real time apply" on standby database,
> > there is No error but data NOT update.
> >
> > --
> > Alex Fatkulin,
> > http://afatkulin.blogspot.com
> > http://www.linkedin.com/in/alexfatkulin
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jan 05 2009 - 11:06:19 CST