Re: Emergency

On Sat, 23 Jul 2005 09:46:46 -0400, "Andreas" <a_kondilis_at_hotmail.com> wrote:

>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.
>

You are missing the init*.ora and/or sp*.ora parameter files to start up the database. Heaven knows what was in them. I think it was unnecessary to recreate the database, and it definitely did overwrite those files.
As to your current situation, the only thing you could do is, is (after you copied the original files back in) connect using sqlplus as sys, and issue
startup mount
recover database using backup control file until cancel hit CANCEL
alter database open resetlogs

If that doesn't work, time to play the Marche Funebre on your database.  

--
Sybrand Bakker, Senior Oracle DBA