Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Restore Strategy
Hello, Andreas
You are right that no chances to restore database. But you are wrong with "Congratulation".
I bet he has chance to recover data.
If there are scripts which was used for creation of tables and PL/SQL code
it is not impossible.
Regards,
Igor Poteryaev
--
Ranum's Law: "You can't solve social problems with software".
Andreas Michler wrote:
>
> Congratulation.
> I think you have no chance to restore your database.
>
> - The information about the datafiles is in the controlfile (not backuped)
> - The information about your additional tables is in the systemtablespace (not
> backuped).
>
> In your case I would do the scenario described in Chapter 12 "Recovering a
> Database","Preparing for Disaster Recovery" in the "Backup and Recovery" book of
> Oracle.
>
> 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.
>
> --
> -------------------------------------
> ADICOM Informatik GmbH
> Andreas Michler
> Wiesfleckenstr. 34
> 72336 Balingen
> Tel: 07433/9977-57,Fax: -90
> E-Mail: Andreas.Michler_at_adicom.de
> http:\\www.adicom.de
> -------------------------------------
--
Ranum's Law: "You can't solve social problems with software".
Received on Mon Jan 24 2000 - 07:41:52 CST