7 Replies Latest reply on Feb 1, 2010 6:25 PM by Uwehesse-Oracle

    Archive transfer to Standby

    user10394804
      Hi ,

      I have configured standby database ,to transfer archive log file using archiver.

      My archive generation rate is too high ,but still manages to transfer 500 MB archive file in 12 minutes.

      But some archive log files are taking unusal time (4-5 hours)

      During that period I am getting following error messages in alert log fiel on primary

      Errors in file /prd/10.2.0/admin/PROD_auho/bdump/prod_arc0_10973372.trc:
      ORA-03135: connection lost contact
      Wed Jan 27 14:55:10 2010
      FAL[server, ARC0]: FAL archive failed, see trace file.
      Wed Jan 27 14:55:10 2010
      Errors in file /prd/10.2.0/admin/PROD_auho/bdump/prod_arc0_10973372.trc:
      ORA-16055: FAL request rejected
      ARCH: FAL archive failed. Archiver continuing
      Wed Jan 27 14:55:10 2010
      ORACLE Instance PROD - Archival Error. Archiver continuing.
      Wed Jan 27 15:02:44 2010

      and in trace file follwoing error


      *** 2010-01-23 05:51:40.417
      *** SERVICE NAME:(SYS$BACKGROUND) 2010-01-23 05:51:40.416
      *** SESSION ID:(9985.1) 2010-01-23 05:51:40.416
      Redo shipping client performing standby login
      *** 2010-01-23 05:51:40.501 66535 kcrr.c
      Logged on to standby successfully
      Client logon and security negotiation successful!
      ABC: tkrsf_al_read: No mirror copies to re-read data
      *** 2010-01-23 06:08:14.129
      Error 19502 writing standby archive log file at host 'PROD_SITRA'
      *** 2010-01-23 06:08:14.134 62692 kcrr.c
      ARC0: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (19502)
      *** 2010-01-23 06:08:14.134 62692 kcrr.c
      ARC0: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
      ORA-19502: write error on file "", blockno (blocksize=)
      *** 2010-01-23 06:08:14.134 60970 kcrr.c
      kcrrfail: dest:2 err:19502 force:0 blast:1
      Error 19510 detaching RFS from standby instance at host 'PROD_SITRA'
      kcrrwkx: unknown error:19502
      ORA-16055: FAL request rejected
      ARCH: Connecting to console port...
      ARCH: Connecting to console port...
      *** 2010-01-23 06:14:58.743
      Redo shipping client performing standby login
      *** 2010-01-23 06:14:58.846 66535 kcrr.c
      Logged on to standby successfully
      Client logon and security negotiation successful!
      ABC: tkrsf_al_read: No mirror copies to re-read data


      and another thing I noticed was that for one seq# number 2 archive process are running
      one for writing and another for closing.

      Can some one help me to find out the reason

      Database : 10.2.0.4
      Os :AIX

      Thanks