OraFAQ Forum: Backup & Recovery » Can restoring backup from tape to disk help me to restore spilfw

Home » RDBMS Server » Backup & Recovery » Can restoring backup from tape to disk help me to restore spilfw (11.2.0.4 windows 2012 r2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Can restoring backup from tape to disk help me to restore spilfw [message #665653]

Thu, 14 September 2017 02:23

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

Code: [Select all] [Show/ hide]

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

Code: [Select all] [Show/ hide]

RESTORE spFILE FROM 'backuppiece full path';

thanks a lot!

Report message to a moderator

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

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

You should be able to simply:

Code: [Select all] [Show/ hide]

RMAN> STARTUP NOMOUNT;
RMAN> RESTORE SPFILE FROM AUTOBACKUP;

Report message to a moderator

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

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!

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 17 07:04:43 CDT 2025