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

From: John Hallas <>
Date: Thu, 24 Apr 2008 12:25:49 +0100
Message-ID: <>

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.  

[] 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

On Thu, Apr 24, 2008 at 6:58 PM, Eagle Fan <> 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

alter database register logfile


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.


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

Received on Thu Apr 24 2008 - 06:25:49 CDT

Original text of this message