Thanks for the info guys. I`ll try these things out and will inform of success.
pagesflames_at_usa.net (Dusan Bolek) wrote in message news:<1e8276d6.0110040000.2ba24c4f_at_posting.google.com>...
> divined2000_at_hotmail.com (George) wrote in message news:<e480c22a.0110031429.411336a7_at_posting.google.com>...
> > We had this Oracle 8.0.5 database, running under Windows 2000 Server,
> > whcih collapsed due to a system failure. Since the last backup was
> > rather old I had to copy all working database files (SYSEIK.ORA,
> > USEREIK.ORA, TEMPEIK.ORA, RBSEIK.ORA, LOG1EIK.ORA, LOG2EIK.ORA,
> > CTL1EIK.ORA, CTL2EIK.ORA with SID = EIK) from the direvtory
> > ORACLE_HOME\rdbms80. Which of the above files contains the actual
> > data. Is it possible to recover the database only using the files
> > above? I tried setting up a new Oracle installation. The services
> > oracleserviceEIK & oraclestartEIK have started witthout problem, but
> > when I use the servicemanager to startup the database I get the error
> > TNS:could not resolve service name. Since this is rather urgent any
> > help would be greatly appreciated.
>
> It seems to me that you have all your data. However you need some
> configuration files and parameters. You must have ORACLE_SID set to
> EIK and you need initEIK.ora file to start your database. Also for
> using your database you need properly configured LISTENER.ORA,
> TNSNAMES.ORA and SQLNET.ORA. This files were in
> $ORACLE_HOME\NET80\ADMIN.
> Because your database was not closed properly, there will be need for
> crash recovery after startup, since you have your redo logs available,
> this recovery should be succesful.
>
> --
> _________________________________________
>
> Dusan Bolek, Ing.
> Oracle team leader
>
> Note: pagesflames_at_usa.net has been cancelled due to changes (maybe we
> can call it an overture to bankruptcy) on that server. I'm still using
> this email to prevent SPAM. Maybe one day I will change it and have a
> proper mail even for news, but right now I can be reached by this
> email.
Received on Thu Oct 04 2001 - 13:25:59 CDT
