Data Guard / Far Sync Best Practice – Control Protection Levels

Data Guard / Far Sync Best Practice – Control Protection Levels

The following meta parameter, called DB_ULTRA_SAFE, sets the values for all of the mentioned parameters in Far Sync Best Practice Recommendations (for Oracle 12.1).

When DB_ULTRA_SAFE=DATA_ONLY
• DB_BLOCK_CHECKING => MEDIUM.
• DB_LOST_WRITE_PROTECT => TYPICAL.
• DB_BLOCK_CHECKSUM => FULL.

When DB_ULTRA_SAFE=DATA_AND_INDEX
• DB_BLOCK_CHECKING => FULL.
• DB_LOST_WRITE_PROTECT => TYPICAL.
• DB_BLOCK_CHECKSUM => FULL.

When DB_ULTRA_SAFE=OFF
• When any of DB_BLOCK_CHECKING, DB_BLOCK_CHECKSUM, or DB_LOST_WRITE_PROTECT are explicitly set, no changes are made.