Home » RDBMS Server » Backup & Recovery » restore database using datafiles controlfiles
restore database using datafiles controlfiles [message #167588] Fri, 14 April 2006 04:08 Go to next message
tridentadm
Messages: 142
Registered: March 2006
Senior Member
i would like to know if i have existing datafiles and the coltrolfiles, but everything is lost
and
i have to do a new oracle installation.

can i restore back the database based on the old existing datafiles and controlfiles ???

Report message to a moderator

Re: restore database using datafiles controlfiles [message #169272 is a reply to message #167588] Wed, 26 April 2006 00:49 Go to previous messageGo to next message
sanka_yanka
Messages: 184
Registered: October 2005
Location: Kolkata
Senior Member
Yea,
You can do it.
Follow the link http://download-west.oracle.com/docs/cd/B25329_01/doc/admin.102/b25107/backrest.htm#CHDJIIDJhttp://download-west.oracle.com/docs/cd/B25329_01/doc/admin.102/b25107/backrest.htm#CHDJIIDJ


Thanks & Regards
Sanka

Report message to a moderator

Re: restore database using datafiles controlfiles [message #169893 is a reply to message #169272] Sun, 30 April 2006 03:09 Go to previous message
lakher
Messages: 14
Registered: April 2006
Junior Member
1、you backup datafile and controlfile to new dictionary better.
2、you must install oracle software,and oracle's dictionary is same that old oracle program.
3、you can copy datafile and controlfile to old dictionary。
4、you edit a init.ora as you new init file.
5、then startup and resolve problem

Report message to a moderator

Previous Topic: Recovery catalog backup & recovery
Next Topic: Recovering Database
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 17:37:14 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.