FORCE LOGGING
logging force
2023-09-14 08:59:32 时间
- 如何将数据库设置成FORCE LOGGING模式?
- 执行此命令可以在mount或者Open状态都可以.假如在open状态执行此命令,执行过程会消耗很长时间;推荐在mount状态下执行.
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信息
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
相关文章
- 常见java日志系统的搭配详解:关于slf4j log4j log4j2 logback jul jcl commons-logging jdk-logging
- 使用python的logging模块(转)
- logging.basicConfig参数简介
- [Javascrip] Logging Timing Data to the Console
- [RxJS] Logging a Stream with do()
- python中日志logging模块的性能及多进程详解
- [Node.js] Add Logging to a Node.js Application using Winston
- Py之logging:logging的简介、安装、使用方法之详细攻略
- 最棒总结,Python日志库 logging 使用指南来了
- 使用 Python 中 logging 模块,抛弃print吧
- logging模块配置笔记
- logging模块的使用
- Java:日志输出JDK Logging、commons-logging、log4j、SLF4J、Logback
- springBoot Logging 日志详解
- Docker中mysql启动错误Could not open file ‘/var/log/mysqld.log‘ for error logging: Permission denied
- 解决办法:Could not load file or assembly 'Microsoft.Practices.EnterpriseLibrary.Logging