在一个带有standby的oracle817机器中, 主要是Thread 1 cannot allocate new log 为什么出现这种情况, standby参数是log_archive_dest_3='service=ORADBSTANDBY1.aa.COM reopen=60' 如果我的standby服务器不可用很久,会出现这种情况吗? 还是说我的online logfile 是1MB太小,而产生这种错误呢! 警告文件内容如下:
Thread 1 advanced to log sequence 1694
Current log# 2 seq# 1694 mem# 0: C:\ORACLE\ORADATA\ORADB\REDO02.LOG
Current log# 2 seq# 1694 mem# 1: D:\ORACLE\ORADATA\REDO02A.LOG
Sun Feb 12 00:21:53 2006
ARC1: Beginning to archive log# 3 seq# 1692
ARC1: Failed to archive log# 3 seq# 1692
ARC1: Beginning to archive log# 1 seq# 1693
Sun Feb 12 00:21:53 2006
Thread 1 cannot allocate new log, sequence 1695
All online logs needed archiving
Sun Feb 12 00:21:53 2006
Current log# 2 seq# 1694 mem# 0: C:\ORACLE\ORADATA\ORADB\REDO02.LOG
Current log# 2 seq# 1694 mem# 1: D:\ORACLE\ORADATA\REDO02A.LOG
Sun Feb 12 00:21:53 2006
ARC1: Error 12505 connecting to standby host 'ORADBSTANDBY1.aa.com'
ARC1: Error 12505 creating archivelog file 'ORADBSTANDBY1.aa.com'
Sun Feb 12 00:21:54 2006
ARC2: Beginning to archive log# 3 seq# 1692
Sun Feb 12 00:21:54 2006
ARC2: Failed to archive log# 3 seq# 1692
ARC2: Beginning to archive log# 1 seq# 1693
ARC2: Failed to archive log# 1 seq# 1693
Sun Feb 12 00:21:54 2006
ARC1: Completed archiving log# 1 seq# 1693
ARC1: Beginning to archive log# 3 seq# 1692
Sun Feb 12 00:21:54 2006
ARC2: Beginning to archive log# 3 seq# 1692
Sun Feb 12 00:21:54 2006
ARC2: Failed to archive log# 3 seq# 1692
Sun Feb 12 00:21:55 2006
ARC1: Failed to archive log# 3 seq# 1692
Sun Feb 12 00:21:55 2006
ARC1: Beginning to archive log# 3 seq# 1692
ARC1: Failed to archive log# 3 seq# 1692
Sun Feb 12 00:21:56 2006
ARC0: Error 12505 connecting to standby host 'ORADBSTANDBY1.aa.COM'
ARC0: Error 12505 creating archivelog file 'ORADBSTANDBY1.aa.COM'
ARC0: Completed archiving log# 3 seq# 1692
Sun Feb 12 00:21:57 2006
Thread 1 advanced to log sequence 1695
Current log# 3 seq# 1695 mem# 0: C:\ORACLE\ORADATA\ORADB\REDO01.LOG
Current log# 3 seq# 1695 mem# 1: D:\ORACLE\ORADATA\REDO03A.LOG
Sun Feb 12 00:21:57 2006
ARC0: Beginning to archive log# 2 seq# 1694
ARC0: Completed archiving log# 2 seq# 1694
Sun Feb 12 00:21:57 2006
Thread 1 advanced to log sequence 1696
Current log# 1 seq# 1696 mem# 0: C:\ORACLE\ORADATA\ORADB\REDO03.LOG
Current log# 1 seq# 1696 mem# 1: D:\ORACLE\ORADATA\REDO01A.LOG
Sun Feb 12 00:21:57 2006
ARC2: Beginning to archive log# 3 seq# 1695
ARC2: Completed archiving log# 3 seq# 1695
Sun Feb 12 11:39:08 2006
Thread 1 advanced to log sequence 1697
Current log# 2 seq# 1697 mem# 0: C:\ORACLE\ORADATA\ORADB\REDO02.LOG
Sun Feb 12 11:39:08 2006
ARC1: Beginning to archive log# 1 seq# 1696
Sun Feb 12 11:39:08 2006
ARC1: Error 12505 connecting to standby host 'ORADBSTANDBY1.aa.com'
ARC1: Error 12505 creating archivelog file 'ORADBSTANDBY1.aa.COM'
ARC1: Completed archiving log# 1 seq# 1696
Sun Feb 12 11:39:09 2006
Current log# 2 seq# 1697 mem# 1: D:\ORACLE\ORADATA\REDO02A.LOG
Dump file C:\oracle\admin\oradb\bdump\oradbALRT.LOG
Mon Feb 13 09:15:12 2006
ORACLE V8.1.7.4.1 - Production vsnsta=0
vsnsql=f vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.7.4.1.
System parameters with non-default values:
processes = 150
shared_pool_size = 209715200
large_pool_size = 614400
java_pool_size = 20971520