1 2 Previous Next 27 Replies Latest reply: May 9, 2008 7:17 AM by 638429 RSS

    Help with data guard

    542838
      oracle 10gr2
      soalris 9

      Hi ,

      I keep getting these follwoing errors in alert log file of primary database.
      I got this for a while and stopped after issuing the "alter system switch logifle"
      command few times and once standby started applying logs.

      What could be the reason?

      PRIMARY
      ------------


      ORA-12154: TNS:could not resolve the connect identifier specified
      PING[ARC0]: Heartbeat failed to connect to standby 'entrust.on.newsun.tcp'. Erro
      r is 12154.
      Tue May 6 11:52:48 2008
      Error 12154 received logging on to the standby
      Tue May 6 11:52:48 2008
      Errors in file /orahome/oracle/admin/10.2.0/entrust/bdump/entrust_arc0_16700.trc
      :
      ORA-12154: TNS:could not resolve the connect identifier specified
      PING[ARC0]: Heartbeat failed to connect to standby 'entrust.on.newsun.tcp'. Erro
      r is 12154.
      Tue May 6 11:55:24 2008
      Thread 1 advanced to log sequence 231
      Current log# 3 seq# 231 mem# 0: /ora/oradata/entrust/redo03.log
      Current log# 3 seq# 231 mem# 1: /ora1/oradata/entrust/redo03a.log
      Thread 1 advanced to log sequence 232
      Current log# 1 seq# 232 mem# 0: /ora/oradata/entrust/redo01.log
      Current log# 1 seq# 232 mem# 1: /ora1/oradata/entrust/redo01a.log
      Thread 1 cannot allocate new log, sequence 233
      Checkpoint not complete
      Current log# 1 seq# 232 mem# 0: /ora/oradata/entrust/redo01.log
      Current log# 1 seq# 232 mem# 1: /ora1/oradata/entrust/redo01a.log
      Tue May 6 11:55:35 2008
      Thread 1 advanced to log sequence 233
      Current log# 2 seq# 233 mem# 0: /ora/oradata/entrust/redo02.log
      Current log# 2 seq# 233 mem# 1: /ora1/oradata/entrust/redo02a.log
      Tue May 6 11:57:19 2008
      Thread 1 advanced to log sequence 234
      Current log# 3 seq# 234 mem# 0: /ora/oradata/entrust/redo03.log
      Current log# 3 seq# 234 mem# 1: /ora1/oradata/entrust/redo03a.log
      Tue May 6 12:01:03 2008
      Thread 1 advanced to log sequence 235
      Current log# 1 seq# 235 mem# 0: /ora/oradata/entrust/redo01.log
      Current log# 1 seq# 235 mem# 1: /ora1/oradata/entrust/redo01a.log
      Thread 1 cannot allocate new log, sequence 236
      Checkpoint not complete
      Current log# 1 seq# 235 mem# 0: /ora/oradata/entrust/redo01.log
      Current log# 1 seq# 235 mem# 1: /ora1/oradata/entrust/redo01a.log
      Thread 1 advanced to log sequence 236
      Current log# 2 seq# 236 mem# 0: /ora/oradata/entrust/redo02.log
      Current log# 2 seq# 236 mem# 1: /ora1/oradata/entrust/redo02a.log
      Tue May 6 12:18:16 2008
      Thread 1 advanced to log sequence 237
      Current log# 3 seq# 237 mem# 0: /ora/oradata/entrust/redo03.log
      Current log# 3 seq# 237 mem# 1: /ora1/oradata/entrust/redo03a.log
      Thread 1 advanced to log sequence 238
      Current log# 1 seq# 238 mem# 0: /ora/oradata/entrust/redo01.log
      Current log# 1 seq# 238 mem# 1: /ora1/oradata/entrust/redo01a.log
      Tue May 6 12:20:06 2008
      Thread 1 advanced to log sequence 239
      Current log# 2 seq# 239 mem# 0: /ora/oradata/entrust/redo02.log
      Current log# 2 seq# 239 mem# 1: /ora1/oradata/entrust/redo02a.log
      Thread 1 advanced to log sequence 240
      Current log# 3 seq# 240 mem# 0: /ora/oradata/entrust/redo03.log
      Current log# 3 seq# 240 mem# 1: /ora1/oradata/entrust/redo03a.log
      Tue May 6 15:55:42 2008
      Thread 1 advanced to log sequence 241
      Current log# 1 seq# 241 mem# 0: /ora/oradata/entrust/redo01.log
      Current log# 1 seq# 241 mem# 1: /ora1/oradata/entrust/redo01a.log
      Thread 1 advanced to log sequence 242
      Current log# 2 seq# 242 mem# 0: /ora/oradata/entrust/redo02.log
      Current log# 2 seq# 242 mem# 1: /ora1/oradata/entrust/redo02a.log
      Tue May 6 16:22:51 2008
      alter database backup controlfile to trace
      Tue May 6 16:23:07 2008
      Completed: alter database backup controlfile to trace
      Tue May 6 16:23:13 2008
      Thread 1 advanced to log sequence 243
      Current log# 3 seq# 243 mem# 0: /ora/oradata/entrust/redo03.log
      Current log# 3 seq# 243 mem# 1: /ora1/oradata/entrust/redo03a.log
      Thread 1 advanced to log sequence 244
      Current log# 1 seq# 244 mem# 0: /ora/oradata/entrust/redo01.log
      Current log# 1 seq# 244 mem# 1: /ora1/oradata/entrust/redo01a.log
      Tue May 6 16:50:16 2008
      Thread 1 advanced to log sequence 245
      Current log# 2 seq# 245 mem# 0: /ora/oradata/entrust/redo02.log
      Current log# 2 seq# 245 mem# 1: /ora1/oradata/entrust/redo02a.log
      Thread 1 advanced to log sequence 246
      Current log# 3 seq# 246 mem# 0: /ora/oradata/entrust/redo03.log
      Current log# 3 seq# 246 mem# 1: /ora1/oradata/entrust/redo03a.log
      Tue May 6 22:02:28 2008
      Thread 1 advanced to log sequence 247
      Current log# 1 seq# 247 mem# 0: /ora/oradata/entrust/redo01.log
      Current log# 1 seq# 247 mem# 1: /ora1/oradata/entrust/redo01a.log
      Wed May 7 05:00:57 2008
      Thread 1 advanced to log sequence 248
      Current log# 2 seq# 248 mem# 0: /ora/oradata/entrust/redo02.log
      Current log# 2 seq# 248 mem# 1: /ora1/oradata/entrust/redo02a.log
      Wed May 7 07:33:02 2008
      Thread 1 advanced to log sequence 249
      Current log# 3 seq# 249 mem# 0: /ora/oradata/entrust/redo03.log
      Current log# 3 seq# 249 mem# 1: /ora1/oradata/entrust/redo03a.log
      Thread 1 advanced to log sequence 250
      Current log# 1 seq# 250 mem# 0: /ora/oradata/entrust/redo01.log
      Current log# 1 seq# 250 mem# 1: /ora1/oradata/entrust/redo01a.log
      Wed May 7 08:59:57 2008
      Thread 1 advanced to log sequence 251
      Current log# 2 seq# 251 mem# 0: /ora/oradata/entrust/redo02.log
      Current log# 2 seq# 251 mem# 1: /ora1/oradata/entrust/redo02a.log


      STANDBY
      ---------------

      RFS[2]: No standby redo logfiles created
      RFS[2]: Archived Log: '/orahome/oracle/admin/10.2.0/entrust/arch/arch_1_242_653'
      RFS[2]: No standby redo logfiles created
      RFS[2]: Archived Log: '/orahome/oracle/admin/10.2.0/entrust/arch/arch_1_243_653'
      Tue May 6 16:29:33 2008
      Media Recovery Log /orahome/oracle/admin/10.2.0/entrust/arch/arch_1_242_6538642l
      Media Recovery Log /orahome/oracle/admin/10.2.0/entrust/arch/arch_1_243_6538642l
      Media Recovery Waiting for thread 1 sequence 244
      Tue May 6 16:56:21 2008
      RFS[2]: No standby redo logfiles created
      RFS[2]: Archived Log: '/orahome/oracle/admin/10.2.0/entrust/arch/arch_1_244_653'
      Tue May 6 16:56:22 2008
      Media Recovery Log /orahome/oracle/admin/10.2.0/entrust/arch/arch_1_244_6538642l
      Tue May 6 16:56:23 2008
      RFS[2]: No standby redo logfiles created
      RFS[2]: Archived Log: '/orahome/oracle/admin/10.2.0/entrust/arch/arch_1_245_653'
      Tue May 6 16:56:24 2008
      Media Recovery Log /orahome/oracle/admin/10.2.0/entrust/arch/arch_1_245_6538642l
      Media Recovery Waiting for thread 1 sequence 246
      Tue May 6 22:08:35 2008
      RFS[2]: No standby redo logfiles created
      RFS[2]: Archived Log: '/orahome/oracle/admin/10.2.0/entrust/arch/arch_1_246_653'
      Tue May 6 22:08:45 2008
      Media Recovery Log /orahome/oracle/admin/10.2.0/entrust/arch/arch_1_246_6538642l
      Tue May 6 22:09:35 2008
      Media Recovery Waiting for thread 1 sequence 247
      Wed May 7 05:07:03 2008
      RFS[2]: No standby redo logfiles created
      RFS[2]: Archived Log: '/orahome/oracle/admin/10.2.0/entrust/arch/arch_1_247_653'
      Wed May 7 05:07:07 2008
      Media Recovery Log /orahome/oracle/admin/10.2.0/entrust/arch/arch_1_247_6538642l
      Wed May 7 05:07:53 2008
      Media Recovery Waiting for thread 1 sequence 248
      Wed May 7 07:39:07 2008
      RFS[2]: No standby redo logfiles created
      RFS[2]: Archived Log: '/orahome/oracle/admin/10.2.0/entrust/arch/arch_1_248_653'
      RFS[2]: No standby redo logfiles created
      RFS[2]: Archived Log: '/orahome/oracle/admin/10.2.0/entrust/arch/arch_1_249_653'
      Wed May 7 07:39:11 2008
      Media Recovery Log /orahome/oracle/admin/10.2.0/entrust/arch/arch_1_248_6538642l
      Wed May 7 07:39:22 2008
      Media Recovery Log /orahome/oracle/admin/10.2.0/entrust/arch/arch_1_249_6538642l
      Media Recovery Waiting for thread 1 sequence 250
      Wed May 7 09:06:02 2008
      RFS[2]: No standby redo logfiles created
      RFS[2]: Archived Log: '/orahome/oracle/admin/10.2.0/entrust/arch/arch_1_250_653'
      Wed May 7 09:06:05 2008
      Media Recovery Log /orahome/oracle/admin/10.2.0/entrust/arch/arch_1_250_6538642l
      Media Recovery Waiting for thread 1 sequence 251

      Message was edited by:
      user539835
        • 1. Re: Help with data guard
          Aman....
          Hi,
          Check the tnsnames,ora enteries that you have made for the primary and secondary. The issue is for that.
          Aman....
          • 2. Re: Help with data guard
            542838
            Thank you!

            It is working fine now.
            I could see these errors until archive logs are shipped and recovered on standby.
            It took a while to transfer logs to standby, during that time I see these errors.
            The following are the tnsnames.ora entries.

            PRIMARY
            ---------------

            entrust.on.sunblade.tcp =
            (DESCRIPTION =
            (ADDRESS = (PROTOCOL = TCP)(HOST = sunblade)(PORT = 1521))
            (CONNECT_DATA =
            (SERVER = DEDICATED)
            (SERVICE_NAME = entrust.on.sunblade.tcp)
            )
            )

            entrust.on.newsun.tcp =
            (DESCRIPTION =
            (ADDRESS = (PROTOCOL = TCP)(HOST = newsun)(PORT = 1521))
            (CONNECT_DATA =
            (SERVER = DEDICATED)
            (SERVICE_NAME = entrust.on.newsun.tcp)
            )
            )

            STANDBY
            ----------------

            entrust.on.newsun.tcp =
            (DESCRIPTION =
            (ADDRESS = (PROTOCOL = TCP)(HOST = newsun)(PORT = 1521))
            (CONNECT_DATA =
            (SERVER = DEDICATED)
            (SERVICE_NAME = entrust.on.newsun.tcp)
            )
            )

            entrust.on.sunblade.tcp =
            (DESCRIPTION =
            (ADDRESS = (PROTOCOL = TCP)(HOST = sunblade)(PORT = 1521))
            (CONNECT_DATA =
            (SERVER = DEDICATED)
            (SERVICE_NAME = entrust.on.sunblade.tcp)
            )
            )

            Message was edited by:
            user539835
            • 3. Re: Help with data guard
              542838
              Any updates on this?
              tnsnames looks fine to me.
              • 4. Re: Help with data guard
                Boochi
                Have you created standby redo logs on both primary and standby databases. The no. of standby logs required are no.of redo logs+1.

                null
                • 5. Re: Help with data guard
                  542838
                  I have not.
                  Database is in folllowing protection_mode.

                  select protection_mode from v$database;

                  PROTECTION_MODE
                  --------------------
                  MAXIMUM PERFORMANCE

                  Do you think this is related to standby redologs?

                  Thanks.
                  • 6. Re: Help with data guard
                    Boochi
                    Standby redo log is required for the maximum protection and maximum availability modes. As yours is maximum performance, standby logs are not required.

                    The error may be due to the entries in SQLNET.ORA file. Check the entries for NAMES.DIRECTORY_PATH in SQLNET.ORA. The NAMES resolution is made from right to left. If you still have the problem, change the NAMES entry like NAMES.DIRECTORY_PATH=(TNSNAMES).
                    • 7. Re: Help with data guard
                      529937
                      You do need standby redo logs, even if you're in maximum performance. Archive logs are used only when it needs to resolve gaps.
                      • 8. Re: Help with data guard
                        529937
                        Standby logs on the primary aren't required, but then you wouldn't be able to switch roles between the databases.
                        • 9. Re: Help with data guard
                          542838
                          With highlighted parameter dataguard was working.
                          wIth LGWR SYNC, database crashes. and generated following error in alert log file when I tried to chnage the protection mode to MAXMIMIZE PRETECTION in mount state and tried to open the database.

                          SQL> startup mount;
                          ORACLE instance started.

                          Total System Global Area 520093696 bytes
                          Fixed Size 2031352 bytes
                          Variable Size 188743944 bytes
                          Database Buffers 327155712 bytes
                          Redo Buffers 2162688 bytes
                          Database mounted.
                          SQL> alter database set standby database to maximize protection;

                          Database altered.

                          SQL> alter database open;
                          alter database open
                          *
                          ERROR at line 1:
                          ORA-03113: end-of-file on communication channel




                          LGWR: STARTING ARCH PROCESSES COMPLETE
                          ARC1 started with pid=15, OS id=569
                          Thu May 8 11:20:01 2008
                          LGWR: Primary database is in MAXIMUM PROTECTION mode
                          LGWR: Destination LOG_ARCHIVE_DEST_1 is not serviced by LGWR
                          LGWR: Minimum of 1 synchronous standby database required
                          Thu May 8 11:20:01 2008
                          Errors in file /orahome/oracle/admin/10.2.0/entrust/bdump/entrust_lgwr_443.trc:
                          ORA-16072: a minimum of one standby database destination is required
                          Thu May 8 11:20:01 2008
                          Errors in file /orahome/oracle/admin/10.2.0/entrust/bdump/entrust_lgwr_443.trc:
                          ORA-16072: a minimum of one standby database destination is required
                          LGWR: terminating instance due to error 16072


                          ######################################################################
                          # Data Guard
                          ######################################################################
                          #log_archive_dest_2 = 'service=entrust.on.newsun.tcp optional reopen=60
                          max_failure=10'
                          #log_archive_dest_2 = 'service=entrust.on.newsun.tcp LGWR ASYNC
                          optiona
                          l reopen=60 max_failure=10'
                          log_archive_dest_2 = 'service=entrust.on.newsun.tcp LGWR SYNC optional
                          reopen=60 max_failure=10'
                          fal_client = entrust.on.newsun.tcp
                          fal_server = entrust.on.sunblade.tcp
                          standby_archive_dest = '/orahome/oracle/admin/10.2.0/entrust/arch'
                          standby_file_management = AUTO

                          Message was edited by:
                          user539835
                          • 10. Re: Help with data guard
                            542838
                            BTW I do not previous errors in alert log files after creating standby redo logs in primary and standby and modifying sqlnet.ora file with following.

                            NAMES.DIRECTORY_PATH=(TNSNAMES)


                            Thanks.
                            • 11. Re: Help with data guard
                              Boochi
                              When you have changed to LOG SYNC and protection mode as MAXIMUM PROTECTION, you need to create standby logs. But, the standby logs may not be required when you are using MAXIMUM PERFORMANCE mode.
                              • 12. Re: Help with data guard
                                542838
                                I did create standby redologs on both Primary and standby databases.


                                PRIMARY
                                ---------------
                                SQL> select group#||'|'||type||'|'||member||'|' from v$logfile;

                                GROUP#||'|'||TYPE||'|'||MEMBER||'|'
                                --------------------------------------------------------------------------------
                                1|ONLINE|/ora/oradata/entrust/redo01.log|
                                1|ONLINE|/ora1/oradata/entrust/redo01a.log|
                                2|ONLINE|/ora/oradata/entrust/redo02.log|
                                3|ONLINE|/ora/oradata/entrust/redo03.log|
                                2|ONLINE|/ora1/oradata/entrust/redo02a.log|
                                3|ONLINE|/ora1/oradata/entrust/redo03a.log|
                                4|STANDBY|/ora/oradata/entrust/stdby01.log|
                                4|STANDBY|/ora1/oradata/entrust/stdby01a.log|
                                5|STANDBY|/ora/oradata/entrust/stdby02.log|
                                5|STANDBY|/ora1/oradata/entrust/stdby02a.log|
                                6|STANDBY|/ora/oradata/entrust/stdby03.log|

                                GROUP#||'|'||TYPE||'|'||MEMBER||'|'
                                --------------------------------------------------------------------------------
                                6|STANDBY|/ora1/oradata/entrust/stdby03a.log|

                                12 rows selected.


                                STANDBY
                                --------------
                                SQL> select group#||'|'||type||'|'||member||'|' from v$logfile;

                                GROUP#||'|'||TYPE||'|'||MEMBER||'|'
                                --------------------------------------------------------------------------------
                                1|ONLINE|/ora/oradata/entrust/redo01.log|
                                1|ONLINE|/ora1/oradata/entrust/redo01a.log|
                                2|ONLINE|/ora/oradata/entrust/redo02.log|
                                3|ONLINE|/ora/oradata/entrust/redo03.log|
                                2|ONLINE|/ora1/oradata/entrust/redo02a.log|
                                3|ONLINE|/ora1/oradata/entrust/redo03a.log|
                                4|STANDBY|/ora/oradata/entrust/stdby01.log|
                                4|STANDBY|/ora1/oradata/entrust/stdby01a.log|
                                5|STANDBY|/ora/oradata/entrust/stdby02.log|
                                5|STANDBY|/ora1/oradata/entrust/stdby02a.log|
                                6|STANDBY|/ora/oradata/entrust/stdby03.log|

                                GROUP#||'|'||TYPE||'|'||MEMBER||'|'
                                --------------------------------------------------------------------------------
                                6|STANDBY|/ora1/oradata/entrust/stdby03a.log|

                                12 rows selected.
                                • 13. Re: Help with data guard
                                  277993
                                  If your Primary databases net service is entrust.on.newsun.tcp

                                  Then init parameter on Primary

                                  fal_client = entrust.on.newsun.tcp
                                  fal_server = entrust.on.sunblade.tcp

                                  If your Stanby databases net service is entrust.on.sunblade.tcp

                                  Then init parameter on Standby

                                  fal_client = entrust.on.sunblade.tcp
                                  fal_server = entrust.on.newsun.tcp


                                  Remember to eanble the state of destinations you are using.

                                  e.g

                                  LOG_ARCHIVE_DEST_STATE_1='ENABLE'
                                  LOG_ARCHIVE_DEST_STATE_2='ENABLE'
                                  1 2 Previous Next