Re: Re: data format error in RMAN

hi,Fuad Arshad

 what are your  NLS_DATE_FORMAT  and NLS_LANG in the  ENV ?
 do not set the NLS_DATE_FORMAT ,and try to set  
NLS_LANG=AMERICAN_AMERICA.xxxxxx     



Best regards

msn: biti_rainy@xxxxxxxxxxx
a dba from alibaba(china)

---- from the  mail-----
>can you post your rman restore script.
>it seems that the restore was successful but there was something else that was 
>after the restore command.
>cannot say until  know what script has
>jaysingh1@xxxxxxxxxxxxx wrote:
>Hi All,
>Could someone help me to fix this issue? I checked metalink but nothing 
>related to RMAN.
>
>
>Recovery Manager: Release 10.1.0.2.0 - Production
>Copyright (c) 1995, 2004, Oracle. All rights reserved.
>
>RMAN> 
>connected to target database: HSBC (DBID=1678769544)
>
>RMAN> 
>connected to recovery catalog database
>
>RMAN> 2> 3> 4> 5> 6> 7> 8> 
>sql statement: alter datafile 4 offline
>
>executing command: SET NEWNAME
>
>Starting restore at 28-AUG-04
>allocated channel: ORA_DISK_1
>channel ORA_DISK_1: sid=215 devtype=DISK
>
>channel ORA_DISK_1: restoring datafile 00004
>input datafilecopy recid=7 stamp=535373761 
>filename=+ORCL_DATA4/hsbc/datafile/users.294.1
>destination for restore of datafile 00004: +ORCL_DATA4
>channel ORA_DISK_1: copied datafilecopy of datafile 00004
>output filename=+ORCL_DATA4/hsbc/datafile/users.301.1 recid=8 stamp=535376913
>Finished restore at 28-AUG-04
>RMAN-00571: ===========================================================
>RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
>RMAN-00571: ===========================================================
>RMAN-03008: error while performing automatic resync of recovery catalog
>ORA-01801: date format is too long for internal buffer
>
>RMAN> 
>
>Recovery Manager complete.
>
>----------------------------------------------------------------
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>----------------------------------------------------------------
>To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
>put 'unsubscribe' in the subject line.
>--
>Archives are at http://www.freelists.org/archives/oracle-l/
>FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
>-----------------------------------------------------------------
>
>
>----------------------------------------------------------------
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>----------------------------------------------------------------
>To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
>put 'unsubscribe' in the subject line.
>--
>Archives are at http://www.freelists.org/archives/oracle-l/
>FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
>-----------------------------------------------------------------
>
>.


        


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts:

  • » Re: Re: data format error in RMAN