oracle9i无法手动归档,数据库-Oracle9i DG remote archive卡住可能导致主库无法归档而挂起--嘉为科技...

而挂起

罗群

一、问题描述

前段时间，给客户部署了三套DataGuard，一直都非常稳定，但最近客户反应primary database时常出现无响应，重启后一切正常，但不久后仍然处于无响应状态。

环境：windows2003+oracle 9.2.0.8

DataGuard保护模式：最大性能模式，ARCH传输。

primary database告警日志：

Mon Aug 26 00:04:11 2013

ARC2: Begin FAL archive (thread 1 sequence 38840 destination standby)

Creating archive destination LOG_ARCHIVE_DEST_2: 'standby'

ARC2: FAL archive, error 270 creating remote archivelog file 'standby'

Mon Aug 26 00:04:12 2013

Errors in file c:\oracle\admin\prd1\bdump\prd1_arc2_7128.trc:

ORA-00270: error creating archive log

ARC2: FAL archive failed, see trace file.

ARCH: FAL archive failed. Archiver continuing

Mon Aug 26 00:04:12 2013

Errors in file c:\oracle\admin\prd1\bdump\prd1_arc2_7128.trc:

ORA-16055: FAL request rejected

Mon Aug 26 00:04:31 2013

Thread 1 advanced to log sequence 38842

Current log# 2 seq# 38842 mem# 0: D:\DATA\PRD1\REDO02_A.LOG

Mon Aug 26 00:04:31 2013

Current log# 2 seq# 38842 mem# 1: F:\DATA\PRD1\REDO02_B.LOG

Mon Aug 26 00:04:32 2013

ARCH: Evaluating archive log 1 thread 1 sequence 38841

Mon Aug 26 00:04:32 2013

ARCH: Beginning to archive log 1 thread 1 sequence 38841

Mon Aug 26 00:04:32 2013

ARC0: Evaluating archive log 1 thread 1 sequence 38841

ARC0: Unable to archive log 1 thread 1 sequence 38841

Log actively being archived by another process