Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: data format error in RMAN
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.
![]() |
![]() |