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.

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.

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

No comments: