RE: how to build cascaded logical standby from a logical standby
- From: "John Hallas" <john.hallas@xxxxxxxxxx>
- To: <eagle.f@xxxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 24 Apr 2008 12:25:49 +0100
This relates to a question I was asking a couple of weeks ago about
Streams from a standby database.
I was under the impression that you could not run a standby (or Streams)
from another standby database. I do not know this for certain and
logically it seems to be a sound idea but I have not seen anything that
suggests it can be done.
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Eagle Fan
Sent: 24 April 2008 12:00
To: oracle-l
Subject: Re: how to build cascaded logical standby from a logical
standby
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
The information included in this email and any files transmitted with it may
contain information that is confidential and it must not be used by, or its
contents or attachments copied or disclosed, to persons other than the intended
addressee. If you have received this email in error, please notify BJSS.
In the absence of written agreement to the contrary BJSS’ relevant standard
terms of contract for any work to be undertaken will apply.
Please carry out virus or such other checks as you consider appropriate in
respect of this email. BJSS do not accept responsibility for any adverse effect
upon your system or data in relation to this email or any files transmitted
with it.
BJSS Limited, a company registered in England and Wales (Company Number
2777575), VAT Registration Number 613295452, Registered Office Address, First
Floor, Coronet House, Queen Street, Leeds, LS1 2TW
Other related posts:
