This discussion is archived
1 2 Previous Next 18 Replies Latest reply: Oct 15, 2012 3:31 AM by Sunny kichloo RSS

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

Suddhasatwa_Bhaumik Newbie
Currently Being Moderated
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 Pro
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Pro
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points