Friday, April 17, 2020

When using Data Guard broker Error: ORA-16627: operation disallowed since no member would remain to support protection mode

You will encounter this error when PROTECTION mode is not consistent betweeen PRIMARY and STANDBY. Make sure you are using DGMGRL to update the configurationn.

DGMGRL> show configuration;
Configuration - oradb_dg_fsfconf
Protection Mode: MaxPerformance
Members:
oradb - Primary database
oradb_stdby - Physical standby database

Fast-Start Failover: Disabled

Configuration Status:
SUCCESS (status updated 13 seconds ago)

DGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;

Error: ORA-16627: operation disallowed since no member would remain to support protection mode Failed.
=============

Make sure you verify the entire configuration using verbose.

DGMGRL> show configuration verbose;
Configuration - oradb_dg_fsfconf
Protection Mode: MaxPerformance
Members:
oradb - Primary database
oradb_stdby - Physical standby database

Properties:
FastStartFailoverThreshold = '30'
OperationTimeout = '30'
TraceLevel = 'USER'
FastStartFailoverLagLimit = '30'
CommunicationTimeout = '180'
ObserverReconnect = '0'
FastStartFailoverAutoReinstate = 'TRUE'
FastStartFailoverPmyShutdown = 'TRUE'
BystandersFollowRoleChange = 'ALL'
bserverOverride = 'FALSE'
ExternalDestination1 = ''
ExternalDestination2 = ''
PrimaryLostWriteAction = 'CONTINUE'
ConfigurationWideServiceName = 'ORADB_CFG'

Fast-Start Failover: Disabled

Configuration Status:
SUCCESS

DGMGRL> show database verbose ORADB;
Database - oradb
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
ORADB

Properties:
DGConnectIdentifier = 'oradb'
ObserverConnectIdentifier = ''
FastStartFailoverTarget = ''
PreferredObserverHosts = ''
LogShipping = 'ON'
RedoRoutes = ''
LogXptMode = 'ASYNC'
DelayMins = '0'
Binding = 'optional'
MaxFailure = '0'
ReopenSecs = '300'
NetTimeout = '30'
RedoCompression = 'DISABLE'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyLagThreshold = '30'
TransportLagThreshold = '30'
TransportDisconnectedThreshold = '30'
ApplyParallel = 'AUTO'
ApplyInstances = '0'
StandbyFileManagement = ''
ArchiveLagTarget = '0'
LogArchiveMaxProcesses = '0'
LogArchiveMinSucceedDest = '0'
DataGuardSyncLatency = '0'
LogArchiveTrace = '0'
LogArchiveFormat = ''
DbFileNameConvert = ''
LogFileNameConvert = ''
ArchiveLocation = ''
AlternateLocation = ''
StandbyArchiveLocation = ''
StandbyAlternateLocation = ''
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
LogXptStatus = '(monitor)'
SendQEntries = '(monitor)'
RecvQEntries = '(monitor)'
HostName = 'scllqa0078'
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=seroradb-db)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORADB_DGMGRL)(INSTANCE_NAME=ORADB)(SERVER=DEDICATED)))'
TopWaitEvents = '(monitor)'
SidName = '(monitor)'

Log file locations:
Alert log : /home/oracle/diag/rdbms/oradb/ORADB/trace/alert_ORADB.log
Data Guard Broker log : /home/oracle/diag/rdbms/oradb/ORADB/trace/drcORADB.log

Database Status:
SUCCESS
DGMGRL> show database verbose ORADB_STDBY;

Database - oradb_stdby
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: 26.00 KByte/s
Active Apply Rate: 938.00 KByte/s
Maximum Apply Rate: 940.00 KByte/s
Real Time Query: OFF
Instance(s):
ORADB

