FreeLists / oracle-l / RE: RMAN: restoring autobackup spfile and controlfile

["Powell, Mark D" <mark.powell@xxxxxxx>]

Thank you Jared.  You never know when the information like what you
presented here is going to come in useful.

-- Mark D Powell -- 
Phone (313) 592-5148 

 


________________________________

        From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jared Still
        Sent: Tuesday, July 31, 2007 3:11 PM
        To: Oracle-L Freelists
        Subject: RMAN: restoring autobackup spfile and controlfile
        
        

        I seem to run into lots of issues using RMAN.
        
        Maybe I'm just unlucky with RMAN more frequently than others.
        
        Anyway an interesting issue popped up while trying to restore
autobackup
        copies of an spfile and controlfile. 
        
        First the particulars:
        
        Linux - RH ES 4 64 bit
        Oracle 9.2.0.7
        Veritas NetBackup 5.1 MP5 at both Client and Master Server
        
        This is a test restore (not an emergency thankfully) for
Sarbanes Oxley compliance 
        testing, so the restore is to a new database.
        
        Here's the script I first attempted to use to restore both the
spfile and controlfile.
        
        set DBID=2182868868;
        startup nomount;
        
        run {
                ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' debug=5 trace 2; 
                restore spfile from      'c-2182868868-20070608-01';
                restore controlfile from 'c-2182868868-20070608-01';
                RELEASE CHANNEL ch00;
        }
        
        This script ends with the following output: 
        allocated channel: ch00
        channel ch00: sid=7 devtype=SBT_TAPE
        channel ch00: VERITAS NetBackup for Oracle - Release 5.1
(2005081402)
        
        Starting restore at 07/30/2007 17:11:47
        
        channel ch00: autobackup found: c-2182868868-20070730-01 
        released channel: ch00
        RMAN-00571:
===========================================================
        RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
===============
        RMAN-00571:
=========================================================== 
        RMAN-03002: failure of restore command at 07/30/2007 17:29:35
        ORA-27192: skgfcls: sbtclose2 returned error - failed to close
file
        ORA-19511: Error received from media manager layer, error text:
           Failed to process backup file <c-2182868868-20070730-01> 
                ORA-07202: sltln: invalid parameter to sltln.
        
        The ML response to this is "open an SR"  ( ML 20259.1)
        
        Quite by accident I found a workaround:  restore each file
separately
        
        
        set DBID=2182868868; 
        startup nomount;
        
        run {
                ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' debug=5 trace 2;
                restore spfile from      'c-2182868868-20070608-01';
                RELEASE CHANNEL ch00;
        }
        
        
        run {
                ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' debug=5 trace 2;
                restore controlfile from 'c-2182868868-20070608-01';
                RELEASE CHANNEL ch00;
        }
        
        
        Maybe a tidbit to tuck away for later use. 
        
        
        -- 
        Jared Still
        Certifiable Oracle DBA and Part Time Perl Evangelist