Re: how to build cascaded logical standby from a logical standby
- From: "Eagle Fan" <eagle.f@xxxxxxxxx>
- To: "Edgar Chupit" <chupit@xxxxxxxxx>
- Date: Fri, 25 Apr 2008 15:54:57 +0800
Thanks Chupit.
One more question:
Does anybody know if the cascaded logical standby from physical standby can
do real-time apply?
From my test, seems it only applies changes after the logfile switched on
primary.
On Thu, Apr 24, 2008 at 8:12 PM, Edgar Chupit <chupit@xxxxxxxxx> wrote:
> Dear Eagle,
>
> According to Note:409013.1
>
> "
> Cascading logical standby databases from a logical standby database is
> not supported.
> "
>
> :(
>
> On Thu, Apr 24, 2008 at 1:59 PM, Eagle Fan <eagle.f@xxxxxxxxx> wrote:
> > The oracle database version is 10.2.0.3.
> >
> >
> >
> > On Thu, Apr 24, 2008 at 6:58 PM, Eagle Fan <eagle.f@xxxxxxxxx> wrote:
> > > Hi All:
> > >
> > > I'm trying to build a cascaded logical standby using logical standby as
> > intermedial server.
> > >
> > > The redo route is like this:
> > >
> > > Primary (server A) -> logical standby (server B) -> cascaded logical
> > standby (server C).
> > >
> > > Server B was copied from Server A and has already been activated as
> > logical standby. It's working very well.
> > >
> > > Then I copied server C from server B and tried to setup a cascaded
> logical
> > standby.
> > >
> > > But when I started logical standby apply on Server C, it was looking
> for
> > archive logs from server A, not Server B.
> > >
> > > I was trying to register archive logs from Server B, but got the
> following
> > error:
> > >
> > > SQL> alter database register logfile
> > '/oracle/TENG/data01/XFAN10g/archive2/XFAN10g_74.1_652661119_arc';
> > >
> > > alter database register logfile
> > '/oracle/TENG/data01/XFAN10g/archive2/XFAN10g_74.1_652661119_arc'
> > >
> > > *
> > >
> > > ERROR at line 1:
> > >
> > > ORA-01324: cannot add file due to DB_ID mismatch
> > >
> > > In DBA_LOGSTDBY_LOG, the archive log is from primary (Server A). I
> didn't
> > find detailed action plan of building cascaded logical standby, if you
> have
> > such kind of doc, please give me a copy:)
> > >
> > > Any comments or suggestions are appreciated.
> > >
> > > Thanks.
> > >
> > > --
> > > Eagle Fan
> > >
> > > Sr. DBA
> >
> >
> >
> > --
> > Eagle Fan
> >
> > Sr. DBA
>
>
>
> --
> Best regards,
> Edgar Chupit
> callto://edgar.chupit
>
--
Eagle Fan
Sr. DBA
Other related posts:
