Re: Accidentally moved *.dbf file.

"Access" <idmwarpzone_NOSPAM__at_yahoo.com> wrote in message news:4189378b$0$19561$ba620e4c_at_news.skynet.be...
>
> <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
>
>

Sorry I was a bit too fast ... Seems like your datafile is out of sync with the rest of the db. Do you use archive logging ?

Matthias Received on Wed Nov 03 2004 - 14:00:30 CST