Help to recover database. [message #476997] |
Mon, 27 September 2010 13:21 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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.
|
|
|
|
|
|
Re: Help to recover database. [message #478666 is a reply to message #477001] |
Mon, 11 October 2010 14:04 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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
|
|
|
|
|
|
|
Re: Help to recover database. [message #479403 is a reply to message #479401] |
Sat, 16 October 2010 13:24 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 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
|
|
|