Solved

Oracle 8i and Equity Edge recover DB

Posted on 2004-04-21
5
993 Views
Last Modified: 2012-06-27
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
0
Comment
Question by:jperez0559
5 Comments
 
LVL 2

Accepted Solution

by:
GDE earned 200 total points
ID: 10885495
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
 
LVL 8

Assisted Solution

by:baonguyen1
baonguyen1 earned 200 total points
ID: 10886031
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
 

Author Comment

by:jperez0559
ID: 11017194
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

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Oracle Database creation fails 5 36
report returning null 21 50
What is the version of ojdbc6.jar 2 23
Oracle and DateTime math 6 0
Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now