3 Replies Latest reply: Apr 1, 2014 10:11 AM by mseberg RSS

    Error 16401 creating standby archive log file at host

    GeetaM

      Hi Gurus

       

      I am receiving below standby error, i have checked the primary init. ora parameters and trace file .

      Please help me in figuring out why we are receiving below alert. I have attached init. ora parameter and trace file.

       

      SQL> select destination, binding, archiver from v$archive_dest where status <>'I

       

      DESTINATION

      BINDING                                            ARCHIVER                   

      --------- ----------

      USE_DB_RECOVERY_FILE_DEST OPTIONAL  ARCH

      SBWODB_DR               OPTIONAL  ARCH         

       

      Error 16401 creating standby archive log file at host '****'

      ORA-16401: archivelog rejected by RFS

      *** 2013-09-28 08:09:56.190

      ABC: tkrsf_al_read: No mirror copies to re-read data

       

      Trace file

      {code}

      /export/home/oracle/admin/****/bdump/****1_arc2_23904.trc

      Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

      With the Partitioning, Real Application Clusters, OLAP, Data Mining

      and Real Application Testing options

      ORACLE_HOME = /export/home/oracle/product/10.2.0/db

      System name: SunOS

      Node name: ****

      Release: 5.10

      Version: Generic_127111-11

      Machine: sun4v

      Instance name: ****1

      Redo thread mounted by this instance: 1

      Oracle process number: 52

      Unix process pid: 23904, image: oracle@**** (ARC2)

       

       

      *** 2013-09-19 04:22:28.450

      *** SERVICE NAME:(SYS$BACKGROUND) 2013-09-19 04:22:28.449

      *** SESSION ID:(6550.3) 2013-09-19 04:22:28.449

      Redo shipping client performing standby login

      *** 2013-09-19 04:22:28.590 66535 kcrr.c

      Logged on to standby successfully

      Client logon and security negotiation successful!

      *** 2013-09-27 04:07:03.829

      Error 16401 creating standby archive log file at host '****_DR'

      ORA-16401: archivelog rejected by RFS

      *** 2013-09-28 08:09:56.190

      ABC: tkrsf_al_read: No mirror copies to re-read data

      *** 2013-10-05 04:20:51.000

      ABC: tkrsf_al_read: No mirror copies to re-read data

      *** 2013-10-05 19:55:57.842

      ABC: tkrsf_al_read: No mirror copies to re-read data

      *** 2013-10-07 19:26:26.368

      ABC: tkrsf_al_read: No mirror copies to re-read data

      *** 2013-10-22 03:23:53.440

      ABC: tkrsf_al_read: No mirror copies to re-read data

      *** 2013-10-25 01:03:22.791

      ABC: tkrsf_al_read: No mirror copies to re-read data

      *** 2013-11-03 04:50:00.607

      ABC: tkrsf_al_read: No mirror copies to re-read data

      *** 2013-11-06 17:48:31.368

      ABC: tkrsf_al_read: No mirror copies to re-read data

      *** 2013-11-29 01:56:25.427

      ABC: tkrsf_al_read: No mirror copies to re-read data

      *** 2013-12-06 05:01:53.520

      Error 16040 creating standby archive log file at host '****_DR'

      ORA-16040: standby destination archive log file is locked

      *** 2013-12-07 04:07:40.498

      ABC: tkrsf_al_read: No mirror copies to re-read data

      *** 2013-12-20 23:20:39.099

      ABC: tkrsf_al_read: No mirror copies to re-read data

      *** 2013-12-31 00:59:55.290

      ABC: tkrsf_al_read: No mirror copies to re-read data

      *** 2014-01-07 04:53:49.362

      ORA-19815: WARNING: db_recovery_file_dest_size of 644245094400 bytes is 85.07% used, and has 96182730752 remaining bytes available.

      *** 2014-01-07 04:53:49.362

      ************************************************************************

      You have following choices to free up space from flash recovery area:

      1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,

         then consider changing RMAN ARCHIVELOG DELETION POLICY.

      2. Back up files to tertiary device such as tape using RMAN

         BACKUP RECOVERY AREA command.

      3. Add disk space and increase db_recovery_file_dest_size parameter to

         reflect the new space.

      4. Delete unnecessary files using RMAN DELETE command. If an operating

         system command was used to delete files, then use RMAN CROSSCHECK and

         DELETE EXPIRED commands.

      ************************************************************************

      *** 2014-01-13 03:40:26.103

      ABC: tkrsf_al_read: No mirror copies to re-read data

      *** 2014-01-16 04:51:49.687

      ABC: tkrsf_al_read: No mirror copies to re-read data

      *** 2014-01-24 01:55:44.145

      Error 16401 creating standby archive log file at host '****_DR'

      ORA-16401: archivelog rejected by RFS

      *** 2014-01-26 05:02:21.240

      ABC: tkrsf_al_read: No mirror copies to re-read data

      *** 2014-01-27 22:10:17.290

      ABC: tkrsf_al_read: No mirror copies to re-read data

      *** 2014-01-28 05:23:47.811

      ABC: tkrsf_al_read: No mirror copies to re-read data

      *** 2014-02-04 04:16:12.408

      Error 16040 creating standby archive log file at host '****_DR'

      ORA-16040: standby destination archive log file is locked

      *** 2014-02-08 04:50:16.693

      ORA-19815: WARNING: db_recovery_file_dest_size of 644245094400 bytes is 85.04% used, and has 96383008768 remaining bytes available.

      *** 2014-02-08 04:50:16.693

      ************************************************************************

      You have following choices to free up space from flash recovery area:

      1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,

         then consider changing RMAN ARCHIVELOG DELETION POLICY.

      2. Back up files to tertiary device such as tape using RMAN

         BACKUP RECOVERY AREA command.

      3. Add disk space and increase db_recovery_file_dest_size parameter to

         reflect the new space.

      4. Delete unnecessary files using RMAN DELETE command. If an operating

         system command was used to delete files, then use RMAN CROSSCHECK and

         DELETE EXPIRED commands.

      ************************************************************************

      *** 2014-02-11 04:59:34.477

      ABC: tkrsf_al_read: No mirror copies to re-read data

      *** 2014-02-13 01:52:18.296

      Error 16040 creating standby archive log file at host '****_DR'

      ORA-16040: standby destination archive log file is locked

      *** 2014-02-17 02:48:43.993

      ABC: tkrsf_al_read: No mirror copies to re-read data

      *** 2014-02-17 18:48:48.458

      ABC: tkrsf_al_read: No mirror copies to re-read data

      *** 2014-02-18 13:31:55.033

      ABC: tkrsf_al_read: No mirror copies to re-read data

      *** 2014-02-18 19:13:37.587

      ABC: tkrsf_al_read: No mirror copies to re-read data

      *** 2014-03-01 23:51:34.685

      Error 16040 creating standby archive log file at host '****_DR'

      ORA-16040: standby destination archive log file is locked

      *** 2014-03-07 05:00:27.714

      ABC: tkrsf_al_read: No mirror copies to re-read data

      *** 2014-03-08 00:47:52.859

      ABC: tkrsf_al_read: No mirror copies to re-read data

      *** 2014-03-15 05:24:34.055

      ABC: tkrsf_al_read: No mirror copies to re-read data

      *** 2014-03-19 21:20:32.735

      ABC: tkrsf_al_read: No mirror copies to re-read data

      *** 2014-03-26 02:29:08.466

      ABC: tkrsf_al_read: No mirror copies to re-read data

      *** 2014-04-01 04:45:50.821

      ORA-19815: WARNING: db_recovery_file_dest_size of 644245094400 bytes is 85.02% used, and has 96507789312 remaining bytes available.

      *** 2014-04-01 04:45:50.821

      ************************************************************************

      You have following choices to free up space from flash recovery area:

      1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,

         then consider changing RMAN ARCHIVELOG DELETION POLICY.

      2. Back up files to tertiary device such as tape using RMAN

         BACKUP RECOVERY AREA command.

      3. Add disk space and increase db_recovery_file_dest_size parameter to

         reflect the new space.

      4. Delete unnecessary files using RMAN DELETE command. If an operating

         system command was used to delete files, then use RMAN CROSSCHECK and

         DELETE EXPIRED commands.

      ************************************************************************

      {/code}

       

      Primary Init prarameter file -

      {code}

      ****.__db_cache_size=4143972352

      ****2.__db_cache_size=3976200192

      ****3.__db_cache_size=4177526784

      ****.__java_pool_size=33554432

      ****3.__java_pool_size=16777216

      ****2.__java_pool_size=16777216

      ****.__large_pool_size=16777216

      ****3.__large_pool_size=50331648

      ****2.__large_pool_size=33554432

      ****.__shared_pool_size=1140850688

      ****2.__shared_pool_size=1325400064

      ****3.__shared_pool_size=1107296256

      ****.__streams_pool_size=16777216

      ****3.__streams_pool_size=0

      ****2.__streams_pool_size=0

      *.audit_file_dest='/export/home/oracle/admin/****/adump'

      *.background_dump_dest='/export/home/oracle/admin/****/bdump'

      *.cluster_database_instances=3

      *.cluster_database=true

      ****.cluster_interconnects='172.18.2.46'

      ****2.cluster_interconnects='172.18.2.47'

      ****3.cluster_interconnects='172.18.2.48'

      *.compatible='10.2.0.3.0'

      *.control_file_record_keep_time=30

      *.control_files='+SB_DATA_DG/****/controlfile/control01.ctl','+BACKUP_DG/****/controlfile/control02.ctl'

      *.core_dump_dest='/export/home/oracle/admin/****/cdump'

      *.db_block_size=8192

      *.db_create_file_dest='+SB_DATA_DG'

      *.db_create_online_log_dest_1='+SB_DATA_DG'

      *.db_create_online_log_dest_2='+BACKUP_DG'

      *.db_domain=''

      *.db_file_multiblock_read_count=16

      *.db_name='****'

      *.db_recovery_file_dest_size=644245094400

      *.db_recovery_file_dest='+BACKUP_DG'

      *.dispatchers=''

      *.fal_client=''

      *.fal_server='****_DR'

      ****3.instance_number=3

      ****2.instance_number=2

      ****.instance_number=1

      *.job_queue_processes=10

      *.log_archive_config='dg_config=(****,****_DR)'

      *.log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST'

      *.log_archive_dest_2='service=****_DR ARCH optional reopen=30 valid_for=(online_logfiles,primary_role) db_unique_name=****_DR'

      *.log_archive_dest_state_2='ENABLE'

      *.log_archive_format='%t_%s_%r.arc'

      *.log_archive_max_processes=6

      *.open_cursors=1000

      *.pga_aggregate_target=4294967296

      *.processes=6000

      *.remote_listener=''

      *.remote_login_passwordfile='exclusive'

      *.service_names='****,SBVOIPDB, SBHSDDB, DATA1,DATA2,CENTRAL'

      *.sessions=3305

      *.sga_target=5368709120

      *.standby_file_management='manual'

      ****2.thread=2

      ****3.thread=3

      ****.thread=1

      *.undo_management='AUTO'

      *.undo_retention=3600

      ****3.undo_tablespace='UNDOTBS3'

      ****2.undo_tablespace='UNDOTBS2'

      ****.undo_tablespace='UNDOTBS1'

      *.user_dump_dest='/export/home/oracle/admin/****/udump'

      {/code}