OraFAQ Forum: Backup & Recovery » Recover Data base from previos database

Home » RDBMS Server » Backup & Recovery » Recover Data base from previos database (Oracle 8.1.7 Enterprize edition)

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

Recover Data base from previos database [message #450108]

Mon, 05 April 2010 00:24

sweetkhaliq
Messages: 200
Registered: April 2006

Senior Member

Dear members

I am working on oracle 8.1.7 enterprize edition. I have installed it on window XP. But know the window xp has currupted and i was unable to repair it. My Oracle installation folder for oracle 8i is still on my d:\ drive. I did not take backup for last few months by using exp command. So i have installed the fresh XP window and want to get the previos data from previos databse installed on d:\.

Please tell me how can i achieve this task.

Thanks & Regards.

Report message to a moderator

Re: Recover Data base from previos database [message #450109 is a reply to message #450108]

Mon, 05 April 2010 01:16

Michel Cadot
Messages: 68637
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

What do you still have exactly?

Regards
Michel

Report message to a moderator

Re: Recover Data base from previos database [message #450111 is a reply to message #450109]

Mon, 05 April 2010 01:35

sweetkhaliq
Messages: 200
Registered: April 2006

Senior Member

Dear Michel
Before the OS corruption the oracle is working quite well.
And its location in computer is d:\orant\oradata\orcl where the database files are located.
But know i have installed the fresh XP Window. How can i get the previous data from previous database.

Thanks & Regards

Report message to a moderator

Re: Recover Data base from previos database [message #450113 is a reply to message #450111]

Mon, 05 April 2010 01:54

Michel Cadot
Messages: 68637
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Which files do you still have?
data files?
control files?
Redo logs files?
Archived logs files?
init.ore?
spfile?
...

Regards
Michel

Report message to a moderator

Re: Recover Data base from previos database [message #450114 is a reply to message #450111]

Mon, 05 April 2010 02:05

sweetkhaliq
Messages: 200
Registered: April 2006

Senior Member

I have complete database installation folder on my d:\ drive. Only XP operating system is corrupted but the database is still on my D:\orant folder. And i have all the files as you mention. I only want to know if i installed new database Oracle 8i on any other location like e:\ drive how can i get the previous database data that was install on d:\ drive.

Thanks & regards

Report message to a moderator

Re: Recover Data base from previos database [message #450116 is a reply to message #450114]

Mon, 05 April 2010 02:43

Michel Cadot
Messages: 68637
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Reinstall in the same directory and use oradim to create a service for your database.

Regards
Michel

Report message to a moderator

Re: Recover Data base from previos database [message #450138 is a reply to message #450116]

Mon, 05 April 2010 04:44

sweetkhaliq
Messages: 200
Registered: April 2006

Senior Member

I have installed the the oracle 8.1.7 on the same location and replace the d:\orant\oradata\orcl folder with the previous database orcl folder and when i try to connect to the database it give messgae "Oracle shutdown in prcess".

Please tell me how i can solve this problem.

[Updated on: Mon, 05 April 2010 04:44]

Report message to a moderator