Oracle OCP 1Z0 053 Q52(DB_ULTRA_SAFE)
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
DB_ULTRA_SAFE設定為DATA_ONLY有以下影響:
1. DB_BLOCK_CHECKING設定為MEDIUM
https://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams045.htm
All LOW checks are performed, as well as semantic block checking for all non-index-organized table blocks.
2. DB_LOST_WRITE_PROTECT設定為TYPICAL
https://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams058.htm
When the parameter is set to TYPICAL on the primary database, the instance logs buffer cache reads for read-write tablespaces in the redo log, which is necessary for detection of lost writes.
3. DB_BLOCK_CHECKSUM設定為FULL
https://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams046.htm
If set to FULL, DB_BLOCK_CHECKSUM also catches in-memory corruptions and stops them from making it to the disk.
參考:https://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams064.htm
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
DB_ULTRA_SAFE設定為DATA_ONLY有以下影響:
1. DB_BLOCK_CHECKING設定為MEDIUM
https://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams045.htm
All LOW checks are performed, as well as semantic block checking for all non-index-organized table blocks.
2. DB_LOST_WRITE_PROTECT設定為TYPICAL
https://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams058.htm
When the parameter is set to TYPICAL on the primary database, the instance logs buffer cache reads for read-write tablespaces in the redo log, which is necessary for detection of lost writes.
3. DB_BLOCK_CHECKSUM設定為FULL
https://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams046.htm
If set to FULL, DB_BLOCK_CHECKSUM also catches in-memory corruptions and stops them from making it to the disk.
參考:https://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams064.htm
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/8520577/viewspace-2076125/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle OCP 1Z0 053 Q650Oracle
- Oracle OCP 1Z0 053 Q324Oracle
- Oracle OCP 1Z0 053 Q27Oracle
- Oracle OCP 1Z0 053 Q49Oracle
- Oracle OCP 1Z0 053 Q10Oracle
- Oracle OCP 1Z0 053 Q685Oracle
- Oracle OCP 1Z0 053 Q454Oracle
- Oracle OCP 1Z0 053 Q500Oracle
- Oracle OCP 1Z0 053 Q444(Scheduler)Oracle
- Oracle OCP 1Z0 053 Q440(Scheduler)Oracle
- Oracle OCP 1Z0 053 Q601Oracle
- Oracle OCP 1Z0 053 Q472(Locale)Oracle
- Oracle OCP 1Z0 053 Q525(ASM)OracleASM
- Oracle OCP 1Z0 053 Q292(NFS)OracleNFS
- Oracle OCP 1Z0 053 Q538(ASM)OracleASM
- Oracle OCP 1Z0 053 Q416Oracle
- Oracle OCP 1Z0 053 Q648(Flashback)Oracle
- Oracle OCP 1Z0 053 Q520Oracle
- Oracle OCP 1Z0 053 Q607Oracle
- Oracle OCP 1Z0 053 Q500(Rman)Oracle
- Oracle OCP 1Z0 053 Q707Oracle
- Oracle OCP 1Z0 053 Q28(INCREMENTAL)OracleREM
- Oracle OCP 1Z0 053 Q332Oracle
- Oracle OCP 1Z0 053 Q269Oracle
- Oracle OCP 1Z0 053 Q83(Flashback Database)OracleDatabase
- Oracle OCP 1Z0 053 Q344(V$SESSION)OracleSession
- Oracle OCP 1Z0 053 Q558(V$BACKUP)Oracle
- Oracle OCP 1Z0 053 Q427(Transportable Tablespace)Oracle
- Oracle OCP 1Z0 053 Q182(RMAN)Oracle
- Oracle OCP 1Z0 053 Q428(transport database)OracleDatabase
- Oracle OCP 1Z0 053 Q458(Globalization NLSRTL)Oracle
- Oracle OCP 1Z0 053 Q465(NLS Parameters)Oracle
- Oracle OCP 1Z0 053 Q21(RMAN Duplicate)Oracle
- Oracle OCP 1Z0 053 Q600(RMAN BACKUP)Oracle
- Oracle OCP 1Z0 053 Q114Oracle
- Oracle OCP 1Z0 053 Q700(RMAN Duplicate)Oracle
- Oracle OCP 1Z0 053 Q223Oracle
- Oracle OCP 1Z0 053 Q703(Rman Backup)Oracle