数据库信息不能同步到CATALOG，报RMAN-20032 错误

Kevin Zou

2011-9-15

在一个准生产环境中，在搭建RMAN 备份时发现有报错：

oracle@sjfdcpdb12:~> rman target / catalog rman/password@rmanp1

Recovery Manager: Release 10.2.0.4.0 - Production on Wed Sep 14 19:42:46 2011

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: TIMSDB (DBID=3333692251)
connected to recovery catalog database

RMAN> report schema;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of report command at 09/14/2011 19:43:02
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of full resync command on default channel at 09/14/2011 19:43:02
RMAN-20032: checkpoint change# too low

在CATALOG 数据库中，发现这个DB已经REGISTER 到CATALOG。

RMAN@rmanp1>select * from RC_DATABASE;

DB_KEY DBINC_KEY DBID NAME RESETLOGS_CHANGE# RESETLOGS_TIME

---------- ---------- ---------- -------- ----------------- ---------------

1 2 3657415769 HR9DBA 7498084 09-NOV-09

701 6482329 314373913 HR9PRD 6475783690 29-MAY-11

6260620 6260621 3333692251 TIMSDB 1 02-NOV-09

由于这个准生产环境是从生产环境中通过ONLINE backup搭建后RESETLOG的，CATALOG不知道这种情况。而且生产环境还在使用，所以不能用这个CATALOG，需要另外找个CATALOG的数据库。

在做系统切换时，需要做以下步骤：

RMAN> UNREGISTER DATABASE NOPROMPT;

RMAN> REGISTER DATABASE;

-THE END-