RMAN-03009: failure of backup command on ORA_SBT_TAPE_2 channel at 06/25/2009 10:53:54

Admin — Thu, 09 Jul 2009 15:12:05 GMT

I was getting the following error message when using RMAN to backup the FRA (Flash Recovery Area) to tape.

input backupset count=436 stamp=690417844 creation_time=24-JUN-2009 22:44:04

channel ORA_SBT_TAPE_2: starting piece 1 at 25-JUN-2009 10:53:54

RMAN-03009: failure of backup command on ORA_SBT_TAPE_2 channel at 06/25/2009 10:53:54

ORA-01830: date format picture ends before converting entire input string

continuing other job steps, job failed will not be re-run

piece handle=PRODDB_S434_P1_20090625 comment=API Version 2.0,MMS Version 5.0.0.0

channel ORA_SBT_TAPE_1: finished piece 1 at 25-JUN-2009 10:57:39

channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:32:36

RMAN-00571: ===========================================================

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

RMAN-00571: ===========================================================

RMAN-12009: command aborted because some backup pieces could not be located

RMAN-12008: could not locate backup piece +SHARED_FRA_DG01/proddb/autobackup/2009_06_24/s_690417844.289.690417845

RMAN-03009: failure of backup command on ORA_SBT_TAPE_2 channel at 06/25/2009 10:53:54

ORA-01830: date format picture ends before converting entire input string

RMAN-12008: could not locate backup piece +SHARED_FRA_DG01/proddb/autobackup/2009_06_24/s_690368534.438.690368535

RMAN-03009: failure of backup command on ORA_SBT_TAPE_1 channel at 06/25/2009 10:03:59

ORA-01830: date format picture ends before converting entire input string

This configuration was as follows:

Oracle 10.2.0.4 Running on Solars 10 using Oracle ASM.

I tried everything to figure out what the error could be.

This is what was in my rman script:

configure default device type to sbt;
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' FORMAT '%d_S%s_P%p_%T';
backup recovery area;

After a couple of days trying to figure this one out. I turned to metalink and they really didn't have much untile a fellow dba pointed out this note on metalink: 433559.1

After reading through that, I updated my unix shell script to add the following entry:

export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1

That solved my problem. After setting this, the issue went away.

I hope this helps you out.

Thanks,

FranklinFaces.com - Oracle & SQL Server Database Forums for all IT Professionals / Oracle Forum / RMAN - Error Codes / RMAN-03000-03999

RMAN-03009: failure of backup command on ORA_SBT_TAPE_2 channel at 06/25/2009 10:53:54