| Retrive Oracle Database [message #62190] |
Sun, 04 July 2004 10:19  |
Ramanathan
Messages: 7
Registered: May 2004
|
Junior Member |
|
|
Hi,
I have a big problem.Please Help me.
I am using O/S Windows NT workstation 4.0 and Oracle 8.1.6.
My OS get curropted. I try to retrived oracle database. No use.
I coppied the oradata folder into some other system along with all subfolders.
I reinstalled same O/S and Installed Oracle 8.1.6 and created same instances, same domain name also. It's working fine.
Then What i did.
Stopped the services and coppied the Old oracle data(instances) folder into the same location. The I restarted the services.Now it's not working. Plases help me to get the data form old database. I am not oracle Administrator.
|
|
|
|
| Re: Retrive Oracle Database [message #62192 is a reply to message #62190] |
Sun, 04 July 2004 20:34  |
Deepak Panda
Messages: 24
Registered: May 2004
|
Junior Member |
|
|
You have to copy the control files, datafiles & log files and init.ora files to the right locations and may be you'll need to recreate the Oracle service to get the database up and running.
Or
If you do not have the control files with you then you can recreate the control files.
Hope this helps.
Any corrections Gurus?
|
|
|
|
| Re: Retrive Oracle Database [message #62205 is a reply to message #62192] |
Mon, 05 July 2004 07:45 |
croK
Messages: 170
Registered: April 2002
|
Senior Member |
|
|
It seems correct.
Of course, to recreate control files you will have to know exactly all your datafiles names, and i think your charset also.
It is also recomended to add 'backup to trace' command
to add to your backup policy, that way will have a scritp to recreate your controlfiles (if lost)
Best luck!
www.otools.com.ar
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
