V$DATABASE column PROTECTION_MODE on Standby db in 10g

From: <robin.halabicki_at_gmail.com>
Date: 21 Nov 2006 09:10:10 -0800
Message-ID: <1164129010.681920.291480@m73g2000cwd.googlegroups.com>

In 9i on the standby, querying the v$database we get:

SQL> select open_mode, SWITCHOVER_STATUS, GUARD_STATUS, PROTECTION_MODE, PROTECTION_LEVEL from v$database;

OPEN_MODE SWITCHOVER_STATUS GUARD_S PROTECTION_MODE PROTECTION_LEVEL

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


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

MOUNTED SESSIONS ACTIVE NONE MAXIMUM PERFORMANCE MAXIMUM PERFORMANCE In 10g on the standby, querying the v$database we get: SQL> select open_mode, SWITCHOVER_STATUS, GUARD_STATUS, PROTECTION_MODE, PROTECTION_LEVEL from v$database;

OPEN_MODE SWITCHOVER_STATUS GUARD_S PROTECTION_MODE PROTECTION_LEVEL

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


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

MOUNTED    SESSIONS ACTIVE      NONE    UNPROTECTED

UNPROTECTED Now, I "get" that the standby itself isn't protected, so that to me makes the 10g logical. However, I do not understand why it changed. I can't find anything in metalink or the docs (point it out if you do). Received on Tue Nov 21 2006 - 11:10:10 CST