Properties:
DGConnectIdentifier = 'oradb_stdby'
ObserverConnectIdentifier = ''
FastStartFailoverTarget = ''
PreferredObserverHosts = ''
LogShipping = 'ON'
RedoRoutes = ''
LogXptMode = 'ASYNC'
DelayMins = '0'
Binding = 'optional'
MaxFailure = '0'
ReopenSecs = '300'
NetTimeout = '30'
RedoCompression = 'DISABLE'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyLagThreshold = '30'
TransportLagThreshold = '30'
TransportDisconnectedThreshold = '30'
ApplyParallel = 'AUTO'
ApplyInstances = '0'
StandbyFileManagement = ''
ArchiveLagTarget = '0'
LogArchiveMaxProcesses = '0'
LogArchiveMinSucceedDest = '0'
DataGuardSyncLatency = '0'
LogArchiveTrace = '0'
LogArchiveFormat = ''
DbFileNameConvert = ''
LogFileNameConvert = ''
ArchiveLocation = ''
AlternateLocation = ''
StandbyArchiveLocation = ''
StandbyAlternateLocation = ''
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
LogXptStatus = '(monitor)'
SendQEntries = '(monitor)'
RecvQEntries = '(monitor)'
HostName = 'scllqa0120'
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oraoradb-dg)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORADB_STDBY_DGMGRL)(INSTANCE_NAME=ORADB)(SERVER=DEDICATED)))'
TopWaitEvents = '(monitor)'
SidName = '(monitor)'

Log file locations:
Alert log : /home/oracle/diag/rdbms/oradb_stdby/ORADB/trace/alert_ORADB.log
Data Guard Broker log : /home/oracle/diag/rdbms/oradb_stdby/ORADB/trace/drcORADB.log

Database Status:
SUCCESS

Make sure you update the LogXptMode and set the protection mode.

DGMGRL> EDIT DATABASE ORADB SET PROPERTY 'LogXptMode'='SYNC';
Property "LogXptMode" updated
DGMGRL> EDIT DATABASE ORADB_STDBY SET PROPERTY 'LogXptMode'='SYNC';
Property "LogXptMode" updated

DGMGRL> show configuration;
Configuration - oradb_dg_fsfconf

Protection Mode: MaxPerformance
Members:
oradb - Primary database
oradb_stdby - Physical standby database

Fast-Start Failover: Disabled

Configuration Status:
SUCCESS (status updated 32 seconds ago)

DGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;
Succeeded.

DGMGRL> show configuration;

Configuration - oradb_dg_fsfconf
Protection Mode: MaxAvailability
Members:
oradb - Primary database
oradb_stdby - Physical standby database

Fast-Start Failover: Disabled

Configuration Status:
SUCCESS (status updated 57 seconds ago)
Regards,
Satishbabu Gunukula, Oracle ACE

