how to build cascaded logical standby from a logical standby
Date: Thu, 24 Apr 2008 18:58:35 +0800
Message-ID: <4415a5ed0804240358i1f546b8dyea7a68146ff9a4e2@mail.gmail.com>
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 -- http://www.freelists.org/webpage/oracle-lReceived on Thu Apr 24 2008 - 05:58:35 CDT