Re: Standby on Same box
Date: Wed, 4 Feb 2009 08:36:33 -0200
Message-ID: <172762180902040236s4e652748yfe8602666152fe89_at_mail.gmail.com>
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.
hth
Alan Bort
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.
>
> regards,
>
> Freek D'Hooge
> Uptime
> Oracle Database Administrator
> e-mail: freek.dhooge_at_uptime.be
> tel. +32 (0)3 451 23 82
> http://www.uptime.be
> disclaimer
> ________________________________________
> 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
> --
> http://www.freelists.org/webpage/oracle-l
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 04 2009 - 04:36:33 CST