EDIT DATABASE RESET (Parameter)

The EDIT DATABASE RESET (Parameter) command resets the specified database initialization parameter for the named database to its default value.

Format

EDIT DATABASE <db_unique_name> RESET PARAMETER <parameter_name>;

Command Parameters

db_unique_name

The DB_UNIQUE_NAME initialization parameter value of the database whose parameter value is to be reset.

parameter_name

The name of an existing database initialization parameter whose value that must be reset.

Command Example

The following example shows how to reset the log_archive_trace parameter for the database named South_Sales.

DGMGRL> EDIT DATABASE 'South_Sales' RESET PARAMETER log_archive_trace;
Succeeded.
 

Example 2: Adding additional LAD attributes

DGMGRL> EDIT DATABASE dgremoteb RESET PROPERTY additionalladattributes='REDO_PRIORITIZATION_WHEN_TRANSPORT_LAGS_BY_SEC=20';
Property "AdditionalLadAttributes" updated for member "dgremoteb".

DGMGRL> SHOW DATABASE dgremoteb additionalladattributes 
AdditionalLadAttributes = 'REDO_PRIORITIZATION_WHEN_TRANSPORT_LAGS_BY_SEC=20';

The primary database LAD for standby database dgremoteb now contains the specified additional LAD attribute: