Oracle 参数 LOB_SIGNATURE_ENABLE 官方解释，作用，如何配置最优化建议
本站中文解释
该参数是在11g中引入的，控制是否收集Binary大对象的签名以帮助RMAN介质管理器侦测成功恢复的LOBs。
1. LOB_SIGNATURE_ENABLE：
该参数是Oracle 11g中引入的参数，控制是否收集Binary LOB (BLOB)的签名以帮助RMAN（Recovery Manager）介质管理器侦测成功恢复的LOBs。该参数默认取值是FALSE，表示禁用LOB Signature，也就是不收集BLOB的签名。
2. 如何正确设置：
要正确设置LOB_SIGNATURE_ENABLE参数，应当取值TRUE，这样RMAN就会在RMAN备份期间收集Binary LOB的签名，以便RMAN介质管理器侦测成功恢复这些BLOB。设置参数的SQL语句为：
ALTER SYSTEM SET LOB_SIGNATURE_ENABLE=TRUE SCOPE=SPFILE;
官方英文解释
LOB_SIGNATURE_ENABLE is used to enable or disable the LOB locator signature feature.
| Property | Description |
|---|---|
|
Parameter type |
Boolean |
|
Default value |
|
|
Modifiable |
|
|
Modifiable in a PDB |
Yes |
|
Range of values |
|
|
Basic |
No |
|
Oracle RAC |
Multiple instances must have the same value. |
You can secure your LOBs by enabling the LOB locator signature feature. A LOB locator is a pointer to the location of a large object (LOB) value. If the LOB_SIGNATURE_ENABLED initialization parameter is set to true, then when you create a LOB, Oracle Database automatically assigns a signature to the LOB locator. When Oracle Database receives a request from a client, it uses the signature to determine if any tampering with the LOB locator has occurred.
When this parameter is set to true, you also have the option of further securing your LOBs by encrypting your LOB locator signature keys.
See Also:
Oracle Database Security
Guide for more information on LOB locator signatures and encrypting LOB locator signature keys
