Important Notice

Owned by Anton Els (Deactivated)
Last updated: Jun 06, 2013Version comment
1 min read

Oracle strongly recommends that all NOLOGGING operations be avoided in the primary database. Oracle will not be able to keep the standby database consistent with the primary database during nologging operations. To ensure this does not happen, Oracle introduced the command (version 9i and above):

SQL> ALTER DATABASE FORCE LOGGING;

This ensures that all database write operations are logged and the standby database will be consistent.