Home » RDBMS Server » Backup & Recovery » Missing control file backup (oracle windows)
Missing control file backup [message #638934] Thu, 25 June 2015 10:47 Go to next message
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.

Re: Missing control file backup [message #638935 is a reply to message #638934] Thu, 25 June 2015 11:15 Go to previous messageGo to next message
John Watson
Messages: 7255
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.
Re: Missing control file backup [message #638936 is a reply to message #638934] Thu, 25 June 2015 11:45 Go to previous message
Michel Cadot
Messages: 65380
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator


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

Current Time: Sun Feb 18 13:17:01 CST 2018

Total time taken to generate the page: 0.01312 seconds