Use
You can change the
log mode for the current database instance.Prerequisites
The database instance may be in any mode.
The current log mode is DUAL.
You can only change the log mode if the DEMO variant of the current log mode is deactivated (
Procedure
Under New LogMode, select the option SINGLE.
To change the log mode in the parameter file of the database instance, you must restart the database instance. If you are not in OFFLINE mode, select the option
Restart Database implicitly after LogMode change.
Confirm your entries.
Choose LogMode ® Change LogMode.
Result
The new log mode SINGLE is displayed as the current log mode.