Home » RDBMS Server » Enterprise Manager » Help to recover database.
Help to recover database. [message #476997] Mon, 27 September 2010 13:21 Go to next message
amit.sonar
Messages: 67
Registered: December 2009
Location: Mumbai
Member
Hi all,

I have installed database in E drive of my machine. But somebody format my C drive without taking the database backup. Now

Is it possible to re-establis the connection with existing database because still all the directories are there in my E drive which were created at time of the database installation???

plsease help me on this.


Thanks,
Amit Sonar.
Re: Help to recover database. [message #476998 is a reply to message #476997] Mon, 27 September 2010 13:29 Go to previous messageGo to next message
BlackSwan
Messages: 22558
Registered: January 2009
Senior Member
post values for ORACLE_SID & ORACLE_HOME

What is OS name & version?
What is Oracle version to 4 decimal places?

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

[Updated on: Mon, 27 September 2010 13:30]

Report message to a moderator

Re: Help to recover database. [message #476999 is a reply to message #476997] Mon, 27 September 2010 13:52 Go to previous messageGo to next message
Michel Cadot
Messages: 58645
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Reinstall Oracle and use ORADIM to create the previous service associated to the database.

Regards
Michel
Re: Help to recover database. [message #477001 is a reply to message #476999] Mon, 27 September 2010 14:57 Go to previous messageGo to next message
LKBrwn_DBA
Messages: 427
Registered: July 2003
Location: WPB, FL
Senior Member
PS: Select "Custom install -> Install Software Only"


[Updated on: Mon, 27 September 2010 15:12] by Moderator

Report message to a moderator

Re: Help to recover database. [message #478666 is a reply to message #477001] Mon, 11 October 2010 14:04 Go to previous messageGo to next message
amit.sonar
Messages: 67
Registered: December 2009
Location: Mumbai
Member
Hi All,
Sorry for late reply. My oracle version is Version 10.2.0.1.0. Below are my connection details.....
My SID is orcl and ORACLE_HOME is E:\oracle\product\10.2. 0\db_1

Conncection details = (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=sumit-amit)(PORT=1521))(CONNECT_DATA=(SID=orcl)(CID=PROGRAM=E:\oracle\product\10.2.0\db_1\b in\emagent.exe)
(HOST=SUMIT-AMIT)(USER=OraUser))))

OS version = Microsoft windows XP professionals version 2002, service pack 2

Re: Help to recover database. [message #478668 is a reply to message #478666] Mon, 11 October 2010 14:14 Go to previous messageGo to next message
Michel Cadot
Messages: 58645
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Is there a question in your post?
How is this related to the previous one?

Regards
Michel
Re: Help to recover database. [message #478820 is a reply to message #478668] Tue, 12 October 2010 13:46 Go to previous messageGo to next message
amit.sonar
Messages: 67
Registered: December 2009
Location: Mumbai
Member
Hi Michel,

I have replied it to Blackswan's post. Please help me on this.

Thanks,
Amit

Re: Help to recover database. [message #478823 is a reply to message #478820] Tue, 12 October 2010 14:14 Go to previous messageGo to next message
Michel Cadot
Messages: 58645
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I already answered to this.

Regards
Michel
Re: Help to recover database. [message #479401 is a reply to message #478823] Sat, 16 October 2010 13:06 Go to previous messageGo to next message
amit.sonar
Messages: 67
Registered: December 2009
Location: Mumbai
Member
Hi Michel,

Can u please tell me more on ORADIM. How can i proceed with it?

Thanks,
Amit.

Re: Help to recover database. [message #479403 is a reply to message #479401] Sat, 16 October 2010 13:24 Go to previous message
Michel Cadot
Messages: 58645
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
C:\>oradim
ORADIM: <command> [options].  Refer to manual.
Enter one of the following command:
Create an instance by specifying the following options:
     -NEW -SID sid | -SRVC srvc | -ASMSID sid | -ASMSRVC srvc [-SYSPWD pass]
 [-STARTMODE auto|manual] [-SRVCSTART system|demand] [-PFILE file | -SPFILE]
 [-SHUTMODE normal|immediate|abort] [-TIMEOUT secs] [-RUNAS osusr/ospass]
Edit an instance by specifying the following options:
     -EDIT -SID sid | -ASMSID sid [-SYSPWD pass]
 [-STARTMODE auto|manual] [-SRVCSTART system|demand] [-PFILE file | -SPFILE]
 [-SHUTMODE normal|immediate|abort] [-SHUTTYPE srvc|inst] [-RUNAS osusr/ospass]
Delete instances by specifying the following options:
     -DELETE -SID sid | -ASMSID sid | -SRVC srvc | -ASMSRVC srvc
Startup services and instance by specifying the following options:
     -STARTUP -SID sid | -ASMSID sid [-SYSPWD pass]
 [-STARTTYPE srvc|inst|srvc,inst] [-PFILE filename | -SPFILE]
Shutdown service and instance by specifying the following options:
     -SHUTDOWN -SID sid | -ASMSID sid [-SYSPWD pass]
 [-SHUTTYPE srvc|inst|srvc,inst] [-SHUTMODE normal|immediate|abort]
 Query for help by specifying the following parameters: -? | -h | -help

Use -NEW option.

Regards
Michel
Previous Topic: Error regarding the Enterprise Manager during Installation
Next Topic: How frequently ALERT METRICS are collected/refreshed
Goto Forum:
  


Current Time: Sat Aug 02 04:29:21 CDT 2014

Total time taken to generate the page: 0.11946 seconds