This discussion is archived
10 Replies Latest reply: Jun 21, 2012 9:20 PM by CKPT RSS

ORA-16009: invalid redo transport destination;

912899 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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,

Legend

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