You are told that a datafile is corrupt and needs recovery. You have already connected to database ORCL as sysdba. To find the file
needing recovery, you query the data dictionary view V$RECOVER_FILE. Type SELECT * FROM V$RECOVER_FILE; at the prompt and press
At this time, you may want to find the name for datafile #5. To do this, you query the DBA_DATA_FILES view. Type SELECT FILE_NAME
FROM DBA_DATA_FILES WHERE FILE_ID = 5; at the prompt and press Enter.
Now you need to find out what log files are needed for the recovery. Type SELECT * FROM V$RECOVERY_LOG; at the prompt and press
Now you have the information about the files you need for recovery. This is the end of the Simulation. Click the Exit button.