Re: Taking down a STANDBY database

The simplest thing to do is set the primary database LOG_ARCHIVE_DEST_STATE_n parameter to DEFER, where "n" is the archivelog destination of the standby database (i.e. "alter system log_archive_dest_state_2=defer;"). You can do this dynamically - there is no need to bounce the primary instance.

This allows you to preserve the destination information, so that when you want to turn the standby database back on, you simply set the LOG_ARCHIVE_DEST_STATE_n parameter to ENABLE, and you are off & running.

Hope this helps.

Rick

steve deno wrote:

> I am planning on taking a standby database out of service while
> keeping It's production site in production. (They are both 8.1.7 on
> Solaris.) Am I correct in assuming that all I need to do on the
> Primary side is take the Log_archive_dest_n and
> log_archive_dest_state_n lines out of the init.ora file and restart?