This is a discussion on missing datafile within the Oracle Database forums, part of the Database category; HI, I have a database which has been brought down since long time,when i tried to start up the ...
|
|||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
|
|||
|
missing datafile
HI,
I have a database which has been brought down since long time,when i tried to start up the database it shows that the datafile has been missing in the respective path. ************************** SQL> startup open pfile='/data/oracle/appsdata/tf2/IDMSREG/initIDMSREG.ora' ORA-01081: cannot start already-running ORACLE - shut it down first SQL> shutdown ORA-01109: database not open Database dismounted. ORACLE instance shut down. SQL> startup open pfile='/data/oracle/appsdata/tf2/IDMSREG/initIDMSREG.ora' ORACLE instance started. Total System Global Area 269066696 bytes Fixed Size 451016 bytes Variable Size 150994944 bytes Database Buffers 117440512 bytes Redo Buffers 180224 bytes Database mounted. ORA-01157: cannot identify/lock data file 1 - see DBWR trace file ORA-01110: data file 1: '/data/oracle/appsdata/tf2/IDMSREG/data01/IDMSREG_system_01.dbf' ********************************** is there any way to recover the missing datafile. pls help its urg.... |
![]() |
| Thread Tools | |
|
|
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| SQL management studio missing | clementrosario | SQL Server | 0 | 03-16-2008 01:36 PM |
| please answer these questions | isaac_arun | Oracle Database | 1 | 06-13-2007 05:35 AM |
| Missing Files for Exhibits | mbhatt | Certification News | 1 | 06-09-2005 09:11 PM |
| Mahatma Gandhi, the Missing Laureate | sanereddy | Chit-Chat | 3 | 09-23-2004 06:39 PM |