If one of your junior DBAs informed you that he accidentally deleted the datafile USR1ORCL.ORA using an operating system command, what might you do? Since you know the database is currently open, you must determine to which tablespace the datafile belongs. Click the View Code button to see the command.
From the results of the command, you find out that the removed datafile USR1ORCL.ORA does not belong to the system or rollback segment tablespaces. In this case, the best option for recovery, is to use the method recover open database, initially open.
The following SlideShow walks you through the steps of the recover open database, initially open method.
You may also preview all steps