1 2 Previous Next 21 Replies Latest reply on Mar 9, 2017 3:04 PM by user2034688 Go to original post
      • 15. Re: Oracle 12c Data Guard Setup Primary with Broker, ORA-16698
        BPeaslandDBA

        Is there a document that is recommended that explains configuration details?

         

        I wrote it up here....

         

        DG Broker – Why and How?


        And while you're there...check this one out too:  DG Broker Primer

         

        HTH,
        Brian

        • 17. Re: Oracle 12c Data Guard Setup Primary with Broker, ORA-16698
          CKPT

          Infact you too.     Don't worry.  

          • 19. Re: Oracle 12c Data Guard Setup Primary with Broker, ORA-16698
            user2034688

            I am using the Oracle Grid/ASM in an Oracle Restart, non-RAC environment.  I am reading the Oracle 12c documentation, however, I'm not getting a clear picture.  When I am running these command in the DGMGRL, should I have the DB home set or the Grid home set?  In the Grid home I ran the following, but DG is getting errors.

             

            DB_UNIQUE_NAME:  Primary - WINDPD_P, Standby - WINDPD_S

             

            SQL>  --Primary--

              alter system set dg_broker_start=FALSE scope=both;

              alter system set dg_broker_config_file1 = '+DATA1/WINDPD/DataGuard/DR1WINDPD_P.DAT' scope=both;

              alter system set dg_broker_config_file2 = '+DATA1/WINDPD/DataGuard/DR2WINDPD_P.DAT' scope=both;

                   --Standby--

              alter system set dg_broker_start=FALSE scope=both;

              alter system set dg_broker_config_file1 = '+DATA1/WINDPD/DataGuard/DR1WINDPD_S.DAT' scope=both;

              alter system set dg_broker_config_file2 = '+DATA1/WINDPD/DataGuard/DR2WINDPD_S.DAT' scope=both;

             

              alter system set dg_broker_start=TRUE scope=both;    <--- Both DBs, primary & standby.

              alter system set LOG_ARCHIVE_DEST_2='';         <--- Both DBs, primary & standby.

             

            DGMGRL>

            create configuration 'GOES-DR' AS primary database is 'WINDPD_P' connect identifier is WINDPD;

             

            ADD DATABASE WINDPD_S AS CONNECT IDENTIFIER IS windpd_sby MAINTAINED AS PHYSICAL;

             

            ENABLE CONFIGURATION;

             

            Another question, is the 'connect identifier' the TNS alias?

            • 20. Re: Oracle 12c Data Guard Setup Primary with Broker, ORA-16698
              CKPT

              should I have the DB home set or the Grid home set?  In the Grid home I ran the following, but DG is getting errors.

              No, its RDBMS Home.

              The commands are correct, the configuration files either you can keep on local or disk group as its not an RAC.

              • 21. Re: Oracle 12c Data Guard Setup Primary with Broker, ORA-16698
                user2034688

                I'm getting an error when trying to read the config files.

                 

                Error (drcwindpd.log)

                2017-03-08 14:41:21.648                      >> Starting Data Guard Broker bootstrap <<

                2017-03-08 14:41:21.648                      Broker Configuration File Locations:

                2017-03-08 14:41:21.648                            dg_broker_config_file1 = "+DATA1/WINDPD/DataGuard/DR1WINDPD_P.DAT"

                2017-03-08 14:41:21.648                            dg_broker_config_file2 = "+DATA1/WINDPD/DataGuard/DR2WINDPD_P.DAT"

                2017-03-08 14:41:21.648                      DMON: Attach state object

                2017-03-08 14:41:21.648                      DMON: rfafoGetLocks reinitializing dubious PMYSHUT lock value block contents: sts=0, flags=0x0, spare1=0x0, spare2=0x0, cksm=0x0, rndm=0x0

                2017-03-08 14:41:21.648                      DMON: Broker state reconciled, version = 0, state = 00000000

                2017-03-08 14:41:21.648                      DMON: Broker State Initialized

                2017-03-08 14:41:21.648                            Version = 1

                2017-03-08 14:41:21.648                            State = 00000000

                2017-03-08 14:41:21.648                      DMON: Entered rfm_get_chief_lock() for CTL_BOOTSTRAP, reason 2

                2017-03-08 14:41:21.648 7fffffff           0 DMON: Entered rfm_get_chief_lock() for CTL_BOOTSTRAP, reason 0

                2017-03-08 14:41:24.679                      INSV: cannot open configuration file "+DATA1/WINDPD/DataGuard/dr1windpd_p.dat", retrying

                2017-03-08 14:41:25.695                      INSV: cannot open configuration file "+DATA1/WINDPD/DataGuard/dr1windpd_p.dat"

                2017-03-08 14:41:25.695                        ORA-17503: ksfdopn:2 Failed to open file +DATA1/WINDPD/DataGuard/dr1windpd_p.dat

                2017-03-08 14:41:25.695                        ORA-15173: entry 'dr1windpd_p.dat' does not exist in directory 'DataGuard'

                2017-03-08 14:41:25.695                      INSV: Error opening "+DATA1/WINDPD/DataGuard/DR1WINDPD_P.DAT", error = ORA-16572

                2017-03-08 14:41:25.695                      INSV: Establishing "+DATA1/WINDPD/DataGuard/DR2WINDPD_P.DAT" as the more current file

                2017-03-08 14:41:25.695                      INSV: cannot open configuration file "+DATA1/WINDPD/DataGuard/dr2windpd_p.dat", retrying

                2017-03-08 14:41:26.710                      INSV: cannot open configuration file "+DATA1/WINDPD/DataGuard/dr2windpd_p.dat"

                2017-03-08 14:41:26.710                        ORA-17503: ksfdopn:2 Failed to open file +DATA1/WINDPD/DataGuard/dr2windpd_p.dat

                2017-03-08 14:41:26.710                        ORA-15173: entry 'dr2windpd_p.dat' does not exist in directory 'DataGuard'

                2017-03-08 14:41:26.710                      INSV: Error opening "+DATA1/WINDPD/DataGuard/DR2WINDPD_P.DAT", error = ORA-16572

                2017-03-08 14:41:26.710                      INSV: unable to get FSFO data from "+DATA1/WINDPD/DataGuard/DR2WINDPD_P.DAT"

                2017-03-08 14:41:26.710                            status = ORA-16572                                                

                 

                 

                 

                ASMCMD> ls -lt +DATA1/WINDPD/DataGuard/dr1windpd_p.dat

                Type             Redund  Striped  Time             Sys  Name

                DATAGUARDCONFIG  MIRROR  COARSE   MAR 08 14:00:00  N    dr1windpd_p.dat => +DATA1/WINDPD_P/DATAGUARDCONFIG/WINDPD_P.338.938097843

                ASMCMD>

                 

                +data1/windpd/dataguard/dr2windpd_p.dat

                 

                 

                SQL> show parameter broker

                dg_broker_config_file1               string      +DATA1/WINDPD/DataGuard/DR1WINDPD_P.DAT

                dg_broker_config_file2               string      +DATA1/WINDPD/DataGuard/DR2WINDPD_P.DAT

                1 2 Previous Next