1.326 STANDBY_DB_PRESERVE_STATES
STANDBY_DB_PRESERVE_STATES
controls whether user sessions and other internal states of the instance are retained when a readable physical standby database is converted to a primary database. This parameter is meaningful on a physical standby database that is open in real-time query mode.
Property | Description |
---|---|
Parameter type |
String |
Syntax |
|
Default value |
|
Modifiable |
No |
Modifiable in a PDB |
No |
Basic |
No |
Oracle RAC |
The same value must be used on all instances. |
The possible values for the parameter are NONE
, SESSION
, and ALL
. The default is NONE
, meaning nothing is retained and all sessions are disconnected. When this parameter is set to SESSION
or ALL
, user sessions are retained when a readable physical standby database is converted to primary. When the database is reopened as the primary, the suspended sessions resume their operations as if nothing had happened. If the database (or an individual PDB) is not opened in the primary role, the sessions will be terminated.
Note:
Sessions that have long running queries or are using database links will not be retained regardless of the setting of this parameter.
See Also:
-
Oracle Data Guard Concepts and Administration for more information about real-time query mode
-
Oracle Data Guard Concepts and Administration for more information about preserving user sessions when a standby is converted to primary