Re: Accidentally moved *.dbf file.

<g9chan_at_uwaterloo.ca> wrote in message
news:d57ade3e.0411031144.1e380a29_at_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

Hi,

Are you sure your Oracle db is running ? Try : ps -ef|grep pmon on Unix or check for any oracle.exe processes on Windows. If it's not running, try to start it with : sqlplus /nolog
connect / as sysdba
startup

HTH
Matthias Hoys Received on Wed Nov 03 2004 - 13:54:51 CST