RMAN: restoring autobackup spfile and controlfile

From: Jared Still <jkstill_at_gmail.com>
Date: Tue, 31 Jul 2007 12:11:23 -0700
Message-ID: <bf46380707311211g70fd5303x54dbd0b2f8e89223@mail.gmail.com>

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

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jul 31 2007 - 14:11:23 CDT