Re: loss of system datafile with no cold backup

"julie" <jgaldames_at_xmmcorp.com> wrote in message news:83ac9b2b.0107080652.35ef31a9_at_posting.google.com...
> Hi,
>
> We lost one drive which had the system and tools datafiles. The
> database instance was created only a week ago. I didn't create a cold
> backup right after creating the database because I'm a new dba and
> didn't know that would be a good idea. Any... I have all the other
> datafile, the control file and the init.ora file. Is there a way to
> recover from this? We don't want to loose the data that is in those
> datafiles. My question is can I recreate the database so that I can
> get the data off of the other datafiles. If so how can I do this? Any
> help u can provide would be greatly appreciated! Thanks in advance to
> anyone who might be able to help!!!
>
> Julie

Requiescat in Pacem for this database.
If you don't have a backup, and it sounds like you don't have a backup at all, how do you think you can reconstruct the datadictionary in the SYSTEM tablespace from the other tablespaces?
If you could you should be hired by Oracle immediately. Using Oracle you shouldn't just hack away!

Regards,
Sybrand Bakker, Senior Oracle DBA Received on Sun Jul 08 2001 - 10:17:45 CDT