10 Replies Latest reply on May 7, 2013 1:44 PM by Satish Kumar Sadhu

    Datagaurd is not working

    Satish Kumar Sadhu
      Dear Gurus,

      my dataguard is not working(archives are not applying) and i am seeing below error on alert log. Could you please give some idea..

      Redo Shipping Client Connected as PUBLIC
      -- Connected User is Valid
      RFS[1436]: Assigned to RFS process 1147020
      RFS[1436]: Identified database type as 'physical standby'
      Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x1746ECA82] [PC:0x10008DCC4, kgegpa()+0024]
      Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x1746ECA82] [PC:0x10008DCC4, {empty}]
      Sun May 05 19:33:11 2013
      Redo Shipping Client Connected as PUBLIC
      -- Connected User is Valid
      RFS[1437]: Assigned to RFS process 1147038
      RFS[1437]: Identified database type as 'physical standby'
      Sun May 05 19:33:11 2013
      Redo Shipping Client Connected as PUBLIC
      -- Connected User is Valid
      RFS[1438]: Assigned to RFS process 1921206
      RFS[1438]: Identified database type as 'physical standby'
      Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x1746ECA82] [PC:0x10008DCC4, kgegpa()+0024]
      Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x1746ECA82] [PC:0x10008DCC4, {empty}]
      Sun May 05 19:38:18 2013
      Redo Shipping Client Connected as PUBLIC
      -- Connected User is Valid
      RFS[1439]: Assigned to RFS process 2129950
      RFS[1439]: Identified database type as 'physical standby'
      Sun May 05 19:38:19 2013
        • 1. Re: Datagaurd is not working
          VishP-Oracle
          .

          Edited by: VishalORCL on May 5, 2013 8:43 PM
          • 2. Re: Datagaurd is not working
            Hemant K Chitale
            Cancel recovery.
            shutdown
            startup mount
            recover managed standby database disconnect from session

            If the errors recur, you should log an SR with Oracle Support.



            Hemant K Chitale
            • 3. Re: Datagaurd is not working
              Mahir M. Quluzade
              Hi,

              Can you paste here your primary and standby database parameters?
               show parameter log_archive_dest_2 (if you using other destination, please change)
               show parameter log_archive_config
               show parameter FAL
               show parameter REDO_TRANSPORT_USER 
               select database_role from v$database; 
               
               select process from  v$managed_standby; 
              Regards
              Mahir M. Quluzade
              • 4. Re: Datagaurd is not working
                972378
                Dear,
                Yest I have tried by cancel and restarting the standby by using given commands but no luck :(
                • 5. Re: Datagaurd is not working
                  972378
                  Dear Mahir,

                  Please find the below output

                  From Standby site

                  SQL> show parameter log_archive_dest_2;

                  NAME TYPE VALUE
                  ------------------------------------ ----------- ------------------------------
                  log_archive_dest_2 string service=q013bans LGWR ASYNC va
                  lid_for=(ONLINE_LOGFILE,PRIMAR
                  Y_ROLE) db_unique_name=q013ban
                  sdr
                  SQL> show parameter log_archive_config;

                  NAME TYPE VALUE
                  ------------------------------------ ----------- ------------------------------
                  log_archive_config string dg_config=(q013bans,q013bansdr
                  )
                  SQL> show parameter FAL

                  NAME TYPE VALUE
                  ------------------------------------ ----------- ------------------------------
                  fal_client string (DESCRIPTION=(ADDRESS=(PROTOCO
                  L=tcp)(HOST=draixdbapp)(PORT=1
                  521))(CONNECT_DATA=(SERVICE_NA
                  ME=q013bansdr)(SERVER=DEDICATE
                  D)))
                  fal_server string (DESCRIPTION=(ADDRESS=(PROTOCO
                  L=tcp)(HOST=livaixdbapp)(PORT=
                  1521))(CONNECT_DATA=(SERVICE_N
                  AME=q013bans)(SERVER=DEDICATED
                  )))
                  SQL> show parameter REDO_TRANSPORT_USER

                  NAME TYPE VALUE
                  ------------------------------------ ----------- ------------------------------
                  redo_transport_user string
                  SQL> select database_role from v$database;

                  DATABASE_ROLE
                  ----------------
                  PHYSICAL STANDBY

                  SQL> select process from v$managed_standby;

                  PROCESS
                  ---------
                  ARCH
                  ARCH
                  ARCH
                  ARCH
                  ARCH

                  SQL>

                  _____________________________________________________________________________________________

                  From Primary site

                  SQL> show parameter log_archive_dest_2

                  NAME TYPE VALUE
                  ------------------------------------ ----------- ------------------------------
                  log_archive_dest_2 string service="(DESCRIPTION=(ADDRESS
                  =(PROTOCOL=tcp)(HOST=draixdbap
                  p)(PORT=1521))(CONNECT_DATA=(S
                  ERVICE_NAME=q013bansdr)(SERVER
                  =DEDICATED)))", LGWR ASYNC
                  NOAFFIRM delay=0 OPTIONAL comp
                  ression=DISABLE max_failure=0
                  max_connections=1 reopen=300
                  db_unique_name="q013bansdr" n
                  et_timeout=30 valid_for=(onli
                  ne_logfile,primary_role)
                  SQL> show parameter log_archive_config;

                  NAME TYPE VALUE
                  ------------------------------------ ----------- ------------------------------
                  log_archive_config string dg_config=(q013bans,q013bansdr
                  )
                  SQL> show parameter FAL

                  NAME TYPE VALUE
                  ------------------------------------ ----------- ------------------------------
                  fal_client string q013bans
                  fal_server string Q013BANSDR
                  SQL> show parameter REDO_TRANSPORT_USER

                  NAME TYPE VALUE
                  ------------------------------------ ----------- ------------------------------
                  redo_transport_user string
                  SQL> select database_role from v$database;

                  DATABASE_ROLE
                  ----------------
                  PRIMARY

                  SQL> select process from v$managed_standby;

                  PROCESS
                  ---------
                  ARCH
                  ARCH
                  ARCH
                  ARCH

                  SQL>
                  • 6. Re: Datagaurd is not working
                    Mahir M. Quluzade
                    Hi
                    969375 wrote:
                    Dear Mahir,

                    Please find the below output

                    From Standby site

                    SQL> show parameter log_archive_dest_2;

                    NAME TYPE VALUE
                    ------------------------------------ ----------- ------------------------------
                    log_archive_dest_2 string service=q013bans LGWR ASYNC va
                    lid_for=(ONLINE_LOGFILE,PRIMAR
                    Y_ROLE) db_unique_name=q013bansdr
                    q013bans - is your primary and unique name is q013bans
                    you must change it to :
                    service=q013bans LGWR ASYNC valid_for=(ONLINE_LOGFILE,PRIMARY_ROLE) db_unique_name=q013bans 
                    SQL> show parameter FAL

                    NAME TYPE VALUE
                    ------------------------------------ ----------- ------------------------------
                    fal_client string (DESCRIPTION=(ADDRESS=(PROTOCO
                    L=tcp)(HOST=draixdbapp)(PORT=1
                    521))(CONNECT_DATA=(SERVICE_NA
                    ME=q013bansdr)(SERVER=DEDICATE
                    D)))
                    fal_server string (DESCRIPTION=(ADDRESS=(PROTOCO
                    L=tcp)(HOST=livaixdbapp)(PORT=
                    1521))(CONNECT_DATA=(SERVICE_N
                    AME=q013bans)(SERVER=DEDICATED
                    )))
                    Cange to :

                    fal_client = q013bansdr
                    fal_server = q013bans
                    SQL> select database_role from v$database;

                    DATABASE_ROLE
                    ----------------
                    PHYSICAL STANDBY

                    SQL> select process from v$managed_standby;

                    PROCESS
                    ---------
                    ARCH
                    ARCH
                    ARCH
                    ARCH
                    ARCH

                    SQL>

                    _____________________________________________________________________________________________

                    From Primary site

                    SQL> show parameter log_archive_dest_2

                    NAME TYPE VALUE
                    ------------------------------------ ----------- ------------------------------
                    log_archive_dest_2 string service="(DESCRIPTION=(ADDRESS
                    =(PROTOCOL=tcp)(HOST=draixdbap
                    p)(PORT=1521))(CONNECT_DATA=(S
                    ERVICE_NAME=q013bansdr)(SERVER
                    =DEDICATED)))", LGWR ASYNC
                    NOAFFIRM delay=0 OPTIONAL comp
                    ression=DISABLE max_failure=0
                    max_connections=1 reopen=300
                    db_unique_name="q013bansdr" n
                    et_timeout=30 valid_for=(onli
                    ne_logfile,primary_role)
                    Try change to value:
                    service=q013bansdr LGWR ASYNC NOAFFIRM delay=0 OPTIONAL compression=DISABLE max_failure=0
                    db_unique_name="q013bansdr" net_timeout=30  valid_for=(online_logfile,primary_role)
                    SQL> select process from v$managed_standby;

                    PROCESS
                    ---------
                    ARCH
                    ARCH
                    ARCH
                    ARCH

                    SQL>
                    Can you paste here tnsnames.ora from both side?

                    tnsnames.ora file must be same :

                    tnsping q013bans
                    tnsping q013bansdr

                    Regards
                    Mahir M. Quluzade
                    • 7. Re: Datagaurd is not working
                      Satish Kumar Sadhu
                      Dear Mahir,

                      Primary tnsnames.ora


                      Q013BANS =
                      (DESCRIPTION =
                      (ADDRESS = (PROTOCOL = TCP)(HOST = livaixdbapp)(PORT = 1521))
                      (CONNECT_DATA =
                      (SERVER = DEDICATED)
                      (SERVICE_NAME = q013bans)
                      )
                      )

                      Q013BANSPR =
                      (DESCRIPTION =
                      (ADDRESS = (PROTOCOL = TCP)(HOST = livaixdbapp)(PORT = 1522))
                      (CONNECT_DATA =
                      (SERVER = DEDICATED)
                      (SERVICE_NAME = q013bans)
                      )
                      )

                      Q013BANSDR =
                      (DESCRIPTION =
                      (ADDRESS = (PROTOCOL = TCP)(HOST = draixdbapp)(PORT = 1521))
                      (CONNECT_DATA =
                      (SERVER = DEDICATED)
                      (SERVICE_NAME = q013bans)
                      )
                      )

                      Standby tnsnames.ora
                      Q013BANS =
                      (DESCRIPTION =
                      (ADDRESS = (PROTOCOL = TCP)(HOST = livaixdbapp)(PORT = 1521))
                      (CONNECT_DATA =
                      (SERVER = DEDICATED)
                      (SERVICE_NAME = q013bans)
                      )
                      )

                      Q013BANSPR =
                      (DESCRIPTION =
                      (ADDRESS = (PROTOCOL = TCP)(HOST = livaixdbapp)(PORT = 1522))
                      (CONNECT_DATA =
                      (SERVER = DEDICATED)
                      (SERVICE_NAME = q013bans)
                      )
                      )

                      Q013BANSDR =
                      (DESCRIPTION =
                      (ADDRESS = (PROTOCOL = TCP)(HOST = draixdbapp)(PORT = 1521))
                      (CONNECT_DATA =
                      (SERVER = DEDICATED)
                      (SERVICE_NAME = q013bans)
                      )
                      )
                      • 8. Re: Datagaurd is not working
                        Satish Kumar Sadhu
                        TNSPING from Primary

                        /oracle->tnsping q013bans

                        TNS Ping Utility for IBM/AIX RISC System/6000: Version 11.1.0.7.0 - Production on 06-MAY-2013 08:34:02

                        Copyright (c) 1997, 2008, Oracle. All rights reserved.

                        Used parameter files:


                        Used TNSNAMES adapter to resolve the alias
                        Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = livaixdbapp)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = q013bans)))
                        OK (0 msec)
                        /oracle->tnsping q013bansdr

                        TNS Ping Utility for IBM/AIX RISC System/6000: Version 11.1.0.7.0 - Production on 06-MAY-2013 08:34:11

                        Copyright (c) 1997, 2008, Oracle. All rights reserved.

                        Used parameter files:


                        Used TNSNAMES adapter to resolve the alias
                        Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = draixdbapp)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = q013bans)))
                        OK (10 msec)

                        TNSPING From Standby
                        --------------------------------------------

                        /home/oracle->tnsping q013bans

                        TNS Ping Utility for IBM/AIX RISC System/6000: Version 11.1.0.7.0 - Production on 06-MAY-2013 08:38:34

                        Copyright (c) 1997, 2008, Oracle. All rights reserved.

                        Used parameter files:


                        Used TNSNAMES adapter to resolve the alias
                        Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = livaixdbapp)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = q013bans)))
                        OK (1430 msec)
                        /home/oracle->tnsping q013bansdr

                        TNS Ping Utility for IBM/AIX RISC System/6000: Version 11.1.0.7.0 - Production on 06-MAY-2013 08:38:47

                        Copyright (c) 1997, 2008, Oracle. All rights reserved.

                        Used parameter files:


                        Used TNSNAMES adapter to resolve the alias
                        Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = draixdbapp)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = q013bans)))
                        OK (0 msec)
                        • 9. Re: Datagaurd is not working
                          Mahir M. Quluzade
                          Now, you must change log_archive_dest_2 on primary

                          On primary :
                          SQL> alter system set FAL_SERVER=q013bansdr; 
                          SQL> alter system set FAL_CLIENT= q013bans; 
                          
                          SQL>alter system set log_archive_dest_state_2=defer;
                          SQL>alter system set log_archive_dest_2 ='service=q013bansdr LGWR ASYNC NOAFFIRM valid_for=(online_logfile,primary_role) db_unique_name=q013bansdr'; 
                          SQL>alter system set log_archive_dest_state_2=enable; 
                          On Standby side :
                           SQL> alter system set FAL_SERVER=q013bans; 
                           SQL> alter system set FAL_CLIENT= q013bansdr; 
                           SQL>alter system set log_archive_dest_2 ='service=q013bans LGWR ASYNC NOAFFIRM valid_for=(online_logfile,primary_role) db_unique_name=q013bans'; 
                           SQL>alter system set log_archive_dest_state_2=enable; 
                          
                           SQL>alter database recover managed standby database disconnect from session;
                          I think you didn't forget set db_unique_name=q013bansdr on standby side.


                          Regards
                          Mahir M. Quluzade

                          Edited by: Mahir M. Quluzade on May 6, 2013 11:07 AM
                          • 10. Re: Datagaurd is not working
                            Satish Kumar Sadhu
                            Dear Mahir,

                            Today finally we have resolved the issue. Actually the issue is due to Network

                            Our network Administrator has disabled the SQLNET inspection from CISCO ASA firewall which is the default setting for CISCO ASA then it started working.

                            Thanks for your support.

                            Regards,
                            Satish Kumar Sadhu

                            Edited by: Satish Kumar Sadhu on May 7, 2013 6:44 AM