1 2 Previous Next 17 Replies Latest reply: Sep 20, 2012 9:30 AM by 877440 RSS

    why I cannot change a property using dgmgrl?

    877440
      I put log_archive_trace=8191 for tracing purpose while ago. Now I try to change it back , but with error:

      DGMGRL> edit database 'remeprd' set property 'LogArchiveTrace'='0';
      Error: ORA-16587: ambiguous object specified to Data Guard broker

      Failed.

      How to get that work?
      Thanks.
        • 1. Re: why I cannot change a property using dgmgrl?
          mseberg
          Hello;

          While I try not to mix SQL with broker I believe this will still work :
          alter system set LOG_ARCHIVE_TRACE=0 
          Restarting the system is another option.

          Best Regards

          mseberg
          • 2. Re: why I cannot change a property using dgmgrl?
            CKPT
            982335 wrote:
            I put log_archive_trace=8191 for tracing purpose while ago. Now I try to change it back , but with error:

            DGMGRL> edit database 'remeprd' set property 'LogArchiveTrace'='0';
            Error: ORA-16587: ambiguous object specified to Data Guard broker

            Failed.

            How to get that work?
            Thanks.
            Use below method
            DGMGRL> show database 'remeprd' 'LogArchiveTrace';
              LogArchiveTrace = '0'
            DGMGRL> 
            
            DGMGRL>  edit database 'remeprd' SET PROPERTY LogArchiveTrace=10;
            Property "logarchivetrace" updated
            DGMGRL> show database 'remeprd' 'LogArchiveTrace';
              LogArchiveTrace = '10'
            DGMGRL>
            of course you can change values as per your convenience
            • 3. Re: why I cannot change a property using dgmgrl?
              877440
              However I kept getting this error:
              DGMGRL> show database 'remeprd' 'LogArchiveTrace';
              Error: ORA-16606: unable to find property "LogArchiveTrace"

              DGMGRL> show database verbose remeprd
              Properties:
              DGConnectIdentifier = 'remeprd'
              ObserverConnectIdentifier = ''
              LogXptMode = 'ASYNC'
              DelayMins = '0'
              Binding = 'optional'
              MaxFailure = '0'
              MaxConnections = '1'
              ReopenSecs = '300'
              NetTimeout = '30'
              RedoCompression = 'DISABLE'
              LogShipping = 'ON'
              PreferredApplyInstance = ''
              ApplyInstanceTimeout = '0'
              ApplyParallel = 'AUTO'
              StandbyFileManagement = 'AUTO'
              ArchiveLagTarget = '0'
              LogArchiveMaxProcesses = '10'
              LogArchiveMinSucceedDest = '1'
              DbFileNameConvert = '+REME_DAT, +REME_DAT'
              LogFileNameConvert = '+REME_DAT, +REME_DAT'
              FastStartFailoverTarget = ''
              InconsistentProperties = '(monitor)'
              InconsistentLogXptProps = '(monitor)'
              SendQEntries = '(monitor)'
              LogXptStatus = '(monitor)'
              RecvQEntries = '(monitor)'
              SidName(*)
              StaticConnectIdentifier(*)
              StandbyArchiveLocation(*)
              AlternateLocation(*)
              LogArchiveTrace(*)
              LogArchiveFormat(*)
              TopWaitEvents(*)
              (*) - Please check specific instance for the property value

              Database Status:
              SUCCESS
              • 4. Re: why I cannot change a property using dgmgrl?
                877440
                DGMGRL> show database 'REMEPRD' 'LogArchiveTrace'
                Object "REMEPRD" was not found
                • 5. Re: why I cannot change a property using dgmgrl?
                  CKPT
                  982335 wrote:
                  DGMGRL> show database 'REMEPRD' 'LogArchiveTrace'
                  Object "REMEPRD" was not found
                  You can see this value, when you already set it.
                  As of now, this value has not set.

                  1) First update parameter with value(Edit)
                  2) DGMGRL> show database 'REMEPRD' 'LogArchiveTrace'
                  • 6. Re: why I cannot change a property using dgmgrl?
                    877440
                    I used sqlplus to change it by alter system set log_archive_trace, it will trigger error in dgmgrl.
                    • 7. Re: why I cannot change a property using dgmgrl?
                      CKPT
                      982335 wrote:
                      I used sqlplus to change it by alter system set log_archive_trace, it will trigger error in dgmgrl.
                      Ok, when managing with Broker, highly recommended to use only Broker. Have you tried above test?

                      if you trying to update value, if you see any error then share with us.
                      • 8. Re: why I cannot change a property using dgmgrl?
                        877440
                        above test shows:

                        DGMGRL> show database 'REMEPRD' 'LogArchiveTrace';
                        Object "REMEPRD" was not found
                        DGMGRL>
                        • 9. Re: why I cannot change a property using dgmgrl?
                          CKPT
                          982335 wrote:
                          above test shows:

                          DGMGRL> show database 'REMEPRD' 'LogArchiveTrace';
                          Object "REMEPRD" was not found
                          DGMGRL>
                          can you paste below output?

                          DGMGRL> show configuration;

                          and see what is exactly DB_UNIQUE_NAME and mention as it is, because its case sensitive.
                          • 10. Re: why I cannot change a property using dgmgrl?
                            877440
                            DGMGRL> show configuration

                            Configuration - remeprd_dg

                            Protection Mode: MaxPerformance
                            Databases:
                            remeprd - Primary database
                            remeprds - Physical standby database
                            remeprdl - Physical standby database

                            Fast-Start Failover: DISABLED

                            Configuration Status:
                            SUCCESS

                            DGMGRL> show database 'remeprd' 'LogArchiveTrace'
                            Error: ORA-16606: unable to find property "LogArchiveTrace"
                            • 11. Re: why I cannot change a property using dgmgrl?
                              CKPT
                              982335 wrote:
                              DGMGRL> show configuration

                              Configuration - remeprd_dg

                              Protection Mode: MaxPerformance
                              Databases:
                              remeprd - Primary database
                              remeprds - Physical standby database
                              remeprdl - Physical standby database

                              Fast-Start Failover: DISABLED

                              Configuration Status:
                              SUCCESS

                              DGMGRL> show database 'remeprd' 'LogArchiveTrace'
                              Error: ORA-16606: unable to find property "LogArchiveTrace"
                              Follow these steps

                              1) DGMGRL> edit database 'remeprd' SET PROPERTY LogArchiveTrace=10;
                              2) DGMGRL> show database 'remeprd' 'LogArchiveTrace'

                              Now you should able to see this value.

                              Also paste below information

                              DGMGRL> show database 'remeprd' InconsistentProperties;
                              • 12. Re: why I cannot change a property using dgmgrl?
                                877440
                                DGMGRL> show database 'remeprd' InconsistentProperties;
                                INCONSISTENT PROPERTIES
                                INSTANCE_NAME PROPERTY_NAME MEMORY_VALUE SPFILE_VALUE BROKER_VALUE

                                DGMGRL> edit database 'remeprd' SET PROPERTY LogArchiveTrace=0;
                                Error: ORA-16587: ambiguous object specified to Data Guard broker

                                Failed.
                                DGMGRL> edit database 'remeprd' SET PROPERTY LogArchiveTrace=10;
                                Error: ORA-16587: ambiguous object specified to Data Guard broker

                                Failed.


                                I switched the property back to 8191 in sqlplus, so now there is no inconsistent issues. But I want to change logarchivetrace=0.
                                • 13. Re: why I cannot change a property using dgmgrl?
                                  mseberg
                                  Hello again;

                                  Make sure dgmgrl "show configuration" returns "SUCCESS" to confirm if you do anything.

                                  If it returns a warning hen you need to check the Dataguard Broker logfile.

                                  For some reason broker is sensitive to "alter" commands.
                                  DGMGRL>  edit database 'remeprd' SET PROPERTY 'LogArchiveTrace' =0;
                                  Best Regards

                                  mseberg
                                  • 14. Re: why I cannot change a property using dgmgrl?
                                    877440
                                    Thanks. Here is output.

                                    DGMGRL> show configuration

                                    Configuration - remeprd_dg

                                    Protection Mode: MaxPerformance
                                    Databases:
                                    remeprd - Primary database
                                    remeprds - Physical standby database
                                    remeprdl - Physical standby database

                                    Fast-Start Failover: DISABLED

                                    Configuration Status:
                                    SUCCESS
                                    DGMGRL> edit database 'remeprd' SET PROPERTY 'LogArchiveTrace' =0;
                                    Error: ORA-16587: ambiguous object specified to Data Guard broker
                                    1 2 Previous Next