Hi team list,

What is the purpose of "ALTER SYSTEM CHECK DATAFILES" command and when to use it?
I have tried something like below :

SQL>alter database datafile '/u01/oradata/TBSTEST/test_02.dbf' offline ;

Database altered.

SQL>alter system check datafiles ;

System altered.

So even there is no alert file created from this command.

Your inputs are appreciated

TIA