DATAGUARD中MAXIMUM AVAILABILITY+LGWR SYNC导致主库不能启动 – 提供专业Oracle数据恢复、性能优化、迁移升级、故障诊断等服务@Phone:[phone]

Fri Aug 10 12:37:56 2012

ALTER DATABASE OPEN

Fri Aug 10 12:37:56 2012

LGWR: Primary database is in CLUSTER CONSISTENT mode

LGWR: Primary database is in MAXIMUM AVAILABILITY mode

LGWR: Destination LOG_ARCHIVE_DEST_1 is not serviced by LGWR

LNS0 started with pid=16

Fri Aug 10 12:37:59 2012

ORA-1013 signalled during: ALTER DATABASE OPEN...

Fri Aug 10 12:41:45 2012

LGWR: Error 12535 verifying archivelog destination LOG_ARCHIVE_DEST_2

LGWR: Continuing...

Fri Aug 10 12:41:45 2012

Errors in file /export/home/oracle/admin/abcd/bdump/abcd_lgwr_11504.trc:

ORA-12535: TNS:operation timed out

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

LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2

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

Creating archive destination LOG_ARCHIVE_DEST_2: 'ora9i'

LGWR: Error 12535 creating archivelog file 'ora9i'

Fri Aug 10 12:45:32 2012

Errors in file /export/home/oracle/admin/abcd/bdump/abcd_lgwr_11504.trc:

ORA-12535: TNS:operation timed out

LGWR: Completed archiving  log 1 thread 1 sequence 6808

Thread 1 advanced to log sequence 6808

Fri Aug 10 12:45:32 2012

Errors in file /export/home/oracle/admin/abcd/bdump/abcd_lgwr_11504.trc:

ORA-01157: cannot identify/lock data file 1 - see DBWR trace file

ORA-01110: data file 1: '/export/home/oracle/oradata/abcd/system01.dbf'

LGWR: terminating instance due to error 1157

Instance terminated by LGWR, pid = 11504