RE: RMAN error code

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@xxxxxxxxxxx';
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@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@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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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

Other related posts: