OraFAQ Forum: Enterprise Manager » Help to recover database.

Home » RDBMS Server » Enterprise Manager » Help to recover database.

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

Help to recover database. [message #476997]

Mon, 27 September 2010 13:21

amit.sonar
Messages: 98
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.

Report message to a moderator

Re: Help to recover database. [message #476998 is a reply to message #476997]

Mon, 27 September 2010 13:29

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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

Michel Cadot
Messages: 68634
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

Report message to a moderator

Re: Help to recover database. [message #477001 is a reply to message #476999]

Mon, 27 September 2010 14:57

LKBrwn_DBA
Messages: 487
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

amit.sonar
Messages: 98
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

Report message to a moderator

Re: Help to recover database. [message #478668 is a reply to message #478666]

Mon, 11 October 2010 14:14

Michel Cadot
Messages: 68634
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

Report message to a moderator

Re: Help to recover database. [message #478820 is a reply to message #478668]

Tue, 12 October 2010 13:46

amit.sonar
Messages: 98
Registered: December 2009
Location: Mumbai

Member

Hi Michel,

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

Thanks,
Amit

Report message to a moderator

Re: Help to recover database. [message #478823 is a reply to message #478820]

Tue, 12 October 2010 14:14

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

Senior Member
Account Moderator

I already answered to this.

Regards
Michel

Report message to a moderator

Re: Help to recover database. [message #479401 is a reply to message #478823]

Sat, 16 October 2010 13:06

amit.sonar
Messages: 98
Registered: December 2009
Location: Mumbai

Member

Hi Michel,

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

Thanks,
Amit.

Report message to a moderator

Re: Help to recover database. [message #479403 is a reply to message #479401]

Sat, 16 October 2010 13:24

Michel Cadot
Messages: 68634
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 07:00:55 CDT 2024