This content has been marked as final. Show 1 reply
Hello again and Happy New Year.
No your data is not unprotected. DB_LOST_WRITE_PROTECT performs another layer of validation on the Standby Database. It will attempt to detect corrupted blocks in redo data.
This parameter is Oracle 11. It is part of "Recommendations for High Availability and Fast Recoverability" along with:
You can set the DB_ULTRA_SAFE parameter and it will automatically controls the behavior of the following parameters:
However if you set any of those in your init file then the DB_ULTRA_SAFE parameter has no effect. DB_ULTRA_SAFE is probably not the best idea as it can reduce the throughput of Redo Apply.
Set DB_LOST_WRITE_PROTECT=TYPICAL on the standby database. Lost write protection prevents corruptions on the primary from being propagated and applied to the standby database.
DB_BLOCK_CHECKING should probably be set only on the primary side.
DB_BLOCK_CHECKSUM can be set on Standby side.
If it helps I have 9 production Data Guard systems and I currently don't use any of these parameters.