OraFAQ Forum: Backup & Recovery » Restore database using datafile control file and Redo Logfile

Home » RDBMS Server » Backup & Recovery » Restore database using datafile control file and Redo Logfile (Windows Server 2008)

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

Restore database using datafile control file and Redo Logfile [message #644003]

Sun, 25 October 2015 01:00

reaz62
Messages: 15
Registered: December 2012
Location: dhaka

Junior Member

I have datafile control file and Redo Logfile .
How can I restore database using datafile control file and Redo Logfile to new server ?

Report message to a moderator

Re: Restore database using datafile control file and Redo Logfile [message #644004 is a reply to message #644003]

Sun, 25 October 2015 01:16

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

If you have all files then just ORADIM to create the Oracle database service, create a new pfile with just db_name (and maybe db_block_size if it is not standard) in $ORACLE_HOME/database and start the service.

Report message to a moderator

Re: Restore database using datafile control file and Redo Logfile [message #644008 is a reply to message #644003]

Sun, 25 October 2015 09:12

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

You don't mention the Oracle version, so I'm going to assume 11.2.x See here.

Report message to a moderator

Re: Restore database using datafile control file and Redo Logfile [message #644028 is a reply to message #644004]

Mon, 26 October 2015 06:43

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

Michel Cadot wrote on Sun, 25 October 2015 01:16

If you have all files then just ORADIM to create the Oracle database service, create a new pfile with just db_name (and maybe db_block_size if it is not standard) in $ORACLE_HOME/database and start the service.

.. assuming the OP is on Windows.

Smile