RE: RMAN error code

From: Marquez, Chris <CMarquez_at_aarp.org>
Date: Tue, 8 Mar 2005 12:33:18 -0500
Message-ID: <7E412C164E6ECB468834A39F31E6E0D4066890BF@mbs06dc.na.aarp.int>

Drake,

You still have this issue?
You left out critical info...how exactly did you allocate the channel to tape; sbt_tape?

Below are two examples of RMAN-03009 I have received. Usually you get two things (which you did not); 1. Better info from Oracle RMAN error code. 2. Some info from the OS.

I my guess is that you RMAN/TDPO param's are not good or bad channel syntax,
or
the TSM was simply not ready / available to receive client connections from <-TDPO<-Oracle/RMAN?

Also below I have provided syntax I have used in the past.

hth

Chris Marquez
Oracle DBA
HEYMONitor(tm) - heymonitor.com
"Oracle Monitoring & Alerting Solution"

RMAN-00571: =


=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=

=3D=3D=3D=3D=3D=3D=3D=3D=3D

RMAN-00569: =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D ERROR MESSAGE = STACK FOLLOWS =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

RMAN-00571: =


=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D

RMAN-03009: failure of backup command on c2c channel at 11/21/2003 00:47:56
ORA-19502: write error on file
"/orcl03/orcl/Thu_ORCL_data_1jf6v2mo_1_1.bkp", blockno 968833 (blocksize=3D8192)
ORA-27063: skgfospo: number of bytes read/written is incorrect IBM AIX RISC System/6000 Error: 28: No space left on device Additional information: -1
Additional information: 1048576

RMAN-00571: =


=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=

=3D=3D=3D=3D=3D=3D=3D=3D=3D

RMAN-00569: =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D ERROR MESSAGE = STACK FOLLOWS =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

RMAN-00571: =


=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D

RMAN-03002: failure of restore command at 09/08/2004 15:30:41 ORA-19504: failed to create file "/dev/ra0025l9ida001" ORA-27042: not enough space on raw partition to fullfill request Additional information: 2

---DELETE BACKUP using maintenance channel. allocate channel for maintenance type SBT_TAPE parms 'ENV=3D(TDPO_OPTFILE=3D/a0007/app/oracle/tivoli/orcl_tdpo.opt)'; *OR*
allocate channel for maintenance type disk; allocate channel for maintenance type disk connect 'system/manager_at_orcl6.world';
release channel;

change backuppiece orcl_03ejvmks_1_1.bkp delete; delete NOPROMPT backupset 41, 39, 38, 36, 34, 35;

crosscheck backup;
delete EXPIRED backupset;

---DELETE BACKUP from tape withOUT using "allocate channel for maintenance type SBT_TAPE"!!!
CONFIGURE RETENTION POLICY TO redundancy 1;

CONFIGURE DEFAULT DEVICE TYPE TO     sbt;
CONFIGURE DEVICE TYPE     sbt     PARALLELISM     1;
CONFIGURE CHANNEL     0 DEVICE TYPE     sbt     CLEAR;
CONFIGURE CHANNEL     1 DEVICE TYPE     sbt     CLEAR;
CONFIGURE CHANNEL     2 DEVICE TYPE     sbt     CLEAR;

CONFIGURE CHANNEL     1 DEVICE TYPE     sbt     FORMAT=3D
'%d_%u_%p_%c.bkp'       PARMS

'ENV=3D(TDPO_OPTFILE=3D/a0006/app/oracle/tivoli/orcl_tdpo.opt)';

CONFIGURE CHANNEL     1 DEVICE TYPE     sbt     FORMAT=3D
'%d_%u_%p_%c.bkp'     CONNECT     'system/manager_at_orcl6'     PARMS

'ENV=3D(TDPO_OPTFILE=3D/a0006/app/oracle/tivoli/orcl_tdpo.opt)';

CONFIGURE DEVICE TYPE     disk     PARALLELISM     1;
CONFIGURE CHANNEL     0 DEVICE TYPE     disk     CLEAR;
CONFIGURE CHANNEL     1 DEVICE TYPE     disk     CLEAR;
CONFIGURE CHANNEL     1 DEVICE TYPE     disk     FORMAT=3D
'%d_%u_%p_%c.bkp'     CONNECT     'system/manager_at_orcl6'     PARMS

'ENV=3D(TDPO_OPTFILE=3D/a0006/app/oracle/tivoli/orcl_tdpo.opt)';

change archivelog all crosscheck;
change archivelog all validate;

DELETE NOPROMPT OBSOLETE redundancy 0;
DELETE NOPROMPT BACKUPSET 37,41,43,44,49,50,51,52,53;=20 -----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Drake Emko Sent: Friday, March 04, 2005 10:15 AM
To: Oracle List
Subject: RMAN error code

Could someone please tell me where I can download a manual for RMAN, or go to look up error codes? I've been looking on google as well as the Oracle website, and haven't had any luck.

Here is my problem; When trying to delete obsolete RMAN backupsets, I get an error:

RMAN> change backupset 698, 702, 704, 708 delete;

List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name ------- ------- --- --- ----------- ----------- ----------

698     698     1   1   AVAILABLE   SBT_TAPE    df_546210555_706_1
702     702     1   1   AVAILABLE   SBT_TAPE    df_546296605_709_1
704     704     1   1   AVAILABLE   SBT_TAPE    df_546383776_712_1
708     708     1   1   AVAILABLE   SBT_TAPE    df_546469964_715_1

Do you really want to delete the above objects (enter YES or NO)? YES

RMAN-00571: =


=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=

=3D=3D=3D=3D=3D=3D=3D=3D=3D

RMAN-00569: =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D ERROR MESSAGE = STACK FOLLOWS =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

RMAN-00571: =


=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D

RMAN-03009: failure of delete command on ORA_MAINT_SBT_TAPE_1 channel at 03/02/2005 16:27:06
ORA-27191: sbtinfo2 returned error
Additional information: 2

What in the world does "Additional information: 2" mean? I can't find any more useful detail than this.

Thanks,
Drake

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

Received on Tue Mar 08 2005 - 12:36:53 CST