FORCE LOGGING
- 如何将数据库设置成FORCE LOGGING模式?
- 执行此命令可以在mount或者Open状态都可以.假如在open状态执行此命令,执行过程会消耗很长时间;推荐在mount状态下执行.
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
SQL>ALTER DATABASE FORCE LOGGING;
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信息
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
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
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步