10g DATAGUARD主库提示以下错误.

Leo

10.2.0.4 单机数据库 作的physical standby  and logical standby.

主库是最大可用模式;
SQL> select protection_mode,protection_level from v$database;

PROTECTION_MODE      PROTECTION_LEVEL
-------------------- --------------------
MAXIMUM AVAILABILITY MAXIMUM AVAILABILITY

SQL> select status,schedule,archiver,log_sequence,error from v$archive_dest;

STATUS    SCHEDULE ARCHIVER   LOG_SEQUENCE   ERROR
--------- -------- ---------- ------------ -----------------------------------------------------------------
VALID       ACTIVE   ARCH               25291
VALID       ACTIVE   LGWR              25292
ERROR     ACTIVE   LGWR              25290                  ORA-16163: LGWR network server host attach error

主库alert.log 出现以下错误
Errors in file /home/oracle/admin/oradbbj01/bdump/oradbbj01_lgwr_15875.trc:
ORA-16163: LGWR network server host attach error
Wed Apr 10 20:43:12 2013
LGWR: Standby redo logfile selected to archive thread 1 sequence 25291
LGWR: Standby redo logfile selected for thread 1 sequence 25291 for destination LOG_ARCHIVE_DEST_2
Wed Apr 10 20:43:12 2013
Thread 1 advanced to log sequence 25291 (LGWR switch)
  Current log# 2 seq# 25291 mem# 0: /oradata02/redo_group2/redo02.log
Wed Apr 10 20:43:12 2013
ARC4: Standby redo logfile selected for thread 1 sequence 25290 for destination LOG_ARCHIVE_DEST_3
Wed Apr 10 20:43:16 2013
LGWR: Failed to archive log 2 thread 1 sequence 25291 (16163)
LGWR: Standby redo logfile selected to archive thread 1 sequence 25292
LGWR: Standby redo logfile selected for thread 1 sequence 25292 for destination LOG_ARCHIVE_DEST_2
Wed Apr 10 20:43:16 2013
Thread 1 advanced to log sequence 25292 (LGWR switch)
  Current log# 4 seq# 25292 mem# 0: /oradata02/redo_group2/redo04.log

备库是最大性能模式
SQL> select protection_mode,protection_level from v$database;

PROTECTION_MODE      PROTECTION_LEVEL
-------------------- --------------------
MAXIMUM PERFORMANCE  MAXIMUM PERFORMANCE

physical stanby 日志

-- Connected User is Valid
RFS[68]: Assigned to RFS process 7454
RFS[68]: Identified database type as 'physical standby'
Wed Apr 10 20:44:23 2013
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[69]: Assigned to RFS process 7456
RFS[69]: Identified database type as 'physical standby'
RFS[69]: Archived Log: '/TBSBackup/log_archive/dest_1/1_25291_770897759.dbf'
Wed Apr 10 20:44:25 2013
Media Recovery Log /TBSBackup/log_archive/dest_1/1_25291_770897759.dbf
Media Recovery Waiting for thread 1 sequence 25292

Leo

mos 上查了ORA-16163: LGWR network server host attach error这个错误
在10.2.0.3的时候已经修复了该bug,上面提到修改 net_timeout=180 ,主库数据库是10.2.0.4 ,compatible 是10.2.0.1 ; 会是这个原因导致的吗?
主备归档日志好像都没有问题.就是主库试图和alert.log日志有错误信息~~~

Leo

主库的归档日志最大sequence为:
SQL> select max(sequence#) from v$archived_log;

MAX(SEQUENCE#)
--------------
         25293

备库归档最大sequence 为:
SQL> select max(sequence#) from v$archived_log;

MAX(SEQUENCE#)
--------------
         25293