Home » RDBMS Server » Backup & Recovery » Recover database without dump . (Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 ,Windows server 200R23)
Recover database without dump . [message #417762] Tue, 11 August 2009 07:47 Go to next message
sasipalarivattom
Messages: 118
Registered: June 2007
Location: Cochin ( INDIA )
Senior Member

Dear All,

Our database server has been crashed.
We cannot login to the OS or the database .

We did recover all the data from the hard disk.
Now what we have is all the installed files of the database and the table spaces.
We do not have a dump of the database.

Is there any way that we can clone this database in another server?
Its bit urgent!!
Please help me.

Thanks and Regards,
Sasi.
Re: Recover database without dump . [message #417775 is a reply to message #417762] Tue, 11 August 2009 09:17 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10615
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>Now what we have is all the installed files of the database and the table spaces.
Tablespaces are logical. You cannot "see it" unless you are logged into the database.
>>We did recover all the data from the hard disk.
If that holds true and Oracle is happy about it,
You can just mount the database and open it, provided all the files are in same directory structure.
Re: Recover database without dump . [message #417883 is a reply to message #417775] Wed, 12 August 2009 00:16 Go to previous messageGo to next message
sasipalarivattom
Messages: 118
Registered: June 2007
Location: Cochin ( INDIA )
Senior Member

Dear Mahesh,

Thanks for your reply.


Now we are installing a database in a new server and we need all our data in this new database.

Can you please tell me the steps to do this?

Thanks once again.

Regards,
Sasi.
Re: Recover database without dump . [message #417886 is a reply to message #417762] Wed, 12 August 2009 00:31 Go to previous messageGo to next message
BlackSwan
Messages: 22539
Registered: January 2009
Senior Member
>Can you please tell me the steps to do this?
Exactly what do you have?
Re: Recover database without dump . [message #417980 is a reply to message #417775] Wed, 12 August 2009 05:54 Go to previous message
Mahesh Rajendran
Messages: 10615
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Same answer. To make your process simple,
create the same directory structure.
Place the files in same directory as before.
Mount and open the database.
Again it will work if your "recovered files" are good.

The exact steps /alternative options will depend on how you answer BlackSwan's question.
Quote:
Exactly what do you have?
Previous Topic: RMAN-04006 with ORA-01031 (Auxiliary Connect)
Next Topic: rman instance shutdown suddenly
Goto Forum:
  


Current Time: Wed Jul 30 19:37:45 CDT 2014

Total time taken to generate the page: 0.08923 seconds