Oracle 8i and Equity Edge recover DB

Hi;
I have a situation. I installed Equity Edge which is a program that uses Oracle 8i. The hard drive (C:) crahed, but Oracle and Equity were installed on Drive D. I have all the data in drive D but I need to retrieve back. I installed equity and Oracle again but this time is on drive C. Is there a way to read the old data using the new installation? how can I get a "dump" of the Oracle/Equity DB from the old info?

Any help would be greatly appreciate it.
Gracias
jperez0559Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
GDEConnect With a Mentor Commented:
If your DB running in Archive Log Mode create new DB, with name of old DB and files equals path. shutdown it, copy old files with replace all new files. startup mount, recover DB, open DB with resetlog option.
Better, if you first read backup/recovery guide. (recover DB + cold backup).

Best regards
Dmitry.
0
 
baonguyen1Connect With a Mentor Commented:
I dont know about Equity Edge but you can start Oracle database with new installation on C.  I assume that all datafiles, control files, init file ... are still on D. you need to:

-Set the ORACLE_HOME to the new install
C:\set ORACLE_HOME=<new home>
-Set the correct ORACLE_SID
C:\set ORACLE_SID=<SID>
-You may need to recreate a new service for your SID using ORADIM utility
C:\oradim ....
-Startup the database using the correct path of the init<SID>.ora file.
C:\sqlplus /nolog
SQL>connect internal
or
SQL>connect / as sysdba
or
SQL>connect sys/pass as sysdba
Then:
SQL>startup pfile=<correct init<SID>.ora file with full path>

This way will start the Oracle database from D.

Hope this helps
0
 
jperez0559Author Commented:
well, none of those solutions really worked, so a DB especialist ended up craking the old DB and creating a dump (12 hrs later), which later on, I imported into a new DB.
However, thanks for you guys answers
0
All Courses

From novice to tech pro — start learning today.