RE: Dropping online logs on physical standby

  • From: <JayMiller@xxxxxxxxxxxxxxxx>
  • To: <topshot.rhit@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 5 Apr 2006 18:49:34 -0400

On 8i when you do a graceful failover you copy the online redo logs
manually from production to the standby.

9i makes it even easier and it creates the online redo logs on the new
primary for you.  The files for the redo logs on the old primary remain
on the system but they are no longer written to.  

Jay Miller

 

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 
Sent: Wednesday, April 05, 2006 5:57 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: Dropping online logs on physical standby

Jay,
I was under the impression that the standby would need them once it
became the primary. Since they switch roles, doesn't the new primary
(old standby) use online logs and sync them to the standby logs on the
new standby (old primary) once it's back online?

On 4/5/06, JayMiller@xxxxxxxxxxxxxxxx <JayMiller@xxxxxxxxxxxxxxxx>
wrote:
> 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.
--
//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.

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


Other related posts: