2.96 DB_RECOVERY_AUTO_REKEY

Use DB_RECOVERY_AUTO_REKEY to enable or disable automatic tablespace rekey recovery on Oracle Data Guard standby instances.

Property	Description
Parameter type	String
Syntax	DB_RECOVERY_AUTO_REKEY = { ON | OFF }
Default value	ON
Modifiable	ALTER SYSTEM
Modifiable in a PDB	No
Basic	No
Oracle RAC	Multiple instances should use the same value.

This parameter is effective when Oracle Data Guard standby recovery encounters a redo that indicates that the primary database performed a tablespace rekey. If the value of this parameter is ON, then standby recovery automatically performs the corresponding tablespace rekey. If the value of this parameter is OFF, then standby recovery does not perform a tablespace rekey.

Note:

This parameter is available starting with Oracle Database 23ai.