ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Archiving With Multiple Destinations Fails With ORA-16040

Archiving With Multiple Destinations Fails With ORA-16040

原创 Linux操作系统 作者:thompsun 时间:2011-01-21 09:00:09 0 删除 编辑
  • fact: Oracle Server - Enterprise Edition 9.0
  • fact: Oracle Server - Enterprise Edition 8.1
  • symptom: Archiving fails
  • symptom: ORA-16040: standby destination archivelog file is locked
  • symptom: Multiple archive destinations
  • cause: The archiving is done by two or more LOG_ARCHIVE_DEST_X to the same
    standby database.



  • fix:

    Check in the view V$ARCHIVE_DEST for conflicting destinations :
     
      SQL> select destination, binding, archiver
           from v$archive_dest
           where status <>'INACTIVE';

    A confliction destination is for instance :
       Destination 1 : standby archived by LGWR
       Destination 2 : standby archived by ARCH

    The archive is archived to the standby database by the LGWR and ARCH process
    which is causing the conflict. Only one process can archive to the same standby
    destination.

    Stop the least important destination. (in the example destination 2) with

      SQL> alter system set log_archive_dest_state_2=defer;


    显示相关信息 相关的


    产品
    • Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Enterprise Edition
    • Oracle Database Products > Oracle Database > Oracle Database > Oracle Database Configuration Assistant
    • Enterprise Management > Enterprise Manager Consoles, Packs, and Plugins > Managing Databases using Enterprise Manager > Enterprise Manager for RDBMS

    来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11134237/viewspace-684409/,如需转载,请注明出处,否则将追究法律责任。

    请登录后发表评论 登录
    全部评论

    注册时间:2009-01-11

    • 博文量
      96
    • 访问量
      251494