RSS:
Publications
Comments

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.


Leave a Reply

You can use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>