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,