1 2 3 Previous Next 43 Replies Latest reply: Mar 11, 2014 8:07 PM by petra-K Go to original post RSS
      • 30. Re: Gaps exists again

        Hi all,

         

        Oue firewall was messed up hence this issue occured. The sysadmin just resigned 2 weeks ago. Nobody is expert here now

        That is why our dataguard can not update the standby. Also the connection is very slow. I do ftp gaps logs and it speed is just 10kbs.

        Can you guide me how to prove that there is a firewall problem?

         

        Why is that even if I ftp all the missing archive logs to the standby it will not apply it? even if I cataloged it? Does it need go signal from Primary? Can they be not disconnected for a while? I also observed that missing log gap  5162 is being recreated by dg on the latest date folder but why can not it be applied? what is it waiting for?

         

        Thanksss

        • 31. Re: Gaps exists again
          Baris Yildirim

          before trying to fetch gaps to your standby

           

          you can give an OK at the below command

           

          tnsping BNCTDR


          look at BNCTDR in your tnsnames.ora file at standby whether it indicates your primary or not


          Regards

          • 32. Re: Gaps exists again

            Hi all,

             

            What command shall I run to check if there is firewall issue? Aside from the alert log?  is it tnsping? ping? or etc? Just to show to my boss that it is a network problem or a firewall.

             

             

            Thanks

            • 33. Re: Gaps exists again
              Baris Yildirim

              Hi,

              firstly you should check BNCTDR

               

              search for tnsnames.ora

               

              it is under oracle_base$/oracle_home$/network/admin

               

              Regards

              • 34. Re: Gaps exists again

                tnsping BNCTDR

                 

                 

                TNS Ping Utility for IBM/AIX RISC System/6000: Version 11.2.0.1.0 - Production on 11-MAR-2014 20:26:24

                 

                 

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

                 

                 

                Used parameter files:

                /oracle/product/11.2.0/dbhome_1/network/admin/sqlnet.ora

                 

                 

                 

                 

                Used TNSNAMES adapter to resolve the alias

                Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.253.233.100)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = BNCTDR)))

                OK (270 msec)

                • 35. Re: Gaps exists again

                  What next to do dear?

                  • 36. Re: Gaps exists again
                    CKPT

                    f55237a7-2c38-4db3-a7a3-1d77256f0730 wrote:

                     

                    tnsping BNCTDR

                     

                     

                    TNS Ping Utility for IBM/AIX RISC System/6000: Version 11.2.0.1.0 - Production on 11-MAR-2014 20:26:24

                     

                     

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

                     

                     

                    Used parameter files:

                    /oracle/product/11.2.0/dbhome_1/network/admin/sqlnet.ora

                     

                     

                     

                     

                    Used TNSNAMES adapter to resolve the alias

                    Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.253.233.100)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = BNCTDR)))

                    OK (270 msec)

                    Response time 270 msec indeed its huge. You have to work on network bandwidthh speed

                    • 37. Re: Gaps exists again

                      So assuming there is problem in our network. So I can not manually apply archivelogs by copying them on the standby and apply?

                      • 38. Re: Gaps exists again
                        Baris Yildirim

                        start log apply again while watching alert log

                         

                        Regards

                        • 39. Re: Gaps exists again

                          Which alert log? primary or standby

                          • 40. Re: Gaps exists again

                            Hi Baris,

                             

                            I did this over and over again at standby db

                             

                            SQL> alter database recover managed standby database cancel;

                             

                             

                            Database altered.

                             

                             

                            SQL> alter database recover managed standby database using current logfile disconnect;

                             

                             

                            Database altered.

                            SQL>  SELECT STATUS,SEQUENCE# FROM V$MANAGED_STANDBY WHERE PROCESS='MRP0';

                             

                             

                            STATUS        SEQUENCE#

                            ------------ ----------

                            WAIT_FOR_LOG       5162

                             

                            Still it stuck on 5162

                             

                            The alert log said

                             

                            Tue Mar 11 21:37:03 2014

                            Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST

                            Tue Mar 11 21:38:03 2014

                            Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST

                            Tue Mar 11 21:39:03 2014

                            Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST

                            Tue Mar 11 21:40:03 2014

                            Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST

                            Tue Mar 11 21:40:29 2014

                            alter database recover managed standby database cancel

                            Tue Mar 11 21:40:30 2014

                            MRP0: Background Media Recovery cancelled with status 16037

                            Errors in file /oracle/diag/rdbms/bnctdr/BNCTDR/trace/BNCTDR_pr00_458996.trc:

                            ORA-16037: user requested cancel of managed recovery operation

                            Managed Standby Recovery not using Real Time Apply

                            Recovery interrupted!

                            Waiting for MRP0 pid 467180 to terminate

                            Errors in file /oracle/diag/rdbms/bnctdr/BNCTDR/trace/BNCTDR_pr00_458996.trc:

                            ORA-16037: user requested cancel of managed recovery operation

                            Tue Mar 11 21:40:30 2014

                            MRP0: Background Media Recovery process shutdown (BNCTDR)

                            Managed Standby Recovery Canceled (BNCTDR)

                            Completed: alter database recover managed standby database cancel

                            Tue Mar 11 21:40:59 2014

                            alter database recover managed standby database using current logfile disconnect

                            Attempt to start background Managed Standby Recovery process (BNCTDR)

                            Tue Mar 11 21:40:59 2014

                            MRP0 started with pid=25, OS id=684114

                            MRP0: Background Managed Standby Recovery process started (BNCTDR)

                            Tue Mar 11 21:41:03 2014

                            Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST

                            started logmerger process

                            Tue Mar 11 21:41:04 2014

                            Managed Standby Recovery starting Real Time Apply

                            Parallel Media Recovery started with 12 slaves

                            Waiting for all non-current ORLs to be archived...

                            All non-current ORLs have been archived.

                            Media Recovery Waiting for thread 1 sequence 5162 (in transit)

                            Completed: alter database recover managed standby database using current logfile disconnect

                            Tue Mar 11 21:42:03 2014

                            Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST

                            Tue Mar 11 21:43:03 2014

                            Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST

                             

                             

                            Please helppp

                            Thanks

                            • 41. Re: Gaps exists again
                              Baris Yildirim

                              what is the result of the below query at PRIMARY

                               

                              SELECT THREAD#,SEQUENCE# FROM v$log where status='CURRENT'

                               

                              and the belows at STANDBY

                               

                              SELECT name,value FROM v$parameter

                              where name LIKE 'log_archive_dest%' and value is not null

                              SELECT name,value FROM v$parameter

                              where name = 'standby_archive_dest' and value is not null

                               

                              Regards

                              • 42. Re: Gaps exists again
                                mohith2009

                                are you all set here?

                                • 43. Re: Gaps exists again

                                  Hi Baris, Mohith,

                                   

                                  Sorry for the delayed response. I just got back.

                                   

                                  At PrimaryDB:

                                  SELECT THREAD#,SEQUENCE# FROM v$log where status='CURRENT';

                                   

                                   

                                     THREAD#  SEQUENCE#

                                  ---------- ----------

                                           1       5233

                                   

                                  At StandbyDB:

                                    1  SELECT name,value FROM v$parameter

                                    2* where name LIKE 'log_archive_dest%' and value is not null

                                  SQL> /

                                  log_archive_dest_2             SERVICE=BN

                                                                 CT ASYNC

                                                                 VALID_FOR=

                                                                 (ONLINE_LO

                                                                 GFILES,PRI

                                                                 MARY_ROLE)

                                   

                                   

                                                                 DB_UNIQUE_

                                                                 NAME=BNCT

                                   

                                   

                                  log_archive_dest_state_1       enable

                                  log_archive_dest_state_2       ENABLE

                                  log_archive_dest_state_3       enable

                                  log_archive_dest_state_4       enable

                                  log_archive_dest_state_5       enable

                                  log_archive_dest_state_6       enable

                                  log_archive_dest_state_7       enable

                                  log_archive_dest_state_8       enable

                                  log_archive_dest_state_9       enable

                                  log_archive_dest_state_10      enable

                                  log_archive_dest_state_11      enable

                                  log_archive_dest_state_12      enable

                                  log_archive_dest_state_13      enable

                                  log_archive_dest_state_14      enable

                                  log_archive_dest_state_15      enable

                                  log_archive_dest_state_16      enable

                                  log_archive_dest_state_17      enable

                                  log_archive_dest_state_18      enable

                                  log_archive_dest_state_19      enable

                                  log_archive_dest_state_20      enable

                                  log_archive_dest_state_21      enable

                                  log_archive_dest_state_22      enable

                                  log_archive_dest_state_23      enable

                                  log_archive_dest_state_24      enable

                                  log_archive_dest_state_25      enable

                                  log_archive_dest_state_26      enable

                                  log_archive_dest_state_27      enable

                                  log_archive_dest_state_28      enable

                                  log_archive_dest_state_29      enable

                                  log_archive_dest_state_30      enable

                                  log_archive_dest_state_31      enable

                                   

                                   

                                  32 rows selected.

                                   

                                   

                                  SELECT name,value FROM v$parameter

                                  where name = 'standby_archive_dest' and value is not null  2  ;

                                  standby_archive_dest           ?/dbs/arch

                                  1 2 3 Previous Next