| is database Recovery is possible with datafile only ? [message #54294] |
Fri, 08 November 2002 20:49  |
Rao MS
Messages: 1
Registered: November 2002
|
Junior Member |
|
|
Hai oracle Friends,
One bad Morning my colleauge,who is working on oracle 7.3.2. went to work place and removed all the files (init.ora,control files,log files and system files) except a datafile what we had created.
the database is running in noarchivelog mode and no backups .Can we recover the data ?
if so please explain.
Thanking You
Rao
|
|
|
|
|
|
| Re: is database Recovery is possible with datafile only ? [message #54298 is a reply to message #54294] |
Fri, 08 November 2002 23:13  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
What a smart guy !! Removed all the files, but left its own one. What you guys did to this fellas???
If you find any full database export of this database, before this bad morning, you might get some old copy running. Other than that - nothing...
Next time run in archivedlog mode, take hot backups, duplicate the tapes and keep them in separate locations. Also take full db export every night. You will know it already...
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
| Re: is database Recovery is possible with datafile only ? [message #54337 is a reply to message #54294] |
Tue, 12 November 2002 03:40 |
Jay
Messages: 127
Registered: October 1999
|
Senior Member |
|
|
You need a copy of all datafiles in the database before crash to recover al the data or the system files plus files of tablespaces you want to recover. The system datafile is used only to recover the data dictionary, so it needs to be after the last change of DB structure (new users/tablespaces etc). If you don't have system datafile you can not recover anything.
You can recover all the data from datafiles using Oracle utility to unload data directly from files but it will cost you a lot of money. It is an Oracle internal use only utility, and they use only in case of disaster (because Oracle it supposed to be unbreakable)
Good luck & let me know what happened.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
