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:
Oracle Database supports different techniques for detecting, repairing, and
monitoring block corruption. The technique depends on whether the corruption is interblock
corruption or intrablock corruption. In intrablock corruption, the corruption occurs within the block
itself. This corruption can be either physical or logical. In an interblock corruption, the corruption
occurs between blocks and can only be logical.
Note:
* The main purpose of RMAN validation is to check for corrupt blocks and missing files. You can
also use RMAN to determine whether backups can be restored. You can use the following RMAN
commands to perform validation:
VALIDATE
BACKUP … VALIDATE
RESTORE … VALIDATE
The validate command checks for intrablock corruption only. It does NOT check for interblock corruption.
A is right, and I think B AND C also…. But that means 3 answers.
In the docu they said: all datafiles, controlfiles and initialization parameter files.
The answer should be A,C
The VALIDATE command checks for intrablock corruptions only.
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.
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
AC are correct
AC
https://docs.oracle.com/database/121/RCMRF/rcmsynta2025.htm#RCMRF162
VALIDATE DATABASE Validates the database.
In a multitenant container database (CDB), validates the whole CDB. Connect to the root as described in “Connecting to CDBs and PDBs”. When connected to a pluggable database (PDB), validates the PDB.
RMAN validates all data files and control files. If the database is currently using a server parameter file, then RMAN validates the server parameter file.
Note: The online redo log files and temp files are not validated.
Only DBVERIFY and the ANALYZE statement detect interblock corruption.
AC
https://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmvalid.htm#BRADV90063
https://docs.oracle.com/database/121/RCMRF/rcmsynta2025.htm#RCMRF162
D is wrong :
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.
C is right
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.
A & C
AC