Re: Parallel Server & Standby Database

From: Roger <NOrgSPAM_at_mcs-hh.de>
Date: 2000/04/27
Message-ID: <8e8gar$etb$1@garnet.hamburg.cityline.net>#1/1

Martin Haltmayer <Martin.Haltmayer_at_0800-einwahl.de> schrieb in im Newsbeitrag: 3906DFB6.E6263929_at_0800-einwahl.de...

>>I doubt that this works. Imagine you have two archived redo logs, one from
each
thread.
In which sequence shall the standby database replay the archived logs? If Oracle
support can answer that question then please tell me as I faintly remember that
in our OPS course we were told that this cannot work.<<

I asked three different people at Oracle and all said that it should work. All the archived logs have a log sequence number and a thread number. Besides that they contain the system change numbers for the transactions (SCN). And that number is global to the whole OPS cluster. So I don't see why the standby database shouldn't be able to apply the redo logs in the correct order.

Roger Received on Thu Apr 27 2000 - 00:00:00 CDT