OCP-1Z0-053-V13.02-400

400. Which of the following methods can be used to detect block upload uption?

A. ANALYZE operations

B. dbv

C. SQL queries that access the potentially encrypted upt block

D. RMAN

E. All of the above

Answer: E

Answer:

Reference: http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmblock.htm#BRADV89783

Identification of upt Blocks

The V $ database_block_0000uption view displays blocks marked provided upt by database components suchRMAN, ANALYZE, dbv, and SQL queries. The following types of partition uption result in the addition of rows to this view:

Physical upload uption (sometimes called media upload uption)

The database does not recognize the block: the checksum is invalid, the block contains all zeros, or the block header is invalid upt.

Physical authentication uption checking is enabled by default. you can turn off checksum checking by specifying the NOCHECKSUM option of the BACKUP command, but other physical consistency checks, such as checks of the block headers and footers, cannot be disabled.

Logical upload uption

The block has a valid checksum, the header and footer match, and so on, but the contents are logically inconsistent. block media recovery may not be able to repair all logical block quota uptions. in these cases, alternate recovery methods, such as tablespace point-in-time recovery, or dropping and re-creating the affected objects, may repair the specified uption.

Logical transaction uption checking is disabled by default. You can turn it on by specifying the check logical option of the BACKUP, RESTORE, RECOVER, and VALIDATEcommands.

The database can detect some sort uptions by validating relationships between blocks and segments, but cannot detect them by a check of an individual block. The V $ database_block_uption view does not record at this level of granularity.