Purpose
The purpose of this parameter is to see instant file corruption on disk then DBA takes action against the issue.
Usage
Current setting:
SQL> show parameter db_ultra_safe;
-- default is "OFF"
Change setting (options -> OFF | DATA_ONLY | DATA_AND_INDEX):
add this into init.ora file;
*.db_ultra_safe='DATA_ONLY'
-- DB_BLOCK_CHECKING, DB_BLOCK_CHECKSUM, and DB_LOST_WRITE_PROTECT parameter are set by automatically according to db_ultra_safe parameter setting.
Then restart the instance to perform.
Result
SQL> show parameter db_ultra_safe;
-- output; data_only
Ref: https://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams064.htm#REFRN10295
The purpose of this parameter is to see instant file corruption on disk then DBA takes action against the issue.
Usage
Current setting:
SQL> show parameter db_ultra_safe;
-- default is "OFF"
Change setting (options -> OFF | DATA_ONLY | DATA_AND_INDEX):
add this into init.ora file;
*.db_ultra_safe='DATA_ONLY'
-- DB_BLOCK_CHECKING, DB_BLOCK_CHECKSUM, and DB_LOST_WRITE_PROTECT parameter are set by automatically according to db_ultra_safe parameter setting.
Then restart the instance to perform.
Result
SQL> show parameter db_ultra_safe;
-- output; data_only
Ref: https://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams064.htm#REFRN10295