24 comments:

  1. We have sell some products of different custom boxes.it is very useful and very low price please visits this site thanks and please share this post with your friends. fx마진거래

    ReplyDelete
  2. Initial You got a awesome blog .I determination be involved in plus uniform minutes. i view you got truly very functional matters , i determination be always checking your blog blesss. fx마진거래

    ReplyDelete
  3. Feeling that arranging and over arranging phase of interchanges is, obviously, adequately not. As a rule, an emergency is the consequence of an absence of sufficient information on the social, political and monetary conditions we are living and working in, whatever the points and motivations behind the elements we are working for.Disability concerns

    ReplyDelete
  4. If you feel I am getting someone to write my essay entails doing something illegal, you are safe. It’s not wrong to take the help of online homework help sites from time to time to write your essays, assignments etc., if it allows you to pursue other things which add value to your life. Can Someone Do My Essay For Me

    ReplyDelete
  5. I know the importance of Guard broker but it is useless for me because marketing is my occupation, I think I should not waste my precious time on this topic. dissertation proposal writing services

    ReplyDelete
  6. If you are going for most excellent contents like me, simply go to see this site every day for the reason that it presents quality contents, thanks 휴게텔


    ReplyDelete
  7. This is such a great resource that you are providing and you give it away for free. I love seeing blog that understand the value of providing a quality resource for free. security guard services

    ReplyDelete
  8. hi was just seeing if you minded a comment. i like your website and the thme you picked is super. I will be back. Prince Security Service

    ReplyDelete
  9. Love to read it,Waiting For More new Update and I Already Read your Recent Post its Great Thanks. security company

    ReplyDelete
  10. I've been looking for photos and articles on this topic over the past few days due to a school assignment, 우리카지노 and I'm really happy to find a post with the material I was looking for! I bookmark and will come often! Thanks :D


    ReplyDelete
  11. I appreciate you creating such a fantastic website. I'm constantly looking for top-notch goods to sell on my website. In addition, your work is superb. I enjoy reading your insightful blogs like I get from Help Me Do My Assignment, so I'd like to continue doing so. You work quite hard.

    ReplyDelete
  12. Your website is wonderful and really helpful, and I appreciate your efforts. I was eager to find a Qatar vs Ecuador live stream because I'm a student and a sports fan. Fortunately, I found Vpnsports, which I also think is a top-notch website.

    ReplyDelete
  13. Public Relationship of Real estate professionals (NAR) conjecture: 6% in 2016. toprankinmortgages

    ReplyDelete
  14. Thanks for sharing your experience with using Data Guard broker and the ORA-16627 error. Speaking of finding resources, Meri Sehat's doctor directory offers a convenient way to access qualified doctors for medical consultation and treatment. With their online medical services, patients can receive expert care and advice without leaving their homes.

    ReplyDelete
  15. A property mortgage is a loan that is secured by a piece of real estate. https://toprankinmortgages.com/

    ReplyDelete
  16. Are you a student struggling with your accounting assignments? Do complex financial statements and balance sheets make you break into a cold sweat? Don't worry; you're not alone. Many students find accounting assignments help challenging and overwhelming. In this article, we will explore the world of Accounting Assignment help services and how they can assist you in mastering this intricate subject. Professional accounting assignment help services employ experienced experts who can provide guidance and clarify doubts related to accounting concepts. They can simplify complex topics and make them easier to understand. Every student's learning style and needs are unique. Assignment help services offer customized solutions tailored to individual requirements, ensuring that students receive the assistance they need. accounting assignment help services can be a lifeline for students struggling with the complexities of accounting assignments help. They offer expert guidance, customized solutions, and the opportunity to improve academic performance while reducing stress. When choosing a service, consider factors like expertise, customization, timely delivery, customer reviews, and pricing to make an informed decision.

    ReplyDelete
  17. Professional accounting assignment help services employ experienced experts who can provide guidance and clarify doubts related to accounting concepts. Massage therapy Mississauga

    ReplyDelete
  18. Thanks for sharing your experience with using Data. medspa mississauga on

    ReplyDelete
  19. They offer expert guidance, customized solutions, and the opportunity to improve academic performance while reducing stress. Environmental Consultant Ottawa

    ReplyDelete
  20. Professional accounting assignment help services employ experienced experts who can provide guidance and clarify doubts related to accounting concepts. urban logistics montreal

    ReplyDelete
  21. This technical exchange highlights the importance of maintaining consistency in Data Guard protection modes between primary and standby databases. It demonstrates the meticulousness required for effective disaster recovery management in enterprise systems.
    New Assignment Help, your trusted ally in the journey to academic success. Located in the United Kingdom, New Assignment Help is a top-notch service aimed at giving Assignment Help across different fields to students. Our team of professional assignment helpers is dedicated on assisting students in achieving academic excellence in the UK. At New Assignment Help, we understand that students fail meeting deadlines, lack comprehension of complex topics and turn up with poor quality assignments; this is why we offer various types of assignment writing assistance services that cater for all kinds of courses being studied by college goers. Do you have an essay, research paper or presentation assignment that you are struggling with? Don’t worry because our Assignment Helper will assist you accordingly. Our commitment to excellence can be attested through the nature of our services. Every single helper working at New Assignment Help has been handpicked and holds advanced degrees in their areas of expertise.

    ReplyDelete