Re: Emergency

"Andreas" <a_kondilis_at_hotmail.com> wrote in news:YSrEe.11757$je2.1221386_at_news20.bellglobal.com:

> Hi,
> i am exploring with oracle 10g and i changed something in the
> configuration of a database that made it offline and i couldn't
> reconnect to it. I copied the files in oradata of that database into
> another location as backup. The files i copied are the controlfile,
> onlinelog and the datafiles. Then i deleteded that database with the
> oracle assistant and recreated a new database with the same name.
> That's the only thing i copied before knowing that oracle keeps other
> files for each database in the admin directory. No backup was ever
> done and there are no archived logs. The problem is somebody filled up
> some important data in the database i deleted and they want them
> backup. Having said that is it possible to reconstruct a database
> having only the files i mentioned. I appreciate any information, link
> to a site or a book that anyone can provide or maybe a simple answer
> to let me know if it is possible to rebuild from files or i should
> stop searching. Thank you in advance.
>
>

READY, FIRE, AIM! When you find yourself in a hole, your first actions should be to STOP DIGGING! Before you do anything else, make at least 2 copies of the files from the backup location. This is so you can at least get back to where you are right now.

Since it appears you don't really know what you are doing, hire somebody who has a fighting chance to fix this mess.

If you are willing to spend some serious coinage, Oracle might be able to extract the data using their proprietary DUL utility. Received on Sat Jul 23 2005 - 09:43:31 CDT