Re: Standby DB Question

From: Paul Drake <paled_at_home.com>
Date: Sat, 16 Jun 2001 19:37:43 GMT
Message-ID: <3B2BB574.76621BDB@home.com>

"Howard J. Rogers" wrote:
> Incorrect. Activate standby database puts the standby database into full
> production mode. READ THE DOCUMENTATION!!
>

uh - he gets the
'sqlplus> drop tablespace system including contents;' award.

This is exactly the problem with a "managed standby" mentality. "Oracle will do everything for me - I don't really need to know what is going on."

Wrong.
Even in 9i - the database won't manage everything itself.

If you don't understand how to "manage" your standby database - contract it out or hire the expertise. Buying Enterprise Edition and using "Managed Standby Database" is not a complete solution.

If you are daring enough to learn - this is a good start: http://otn.oracle.com
http://otn.oracle.com/docs/products/oracle8i/doc_index.htm

Oracle8i Standby Database Concepts and Administration Release 2 (8.1.6) Part Number A76995-01
and if you're running 8.1.7:
Oracle8i Documentation Addendum Release 3 (8.1.7) Part Number A85455-01

Also -

SQL> ALTER DATABASE ACTIVATE STANDBY DATABASE; does not actually open the database for production. You must shutdown the database (immediate is fine) and open it as either read-only (unlikely, as it has already been activated)
or as read-write.

good luck.

Paul Received on Sat Jun 16 2001 - 14:37:43 CDT