Primary instandce terminated in max performance mode.

From: ennarr <n_ravee_at_yahoo.com>
Date: 27 Jul 2005 06:02:41 -0700
Message-ID: <1122469361.300742.232350@z14g2000cwz.googlegroups.com>

We have a standby database setup on DB version 9.2.0.4.0. Primary init.ora setting for standby destination is

log_archive_dest_2='SERVICE=STBY LGWR ASYNC=40960'
log_archive_dest_state_2='ENABLE'
log_archive_min_succeed_dest is not set but by default it is 1.

SQL> show parameter min_succ

NAME TYPE VALUE
------------------------------------ -----------

---

log_archive_min_succeed_dest integer 1 SQL> We had 4 redo log files on the Primary.
We took the Shutdown of the standby with out setting the log_archive_dest_state_2 to DEFER.

SQL> select PROTECTION_MODE,PROTECTION_LEVEL from v$database;

PROTECTION_MODE PROTECTION_LEVEL

-------------------- --------------------

MAXIMUM PERFORMANCE MAXIMUM PERFORMANCE The primary database stopped after completing one cycle of the redo logs with the error
PMON: terminating instance due to error 16024 in the alert log.

When the database is with the above settings the primary instance should not be terminated is it not?

By default log_archive_dest_2 is OPTIONAL when "MANDATORY" is not set. Then why should the instance halt?
Am I missing any parameters?

Thanks
Ravi Received on Wed Jul 27 2005 - 08:02:41 CDT