CONFIRM THAT THE TABLE IS NOW ACCESSIBLE BY RUNNING THE QUERY FROM STEP 2

7. Confirm that the table is now accessible by running the query from Step 2.

Recovering a Critical Datafile in Archivelog Mode

The datafiles that make up the SYSTEM and the currently active undo tablespace are

considered critical by Oracle, meaning that it is not possible to keep the database

open if they are damaged. The recovery technique is the same as that for a noncritical

datafile, with the exception that the recovery must be done in mount mode because

the database will have crashed and it will not be possible to open it. It is not necessary

to offline the damaged file. The steps are therefore: