1 2 Previous Next 18 Replies Latest reply: Oct 15, 2012 5:31 AM by Sunny kichloo RSS

    ORA-16057: DGID from server not in Data Guard configuration

    Suddhasatwa_Bhaumik
      Hello All

      DB Version - 10.2.0.3
      OS: Solaris 9

      I have created a physical standby database for one of my databases. While I was performing a manual switch over I got the error "ORA-16057: DGID from server not in Data Guard configuration". Below are the steps I have followed:
      1.  Check for the status in primary database as below:
      
      SQL> Select Database_role from v$Database;
      
      DATABASE_ROLE
      ----------------
      PRIMARY
      
      SQL>
      SQL> Select switchover_status from v$Database;
      
      SWITCHOVER_STATUS
      --------------------
      TO STANDBY
      
      2. To perform manual switch-over I used the below command:
      
      SQL> Alter Database Commit to Switchover to Physical Standby with session Shutdown;
      
      Database altered.
      
      3. Restarted the DB to Open stage. Now it is showing read-only which is obvious. 
      
      4. Check the status of the database now, which earlier was primary but now should show as standby. 
      
      SQL> Select Database_role from v$Database;
      
      DATABASE_ROLE
      ----------------
      PHYSICAL STANDBY
      
      SQL> Select switchover_status from v$Database;
      
      SWITCHOVER_STATUS
      --------------------
      TO PRIMARY
      
      
      5. On the standby database, issue the below command to cancel the MRP process:
      
      SQL> Alter database Recover Managed Standby Database Cancel;
      
      Database Altered.
      
      6. Recover the standby database using the below command before switching it over as primary:
      
      SQL> alter database recover managed standby database finish;
      
      Database altered.
      
      7. Now switch over the standby database as primary:
      
      SQL> Alter Database Commit to Switchover to PRIMARY with session Shutdown;
      
      Database altered.
      
      8. Restart the DB in open stage for settings to take effect:
      
      SQL> shutdown immediate;
      ORA-01507: database not mounted
      
      
      ORACLE instance shut down.
      SQL> startup;
      ORA-32004: obsolete and/or deprecated parameter(s) specified
      ORACLE instance started.
      
      Total System Global Area 3221225472 bytes
      Fixed Size                  2131880 bytes
      Variable Size             985561176 bytes
      Database Buffers         2231369728 bytes
      Redo Buffers                2162688 bytes
      Database mounted.
      Database opened.
      SQL>
      SQL> select name, open_mode from v$database;
      
      NAME      OPEN_MODE
      --------- ----------
      SBDBPROD  READ WRITE
      
      
      9. Confirm that the standby DB is now the primary DB:
      
      SQL> Select Database_role from v$Database;
      
      DATABASE_ROLE
      ----------------
      PRIMARY
      Now I get the below error:
      SQL> list
        1* Select Status, Error from v$Archive_dest where dest_id=2
      SQL> /
      
      STATUS    ERROR
      --------- -----------------------------------------------------------------
      DISABLED  ORA-16057: DGID from server not in Data Guard configuration
      Please advice how this can be rectified.

      Thanks.
      Suddhasatwa
        • 1. Re: ORA-16057: DGID from server not in Data Guard configuration
          saurabh
          have set fal_client and fal_server parameter on both standby and produstion database.
          • 2. Re: ORA-16057: DGID from server not in Data Guard configuration
            Sunny kichloo
            Have you set the value of log_archive_config parameter correctly

            For log_archive_config see this

            http://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams112.htm

            Also one more thing why are you getting below mentioned error during startup
            SQL> startup;
            ORA-32004: obsolete and/or deprecated parameter(s) specified
            ORACLE instance started.
            Can you share you parameter file of Primary and Standby Database???
            • 3. Re: ORA-16057: DGID from server not in Data Guard configuration
              Suddhasatwa_Bhaumik
              More info:

              Below is the configuration for Proomary:
              NAME                                 TYPE        VALUE
              ------------------------------------ ----------- ------------------------------
              log_archive_config                   string      DG_CONFIG=(primary,standby)
              log_archive_dest                     string
              log_archive_dest_1                   string      Location=/oradata/sbdbProd/ora
                                                               arch VALID_FOR=(ALL_LOGFILES,A
                                                               LL_ROLES) db_unique_name=prima
                                                               ry
              log_archive_dest_10                  string
              log_archive_dest_2                   string      Service=sbdbClon lgwr async VA
                                                               LID_FOR=(ONLINE_LOGFILES,PRIMA
                                                               RY_ROLE) db_unique_name=standb
                                                               y
              On Standby - which is now made primary!! :
              log_archive_config                   string      DG_CONFIG=(primary,standby)
              log_archive_dest                     string
              log_archive_dest_1                   string      Location=/oradata/sbdbClone/or
                                                               aarch VALID_FOR=(ALL_LOGFILES,
                                                               ALL_ROLES) db_unique_name=stan
              
              NAME                                 TYPE        VALUE
              ------------------------------------ ----------- ------------------------------
                                                               dby
              log_archive_dest_10                  string
              log_archive_dest_2                   string      Service=sbdbProd VALID_FOR=(ON
                                                               LINE_LOGFILES,PRIMARY_ROLE) db
                                                               _unique_name=primary
              Please let me know for more information.

              Thanks.
              • 4. Re: ORA-16057: DGID from server not in Data Guard configuration
                Suddhasatwa_Bhaumik
                Below is the FAL parameters in both Primary and Standby:
                SQL> show parameter fal
                
                NAME                                 TYPE        VALUE
                ------------------------------------ ----------- ------------------------------
                fal_client                           string      SBDBPROD
                fal_server                           string      SBDBCLON
                DB version is 10.2.0.3.

                Thanks,
                Suddhasatwa
                • 5. Re: ORA-16057: DGID from server not in Data Guard configuration
                  Suddhasatwa_Bhaumik
                  Hi Sunny

                  Below are the params I am using for DG:
                  SQL> show parameter log_archive_config
                  
                  NAME                                 TYPE        VALUE
                  ------------------------------------ ----------- ------------------------------
                  log_archive_config                   string      DG_CONFIG=(primary,standby)
                  SQL>
                  Thanks.
                  Suddhasatwa
                  • 6. Re: ORA-16057: DGID from server not in Data Guard configuration
                    Sunny kichloo
                    What is the value of log_archive_dest_state_2 and log_archive_dest_state_1 On Standby - which has become primary after switchover.
                    • 7. Re: ORA-16057: DGID from server not in Data Guard configuration
                      Suddhasatwa_Bhaumik
                      Hello Sunny

                      Below are the inputs you asked for:
                      SQL> show parameter log_archive_dest_
                      
                      NAME                                 TYPE        VALUE
                      ------------------------------------ ----------- ------------------------------
                      log_archive_dest_1                   string      Location=/oradata/sbdbClone/or
                                                                       aarch VALID_FOR=(ALL_LOGFILES,
                                                                       ALL_ROLES) db_unique_name=stan
                                                                       dby
                      log_archive_dest_10                  string
                      log_archive_dest_2                   string      Service=sbdbProd VALID_FOR=(ON
                                                                       LINE_LOGFILES,PRIMARY_ROLE) db
                                                                       _unique_name=primary
                      Thanks,
                      Suddhasatwa
                      • 8. Re: ORA-16057: DGID from server not in Data Guard configuration
                        Sunny kichloo
                        Below is the FAL parameters in both Primary and Standby:
                        
                        SQL> show parameter fal
                         
                        NAME                                 TYPE        VALUE
                        ------------------------------------ ----------- ------------------------------
                        fal_client                           string      SBDBPROD
                        fal_server                           string      SBDBCLON
                        why is it same on both primary and standby database

                        Also i asked for value of log_archive_dest_state_1 and log_archive_dest_state_2
                        • 9. Re: ORA-16057: DGID from server not in Data Guard configuration
                          saurabh
                          please post the output of fal on both standby and primary differently also post output of db_unique name of both standby and primary

                          Edited by: saurabh on Oct 15, 2012 1:39 PM
                          • 10. Re: ORA-16057: DGID from server not in Data Guard configuration
                            Suddhasatwa_Bhaumik
                            Hi

                            Even after reversing it on the standby (which is now Primary) it does not help. I am still getting below error:
                            SQL> alter system switch logfile;
                            
                            System altered.
                            
                            SQL> Select Status, Error from v$Archive_dest where dest_id=2;
                            
                            STATUS    ERROR
                            --------- -----------------------------------------------------------------
                            DISABLED  ORA-16057: DGID from server not in Data Guard configuration
                            Thanks,
                            Suddhasatwa
                            • 11. Re: ORA-16057: DGID from server not in Data Guard configuration
                              Suddhasatwa_Bhaumik
                              Hi Sourav,

                              From Standby (which is now Primary):
                              SQL> show parameter fal
                              
                              NAME                                 TYPE        VALUE
                              ------------------------------------ ----------- ------------------------------
                              fal_client                           string      SBDBPROD
                              fal_server                           string      SBDBCLON
                              SQL>
                              SQL> show parameter db_uniq
                              
                              NAME                                 TYPE        VALUE
                              ------------------------------------ ----------- ------------------------------
                              db_unique_name                       string      STANDBY
                              From Primary (which is now standby):
                              SQL> show parameter fal
                              
                              NAME                                 TYPE        VALUE
                              ------------------------------------ ----------- ------------------------------
                              fal_client                           string      SBDBCLONE
                              fal_server                           string      SBDBPROD
                              SQL>
                              SQL> show parameter db_uniq
                              
                              NAME                                 TYPE        VALUE
                              ------------------------------------ ----------- ------------------------------
                              db_unique_name                       string      PRIMARY
                              Thanks,
                              Suddhasatwa
                              • 12. Re: ORA-16057: DGID from server not in Data Guard configuration
                                Sunny kichloo
                                Why on primary is it
                                SQL> show parameter fal
                                 
                                NAME                                 TYPE        VALUE
                                ------------------------------------ ----------- ------------------------------
                                fal_client                           string      SBDBCLONE
                                And on Standby it is
                                fal_server                           string      SBDBCLON
                                Update it with correct name either SBDBCLON or SBDBCLONE
                                • 13. Re: ORA-16057: DGID from server not in Data Guard configuration
                                  Suddhasatwa_Bhaumik
                                  Hi Sourabh

                                  I have updated it on Primary now, but still no luck!!

                                  Thanks,
                                  Suddhasatwa
                                  • 14. Re: ORA-16057: DGID from server not in Data Guard configuration
                                    Sunny kichloo
                                    Also have you updated Service value of log_archive_dest_1 with correct value of Service name as SBDBCLON was mentioned there also

                                    Also review your setting as per below mentioned doc

                                    http://docs.oracle.com/cd/E11882_01/server.112/e25608/create_ps.htm#i63561

                                    Also this dataguard concepts doc will help

                                    http://allthingsoracle.com/data-guard-physical-standby-database-best-practices-part-i/

                                    http://allthingsoracle.com/data-guard-physical-standby-database-best-practices-part-ii/
                                    1 2 Previous Next