RE: RMAN: restoring autobackup spfile and controlfile

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Wed, 1 Aug 2007 09:47:18 -0400
Message-ID: <D1DC33E67722D54A93F05F702C99E2A901294C96@usahm208.amer.corp.eds.com>

 

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 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
	

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

Received on Wed Aug 01 2007 - 08:47:18 CDT