To resume logging, issue the following statement:

The SET LOGGING statement re-enables logging for a session for which the SET NOLOGGING statement was issued.

After SET LOGGING is executed, automatic database recovery is again guaranteed.

If you use SET NOLOGGING on a journaled database, take a new checkpoint immediately after completion of the SET LOGGING operations to establish a new base from which to journal updates.

When a session operation in SET NOLOGGING mode disconnects from a database, a SET LOGGING operation is implicitly executed to bring the database to a guaranteed consistent state before completing the disconnect.