FORCE LOGGING

如何将数据库设置成FORCE LOGGING模式?
- 执行此命令可以在mount或者Open状态都可以.假如在open状态执行此命令，执行过程会消耗很长时间；推荐在mount状态下执行.

SQL>ALTER DATABASE FORCE LOGGING;

View Code

FORCE LOGGING Mode

FORCE LOGGING mode is recommeded to ensure data consistency.
FORCE LOGGING forces redo to be generated even when NOLOGGING operations are executed.
Tempory tablespaces and temporary segments are not logged.
FORCE LOGGING is recommended for both physical ad logical standby databases.
Issue the following command on the primary databse:

SQL>ALTER DATABASE FORCE LOGGING;

从数据库动态性能视图中查看关于FORCE LOGGING信息

SQL> col name format a30
SQL> col database_name format a30
SQL> col force_logging format a30
SQL> select name,database_role,force_logging from v$database;

NAME                           DATABASE_ROLE    FORCE_LOGGING
------------------------------ ---------------- ------------------------------
ARCERZHA                       PRIMARY          NO

View Code