Is running the FORCE LOGGING option recommended for Primary and why?


The FORCE LOGGING option is the safest method to ensure all the changes made in the primary database will be captured and available for recovery.

If the number of archives on the primary side is not too big , once you set LOGGING, that signifies a large number of NOLOGGING are being performed on the primary database. The end result is that these operations are not applied to the standby due to no redo information being available for these transactions.

The standby will appear to be up to date, but when these objects are accessed – when standby is open in READ-ONLY mode, roles were changed with the primary or it is activated – you will receive unrecoverable errors.

Our recommendation setting and keeping FORCE LOGGING on primary to protect your standby.

Have more questions? Submit a request