OraFAQ Forum: Backup & Recovery » Missing control file backup

Home » RDBMS Server » Backup & Recovery » Missing control file backup (oracle 10.2.0.1 windows)

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

Missing control file backup [message #638934]

Thu, 25 June 2015 10:47

SwaminathG
Messages: 1
Registered: June 2015
Location: India

Junior Member

Hi All,

Recently production db server was crashed and db has been gone. We have the backup in tape but control file backup location was in database server. So we are unavailable with control file backup only available with data files backup.

Now I need to restore the database. Can any one suggest the procedure to restore the database.

Thanks,
Swaminath.

Report message to a moderator

Re: Missing control file backup [message #638935 is a reply to message #638934]

Thu, 25 June 2015 11:15

John Watson
Messages: 8989
Registered: January 2010
Location: Global Village

Senior Member

Start the instance in nomount (all you need for that is a pfile with one parameter, db_name) then tell rman to restore the spfile and controlfile from the tape backup.

Report message to a moderator

Re: Missing control file backup [message #638936 is a reply to message #638934]

Thu, 25 June 2015 11:45

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

Senior Member
Account Moderator

http://www.orafaq.com/forum/t/197707/0/unread/#msg_638934

Report message to a moderator

Previous Topic:	I need help
Next Topic:	Restoration through full rman backup

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Sep 14 08:47:48 CDT 2025