Trying to register a database with my rman catalog I was getting the following error
$ rman target sys/xxx@DB01 catalog=RMAN_DB01/xxx@rmancat Recovery Manager: Release 11.2.0.4.0 - Production on Mon Aug 7 11:42:37 2017 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to target database: DB01 (DBID=114156133) connected to recovery catalog database RMAN> create catalog; recovery catalog created RMAN> register database; starting full resync of recovery catalog RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of register command at 08/07/2017 11:42:44 RMAN-03014: implicit resync of recovery catalog failed RMAN-03009: failure of full resync command on default channel at 08/07/2017 11:42:44 RMAN-20036: invalid record order
Poking around metalink I found note 113325.1
Basicly it says there is a mismatch in the number of standby redo logs, but this database does not have a standby. However it was cloned from a database that had a standby, and I apparently forgot to remove the standby redo logs after I cloned it.
SQL> select INST_ID,GROUP#,TYPE from gv$logfile;
1 1 ONLINE
1 2 ONLINE
1 3 ONLINE
1 4 INVALID STANDBY
1 5 STANDBY
2 6 ONLINE
2 7 ONLINE
2 8 ONLINE
2 9 INVALID STANDBY
2 10 STANDBY
So cleanup the standby logfiles
SQL> alter database drop standby logfile group 1 thread 4; Database altered. SQL> alter database drop standby logfile group 1 thread 5; Database altered. SQL> alter database drop standby logfile group 2 thread 9; Database altered. SQL> alter database drop standby logfile group 2 thread 9; Database altered.
I dropped and re-created the catalog
RMAN> create catalog; recovery catalog created RMAN> register database; database registered in recovery catalog starting full resync of recovery catalog full resync complete
Recent Comments