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

25 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. Ensure consistent PROTECTION mode between PRIMARY and STANDBY in Data Guard configuration to avoid ORA-16627 error. Use DGMGRL for seamless updates and verify settings with "show configuration" and "show database verbose" commands.
    I have been using New Assignment Help's online Accounting Assignment Help service for some time now, and I must say, it has been a game-changer for me as a UK student pursuing accounting. The support and guidance provided by their team, particularly their Accounting Assignment Helper, have been instrumental in helping me excel in my coursework. They possess a deep understanding of accounting principles and consistently deliver assignments that are well-researched and meticulously written. What sets them apart is their dedication to ensuring customer satisfaction – they are always willing to go above and beyond to address any concerns or revisions promptly. With their assistance, I was able to improve my grades and gain a better understanding of complex accounting concepts. I highly recommend Accounting Assignment Help to any UK student in need of professional assignment assistance.

    ReplyDelete
  22. Ensuring consistent PROTECTION mode and LogXptMode between primary and standby databases is crucial for Data Guard reliability. Use DGMGRL to maintain synchronization and avoid ORA-16627 errors.
    As a student struggling with the complexities of a marketing assignment, I sought assistance from New Assignment Help's Marketing Assignment Help service, and I have been more than satisfied with the results. Their team of dedicated professionals acted as my Marketing Assignment Helper, and guided me through the complexities of marketing principles and concepts. With their expert assistance, I was able to complete challenging tasks with confidence and clarity.




    ReplyDelete