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.
I have attended Ask Tom Live seminar about 11g Rel2 at Tokyo, Japan. Do you believe it I have got an opportunity to take a snap with him. I am very happy to share with you.