RE: Applying logs to standby in 11g

From: Sweetser, Joe <JSweetser_at_icat.com>
Date: Mon, 22 Oct 2012 18:55:02 +0000
Message-ID: <D18D6513433DF04394041EA42B53E91C9CD63DDD_at_ICATMAIL1.ICAT.com>

I can't directly speak to the 10g v. 11g changes since I have not done that but it does look like the meaning/usage of applied in the v$archived_log view has been slightly modified from 10g to 11g. Does the most recent log in the 11g standby have applied = IN-MEMORY?

10g: http://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_1016.htm

11g: http://docs.oracle.com/cd/B28359_01/server.111/b28320/dynviews_1016.htm

hth,
-joe

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sandra Becker Sent: Monday, October 22, 2012 12:32 PM
To: oracle-l
Subject: Applying logs to standby in 11g

This pas weekend I upgraded my production OLTP from 10g to 11g (SUSE11 on IBM zLinux), then I created an 11g standby. We moved the database to newer, faster, correctly configured storage at the same time. All went well and everything is functioning better than it did before the upgrade. My question is regarding the value in the applied column of v$archived_log.  Under 10g the value was changed to 'YES' within a few minutes, or less, for smaller logs such as less than 1M. Under 11g I don't see that changing until a log switch so it appears I am a log behind. I can see the messages that media recover has started for one log followed by a message that another log is in transit so I am assuming that the first log has been successfully applied, but v$archived_log still shows it isn't applied.  Perhaps that's not a valid assumption.

.
.
.

Media Recovery Log /u06/oradata/prod/arch/1_304_797150180.arc Media Recovery Waiting for thread 1 sequence 305 (in transit)

Question: Is this normal behavior in 11g? If not, where should I look to see what the cause is? I've been searching MOS and Google but haven't seen this scenario addressed yet.

Thanks in advance.

--
Sandy
Transzap, Inc.


--
http://www.freelists.org/webpage/oracle-l



Confidentiality Note: This message contains information that may be confidential and/or privileged. If you are not the intended recipient, you should not use, copy, disclose, distribute or take any action based on this message. If you have received this message in error, please advise the sender immediately by reply email and delete this message. Although ICAT Managers, LLC, Underwriters at Lloyd's, Syndicate 4242, scans e-mail and attachments for viruses, it does not guarantee that either are virus-free and accepts no liability for any damage sustained as a result of viruses. Thank you.

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Oct 22 2012 - 20:55:02 CEST