Re: Help: Standby database config.

Howard J. Rogers wrote:

> Standby databases are meant to protect you from disaster. User errors,
> however inconvenient, are not disasters, and ordinary incomplete recoveries
> are your 'way out' of them. I think it an extremely bad idea to confuse the
> two, and your friend is giving you very poor advice.

Standby databases are not meant to be used any particular way. They can be used however they fit into your architecture. I've seen standby databases also used to facilitate database backups, easily create clones of production databases, failover into new hardware, et. al.

I have a client that has been using standby databases with custom software that we wrote for Oracle 7.0 in 1995. One of the first things we built in was the ability to delay recovery so that we would have a reaction time to deal with dumb things done by users.

We wrote our own mechanism for detecting, copying, and applying redo logs since standby database functionality didn't exist when we needed it. This allowed us to delay or suspend recovery of the standby database while still copying archived redo logs from the production database. If you did need to catch up the standby database, it could be done very quickly since all of the redo was already on the standby database box.

Posted via www.orafocus.com - Focusing on the World of Oracle Received on Mon Jul 02 2001 - 08:42:48 CDT