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
validate database does not check for inter block corruptions. It checks for corrupt control file/spfile
Hence correct Ans are A,C
A and C.
Check http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta2024.htm#RCMRF162
A, C – TRUE
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
http://docs.oracle.com/database/121/BRADV/rcmvalid.htm#BRADV994
check documentation in 12 version not 11 !!!
sorry error
A, D – TRUE
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
http://docs.oracle.com/database/121/BRADV/rcmvalid.htm#BRADV994
check documentation in 12 version not 11 !!!
JanK, the document you posted says;
“Only DBVERIFY and the ANALYZE statement detect interblock corruption.”
So, isn’t it A and C are correct answers?
My opition: A and C
From the 12 documentation:
The VALIDATE command checks for intrablock corruptions only.
http://docs.oracle.com/database/121/RCMRF/rcmsynta2025.htm#RCMRF162
By default, the VALIDATE command checks for physical corruption only. You can specify CHECK LOGICAL to check for logical corruption as well. RMAN populates the V$DATABASE_BLOCK_CORRUPTION view with its findings.
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.
So, RMAN VALIDATE checks INTRABLOCK corruption with either PHYSICAL by default or LOGICAL with “CHECK LOGICAL” optioin.
The VALIDATE command checks for intrablock corruptions only.
FYI….But the VALIDATE command with CHECK LOGICAL checks for interblock corruptions as well.
So, A and C are correct.
AC
sorry my mestake:
AC – OK
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.
The VALIDATE command checks for intrablock corruptions only.
https://docs.oracle.com/database/121/RCMRF/rcmsynta2025.htm#RCMRF162
AC
Use the VALIDATE command to check for corrupt blocks and missing files, or to determine whether a backup set can be restored.
In a physical corruption, the database does not recognize the block at all. In a logical corruption, the contents of the block are logically inconsistent. By default, the VALIDATE command checks for physical corruption only. You can specify CHECK LOGICAL to check for logical corruption as well. RMAN populates the V$DATABASE_BLOCK_CORRUPTION view with its findings.
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.
Only DBVERIFY and the ANALYZE statement detect interblock corruption.
VALIDATE command checks for the controlfile and spfile status and their proper locations.
Anserws: A, C
Logical does not mean interblock, only DBVERIFY and ANALYZE support interblock checking
AC
It does not check interblock corruption.
Agree with J Antonio, interblock does not mean logical corruption, as intrablock can either be physical or logical corruption. Interblock can only be logical corruption though.
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.