Re: ORACLE 10GR2 data guard real time apply did NOT work??
Date: Mon, 5 Jan 2009 12:06:19 -0500
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):
LOG_ARCHIVE_CONFIG='DG_CONFIG=(chicago,boston)' CONTROL_FILES='/arch1/chicago/control1.ctl', '/arch2/chicago/control2.ctl' LOG_ARCHIVE_DEST_1=
'SERVICE=boston LGWR ASYNC
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