Re: Standby on Same box
Date: Wed, 4 Feb 2009 08:36:33 -0200
if you want minumum downtime, you can also have a 4 node RAC with a 4 node RAC as standby... on a redundant storage using asm high redundancy... but that would be a bit of an overkill. And minumum downtime implies that there should be no unplanned downtime. There was another thread where planned downtime was discussed, and I believe every database should have planned downtime in order to apply patchsets to the db engine and all that stuff.
Oracle Certified Associate
On Tue, Feb 3, 2009 at 6:08 PM, D'Hooge Freek <Freek.DHooge_at_uptime.be> wrote:
> If you want to have a rapid restore of a datafile, you could also use a copy backup on disk and then use the switch to copy command in case of a lost datafile.
> Freek D'Hooge
> Oracle Database Administrator
> e-mail: freek.dhooge_at_uptime.be
> tel. +32 (0)3 451 23 82
> From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] On Behalf Of Howard Latham [howard.latham_at_gmail.com]
> Sent: 03 February 2009 20:00
> To: Maureen English
> Cc: oracle-l_at_freelists.org
> Subject: Re: Standby on Same box
> At a certain Bank someone unknown deleted a database file. In that
> situation the
> Standby on the same box would be ideal. Financial trading needs rapid
> failover. The same thing happened the next day !
> (Double ouch) I think there was a string of redundancies at the time.
> On 03/02/2009, Maureen English <sxmte_at_email.alaska.edu> wrote:
>> I agree with the other comments regarding having a standby that is
>> planned for use as a failover on a different box. However, we've
>> been considering having a logical standby on the same box, where its
>> purpose would be simply a reporting database.
>> - Maureen
>> Howard Latham wrote:
>>> Oracle 10g and 11g.
>>> REDHAT LInux
>>> I have just been told by a consultant that a standby on the same box
>>> as a primary is not recommended.(We also have a standby on another
>>> box) My feeling is that will speedup a rebuild should we ever have to
>>> switch over and switch back.Any views?
> Howard A. Latham