10 Replies Latest reply: Jun 21, 2012 11:20 PM by CKPT RSS

    ORA-16009: invalid redo transport destination;

    912899
      Dear friends.
      I am trying to set up phycial standby in Oracle 11g on linux in vmware.
      Everything seems to fine but The configuration is not taking effect.
      An error cropping repeatedly
      ORA-16009
      I am putting the errors and some of the contents.
      Standby System
      ------------------
      archive log list
      Database log mode Archive Mode
      Automatic archival Enabled
      Archive destination /disk1/oradata/arch
      Oldest online log sequence 2
      Next log sequence to archive 3
      Current log sequence 3

      Production System
      -----------------
      atabase log mode Archive Mode
      Automatic archival Enabled
      Archive destination /disk1/oradata/arch
      Oldest online log sequence 8
      Next log sequence to archive 9
      Current log sequence 9
      on Client Errors:
      ORA-16009: invalid redo transport destination
      PING[ARC0]: Heartbeat failed to connect to standby 'to_orcl1'. Error is 16009.
      Fri May 04 22:45:54 2012
      Errors in file /disk1/oradata/oracldir/diag/rdbms/orcl3/orcl3/trace/orcl3_arc0_10286.trc:
      ORA-16009: invalid redo transport destination
      PING[ARC0]: Heartbeat failed to connect to standby 'to_orcl1'. Error is 16009.
      Fri May 04 22:47:45 2012
      Errors in file /disk1/oradata/oracldir/diag/rdbms/orcl3/orcl3/trace/orcl3_arc0_10286.trc:
      ORA-16009: invalid redo transport destination
      PING[ARC0]: Heartbeat failed to connect to standby 'to_orcl1'. Error is 16009.
      Fri May 04 22:49:48 2012
      Errors in file /disk1/oradata/oracldir/diag/rdbms/orcl3/orcl3/trace/orcl3_arc0_10286.trc:
      ORA-16009: invalid redo transport destination
      PING[ARC0]: Heartbeat failed to connect to standby 'to_orcl1'. Error is 16009.
      Fri May 04 22:51:40 2012
      Errors in file /disk1/oradata/oracldir/diag/rdbms/orcl3/orcl3/trace/orcl3_arc0_10286.trc:
      ORA-16009: invalid redo transport destination
      PING[ARC0]: Heartbeat failed to connect to standby 'to_orcl1'. Error is 16009.

      On Production System Errors:

      ORA-16009: invalid redo transport destination
      Fri May 04 22:47:37 2012
      Error 1034 received logging on to the standby
      Fri May 04 22:47:48 2012
      RFS[43]: Assigned to RFS process 17922
      RFS[43]: Database mount ID mismatch [0x2a846b0e:0x2a856e71] (713321230:713387633)
      RFS[43]: Client instance is standby database instead of primary
      RFS[43]: Not using real application clusters
      Errors in file /disk1/oradata/oracldir/diag/rdbms/orcl3/orcl3/trace/orcl3_rfs_17922.trc:
      ORA-16009: invalid redo transport destination
      Fri May 04 22:49:17 2012
      Destination LOG_ARCHIVE_DEST_2 is UNSYNCHRONIZED
      Thread 1 advanced to log sequence 14 (LGWR switch)
      Current log# 2 seq# 14 mem# 0: /disk1/oradata/oracldir/redolog2.log
      Fri May 04 22:49:18 2012
      Archived Log entry 17 added for thread 1 sequence 13 ID 0x2a7a0eb4 dest 1:
      Fri May 04 22:49:50 2012
      RFS[44]: Assigned to RFS process 17999
      RFS[44]: Database mount ID mismatch [0x2a846b0e:0x2a856e71] (713321230:713387633)
      RFS[44]: Client instance is standby database instead of primary
      RFS[44]: Not using real application clusters
      Errors in file /disk1/oradata/oracldir/diag/rdbms/orcl3/orcl3/trace/orcl3_rfs_17999.trc:
      ORA-16009: invalid redo transport destination
      Fri May 04 22:51:42 2012
      RFS[45]: Assigned to RFS process 18057
      RFS[45]: Database mount ID mismatch [0x2a846b0e:0x2a856e71] (713321230:713387633)
      RFS[45]: Client instance is standby database instead of primary
      RFS[45]: Not using real application clusters
      Errors in file /disk1/oradata/oracldir/diag/rdbms/orcl3/orcl3/trace/orcl3_rfs_18057.trc:
      ORA-16009: invalid redo transport destination
      Fri May 04 22:52:00 2012
      Error 1034 received logging on to the standby
      Fri May 04 22:52:32 2012
      Error 1034 received logging on to the standby
      Errors in file /disk1/oradata/oracldir/diag/rdbms/orcl3/orcl3/trace/orcl3_arc2_17414.trc:
      ORA-01034: ORACLE not available
      FAL[server, ARC2]: FAL archive failed, see trace file.
      Errors in file /disk1/oradata/oracldir/diag/rdbms/orcl3/orcl3/trace/orcl3_arc2_17414.trc:
      ORA-16055: FAL request rejected
      ARCH: FAL archive failed. Archiver continuing
      ORACLE Instance orcl3 - Archival Error. Archiver continuing.
      Fri May 04 22:53:42 2012
      RFS[46]: Assigned to RFS process 18115
      RFS[46]: Database mount ID mismatch [0x2a846b0e:0x2a856e71] (713321230:713387633)
      RFS[46]: Client instance is standby database instead of primary
      RFS[46]: Not using real application clusters
      Errors in file /disk1/oradata/oracldir/diag/rdbms/orcl3/orcl3/trace/orcl3_rfs_18115.trc:
      ORA-16009: invalid redo transport destination
        • 1. Re: ORA-16009: invalid redo transport destination;
          mseberg
          Hello;



          Generally this means LOG_ARCHIVE_DEST_2 is wrong

          If you post both INIT I will review for issues.



          Best Regards

          mseberg
          • 2. Re: ORA-16009: invalid redo transport destination;
            912899
            Production Server int$ORACLE_SID.ora
            db_name='orcl3'
            memory_target=500m
            processes = 150
            #audit_file_dest='<ORACLE_BASE>/admin/orcl/adump'
            #audit_trail ='db'
            db_block_size=8192
            db_domain=''
            #db_recovery_file_dest='/disk1/oradata/anjum'
            #db_recovery_file_dest_size=400m
            diagnostic_dest='/disk1/oradata/oracldir/'
            dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'
            open_cursors=300
            log_archive_dest_1="location=/disk1/oradata/arch"
            #log_archive_dest_1="/disk1/oradata/arch"
            log_archive_dest_2="Service=to_orcl1 lgwr sync affirm reopen=3"
            standby_file_management=auto
            standby_archive_dest=/disk1/oradata/arch
            remote_login_passwordfile='EXCLUSIVE'
            undo_tablespace='UNDOTBS1'
            # You may want to ensure that control files are created on separate physical
            control_files = '/disk1/oradata/oracldir/control1.ctl','/disk2/oradata/oracldir/control2.ctl'
            compatible ='11.2.0'

            Client MAchine int$ORACLE_SID.ora

            db_name='orcl3'
            memory_target=500m
            processes = 150
            #audit_file_dest='<ORACLE_BASE>/admin/orcl/adump'
            #audit_trail ='db'
            db_block_size=8192
            db_domain=''
            #db_recovery_file_dest='/disk1/oradata/anjum'
            #db_recovery_file_dest_size=400m
            diagnostic_dest='/disk1/oradata/oracldir/'
            dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'
            open_cursors=300
            log_archive_dest_1="location=/disk1/oradata/arch"
            #log_archive_dest_2="Service=to_orcl1 lgwr sync reopen=3"
            #log_archive_dest_1="/disk1/oradata/arch"
            #log_archive_dist_1="location=/disk1/oradata/oracldir/dg/
            log_archive_dest_2="Service=to_orcl2 lgwr sync affirm reopen=3"
            standby_file_management=auto
            standby_archive_dest=/disk1/oradata/arch
            remote_login_passwordfile='EXCLUSIVE'
            undo_tablespace='UNDOTBS1'
            # You may want to ensure that control files are created on separate physical
            # devices
            control_files = '/disk1/oradata/oracldir/dg/standby.ctl'
            compatible ='11.2.0'
            • 3. Re: ORA-16009: invalid redo transport destination;
              mseberg
              OK;

              I see several issues. Will post results back here in a Moment.

              Primary

              Missing several parameters :

              FAL_SERVER
              DB_UNIQUE_NAME
              LOG_ARCHIVE_DEST_STATE_1 ( should be ENABLE )
              LOG_ARCHIVE_DEST_STATE_2 ( should be ENABLE )



              Incorrect settings

              log_archive_dest_1
              log_archive_dest_2


              YOURS


              log_archive_dest_1="location=/disk1/oradata/arch"

              EXAMPLE FROM MINE

              log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=PRIMARY'


              YOURS

              log_archive_dest_2="Service=to_orcl1 lgwr sync affirm reopen=3"

              EXAMPLE FROM MINE

              log_archive_dest_2='SERVICE=STANDBY LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=STANDBY'



              Standby

              Missing several parameters :

              LOG_ARCHIVE_DEST_STATE_1 ( should be ENABLE )
              LOG_ARCHIVE_DEST_STATE_2 ( should be DEFER )
              FAL_SERVER
              DB_UNIQUE_NAME

              Incorrect settings

              log_archive_dest_1
              log_archive_dest_2

              (similar to primary issues)

              Summary

              OK, this is way off. I don't in any way want to be unprofessional or rude but I'm not sure how to help without wasting you time or mine. So I'm going to take a few educated guesses and hope I'm helping you.

              First I have a short note on how to do this here :

              http://www.visi.com/~mseberg/data_guard_on_oracle_11_step_by_step.html

              Second, you really need to understand the Oracle parameters needed by Data Guard so I would ask you read :

              Data Guard Concepts and Administration 11g Release 2 (11.2) E10700-02

              The section in chapter 3 "Set Primary Database Initialization Parameters"


              Third, you say vmware. By that do you mean two separate vmware servers? A Primary and a Standby of something else?


              More details here might help. Vmware is fine, but if I'm setting this up I want two Servers, one for the Primary and one for the Standby database.

              Will still post the details of Standby INIt ASAP


              Best Regards

              mseberg

              Edited by: mseberg on May 4, 2012 12:48 PM

              Edited by: mseberg on May 4, 2012 1:43 PM
              • 4. Re: ORA-16009: invalid redo transport destination;
                912899
                I really thanks .
                This is setup in the same VMware 7 . Both are tnspinging and network issues is not there.
                I would do as you told and perhaps would return to u .

                Best Regards.
                • 5. Re: ORA-16009: invalid redo transport destination;
                  mseberg
                  OK

                  I have done the setup using two vmware players and then installing Red Hat AS 5. Depending upon how Vmware hands out the IP you might need to force the listener.ora but using a static entry

                  Better Example :
                  SID_LIST_LISTENER =
                    (SID_LIST =
                      (SID_DESC =
                        (SID_NAME = PLSExtProc)
                        (ORACLE_HOME = /u01/app/oracle/product/11.2.0.2)
                        (PROGRAM = extproc)
                      )
                        (SID_DESC =
                        (global_dbname = STANDBY.hostname)
                        (ORACLE_HOME = /u01/app/oracle/product/11.2.0)
                        (sid_name = STANDBY)
                      )     
                   )    
                  So for each database you add a SID_DESC under the SID_LIST_LISTENER.

                  Similar to the _DGMGRL, but not the same.

                  http://www.visi.com/~mseberg/Data_Guard_Listener_Example.html


                  Can post a better example if you need it.


                  Key Data Guard Parameters

                  FAL_SERVER
                  STANDBY_FILE_MANAGEMENT
                  DB_UNIQUE_NAME
                  DB_FILE_NAME_CONVERT
                  LOG_FILE_NAME_CONVERT
                  log_archive_dest_1
                  log_archive_dest_2
                  LOG_ARCHIVE_DEST_STATE_1
                  LOG_ARCHIVE_DEST_STATE_2
                  LOG_ARCHIVE_MAX_PROCESSES


                  Plus

                  compatible ( Should be same on both )
                  remote_login_passwordfile ( I use 'EXCLUSIVE' )
                  control_files



                  FAL_CLIENT is Obsolete in 11.2




                  Best Regards

                  mseberg

                  Edited by: mseberg on May 4, 2012 1:44 PM

                  Edited by: mseberg on May 4, 2012 3:10 PM
                  • 6. Re: ORA-16009: invalid redo transport destination;
                    Shivananda Rao
                    log_archive_dest_2="Service=to_orcl1 lgwr sync affirm reopen=3"
                    Can you make sure the service name you have provided in the log_archive_dest_2 parameter of primary points to the Oracle Net Service Name of the standby database ?

                    Please refer this http://shivanandarao.wordpress.com/2012/03/10/creating-physical-standby-database-on-oracle-11g/
                    Might help you out.
                    • 7. Re: ORA-16009: invalid redo transport destination;
                      912899
                      Sorry for being late.
                      Yes the to_orcl1 is pointing to the standby database. And one point i would like to say that i have confogured to_orcl1 in tnsname.ora on both the machine.i,e boith machine can tnsping other machine through to_orcl1.
                      I would go through the page u have said.

                      Best Regards.
                      • 8. Re: ORA-16009: invalid redo transport destination;
                        Wyoming Dawn
                        I am also having a problem with archive log transport.
                        When the primary database is mounted but not open log_archive_dest_2 is valid; after I do alter database open log_archive_dest_2 changes to ERROR and shows ORA-01031: insufficient privileges.
                        I have no idea where to look for where the "block" is - any ideas?
                        I can do a sqlplus command from the primary system to the standby system and do not get an error except for the error about the database not being in a condition to connect to - as expected - it is standby.
                        Please help.
                        • 9. Re: ORA-16009: invalid redo transport destination;
                          mseberg
                          Generally you need to open your own question.

                          Also when you ask a question give your exact Oracle version, OS version etc. And enough details so somebody can help without writing a novel.

                          Please review this and the section I denote below.

                          https://wikis.oracle.com/display/Forums/Forums+FAQ

                          See - How do I start a discussion or post a question?

                          Best Regards

                          mseberg
                          • 10. Re: ORA-16009: invalid redo transport destination;
                            CKPT
                            RFS[46]: Database mount ID mismatch [0x2a846b0e:0x2a856e71] (713321230:713387633)
                            RFS[46]: Client instance is standby database instead of primary
                            RFS[46]: Not using real application clusters
                            Errors in file /disk1/oradata/oracldir/diag/rdbms/orcl3/orcl3/trace/orcl3_rfs_18115.trc:
                            ORA-16009: invalid redo transport destination
                            For me it Looks as per your PFILE posted, you forgot to configure only one parameter is LOG_ARCHIVE_CONFIG

                            It should set both in primary and standby as below.

                            Log_archive_config='DG_CONFIG=(Prim_DB_unique_name,stby_DB_unique_name)'
                            you haven't set DB_UNIQUE_NAME also.
                            Also your parameters are incorrect for log_archive_dest_2 mention DB_UNIQUE_NAME,