Home » RDBMS Server » Backup & Recovery » restore db only from .dfb files (XE on Ubuntu10)
restore db only from .dfb files [message #402921] Wed, 13 May 2009 02:56 Go to next message
ragggl
Messages: 9
Registered: May 2009
Junior Member
hey people,

i delete all my redolog files. I just have my .dbf files.
Yes it sounds stupid, but i am a learnig student, sry.

Is it now possible to restore or reset the database without the redolog files, because when i startup my database i get the message...

ora-00313: open failes for members of log group 1 of thread 1
ora-00312: online log 1 thread 1:
'theplacewherethelogshuldbe/.log'
ora-27037: unable to obtain file status

i know i need them but maybe their is a backdoor

thanks for help and a good day

raphael
Re: restore db only from .dfb files [message #402927 is a reply to message #402921] Wed, 13 May 2009 04:03 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Startup in mount mode, recreate log file with alter database clear logfile, and if you are (very) lucky you can open with resetlog option.

Regards
Michel
Re: restore db only from .dfb files [message #403036 is a reply to message #402921] Wed, 13 May 2009 09:36 Go to previous messageGo to next message
ragggl
Messages: 9
Registered: May 2009
Junior Member
sry but it dosn help,

other problem how can i recover a oracle xe database manual

i have the *.dbf and all the configfiles like init.ora tsnames.ora and listener.oar

their is maybe a tutorial or instruction in the www which i don't find. Maybe you can give me the link


thx raphael
Re: restore db only from .dfb files [message #403063 is a reply to message #403036] Wed, 13 May 2009 10:37 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
sry but it dosn help,

And this does not help us help you.
Copy and paste what you did.

The ONLY way is what I told you.
If you can't with it and have no backup you lost your database.

Regards
Michel
Re: restore db only from .dfb files [message #403197 is a reply to message #402921] Thu, 14 May 2009 02:55 Go to previous message
ragggl
Messages: 9
Registered: May 2009
Junior Member
sry, wasn't possible to recover the database. All was to currupted. I take a earlier snapshot from the vmware machine and learnd my lesson not to delete manualy log files,

thy for your help

Raphael
Previous Topic: Validation failed for archived log
Next Topic: purpose of incremental backup
Goto Forum:
  


Current Time: Mon Nov 25 14:12:53 CST 2024