Re: Standby on Same box

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@xxxxxxxxx> 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@xxxxxxxxx
> tel. +32 (0)3 451 23 82
> http://www.uptime.be
> disclaimer
> ________________________________________
> From: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] On Behalf 
> Of Howard Latham [howard.latham@xxxxxxxxx]
> Sent: 03 February 2009 20:00
> To: Maureen English
> Cc: oracle-l@xxxxxxxxxxxxx
> 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@xxxxxxxxxxxxxxxx> 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-l


Other related posts: