oracle 12C dataguard同步状态RESYNCHRONIZATION异常处理

最新推荐文章于 2024-06-19 09:02:04 发布

zjw922

最新推荐文章于 2024-06-19 09:02:04 发布

阅读量822

点赞数

分类专栏： Oracle dataguard

本文链接：https://blog.csdn.net/zjw922/article/details/102556407

版权

Oracle dataguard 专栏收录该内容

5 篇文章 1 订阅

订阅专栏

oracle 12C dataguard同步状态（主备库可以同步数据，但是配置dg broker时会出错）

问题：

DGMGRL> enable configuration
Enabled.
DGMGRL> show configuration

Configuration - dg

Protection Mode: MaxAvailability
Members:
orcl2 - Primary database
Warning: ORA-16629: database reports a different protection level from the protection mode

orcl - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
WARNING (status updated 69 seconds ago)

主库

SQL> select log_mode,open_mode,database_role, PROTECTION_MODE,protection_level from v$database;

LOG_MODE OPEN_MODE DATABASE_ROLE PROTECTION_MODE
------------ -------------------- ---------------- --------------------
PROTECTION_LEVEL
--------------------
ARCHIVELOG READ WRITE PRIMARY MAXIMUM AVAILABILITY
RESYNCHRONIZATION

备库

SQL> select log_mode,open_mode,database_role, PROTECTION_MODE,protection_level from v$database;

LOG_MODE OPEN_MODE DATABASE_ROLE PROTECTION_MODE
------------------------------------ ------------------------------------------------------------ ------------------------------------------------ ------------------------------------------------------------
PROTECTION_LEVEL
------------------------------------------------------------
ARCHIVELOG READ ONLY PHYSICAL STANDBY MAXIMUM PERFORMANCE
MAXIMUM PERFORMANCE
如果出现此种情况，再次切换，并在主库mount状态时更改alter database set standby database to maximize PERFORMANCE;直到主备库两个都是MAXIMUM PERFORMANCE。