52.You have the following requirements in relation to the detection of block corruption for your database instance:
Check for logical self-consistency of data blocks when modified in memory.
Checksums are calculated before and after the block change.
Checks are performed for the lost writes to the physical standby database.
Which method would help you perform the above checks automatically?
A. Set the DB_SECUREFILE parameter to PERMITTED.
B. Set the DB_ULTRA_SAFE parameter to DATA_ONLY.
C. Set the DB_LOCK_CHECKSUM parameter to TYPICAL.
D. Set the DB_LOST_WRITE_PROTECT parameter to TYPICAL.
Answer: B
参考:
http://docs.oracle.com/cd/E11882_01/server.112/e40402/initparams069.htm#REFRN10295
关于检测你的数据库实例的块损坏有以下要求:
当在内存中修改时,检查数据块的逻辑自洽。
在块变化之前和之后计算校验和。
执行检查用于丢失写入到物理备用数据库。
哪种方法,帮助您自动执行上述检查?
B、设置数据DB_ULTRA_SAFE参数为DATA_ONLY。
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/81227/viewspace-2123435/
,如需转载,请注明出处,否则将追究法律责任。