RE: Standby on Same box
From: D'Hooge Freek <Freek.DHooge_at_uptime.be>
Date: Tue, 3 Feb 2009 13:38:06 +0100
Message-ID: <AF9ECF804B2F294BB43BC5063302658F2619CF82B1_at_ws03-exch07.iconos.be>
Yes, but if you are on 10g you could use flashback database to recover from a failover without having to rebuild your primary. At least, if your db files are still intact.
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Niall Litchfield Sent: dinsdag 3 februari 2009 13:32
To: howard.latham_at_gmail.com
Cc: oracle-l_at_freelists.org
Subject: Re: Standby on Same box
Date: Tue, 3 Feb 2009 13:38:06 +0100
Message-ID: <AF9ECF804B2F294BB43BC5063302658F2619CF82B1_at_ws03-exch07.iconos.be>
Yes, but if you are on 10g you could use flashback database to recover from a failover without having to rebuild your primary. At least, if your db files are still intact.
Regards,
Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge_at_uptime.be
tel +32(0)3 451 23 82
http://www.uptime.be
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Niall Litchfield Sent: dinsdag 3 februari 2009 13:32
To: howard.latham_at_gmail.com
Cc: oracle-l_at_freelists.org
Subject: Re: Standby on Same box
well for protection against loss of the original box, it's obviously not a great plan! It might provide some protection against logical corruption (the mythical 'junior dba' for example) if configured with a delay.
As far as switchover/switchback goes - that operation doesn't involve a rebuild - though failover does.
Niall Litchfield
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Feb 03 2009 - 06:38:06 CST