Home » RDBMS Server » Backup & Recovery » Recovering data
Recovering data [message #220049] Sun, 18 February 2007 02:49 Go to next message
Messages: 1
Registered: October 2006
Junior Member
Hi All,

I need help in getting data out of my database. My Windows 2000 server where my database server resides crashed. I have rebuilt the OS without touching the Oracle installation on it but I need to get my data out before reinstalling the oracle server. How do i go about doing this. I do not have any backup. Can someone please help before I lose my mind. I am not a DBA and do not have a clue what to do. I did a default installation of the oracle database and I can see all the folders in the oracle directory. I believe the datafiles and password files are still there. The init.ora file and password file are still there. This is an oracle 9i database.

Thanks in anticipation of your help.
Re: Recovering data [message #220051 is a reply to message #220049] Sun, 18 February 2007 03:13 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

YOu already done BIG mistake...!!!
I do not have any backup
How can you using database without backup..
try below procedure.

First take complete backup of your oracle database files.
All Datafiles
All Redologs
All Control Files

after that
Install Oracle Software without DATABASE creation.

1.create ORACLE_SID=<sid> Your_old_database_sid
2.create oracle services through ORADIM utility.
3.startup nomount;--->if no errors
4.alter database mount; ---> if no errors
5.alter database open;

during process if you receive any RECOVEY error or any type of error please post here.

Previous Topic: Importing only tables from the dump file
Next Topic: Restore 8 to 10
Goto Forum:

Current Time: Wed Aug 23 14:39:27 CDT 2017

Total time taken to generate the page: 0.03066 seconds