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

FORCE LOGGING_执行过程FORCE LOGGING_sql_02


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信息


FORCE LOGGING_执行过程FORCE LOGGING_sql_02


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