edo02.log
Current log# 2 seq# 50 mem# 1: /u01/app/oracle/prod/disk2/log2b.log
Sun Apr 20 16:39:49 2014
Error 12560 received logging on to the standby
Sun Apr 20 16:39:49 2014
Errors in file /u01/app/oracle/product/10.2.0.1/dbhome_1/rdbms/log/prod_lns1_12597.trc:
ORA-12560: TNS:protocol adapter error
LGWR: Error 12560 creating archivelog file 'prod1'
LNS: Failed to archive log 2 thread 1 sequence 50 (12560)
Sun Apr 20 16:43:38 2014
Thread 1 advanced to log sequence 51
Current log# 3 seq# 51 mem# 0: /u01/app/oracle/prod/disk1/redo03.log
Current log# 3 seq# 51 mem# 1: /u01/app/oracle/prod/disk2/log3b.log
Sun Apr 20 16:44:19 2014
Thread 1 advanced to log sequence 52
Current log# 1 seq# 52 mem# 0: /u01/app/oracle/prod/disk1/redo01.log
Current log# 1 seq# 52 mem# 1: /u01/app/oracle/prod/disk2/log1b.log
Sun Apr 20 16:48:11 2014
ARC0: Standby redo logfile selected for thread 1 sequence 49 for destination LOG_ARCHIVE_DEST_2
Sun Apr 20 16:48:14 2014
ARCH: Possible network disconnect with primary database
备库网络恢复后日志:
[oracle@ocm2 ~]$ tail -f alert_PROD1.log
RFS[12]: Assigned to RFS process 14171
RFS[12]: Identified database type as 'physical standby'
RFS[12]: Archived Log: '/u01/app/oracle/prod/arch/1_48_844894247.arc'
Sun Apr 20 04:48:07 2014
Media Recovery Log /u01/app/oracle/prod/arch/1_48_844894247.arc
Media Recovery Log /u01/app/oracle/prod/arch/1_49_844894247.arc
Media Recovery Waiting for thread 1 sequence 50
Fetching gap sequence in thread 1, gap sequence 50-50
Sun Apr 20 04:48:08 2014
RFS[12]: Archived Log: '/u01/app/oracle/prod/arch/1_50_844894247.arc'
Sun Apr 20 04:48:38 2014
Media Recovery Log /u01/app/oracle/prod/arch/1_50_844894247.arc
Media Recovery Waiting for thread 1 sequence 51
Fetching gap sequence in thread 1, gap sequence 51-51
Sun Apr 20 04:48:38 2014
RFS[12]: Archived Log: '/u01/app/oracle/prod/arch/1_51_844894247.arc'
Sun Apr 20 04:49:08 2014
Media Recovery Log /u01/app/oracle/prod/arch/1_51_844894247.arc
Media Recovery Waiting for thread 1 sequence 52
|