OCP CBT Question 639
Please solve the following question.
A critical data file (`/u01/app/oracle/oradata/ORCL/users01.dbf`) belonging to the USERS tablespace has been corrupted. The database is in ARCHIVELOG mode. You have a full backup from two days ago and daily incremental level 1 backups. What is the correct sequence of RMAN commands to recover only the corrupted data file to the latest possible point?
The database is currently open. The corrupted data file is file #4.
NAME STATUS
------------------------------------------------- ------
/u01/app/oracle/oradata/ORCL/users01.dbf RECOVER
SQL> ALTER SYSTEM CHECK DATAFILES; -- Identifies corruption
System altered.```