Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Accidentally moved *.dbf file.

Accidentally moved *.dbf file.

From: <g9chan_at_uwaterloo.ca>
Date: 3 Nov 2004 11:44:46 -0800
Message-ID: <d57ade3e.0411031144.1e380a29@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US