ORACLE DATABASE FORCE LOGGING

 July 20,2009
 KeyWord: ORACLE DATABASE, FORCE LOGGING
 [NO] FORCE LOGGING
 Use this clause to put the database into or take the database out of FORCE LOGGING mode. The database must be mounted or open.
 In FORCE LOGGING mode, Oracle Database logs all changes in the database except changes in temporary tablespaces and temporary segments. This setting takes precedence over and is independent of any NOLOGGING or FORCE LOGGING settings you specify for individual tablespaces and any NOLOGGING settings you specify for individual database objects.
 If you specify FORCE LOGGING, Oracle Database waits for all ongoing unlogged operations to finish.
 ALTER DATABASE FORCE LOGGING;
 ALTER DATABASE NO FORCE LOGGING;
 SELECT FORCE_LOGGING FROM V$DATABASE;