oracle安装中电脑自动关机,在oracle817中,为什么自动关机了!

在一个带有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

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值