ORA-16796: one or more properties could not be imported from the database [ID 358040.1]

ORA-16796: one or more properties could not be imported from the database [ID 358040.1]


 

Modified 29-MAY-2009     Type PROBLEM     Status MODERATED

 

In this Document
  Symptoms
  Cause
  Solution


 

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.4
This problem can occur on any platform.

Symptoms

$ dgmgrl
DGMGRL for Linux: Version 10.2.0.1.0 - Production

Copyright (c) 2000, 2005, Oracle. All rights reserved.

Welcome to DGMGRL, type "help" for information.
DGMGRL> connect sys/<Password>
Connected.
DGMGRL> remove configuration
Removed configuration

DGMGRL> create configuration 'SHRUB' as
> primary database is 'SHRUB'
> connect identifier is 'SHRUB';
Configuration "SHRUB" created with primary database "SHRUB"

DGMGRL> add database 'WAGTAIL' as
> connect identifier is wagtail
> maintained as physical;
Error: ORA-16796: one or more properties could not be imported from the database

Failed.

Following error reported in the standby dataguard broker log

DG 2006-02-14-22:16:08 0 2 0 DMON: cannot open configuration file "/oracle/product/10.2.0/dbs/dr2wagtail.dat"

Cause

Noticed following file was not exists at standby server.

DG 2006-02-14-22:16:08 0 2 0 DMON: cannot open configuration file "/oracle/product/10.2.0/dbs/dr2wagtail.dat"

Solution

1) Stop the Data Guard Broker on both, the Primary and Standby Database using following Command:

 

SQL> alter system set dg_broker_start=false scope=both;

 

2) Remove the old Data Guard Broker Configuration Files specified by the Initialization Parameter 'DG_BROKER_CONFIG_FILE1|2' from Primary and Standby Site.

3)  Start the Data Guard Broker on both Sites again:

 

SQL> alter system set dg_broker_start = true scope=both;

 

4) Recreate the Data Guard Broker Configuration


 

 

 

 

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

QQ:492913789

Email:ahdba@qq.com

Blog: http://www.cndba.cn/dave 


网上资源: http://tianlesoftware.download.csdn.net

相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx

DBA1 群:62697716(); DBA2 群:62697977()

DBA3 群:62697850   DBA 超级群:63306533;    

聊天 群:40132017

--加群需要在备注说明Oracle表空间和数据文件的关系,否则拒绝申请

©️2020 CSDN 皮肤主题: 大白 设计师:CSDN官方博客 返回首页