Home » RDBMS Server » Backup & Recovery » Can restoring backup from tape to disk help me to restore spilfw (11.2.0.4 windows 2012 r2)
Can restoring backup from tape to disk help me to restore spilfw [message #665653] Thu, 14 September 2017 02:23 Go to next message
juniordbanewbie
Messages: 250
Registered: April 2014
Senior Member
Dear all,

currently my customer backup is in tape.
They did enable autobackup and they set the controlfile autobackup to a non default format

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'Z:\backup\autobackup\cont
olcopy.ctl_%d_%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default

unfortunately I have not taken down their dbid.

can restoring tape backup to disk help me to restore spfile since the smallest backup piece is most likely a autocontrolfile backup?

I can just do the following


RESTORE spFILE FROM 'backuppiece full path';

thanks a lot!
Re: Can restoring backup from tape to disk help me to restore spilfw [message #665654 is a reply to message #665653] Thu, 14 September 2017 03:06 Go to previous messageGo to next message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
You should be able to simply:
RMAN> STARTUP NOMOUNT;
RMAN> RESTORE SPFILE FROM AUTOBACKUP;
Re: Can restoring backup from tape to disk help me to restore spilfw [message #667954 is a reply to message #665654] Thu, 25 January 2018 18:37 Go to previous message
juniordbanewbie
Messages: 250
Registered: April 2014
Senior Member
Dear gazzag,

as a matter of fact for this case we need to record down dbid,

that's why I thinking of inserting the dbid into a controlfile trace if customer backup to tape.

see http://orafaq.com/forum/m/667949/#msg_667949

thanks!
Previous Topic: Cannot drop undotbs2 when restoring 10.2.0.4 rac db to 11.2.0.4 single instance db
Next Topic: How to restore these changes to another cluster
Goto Forum:
  


Current Time: Thu Mar 28 15:20:09 CDT 2024