[oradb@database ~]$ rman target sys@orcl catalog=vinay/vinay@dbcata
Recovery Manager: Release 10.2.0.4.0 - Production on Fri Feb 14 22:43:12 2014
Copyright (c) 1982, 2007, Oracle. All rights reserved.
target database Password:
connected to target database: ORCL (DBID=1366343272, not open)
connected to recovery catalog database
RMAN> recover database;
Starting recover at 14-FEB-14
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 02/14/2014 22:43:29
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of full resync command on default channel at 02/14/2014 22:43:29
RMAN-20032: checkpoint change# too low
-----------------If Incomplete recovery perform the must to update catalog database
rman target sys@orcl catalog=vinay/vinay@dbcata
RMAN> unregister database ORCL;
RMAN> register database;
database registered in recovery catalog
starting full resync of recovery catalog
full resync complete
RMAN> resync catalog;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of resync command on default channel at 02/15/2014 01:01:55
RMAN-20020: database incarnation not set
RMAN> reset database;
Recovery Manager: Release 10.2.0.4.0 - Production on Fri Feb 14 22:43:12 2014
Copyright (c) 1982, 2007, Oracle. All rights reserved.
target database Password:
connected to target database: ORCL (DBID=1366343272, not open)
connected to recovery catalog database
RMAN> recover database;
Starting recover at 14-FEB-14
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 02/14/2014 22:43:29
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of full resync command on default channel at 02/14/2014 22:43:29
RMAN-20032: checkpoint change# too low
-----------------If Incomplete recovery perform the must to update catalog database
rman target sys@orcl catalog=vinay/vinay@dbcata
RMAN> unregister database ORCL;
RMAN> register database;
database registered in recovery catalog
starting full resync of recovery catalog
full resync complete
RMAN> resync catalog;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of resync command on default channel at 02/15/2014 01:01:55
RMAN-20020: database incarnation not set
RMAN> reset database;
1 comment:
I found another solution: Just wait.
We made a snapshot of the databaseserver. After that a backup was registered in the RMAN catalog. Then we restored the snapshot.
When we tried to make a new backup we got RMAN-20032.
I tried several times the same day, but with no luck.
2 days later everything was fine, probably because the checkpoint CHANGE# was increased and was higher than the checkpoint CHANGE# registered in the catalog.
Kees
Post a Comment