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_at_hotmail.com
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_at_optonline.net 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_at_freelists.org
>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_at_freelists.org
>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_at_freelists.org
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
-----------------------------------------------------------------
Received on Sat Aug 28 2004 - 22:41:45 CDT