RE: RMAN: restoring autobackup spfile and controlfile
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 1 Aug 2007 09:47:18 -0400
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
Other related posts:
