Re: Restore Strategy

You'll need a control file to mount your database before you can do any sort of recovery. You'll also need the file(s) that contain the SYSTEM tablespace. If you can restore these from a backup, then you can recover your database. But it sounds like you don't have those. Can you go to an earlier backup? IMO, if you can't get an earlier version of you SYSTEM tablespace, you are in trouble. Sounds like the backup and recovery plan wasn't very solid.

HTH,
Brian

Earl Park wrote:
>
> I have a oracle server that was broke down a week ago. I tried to restore
> all data from backup take, and I could only restore datafiles. Is there way
> to restore whole database from datafiles? I don't need any rollback data
> nor logs. I just want the server run so that I can export data.
>
> File list before it break:
>
> Control File
> System File
> Rollback File
> 2 Log Files
> User File that contain all demo tables
> 2 Data Files where actual data is stored.
>
> File list after restore:
>
> 2 Data Files where actual data is stored.
>
> Any possibility? I have huge information stored in those two data files..
>
> Thank you in advance.
> Earl.
Received on Thu Jan 20 2000 - 08:21:19 CST