Home » RDBMS Server » Backup & Recovery » Recovering data
Recovering data [message #220049] Sun, 18 February 2007 02:49 Go to next message
Olodu
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

Hi,
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
Init<sid>.ora
spfile<sid>.ora
pwd<sid>.ora

after that
Install Oracle Software without DATABASE creation.

Step:
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.

regards
Taj
Previous Topic: why recoveery is required after alter database open resetlogs
Next Topic: ORA-01207: file is more recent than controlfile - old controlfile
Goto Forum:
  


Current Time: Fri Dec 06 17:11:01 CST 2024