Re: Sounds good in theory, but will it work?

That is scary to me, we never allow a standby to activate itself. If we are in a true DR type situation we want to manually bring them up ourselves. A loss of network connectivity could easily cause a problem to happen, and unless they are using the once unsupported then later supported method for swapping standby's in 8i, you only get to activate the database once and then you have to start rebuilding the original standby, a huge pain.

Honestly, I would suggest contracting out the work to get a standby built in another server for you. You can do it your way, restore the filesystems and then use RMAN to restore the DB (long outage), or build an 8i standby (best option).

I work for a company that does contract work to small/medium IT companies and we have built out 8i standby's for other people. You would be looking at about 10-20 hours labor costs as long as the other server was built out in advanced. This would include design, scripting, documenting, and testing. Shouldn't be a big deal price wise to get a good, correctly built solution. You should be able to find a qualified contractor DBA that still knows how to do an 8i standby pretty easily.

Mike Fullerton
Mladen Gogala wrote:
> On Thu, 09 Nov 2006 12:21:10 +0000, Richard Foote wrote:
>
> > No but the good old Standby database did exist and could serve these
> > purposes quite well.
>
> I was hired once to untangle old spaghetti Perl code used to copy redo
> logs on Oracle8 databases and it has had feature that current data guard
> does not have: it would activate the database if it detected that the
> primary is out.
> I don't know how useful is that, especially if you need to do maintenance
> from time to time, but it was a plug-in replacement for DG and it was
> quite ingenious.
>
> --
> http://www.mladen-gogala.com
Received on Thu Nov 09 2006 - 09:07:57 CST