Home » RDBMS Server » Backup & Recovery » database crash ( on windows NT)
database crash [message #324505] Mon, 02 June 2008 18:23 Go to next message
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
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
Messages: 25571
Registered: January 2009
Location: SoCal
Senior Member
Please read & follow posting guidelines as stated in URL above
Previous Topic: ORA-00265: instance recovery required, cannot set ARCHIVELOG mode
Next Topic: How to Take export of Synonym
Goto Forum:

Current Time: Sat Aug 19 15:41:28 CDT 2017

Total time taken to generate the page: 0.05564 seconds