Oracle-L: RE: OPS and redos

From: <John.Hallas_at_vodafone.co.uk>
Date: Tue, 02 Jul 2002 04:43:35 -0800
Message-ID: <F001.0048DB1C.20020702044335@fatcity.com>

Thinking about it logically how can any 2 systems that are used independently (which in a way is what OPS is)always keep the same SCN numbers together.
As long as each of the instances has it's own set of redo log files and it's own set of archived log files (i.e both nodes/instances not writing to the same directory and overwriting another instances's files) then recovery should not be a problem.

Have you tried doing a test recovery just to prove that everything is OK

HTH John

-----Original Message-----
Sent: 02 July 2002 12:28
To: Multiple recipients of list ORACLE-L

Hi gurus,

I have a query..Basically we have an OPS set up here (8.0.6) and I have noticed that the scn on node A is 500 and the scn on node B is 2000. I am concerned about this w.r.t recovery- surely this would be an issue ??I logged a call with oracle and they said it wasnt an issue, but then I read in a document that it WAS an issue and could potentially lose everything between 500 abd 2000..and that the workaround would be to add more logs to A or to modify the check point interval....

Please can you advise??

Rgds

Fawzia

Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone.
Thank you for your co-operation.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Malik, Fawzia
INET: Fawzia.Malik_at_bskyb.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: John.Hallas_at_vodafone.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------