OraFAQ Forum: Backup & Recovery » recreating oracle from hard drive

Home » RDBMS Server » Backup & Recovery » recreating oracle from hard drive (9i on windows)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

recreating oracle from hard drive [message #339427]

Thu, 07 August 2008 08:41

eagyeman
Messages: 6
Registered: May 2007

Junior Member

One of our older systems had oracle 9i installed on it. The system was shut down a while ago and when we recently tried to restart it, we could not. We are planning to take the drive out of the old sever and copy the information onto a new server, with all the oracle binaries, oracle files as well as the database physical files (ctrl files, datafiles etc). I am not aware of any backups taken. Which alternatives do I have to bring up this oracle database so we can get to the information.

THanks

Report message to a moderator

Re: recreating oracle from hard drive [message #339435 is a reply to message #339427]

Thu, 07 August 2008 08:57

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

sqlplus
/ as sysdba
startup
exit

If DB starts, you can get old data.
If DB does not start, refer to documented & tested restoration procedures.

Report message to a moderator

Re: recreating oracle from hard drive [message #339454 is a reply to message #339435]

Thu, 07 August 2008 09:33

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

I need few clarification

[1] eagyeman which O/S you are using?
[2] R you able to access all folder and directory relate to oracle datafiles?
[3] Do you know How to set ORACLE_SID on windows and Linux?
[4] Its a personal question R you DBA ? if yes then which command you gave to start DB and what error you got please paste here on forum ....

Report message to a moderator

Re: recreating oracle from hard drive [message #339456 is a reply to message #339454]

Thu, 07 August 2008 09:42

eagyeman
Messages: 6
Registered: May 2007

Junior Member

[1] eagyeman which O/S you are using?
[2] R you able to access all folder and directory relate to oracle datafiles?
[3] Do you know How to set ORACLE_SID on windows and Linux?
[4] Its a personal question R you DBA ? if yes then which command you gave to start DB and what error you got please paste here on forum ....

OS is windows 2000
Yes we are able to access all folders on the hard drive we plugged in
I am a DBA. We just put the drive so I will try to start it and see if it works and will get back to you

Report message to a moderator

Re: recreating oracle from hard drive [message #339802 is a reply to message #339456]

Fri, 08 August 2008 10:00

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

I may be wrong, but I think your best bet might be
1) Install the same version of Oracle on your new box as on the old one.
2) Create a database with the control files in the same locations and with the same names as the old database (get these from the Init.ora file
3) Copy all the datafiles from the old Db into the same locations on the new Db.

You should be able to start this new database up, and it should contain all the data of the old one.

Report message to a moderator

Re: recreating oracle from hard drive [message #339817 is a reply to message #339456]

Fri, 08 August 2008 13:49

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Since this is Windoze, you won't be able to "just start it". Prior to being able to start the database, you'll need to create a Windows service for Oracle with oradim.

Report message to a moderator

Previous Topic:	How we can recover through RMAN...
Next Topic:	BACKUP FAILS

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 25 22:12:01 CST 2024