RMAN-03009: failure of backup command on ORA_SBT_TAPE_2 channel at 06/25/2009 10:53:54
FranklinFaces.com
FranklinFaces.com - Oracle & SQL Server Database Forums for all IT Professionals
 Home          Members     Calendar     Who's On

Welcome Guest ( Login | Register )
        



RMAN-03009: failure of backup command on... Expand / Collapse
Message
Posted 7/9/2009 3:12:05 PM Post #140
 

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being
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,


« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: silencer

Permissions Expand / Collapse

All times are GMT -5:00, Time now is 7:26am

Powered By InstantForum.NET v4.1.4 © 2010
Execution: 0.061. 7 queries. Compression Disabled.