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 -----------------------------------------------------------------