Home » RDBMS Server » Backup & Recovery » database crash (9.2.0.2 on windows NT)
database crash [message #324505] Mon, 02 June 2008 18:23 Go to next message
naushhussain
Messages: 1
Registered: June 2008
Location: Phoenix
Junior Member
we crashed our database and we have no backups. all we have is the system.dbf file and the data files.

is it possible to recover data from these if we create a new database and somewhat replace the system file and then move the data files to where they are supposed to be.
Re: database crash [message #324506 is a reply to message #324505] Mon, 02 June 2008 18:25 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You can't just move datafiles around to different databases.

What do you mean when you say "you crashed your database"? What errors are you getting?
Re: database crash [message #324507 is a reply to message #324505] Mon, 02 June 2008 18:28 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above
Previous Topic: how to backup huge DB
Next Topic: Reg Cold and Hot backup
Goto Forum:
  


Current Time: Fri Nov 29 09:10:59 CST 2024