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