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: 169
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 message
gazzag
Messages: 905
Registered: November 2010
Location: Bristol, UK
Senior Member
You should be able to simply:
RMAN> STARTUP NOMOUNT;
RMAN> RESTORE SPFILE FROM AUTOBACKUP;
Previous Topic: Retention Policy for Control File Auto Backups
Next Topic: Old backups not getting deleted
Goto Forum:
  


Current Time: Wed Nov 22 21:50:24 CST 2017

Total time taken to generate the page: 0.08963 seconds