Which two statements are true about the RMAN validate database command?
A.
It checks the database for intrablock corruptions.
B.
It can detect corrupt pfiles.
C.
It can detect corrupt spfiles.
D.
It checks the database for interblock corruptions.
E.
It can detect corrupt block change tracking files.
Explanation:
Block corruptions can be divided Into Interblock corruption and intrablock corruption. In intrablock
corruption. th« corruption occurs within the block itself and can be either physical or logical
corruption. In interblock corruption, the corruption occurs between blocks and can only be logical
corruption.
(key word) * The VALIDATE command checks for intrablock corruptions only. Only DBVERIFY
and the ANALYZE statement detect Interblock corruption.
VALIDATE Command Output ••> List of Control File and SPFILE.
File TYPE >»» SPFILE or Control File.
Status >»» OK if no corruption, or FAILED If block corruption is found.
Blocks Failing »»» The number of blocks that fail the corruption check. These
blocks are newly corrupt.
Blocks Examined »»» Total number of blocks in the file.
Oracle’ Database Backup and Recovery User’s Guide
12c Release 1 (12.1) – 16 Validating Database Files and Backups
A and C are correct-
http://docs.oracle.com/database/121/RCMRF/rcmsynta2025.htm#RCMRF90393
Block corruptions can be divided into interblock corruption and intrablock corruption. In intrablock corruption, the corruption occurs within the block itself and can be either physical or logical corruption. In interblock corruption, the corruption occurs between blocks and can only be logical corruption. The VALIDATE command checks for intrablock corruptions only.
*
Block corruptions can be divided into interblock corruption and intrablock corruption. In intrablock corruption, the corruption occurs within the block itself and can be either physical or logical corruption. In interblock corruption, the corruption occurs between blocks and can only be logical corruption. The VALIDATE command checks for intrablock corruptions only.
*
VALIDATE Command Output:
List of Control File and SPFILE
===============================
File Type Status Blocks Failing Blocks Examined
———— —— ————– —————
SPFILE OK 0 2
Control File OK 0 506
Finished validate at 26-FEB-13
validateObject
This subclause specifies database files for validation. Refer to validateObject::= for syntax.
SPFILE Validates the server parameter file currently used by the database. RMAN cannot validates other copies of the server parameter file, and cannot validate the server parameter file when the instance was started with an initialization parameter file.
см. доку: http://docs.oracle.com/database/121/RCMRF/rcmsynta2025.htm#RCMRF90393
A C