1.311 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

STANDBY_DB_PRESERVE_STATES = { NONE | SESSION | ALL }

Default value

NONE

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.

Note:

This initialization parameter is available starting with Oracle Database 12c Release 2 (12.2.0.1).

See Also: