Home » RDBMS Server » Backup & Recovery » Missing control file backup (oracle 10.2.0.1 windows)
Missing control file backup [message #638934] Thu, 25 June 2015 10:47 Go to next message
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.
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: 7624
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: 65850
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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

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


Current Time: Tue Oct 23 12:09:17 CDT 2018