Comments embedded.
Regards
HJR
--
Resources for OracleT: www.geocities.com/howardjr2000
=========================================
"George" <divined2000_at_hotmail.com> 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.
God knows. Now you know why they invented Optimal Flexible Architecture,
which recommends that all data files be created with a dbf extension. That
way, there's none of the guessing involved with names like you've inherited!
For the record, I'd guess as follows:
SYSEIK.ORA = the system datafile. Crucial.
USEREIK.ORA = the user data file. Contains all your juicy data.
TEMPEIK.ORA = the temp tablespace datafile. Losable.
RBSEIK.ORA = the rollback segment tablespace. Crucial.
LOG1EIK.ORA = one of your online redo logs
LOG2EIK.ORA = the other of your redo logs
CTL1EIK.ORA = one of your control files
CTL2EIK.ORA = the mirrored copy of your control file
(And quite what they were doing mirroring the control file and not the redo
logs, I haven't the foggiest. Damned stupid if you ask me!)
>Is it possible to recover the database only using the files
> above?
Sounds feasible. It's all there. Trouble is, you can never be sure there
wasn't supposed to be another USER2EIK.ORA or something. Absence of needed
files will only show up when you try and start the thing.
>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.
The fact that the services started is extremely encouraging. I'd wager a
small banana that it means everything is in place and is AOK. The 'couldn't
resolve service name' error is trivial in comparison... it means you haven't
got a listener running, whose job it is to listen out for requests to
connect to "EIK" and map that into a physical connection to the right
Instance.
You'll probably find things easiest if you use the net8 configuration
assistant to create a new listener (its default name is LISTENER, the
default port is 1521), and probably a new TNSNAMES.ORA, which will contain
instructions of how to map a request for a connection to "EIK" to the
listener handling those requests.
If you use Sever Manager locally on the Oracle box, you might find you don't
even need a listener or a tnsnames.ora, since those connections are direct
via ipc.
Good luck
HJR
>
> Thanks in advance
> George
Received on Thu Oct 04 2001 - 00:26:31 CDT
