Data Guard / Far Sync Best Practice - control protection levels

I have just came across a meta parameter called DB_ULTRA_SAFE that sets the values for all of 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.

Comments

Popular posts from this blog

Fixing & Registering ORACLE_HOMES in Central Inventory

List RMAN backups size

AWR Generating & Setting