该参数是Oracle 11g新增的参数。
DB_ULTRA_SAFE参数整合了DB_BLOCK_CHECKING, DB_BLOCK_CHECKSUM, 和 DB_LOST_WRITE_PROTECT三个参数。
DB_ULTRA_SAFE ={ OFF | DATA_ONLY | DATA_AND_INDEX },默认值为OFF。
当DB_ULTRA_SAFE 设置为:
(1)OFF:
When any of DB_BLOCK_CHECKING, DB_BLOCK_CHECKSUM, or DB_LOST_WRITE_PROTECT areexplicitly set, no changes are made.
--不改变这三个参数的值。
(2)DATA_ONLY:
三个参数会按照如下方式进行修改:
DB_BLOCK_CHECKING will be set to MEDIUM.
DB_LOST_WRITE_PROTECT will be set to TYPICAL.
DB_BLOCK_CHECKSUM will be set to FULL.
(3)DATA_AND_INDEX:
三个参数会按照如下方式进行修改:
DB_BLOCK_CHECKING will be set to FULL.
DB_LOST_WRITE_PROTECT will be set to TYPICAL.
DB_BLOCK_CHECKSUM will be set to FULL.
查看db_ultra_safe 参数:show parameter db_ultra_safe
修改db_ultra_safe 为data_only:
alter system setdb_ultra_safe=data_only scope=spfile; --需要重启实例