Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

ORA-16629: database reports a different protection

2025-02-23 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

Oracle 12c RAC- single instance

The alerts are as follows:

DGMGRL > show database verbose coredb;Database-coredb Role: PRIMARY Intended State: TRANSPORT-ON Instance (s): coredb1 coredb2 Database Warning (s): ORA-16629: database reports a different protection level from the protection mode. Omit.

The protection mode is set by us and the protection level is in the current state.

SQL > select database_role,protection_mode,protection_level from vested database share database-- PHYSICAL STANDBY MAXIMUM AVAILABILITY * * RESYNCHRONIZATION**

Because of the test, the log transfer process defer is dropped, and hundreds of archives need to be chased after re-enable, and the highest available file is degraded to maximum performance mode, which becomes asynchronous. I have done a test in the test environment and found that there will be no alarm after I find it even. The above is only one record.

After leveling:

SQL > select database_role,protection_mode,protection_level from vested database: Database role PROTECTION_MODE PROTECTION_LEVEL- PHYSICAL STANDBY MAXIMUM AVAILABILITY MAXIMUM AVAILABILITYDGMGRL > show configuration Configuration-dg_config Protection Mode: MaxAvailability Members: orcl-Primary database orcldg-Physical standby database Fast-Start Failover: DISABLEDConfiguration Status:SUCCESS (status updated 13 seconds ago)

You don't have to do anything, just sit back and wait for everything to get back to normal! We just need to know why!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report