Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Accidentally moved *.dbf file.
Hi, I am a oracle newbie.
I was trying to restore my oracle database by copying over the dbf file corresponding to my database instance with an older version of the same dbf -- while the instance was still running. This is proving to be a big mistake. [insert ur flames here]
Now I have problems connecting to that oracle instance regardless of which dbf file I put in the original path. The error is: ORA-03113: end-of-file on communication channel.
I don't believe that the dbf is corrupted (at least I hope not). Does anyone know if there is a fix for this problem?
I am using oracle 9.2.0.1.0
The log reads:
Wed Nov 03 13:21:44 2004
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address
'(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed Nov 03 13:21:47 2004
alter database mount exclusive
Wed Nov 03 13:21:57 2004
Successful mount of redo thread 1, with mount id 4111066539.
Wed Nov 03 13:21:57 2004
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Wed Nov 03 13:21:58 2004
alter database open
ORA-1113 signalled during: alter database open...
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 3
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Received on Wed Nov 03 2004 - 13:44:46 CST
![]() |
![]() |