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>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment