and if your application supports it, at least some versions of, for example, SAP don't - mind you that particular example is pretty bad (unless you are a consultant) because SAP allows you to run with a standby but expects you to get support from elsewhere :). I Niall On Tue, Feb 3, 2009 at 12:38 PM, D'Hooge Freek <Freek.DHooge@xxxxxxxxx>wrote: > 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@xxxxxxxxx > tel +32(0)3 451 23 82 > http://www.uptime.be > > > ________________________________________ > From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] > On Behalf Of Niall Litchfield > Sent: dinsdag 3 februari 2009 13:32 > To: howard.latham@xxxxxxxxx > Cc: oracle-l@xxxxxxxxxxxxx > 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 > > -- Niall Litchfield Oracle DBA http://www.orawin.info