Solved

Oracle 8i and Equity Edge recover DB

Posted on 2004-04-21
5
996 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

896 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

13 Experts available now in Live!

Get 1:1 Help Now