Re: HELP !!! - Oracle 7.1.6.2 recovery problem

Hi,

First off: you are aware your version of Oracle isn't supported anymore? You need to upgrade to 7.3.4
To recover the database you need at least 1 controlfiles
2 online redo log files
3 tablespace files
If you don't have 1 and 2, and you don't have an export, the only thing you can do is make a create controlfile statement. Hopefully that is already present in 7.1.
If you do have 1 and 2, you should be able to recover the database using your controlfiles and the recover database command in svrmgr. Again, the functionality has changed over time, so it is difficult to tell the exact syntax.
If you have an export, you will need to create the database again and import your export. Be aware of creating a second rollback segment in the system tablespace before you start importing, or your import will blow in your face and make things worse.
Recreating the tablespaces is better suited in the import scenario. Just precreate before you start importing.

Hth,

Sybrand Bakker, Oracle DBA

Ed wrote in message <37749111.E6D_at_virgin.net>...
>Hi.
>One of our hard drives gave up on us two days ago. I can retrieve the
>information from a previous tape. The hard drive contained one or more
>data tablespace data files. Can I recover the system by copying back all
>the datafiles with the same time stamp. If not, can I use EXPORT to
>bring back the whole database if the datafiles are not all there?
>Secondly, regarding index tablespaces. Can I drop the tablespace and
>recreate it with one datafile and could I do that with the data
>tablespace?
>
>Many thanks !!!
>
>Ed.
Received on Sat Jun 26 1999 - 04:40:48 CDT