Home » RDBMS Server » Backup & Recovery » Restoring spfile and control file to a new location (RDBMS10.2.0.4, Win2003 x64, RMAN)
Restoring spfile and control file to a new location [message #518337] Wed, 03 August 2011 04:43 Go to next message
hristo
Messages: 258
Registered: May 2007
Senior Member
Hi!

Im trying to restore my spfile and (later controlfile) to a new location:


RMAN> connect catalog rman11cv/pwd@metarep

Connected...

RMAN> connect target

ansluten till msldatabasen: DATABASE (DBID=510270843)

RMAN> run
2> {
3> allocate channel ch1 type 'sbt_tape'
4> PARMS="BLKSIZE=262144,ENV=(CV_mmsApiVsn=2,CV_channelPar=ch1)"
5> TRACE 0;
6> Restore spfile to pfile 'y:\restore\pfile.ora';
7> }

tilldelad kanal: ch1
kanal ch1: sid=537 devtype=SBT_TAPE
kanal ch1: CommVault Systems for Oracle: Version 9.0.0(BUILD84)

Starting restore at 2011-08-03

frigjord kanal: ch1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: restore-command failed at 08/03/2011 11:39:26
ORA-27191: sbtinfo2 returned an error



The spfile and control file exists.


RMAN>list backup of spfile

BS-nyckel  Typ N Storlek       Enhetstyp Tidsσtgσng Slutf÷randetid
------- ---- -- ---------- ----------- ------------ --------------
736698  Full    256.00K    SBT_TAPE    00:00:04     2011-08-02
        BP-nyckel: 736705   Status: AVAILABLE  Komprimerad: NO  Tagg: TAG2011080
2T181240
        Handtag: dkmj0i8p_1_1   Media: V_73870
  SPFILE har inkluderats: Σndringstid: 2011-08-02



What is wrong here?

Re: Restoring spfile and control file to a new location [message #518344 is a reply to message #518337] Wed, 03 August 2011 05:14 Go to previous messageGo to next message
Michel Cadot
Messages: 68051
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-27191: sbtinfo2 returned error
 *Cause:  sbtinfo2 returned an error.  This happens while retrieving
          backup file information from the media manager's catalog.
 *Action: This error is returned from the media management software which is
          linked with Oracle.  There should be additional messages which
          explain the cause of the error.  This error usually requires
          contacting the media management vendor.

Regards
Michel
Re: Restoring spfile and control file to a new location [message #518345 is a reply to message #518344] Wed, 03 August 2011 05:16 Go to previous messageGo to next message
Michel Cadot
Messages: 68051
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The backup exists in RMAN catalog but does it exist on tape?

Regards
Michel
Re: Restoring spfile and control file to a new location [message #518351 is a reply to message #518345] Wed, 03 August 2011 05:58 Go to previous messageGo to next message
hristo
Messages: 258
Registered: May 2007
Senior Member
Good question, how do I check that?


ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE sbt;
CROSSCHECK BACKUP DEVICE TYPE sbt COMPLETED BETWEEN '01-AUG-11' AND '02-AUG-11';



Or?

[Updated on: Wed, 03 August 2011 06:11]

Report message to a moderator

Re: Restoring spfile and control file to a new location [message #518352 is a reply to message #518351] Wed, 03 August 2011 06:12 Go to previous messageGo to next message
Michel Cadot
Messages: 68051
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't know, check your CommVault manual, or ask your sysadmin.

Regards
Michel
Re: Restoring spfile and control file to a new location [message #518388 is a reply to message #518352] Wed, 03 August 2011 08:22 Go to previous message
hristo
Messages: 258
Registered: May 2007
Senior Member
Well, I found this in the Commvault GUI:

Quote:
SID Specified in GUI [DATABASE] and actual Oracle SID [database] differ. Offline Backup with Lights-out script may not be successful.


So, I changed the SID to lower cases for the Commvault agent. Hopefully, this explains why there are no backups on tape.

[Updated on: Wed, 03 August 2011 08:29] by Moderator

Report message to a moderator

Previous Topic: How to determine the rate of block change?
Next Topic: Question on Backup archive log files
Goto Forum:
  


Current Time: Tue Dec 07 01:22:00 CST 2021