9i Dataguard
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: 9i Dataguard

Hybrid View

  1. #1
    Join Date
    Nov 2000
    Location
    London
    Posts
    94

    9i Dataguard

    Prod->DR

    Prod: can tnsping PROD/DR
    DR: can tnsping PROD/DR

    Prod:

    log_archive_dest_2 SERVICE=DR LGWR NOAFFIRM delay=0 optional max_failure=0 reopen=300 async=20480 register

    fal_client string PROD
    fal_server string DR



    DR:

    SQL> show parameter fal
    fal_client string DR
    fal_server string PROD



    My archivelogs are not getting transferred to the DR side every time I switch a log. I have to keep copying the archivelogs onto the DR system then register them.

    I have 3 redo logs groups on both sides and 4 standby redo log groups.

    I might be getting confused here but don't the standby redo logs get written to by the Production redo logs?

    I've tried populating data on Production to see what happens.
    Production alert log:

    RC1: Evaluating archive log 3 thread 1 sequence 2267
    ARC1: Archive destination LOG_ARCHIVE_DEST_2: Previously completed
    ARC1: Beginning to archive log 3 thread 1 sequence 2267
    Creating archive destination LOG_ARCHIVE_DEST_1: '/u4/oradata/PROD/dgarc/1_2267.arc'
    ARC1: Completed archiving log 3 thread 1 sequence 2267
    Tue Feb 2 15:48:34 2010
    Timing out on NetServer 0 prod=2607,cons=13,threshold=2560
    ORA-16166: LGWR timed out on Network Server 0 due to buffer full condition.
    No action is required since the log file transfer will be attempted via ARCH
    Tue Feb 2 15:48:34 2010
    Errors in file /u1/app/oracle/product/9.2.0.8/admin/PROD/bdump/coopprod_lgwr_14038.trc:
    ORA-16166: LGWR network server failed to send remote message
    LGWR: I/O error 16166 archiving log 1 to 'DR'
    Tue Feb 2 15:48:34 2010
    Errors in file /u1/app/oracle/product/9.2.0.8/admin/PROD/bdump/coopprod_lgwr_14038.trc:
    ORA-16166: LGWR network server failed to send remote message


    Any help would be great

  2. #2
    Join Date
    May 2009
    Posts
    32
    Hey did you check with other parameters too like DG_CONFIG, log_archive_dest_state... and what is the authentication mechanism from PROD to send the redo to DR you can use orapwd as one option and standby log files are on standby site for filling of redo data transported by the LGWR they are different from the online redo log files.

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

    Cool SQL*Net buffers?

    Check and maybe increase the size of the SQL*Net buffers SEND_BUF_SIZE and RECV_BUF_SIZE (default is OS dependant).
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  4. #4
    Join Date
    Nov 2000
    Location
    London
    Posts
    94
    hmm...

    I've also tried creating the standby through 10g Grid control and it goes absolutley bonkers..(probably as its a 9i DB)

    does anyone have a detailed step by step install/config guide for 9i dataguard?

  5. #5
    Join Date
    Nov 2000
    Location
    London
    Posts
    94
    ok tried another test from Prod->DR

    tiny database..

    I can tnsping LIVE_DR, LIVE_PROD service names from both servers. Listeners up on both servers.


    log_archive_dest_2 on primary (service=live_dr optional reopen=60 lgwr async noaffirm)



    Switch logs on the primary(which is taking ages -> 2-3 mins) and ...


    hu Feb 4 11:30:49 2010
    LGWR: Completed archiving log 1 thread 1 sequence 14
    LGWR received timedout error from KSR
    No action necessary. ARCH will attempt to transmit log file
    LGWR: Error 2 closing archivelog file 'live_dr'
    Thu Feb 4 11:33:49 2010
    Errors in file /u1/app/oracle/product/9.2.0.8/admin/LIVE/bdump/live_lgwr_9764.trc:
    ORA-00002: Message 2 not found; product=RDBMS; facility=ORA
    LGWR: Error 2 disconnecting from destination LOG_ARCHIVE_DEST_2 standby host 'live_dr'
    Thread 1 advanced to log sequence 15
    Current log# 2 seq# 15 mem# 0: /u4/oradata/LIVE/redo02.log
    Thu Feb 4 11:33:53 2010
    ARC1: Evaluating archive log 1 thread 1 sequence 14
    ARC1: Beginning to archive log 1 thread 1 sequence 14
    Creating archive destination LOG_ARCHIVE_DEST_1: '/u4/oradata/LIVE/arch/1_14.dbf'
    ARC1: Completed archiving log 1 thread 1 sequence 14



    live_lgwr_9764.trc:

    *** SESSION ID:(4.1) 2010-02-04 11:29:22.051
    *** 2010-02-04 11:29:22.051 43650 kcrr.c
    Initializing NetServer for dest=live_dr
    Initializing PGA storage for Netserver communication
    Allocating a brand new NetServer
    Allocated NetServer 0
    Starting NetServer
    NetServer 0 has been started.Subscribing to KSR Channel 0
    success!
    Indicating recv buffer for KSR Channel 0
    success
    Waiting for Netserver 0 to initialize itself
    *** 2010-02-04 11:29:25.106 43976 kcrr.c
    Netserver 0 has been initialized
    LGWR performing a channel reset to ignore previous responses
    LGWR connecting as publisher to KSR Channel 0
    LGWR-NS 0 initialized for destination=live_dr
    *** 2010-02-04 11:29:25.106 44421 kcrr.c
    Making upiahm request to NetServer 0
    Waiting for NetServer to respond to upiahm
    *** 2010-02-04 11:29:28.537 44607 kcrr.c
    upiahm connect done status is 0
    Receiving message from NetServer 0
    Destination LOG_ARCHIVE_DEST_2 is in CLUSTER CONSISTENT mode
    Destination LOG_ARCHIVE_DEST_2 is in MAXIMUM PERFORMANCE mode
    Receiving message from NetServer 0
    *** 2010-02-04 11:29:28.579 45903 kcrr.c
    Making upinbls request to NetServer 0
    NetServer pid:9786
    *** 2010-02-04 11:30:49.340 45733 kcrr.c
    Making upinblc request to NetServer 0
    NetServer pid:9786
    *** 2010-02-04 11:30:59.333
    LGWR found NetServer 0 alive.. waiting for msg
    LGWR found NetServer 0 alive.. waiting for msg
    LGWR found NetServer 0 alive.. waiting for msg
    LGWR found NetServer 0 alive.. waiting for msg
    LGWR found NetServer 0 alive.. waiting for msg
    LGWR found NetServer 0 alive.. waiting for msg
    LGWR found NetServer 0 alive.. waiting for msg
    *** 2010-02-04 11:32:09.287
    LGWR found NetServer 0 alive.. waiting for msg
    *** 2010-02-04 11:32:19.298
    LGWR found NetServer 0 alive.. waiting for msg
    *** 2010-02-04 11:32:29.299
    LGWR found NetServer 0 alive.. waiting for msg
    LGWR found NetServer 0 alive.. waiting for msg
    LGWR found NetServer 0 alive.. waiting for msg
    LGWR found NetServer 0 alive.. waiting for msg
    *** 2010-02-04 11:33:29.242
    LGWR found NetServer 0 alive.. waiting for msg
    LGWR found NetServer 0 alive.. waiting for msg
    Current time 710076829 exceeds start time 710076649 plus 180 seconds: return timedout error
    LGWR received timedout error from KSR
    No action necessary. ARCH will attempt to transmit log file
    ERROR:kcrrnupinblc 2 on received message 4
    LGWR produced a total of 25 RFSWRITE messages
    ERROR:kcrrnsupirfs.1 LGWR had received a timeout previously. return timeout again
    Error 2 closing standby archive log file at host 'live_dr'
    Archive destination LOG_ARCHIVE_DEST_2 made inactive: File close error
    *** 2010-02-04 11:33:49.003 51426 kcrr.c
    LGWR: Error 2 closing archivelog file 'live_dr'
    *** 2010-02-04 11:33:49.003
    kcrrfail: dest:2 err:2 force:0
    ORA-00002: Message 2 not found; product=RDBMS; facility=ORA
    LGWR produced a total of 25 RFSWRITE messages
    ERROR:kcrrnsupirfs.1 LGWR had received a timeout previously. return timeout again
    Error 2 detaching RFS from standby instance at host 'live_dr'
    *** 2010-02-04 11:33:49.018 45506 kcrr.c
    Making upidhs request to NetServer 0 (hst 0x103edbe58)
    NetServer pid:9786
    *** 2010-02-04 11:33:53.018 45650 kcrr.c
    Cleaninup up LNS0 [pid 9786] after network detach
    *** 2010-02-04 11:33:53.018 43513 kcrr.c
    LNS0 [pid 9786] receiving termination signal..
    .... killed succesfully
    ERROR:kcrrnsupidhs LGWR had received a timeout previously. return timeout again
    *** 2010-02-04 11:33:53.019 51426 kcrr.c
    LGWR: Error 2 disconnecting from destination LOG_ARCHIVE_DEST_2 standby host 'live_dr'
    Ignoring kcrrlcmp() detach error 2
    *** 2010-02-04 11:33:53.019
    kcrrfail: dest:2 err:2 force:0

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