Getting Error while opening database

[Manisha Chowdhary]

Hello,

I have newly created a Database and when i try to open it back its getting mounted but not opening
It shows the following error
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: '/u006/backup/system01.dbf'

Please help me!!!!!!!!!!!!!!!

Regards
Manisha

[nico5038]

There are two types of solutions for an ORA-1157:

I. THE DATAFILE IS LOST OR TOO DAMAGED
-----------------------------------------------------------------------------
In this case, the solution depends on the tablespace to which the datafile belongs. Look for a Solution Reference matching the type of datafile lost.


II. THE DATAFILE HAS SIMPLY BEEN MOVED OR RENAMED
-----------------------------------------------------------------------------------------------------
If you originally wanted to change the name/location of the file, look for the Solution Reference on how to rename datafiles inside Oracle. If the file has been moved or renamed by mistake, simply restore it to its original name/location and startup the database.

Nevertheless, you doublechecked that the path and filename. Do you check the attributes of the file ? Could someone changed it to read only ?

Also, it seems that datafile contains rollback segments. Check the status of the tablespaces contained in that datafile (use the dba_tablespaces table). If the status is missing and, as I'm guessing, contains rollback segments try to drop that segments, then the tablespace and recreate the datafile, tablespaces and segments.

Nic;o)