Controlfile piece handle lost from Tape [message #506552] |
Mon, 09 May 2011 19:02 |
hexmanju
Messages: 78 Registered: September 2005 Location: MUMBAI
|
Member |
|
|
We are trying to restore a database to a cold backup DBID.However while our datafiles were backuped up for 6 months retention we found out subsequent delete obsolete command wiped out the Control file related to this backup piece..Now what is left with this backup piece is just datafiles..
Can we still recover the database with a subsequent controlfile autobackup for the same DBID.?
|
|
|
|
Re: Controlfile piece handle lost from Tape [message #506579 is a reply to message #506552] |
Tue, 10 May 2011 01:30 |
John Watson
Messages: 8951 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
I think you can restore OK. You used the phrase "controlfile autobackup", which sounds like RMAN. That makes it harder than the way Black Swan is suggesting, which assumes a user managed backup. You will have to extract the datafiles from backup sets.
The technique will be to create a controlfile (as Black Swan says), and mount it. Then you will have catalog the backup pieces that contain the datafiles. You should then be able to issue the RESTORE command.
|
|
|