Tuesday, April 29, 2008

ORA-01801: date format is too long for internal buffer while resync catalog

While doing resync catalog in RMAN, getting the following error:
RMAN> list incarnation;
starting full resync of recovery catalogRMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure of list command at 04/29/2008 15:41:19RMAN-03014: implicit resync of recovery catalog failedRMAN-03009: failure of full resync command on default channel at 04/29/2008 15:41:19ORA-01801: date format is too long for internal buffer

Note the resync catalog can be implicly called by other command like reset database, list incarnation, list backup, etc.

Solution:
Change the date format at the recovery catalog and restart.
SQL> alter system set nls_date_format='YYYY-MM-DD:HH24:MI:SS' scope=spfile;
System altered.
SQL> shutdown immediate;Database closed.Database dismounted.ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose], [], [], [], [], [], [], []SQL> startupORACLE instance started.
Total System Global Area 784334848 bytesFixed Size 2074504 bytesVariable Size 423626872 bytesDatabase Buffers 352321536 bytesRedo Buffers 6311936 bytesDatabase mounted.Database opened.
SQL>

Reconnect to rman and then the problem is fixed.
RMAN> exit
Recovery Manager complete.$ rman target sys/password@anly3trn catalog rman/rman@catdev
Recovery Manager: Release 10.2.0.2.0 - Production on Tue Apr 29 15:48:11 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: ANLY3TRN (DBID=25363641)connected to recovery catalog database
RMAN> resync catalog;
starting full resync of recovery catalogfull resync complete
RMAN>

No comments: