| Recovering data [message #220049] |
Sun, 18 February 2007 02:49  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
