oracle arcn 参数,Source of Oracle参数解析(log_archive_trace) - django-\/\/ i K |

前面介绍了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**