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 //www.freelists.org/archives/oracle-l/ >FAQ is at //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 //www.freelists.org/archives/oracle-l/ >FAQ is at //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 //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------