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 - 03:00:20 CDT
