RE: Dropping online logs on physical standby

Um, a physical standby doesn't have online redo logs.

If you drop the log on production then that will be carried over to the standby.

Thanks,
Jay Miller
Sr. Oracle DBA
x68355  

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]
Sent: Wednesday, April 05, 2006 5:20 PM
To: oracle-l_at_freelists.org
Subject: Re: Dropping online logs on physical standby

That works fine for the primary but not the standby. The logs in question have a v$log status of CLEARING and CLEARING_CURRENT, which perhaps is why it thinks it needs these for crash recovery? I didn't think they would be used at all on the standby.

On 4/5/06, Ray Stell <stellr_at_cns.vt.edu> wrote:
> On Wed, Apr 05, 2006 at 04:59:24PM -0400, Michael Ray wrote:
> > Ignorant question here: How do you drop the ONLINE (not standby)
redo
>
>
> Note:1035935.6
> Subject: Example of How To Resize the Online Redo Logfiles
>

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



-----------------------------------------
This message is confidential and sent by TD Waterhouse solely for
use by the intended recipient. If you are not the intended
recipient, you are hereby notified that any use, distribution or
copying of this communication is strictly prohibited. This should
not be deemed as an offer or solicitation, to buy or sell any
product. Any 3rd party information contained herein was prepared by
sources deemed reliable, but is not guaranteed. TD Waterhouse does
not accept electronic instructions that would require an original
signature. Information received by or sent from TD Waterhouse is
stored, subject to review, and may be produced to regulatory
authorities or others with a legal right to such.

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