Which of the following methods can be used to detect block corruption?

Which of the following methods can be used to detect block corruption?

Which of the following methods can be used to detect block corruption?

A.
ANALYZE operations

B.
dbv

C.
SQL queries that access the potentially corrupt block

D.
RMAN

E.
All of the above



Leave a Reply 2

Your email address will not be published. Required fields are marked *


Helcio

Helcio

plus query view V$DATABASE_BLOCK_CORRUPTION

Helcio

Helcio

Typically, block corruption is reported in the following locations:

Results of the LIST FAILURE, VALIDATE, or BACKUP … VALIDATE command

The V$DATABASE_BLOCK_CORRUPTION view

Error messages in standard output

The alert log

User trace files

Results of the SQL commands ANALYZE TABLE and ANALYZE INDEX

Results of the DBVERIFY utility

Third-party media management output