DATABASE RECOVERY , WINDOWS 2000 , ORACLE 10G

0 pts.
Tags:
Database Management Systems
Microsoft Windows
Oracle
Oracle 10g
Hi Brian, I am a student at West Virgibia University, and manage a database with tables. My problem is that my system has crashed, I can get it up and running but on a different partition, so that my files are intact on the original partition, but my database wont run, because it was installed on the original partition c:. I wanted to know my options for databse recovery. I mean can I just use the data files to do some export thing, or...? A STEP BY STEP APPROACH WILL be appreciated. Please its very crucial to my application. Thanks in advance. Deepak
ASKED: April 24, 2005  4:25 PM
UPDATED: May 24, 2005  5:12 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

What RDBMS? If SQL can you get to your database and DETACH the file? Assuming you have installed another copy of SQL elsewhere and can detach the database from it’s original registration you should be able to move it and use it as long as the USERS & LOGINS exist in the new environment. See SQL documentation.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Andrew85
    I suspect your best bet is going to be to attempt to recover that partition at the OS level. I cant think of anyway to do in Oracle if you dont have a backup of the database.
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following