| System datafile is deleted, Urgent help needed!! [message #150761] |
Fri, 09 December 2005 08:59  |
tkiran4u
Messages: 13
Registered: December 2005
|
Junior Member |
|
|
Hi,
Accidently one of my fellow developers deleted the system datafile. Its throwing the following error:
ORA-01116: error in opening database file 10
ORA-01110: data file 10: '/u02/oracle/product/920/syssource.dbf'
ORA-27041: unable to open file
SVR4 Error: 2: No such file or directory
Then I tried the following steps:
SQL> shutdown immediate
ORA-01116: error in opening database file 10
ORA-01110: data file 10: '/u02/oracle/product/920/syssource.dbf'
ORA-27041: unable to open file
SVR4 Error: 2: No such file or directory
Additional information: 3
SQL> shutdown abort
ORACLE instance shut down.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 201938076 bytes
Fixed Size 455836 bytes
Variable Size 83886080 bytes
Database Buffers 117440512 bytes
Redo Buffers 155648 bytes
SQL> alter database mount;
Database altered.
SQL> alter database datafile '/u02/oracle/product/920/syssource.dbf' offline drop;
Database altered.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01147: SYSTEM tablespace file 10 is offline
ORA-01110: data file 10: '/u02/oracle/product/920/syssource.dbf'
Can anybody help me out of this problem...your prompt response is highly appreciated. Thanks in advance.
System tablespace is using both the below datafiles, which I can see in the v$datafile.
SYSTEM - /u03/oracle/db2/sys1db2.dbf
SYSTEM - /u02/oracle/product/920/syssource.dbf
|
|
|
|
|
|
|
|
|
|
| Re: System datafile is deleted, Urgent help needed!! [message #150799 is a reply to message #150761] |
Fri, 09 December 2005 15:46  |
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
|
Senior Member |
|
|
Just some general clues:
1) Do not believe anything I say, because what works for me may not work for you.
2) Do not get yourself in any worse situation than you currently are. Backup what you have right now in case you make it worse while trying to fix it.
3) Check that the tablespace's status is 'online.'
4) Do you still have the datafile that the system tablespace used?
5) Do you have Oracle Support? https://metalink.oracle.com/metalink/plsql/ml2_gui.startup
6) Is this data extremely important so much that you would consider shutting down the computer and having someone recover the datafile that has been deleted. The O/S has not necessarily written over it yet. Most O/S's just mark the blocks free when you do a delete. I know a company that recovers disk blocks one at a time.
I am not sure what what else I can contribute. I wish I could be more help to you. Perhaps some of the others in this group can tell you more.
Good luck, keep us posted.
Neil.
|
|
|
|
) 1 Vote
] 
Blog
Search
Help
Members
Register
Login
Home
