archives not shipping on standby
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: archives not shipping on standby

  1. #1
    Join Date
    May 2013
    Posts
    1

    archives not shipping on standby

    Hii all,

    I am trying to configure physical standby. Everything was fine but at the end i found that archives from primary db are not shipping to standby..Networking is fine.

    Here is the production p file.

    db_name=manish
    db_unique_name=manish1
    #service_name=manish1
    remote_login_passwordfile=exclusive
    shared_pool_size=102341017
    db_block_size=8192
    diagnostic_dest=/disk1/oradata/manish
    undo_tablespace=undotbs
    undo_management=auto
    control_files = /disk1/oradata/manish/control.ctl
    compatible ='11.2.0'
    ###################Data guard PARAM's###################
    log_archive_dest_1='location=/disk1/oradata/manish/arch
    valid_for=(all_logfiles,all_roles)'
    log_archive_dest_2='service=stand
    valid_for=(online_logfiles,primary_role)
    db_unique_name=stand1 lgwr sync affirm reopen=10'
    standby_archive_dest=/dsik1/oradata/manish/arch
    standby_file_management=auto
    log_archive_dest_state_1=enable
    log_archive_dest_state_2=enable
    fal_server=stand
    fal_client=manish

    here is my standby's p file

    db_name=manish
    db_unique_name=stand1
    remote_login_passwordfile=exclusive
    shared_pool_size=102341017
    db_block_size=8192
    diagnostic_dest=/disk1/oradata/manish
    undo_tablespace=undotbs
    undo_management=auto
    control_files = /disk1/oradata/manish/stand.ctl
    compatible ='11.2.0'
    ###################Data guard PARAM's###################
    log_archive_dest_1='location=/disk1/oradata/manish/arch
    valid_for=(all_logfiles,all_roles)'
    log_archive_dest_2='service=manish lgwr sync affirm reopen=10'
    standby_archive_dest=/dsik1/oradata/manish/arch
    standby_file_management=auto
    log_archive_dest_state_1=enable
    log_archive_dest_state_2=enable
    fal_server=manish
    fal_client=stand


    archive log list (primary)

    archive log list;
    Database log mode Archive Mode
    Automatic archival Enabled
    Archive destination /disk1/oradata/manish/arch
    Oldest online log sequence 198
    Next log sequence to archive 199
    Current log sequence 199


    archive log list(standby)

    archive log list;
    Database log mode Archive Mode
    Automatic archival Enabled
    Archive destination /disk1/oradata/manish/arch
    Oldest online log sequence 178
    Next log sequence to archive 179
    Current log sequence 179

    Please help me to get through this ...
    Thanks

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,015
    You should take a look at the alert file. With what you have given, you have not provided any information that would narrow down the reasons for a log not shipping to, or applying on the standby. My guess is that everything you want to know is in either the alert log of the primary database or the alert log of the standby database.
    this space intentionally left blank

  3. #3
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,478

    Cool

    Hi manish,

    After you follow gandolf's suggestion and you do not find anything, try replacing the service name with the full sqlnet identifier (kinda like this):
    Code:
    *.log_archive_dest_2='service="(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myhost.mydomain.com)
    (PORT=1521))(CONNECT_DATA=(SERVICE_NAME=stand)(SERVER=DEDICATED)))"','. . . rest of parameters . . .
    We had same problem and now it works...there are a few bugs related to redo transport in 11.2.0.1 and 0.2 fixed in 0.3.
    Good luck!
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  4. #4
    Join Date
    Nov 2012
    Posts
    2
    Please look in to alert log file and find the status of archive destinations. If there any error you will get from there.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width