Re: how to build cascaded logical standby from a logical standby

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_at_gmail.com> wrote:
> The oracle database version is 10.2.0.3.
>
>
>
> On Thu, Apr 24, 2008 at 6:58 PM, Eagle Fan <eagle.f_at_gmail.com> 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
--
http://www.freelists.org/webpage/oracle-l