【重庆思庄oracle技术分享】-主库增加表空间后，在DG备库备份会失败:RMAN-20079

本文主要是介绍【重庆思庄oracle技术分享】-主库增加表空间后，在DG备库备份会失败:RMAN-20079，对大家解决编程问题具有一定的参考价值，需要的程序猿们随着小编来一起学习吧！

Rman Backup On Physical Standby Database Failing with RMAN-20079 after Structure Changes on Primary (Doc ID 1326706.1)

In this Document
Symptoms
Cause
Solution
References

APPLIES TO:
Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.
Checked for relevance on 24-Jun-2013
SYMPTOMS
RMAN catalog is used to backup the database on Standby Database side.

New tablespace was added on the Primary Database side.

No RMAN backup or connection made on the Primary Database

RMAN backup on standby database failing with errors after adding new tablespace on primary.

RMAN backup failing with:

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of configure command at 05/17/2011 10:55:28
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of partial resync command on default channel at 05/17/2011 10:55:28
RMAN-20079: full resync from primary database is not done
CAUSE

The recovery catalog repository does not know about the new tablespace that was added since no RMAN resync was done between the Primary Database and Catalog Database.

SOLUTION
Unpublished Documentation Bug 7566701 was filed on this issue and closed as documentation bug.

It is necessary to perform resync between Primary Database and Catalog Database whenever there is a structural change done in the Primary Database.

Additionally, in 11g, for resync to get primary database changes, it is required to execute
RESYNC CATALOG FROM DB_UNIQUE_NAME ALL;

.
User will also have to setup necessary configuration using the below command:
CONFIGURE DB_UNIQUE_NAME <db_unique_name> CONNECT IDENTIFIER <sqlnet_alias>;

Make sure when you connect to the target database via the “rman” command you use a password and not to use OS authentication.

If running the resync…all on Standby Database, RMAN-20079 will still occur. The command needs to be run on primary DB.

$ rman target user/pwd@primary catalog rman/pwd@catalog
RMAN> RESYNC CATALOG FROM DB_UNIQUE_NAME ALL;

From the bug:

Changes to example 3-29 on page 3-56 of the B&R Reference Manual were made
for 11.2.
.
Resynchronizing the Recovery Catalog After a Structural Change
.
Suppose you have the following:
A Data Guard environment containing primary database prod and standby
database standby3
Both the primary and the standby databases are registered with the catalog
You take a backup of the database and archivelogs
You start SQL*Plus, connect to database prod, and add a datafile to tablespace users as follows:

SQL> ALTER TABLESPACE <TABLESPACE_NAME> ADD DATAFILE ‘’?/

CONFIGURE DB_UNIQUE_NAME standby CONNECT IDENTIFIER ’’;
.
At this point, you use the RESYNC CATALOG … ALL command to resynchronize
the recovery catalog with changes for all the databases in the Data Guard
environment. While you can resynchronize the catalog with a specific standby
site’s information, Oracle recommends you use the ALL option in order to keep
the recovery catalog schema current with any database changes that may have
occurred within your Data Guard environment:

RMAN> RESYNC CATALOG FROM DB_UNIQUE_NAME ALL;
.
The recovery catalog is updated with metadata about the datafile added to the
users tablespace of database prod.

这篇关于【重庆思庄oracle技术分享】-主库增加表空间后，在DG备库备份会失败:RMAN-20079的文章就介绍到这儿，希望我们推荐的文章对大家有所帮助，也希望大家多多支持为之网！