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
复制代码

 

 

posted @   ArcerZhang  阅读(396)  评论(0编辑  收藏  举报
点击右上角即可分享
微信分享提示