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
Posted by at
Labels: , , , , , , , ,

29 comments:

  1. GhaziDecember 21, 2020 at 6:52 AM

    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. Daniel ThomasDecember 23, 2020 at 12:57 PM

    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. Harry jackFebruary 15, 2021 at 3:43 AM

    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. yanmaneeeMay 30, 2021 at 12:04 PM

    golden goose outlet
    curry 7 shoes
    hermes birkin
    jordan shoes
    supreme clothing
    jordans
    supreme new york
    westbrook shoes
    yeezy
    100% real jordans for cheap

    ReplyDelete
  5. Qasim KhanJune 25, 2021 at 3:04 AM

    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
  6. Roman DavisJuly 13, 2021 at 10:32 PM

    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
  7. opbestcom7August 18, 2021 at 8:10 PM

    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
  8. mohsinSeptember 23, 2021 at 4:22 AM

    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
  9. Kamla LogirNovember 28, 2021 at 9:46 AM

    Wow great blog article. Much thanks again. Much obliged.
    check more info about guard agency

    ReplyDelete
  10. mohsinDecember 17, 2021 at 10:55 PM

    thank you for your interesting infomation. https://swigertwilliam.wixsite.com/securityfastservices

    ReplyDelete
  11. liperkDecember 18, 2021 at 8:57 PM

    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
  12. mohsinDecember 26, 2021 at 2:53 AM

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

    ReplyDelete
  13. 토토사이트December 30, 2021 at 8:38 PM

    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
  14. Harry kevinOctober 31, 2022 at 6:17 AM

    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
  15. EvelynAdamOctober 31, 2022 at 9:37 PM

    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
  16. callmebbFebruary 12, 2023 at 5:58 AM

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

    ReplyDelete
  17. AnonymousFebruary 23, 2023 at 2:03 AM

    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
  18. Adeline MeadowsApril 15, 2023 at 10:47 AM

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

    ReplyDelete
  19. assignment helpOctober 1, 2023 at 10:43 PM

    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
  20. Dynamic physiotherapyNovember 20, 2023 at 4:14 AM

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

    ReplyDelete
  21. Luxe BeautyNovember 20, 2023 at 4:18 AM

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

    ReplyDelete
  22. Alexa AyotiNovember 21, 2023 at 3:36 AM

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

    ReplyDelete
  23. Courier-PlusNovember 23, 2023 at 3:29 AM

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

    ReplyDelete
  24. david hudeMarch 6, 2024 at 12:35 AM

    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
  25. david hudeMarch 27, 2024 at 10:02 PM

    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
  26. Nicholas TanMay 5, 2024 at 11:57 PM

    For premium notarized translation Singapore, turn to NotarizedTranslation.sg. Our dedicated team is proficient in translating and notarizing legal and personal documents, endorsed for ICA, MFA, IRAS, MoM, LTA, and SAL purposes. Trust us for efficient document legalization and apostille services, providing you with accurate and legally recognized translations every time.

    ReplyDelete
  27. Henry WhiteSeptember 12, 2024 at 4:32 AM

    Recently, I had the opportunity to explore Marketing Assignment Help for a particularly challenging topic. The insights and resources provided were invaluable, making the assignment process much smoother. For any student or professional juggling multiple responsibilities, Assignment Help is an excellent way to ensure high-quality work and stress-free learning.

    ReplyDelete
  28. Steaph PualOctober 4, 2024 at 5:36 AM

    This is such a useful explanation! Managing Data Guard broker errors can be tricky. It’s kind of like when I’m stressed about my studies and wish someone could just Take My HESI Exam for me! But I know that getting the configuration right is key. Thanks for the insight

    ReplyDelete
  29. Home Office Translation UKNovember 17, 2024 at 8:34 PM

    Need your birth certificate translated in the UK? HomeOfficeTranslations.co.uk specializes in certified birth certificate translation services approved for Home Office, immigration, and legal purposes. We provide 100% accurate translations with quick delivery, ensuring compliance with official standards. Perfect for visa applications, citizenship, and other legal documentation, our services are trusted nationwide. Experience a seamless process from start to finish.

    ReplyDelete

Subscribe to: Post Comments (Atom)