Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: data format error in RMAN

Re: data format error in RMAN

From: Fuad Arshad <fuadar_at_yahoo.com>
Date: Sat, 28 Aug 2004 16:29:05 -0700 (PDT)
Message-ID: <20040828232905.21378.qmail@web80505.mail.yahoo.com>


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
Received on Sat Aug 28 2004 - 18:25:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US