前面介绍了Oracle的基本参数，从这节开始讲其他的参数，参数从v$parameter中提取 基本参数请看如下链接: [http://www.zhaibibei.cn/oralce/oracle-parameter/](http://www.zhaibibei.cn/oralce/oracle-parameter/) 如无特殊说明数据库版本为11.2 ------- **log_archive_trace** [image:382 size:orig] 1. 参数类型:整型 2. 默认值: 0 4. 修改:修改不需要重启数据库 5. 取值范围: 0, 1, 2, 4, 8, 16, 32, 64, 128, 256, 512, 1024, 2048, 4096, 8192 5. 基本参数:否 6. RAC中各实例可以是不同值 ------ **取值意义** 该参数控制归档进程生成的的输出，如: - 一个 ARCn 后台进程 (日志输出中出现ARCn 字样) - 一个显式的会话调用的前台进程(日志输出中出现ARCH 字样) 具体级别对用的输出如下 - 0: Disable archivelog tracing (this is the default) - 1: Track archival of redo log file - 2: Track archival status of each archivelog destination - 4: Track archival operational phase - 8: Track archivelog destination activity - 16: Track detailed archivelog destination activity - 32: Track archivelog destination parameter modifications - 64: Track ARCn process state activity - 128: Track FAL (fetch archived log) server related activities - 256: Track RFS Logical Client - 512: Track LGWR redo shipping network activity - 1024: Track RFS Physical Client - 2048: Track RFS/ARCn Ping Heartbeat - 4096: Track Real Time Apply - 8192: Track Redo Apply (Media Recovery or Physical Standby) 其中后面的数字包含前面数字代表的内容 动态调整后下次输出生效 -------- **举例说明** - 0 [image:383 size:orig] - 1 [image:384 size:orig] - 2 [image:385 size:orig] ----- --------- **实际截图：** [image:386 size:orig] ----- **参考连接** [https://docs.oracle.com/cd/E18283_01/server.112/e17110/initparams128.htm](https://docs.oracle.com/cd/E18283_01/server.112/e17110/initparams128.htm) ---------- 下期参数 **log_archive_config**