Oct
27
2009
When you start the database you get an error message saying not able start and in Alert log you get the ORA-00376, ORA-01110 error messages
ORA-00376: file 2 cannot be read at this time
ORA-01110: data file 2: ‘D:\ORACLE\ORADATA\ASSETMGT\UNDOTBS01.DBF’
It looks like UNDOTABLESPACE problem.
If you have deleted the file or then you need to recover this file is used for undo space.
Possible solutions are
1. Mount the database.
2. Check the status of the datafile.
3. Recover the datafile. (Do not use alter database, just RECOVER DATAFILE ‘FILESPEC’;
4. Bring datafile online
5. Bring the db up.
