RE: Standby on Same box
Date: Tue, 3 Feb 2009 21:08:38 +0100
Message-ID: <AF9ECF804B2F294BB43BC5063302658F2619D18DEE_at_ws03-exch07.iconos.be>
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-lReceived on Tue Feb 03 2009 - 14:08:38 CST