Re: Accidentally moved *.dbf file.

Thanks,

No, the database is currently not using archive logging.

btw, I notice some errors in the OraDim.log. notably, the "not accessing current version" error message.

---
Mon Nov 01 16:45:48 2004ORA-01122: database file 11 failed verification check
ORA-01110: data file 11: 'D:\ORACLE\ORADATA\CMADB1\CMADB1.DBF'
ORA-01208: data file is an old version - not accessing current version

Mon Nov 01 16:48:51 2004
ORA-01113: file 11 needs media recovery
ORA-01110: data file 11: '<path to dbf>'

Wed Nov 03 10:00:24 2004ORA-01109: database not open

Wed Nov 03 10:05:17 2004
ORA-01113: file 11 needs media recovery
ORA-01110: data file 11: '<path to dbf>'

Wed Nov 03 13:11:05 2004ORA-01109: database not open

Wed Nov 03 13:16:14 2004
ORA-01113: file 11 needs media recovery
ORA-01110: data file 11: '<path to dbf>'
---

"Access" <idmwarpzone_NOSPAM__at_yahoo.com> wrote in message news:<418938dd$0$9540$ba620e4c_at_news.skynet.be>...


> "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