Re: ORACLE 10GR2 data guard real time apply did NOT work??
- From: "David Barbour" <david.barbour1@xxxxxxxxx>
- To: mccdba1@xxxxxxxxx
- 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):
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@xxxxxxxxx> 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@xxxxxxxxx> wrote:
>
> > From: Alex Fatkulin <afatkulin@xxxxxxxxx>
> > Subject: Re: ORACLE 10GR2 data guard real time apply did NOT work??
> > To: mccdba1@xxxxxxxxx
> > Cc: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
> > 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@xxxxxxxxx> 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
>
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
