Shulou(Shulou.com)05/31 Report--

This article mainly introduces the oracle12c broker ArchiveLagTarget inconsistent how to do, the article is very detailed, has a certain reference value, interested friends must read it!

In the dg environment with brokger configured, be sure to use broker to adjust the relevant parameters, remember.

1. Check the DG status and find an alarm DGMGRL > show database orcldg Database-orcldg Role: PHYSICAL STANDBY Intended State: APPLY-ON Transport Lag: 0 seconds (computed 0 seconds ago) Apply Lag: 0 seconds (computed 0 seconds ago) Average Apply Rate: 7.00 KByte/s Real Time Query: OFF Instance (s): orcldg Warning: ORA-16714: the value of property ArchiveLagTarget is inconsistent with the database settingDatabase Status:WARNING2, check inconsistent parameters. The value in broker is 0, and 60DGMGRL > show database orcldg inconsistentProperties in the parameter file INCONSISTENT PROPERTIES INSTANCE_NAME PROPERTY_NAME MEMORY_VALUE SPFILE_VALUE BROKER_VALUE orcldg ArchiveLagTarget 60 60 0 3 、 Confirm the parameters SQL > show parameter archive_lagNAME TYPE VALUE-- archive_lag_target integer 60SQL > 4 in the parameter file. Use broker to modify the parameter DGMGRL > edit database orcldg SET PROPERTY ArchiveLagTarget=0 Property "archivelagtarget" updatedDGMGRL > 5. Check DG status. No DGMGRL > show database orcldg for alarm. Database-orcldg Role: PHYSICAL STANDBY Intended State: APPLY-ON Transport Lag: 0 seconds (computed 1 second ago) Apply Lag: 0 seconds (computed 1 second ago) Average Apply Rate: 6.00 KByte/s Real Time Query: OFF Instance (s): orcldgDatabase Status:SUCCESSDGMGRL > above is all the content of the article "what to do with oracle12c broker ArchiveLagTarget inconsistencies". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

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.