此时,如果发现Primary和Standby中的块SCN不一致,说明较小的块存在写丢失,会主动抛出错误。
可以通过设置DB_ULTRA_SAFE,来同时隐含设置DB_BLOCK_CHECKING, DB_BLOCK_CHECKSUM, DB_LOST_WRITE_PROTECT参数。
点击(此处)折叠或打开
-
Values:
-
-
OFF
-
-
When any of DB_BLOCK_CHECKING, DB_BLOCK_CHECKSUM, or DB_LOST_WRITE_PROTECT are explicitly set, no changes are made.
-
-
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.
-
-
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.
点击(此处)折叠或打开
- alter system set db_ultra_safe='DATA_ONLY' scope=spfile;