0 积分	1 好友	7 主题

发消息

[Exadata硬件] HP 11.31 IA 64bit Oracle 10.2.0.5 RAC 节点2 奇怪的报错：ORA-19504、...

1^#

发表于 2014-12-17 17:20:00 | 查看: 4538| 回复: 6

HP 11.31 IA 64bit  Oracle 10.2.0.5 RAC 节点2 报错：ORA-19504、ORA-27086
节点1、节点的归档目录分别是/backup1、/backup2，并且各自节点通过NFS挂载另外节点的规定目录
ORA-19504、ORA-27086报错时间范围为：
Tue Dec 16 20:00:05 EAT 2014
至
Tue Dec 16 22:20:17 EAT 2014
数据库节点2报错期间，节点1通过NBU进行全库备份，且在节点2上，oracle用户可以对归档目录/backup2写入文件，节点2alert部分日志如下：

......
Tue Dec 16 20:00:05 EAT 2014
Thread 2 advanced to log sequence 85870 (LGWR switch)
  Current log# 6 seq# 85870 mem# 0: /dev/dcodsvg/rredo2_2a_512m
  Current log# 6 seq# 85870 mem# 1: /dev/dcodsvg/rredo2_2b_512m
Tue Dec 16 20:00:05 EAT 2014
Errors in file /oracle/product/10.2.0/admin/dcods/bdump/dcods2_arc1_7424.trc:
ORA-19504: failed to create file "/backup2/2_85869_823635785.dbf"
ORA-27086: unable to lock file - already in use
HPUX-ia64 Error: 13: Permission denied
Additional information: 8
Additional information: 14818
Tue Dec 16 20:00:05 EAT 2014
ARC1: Error 19504 Creating archive log file to '/backup2/2_85869_823635785.dbf'
ARCH: Archival stopped, error occurred. Will continue retrying
Tue Dec 16 20:00:05 EAT 2014
ORACLE Instance dcods2 - Archival Error
Tue Dec 16 20:00:05 EAT 2014
ORA-16038: log 5 sequence# 85869 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 5 thread 2: '/dev/dcodsvg/rredo2_1a_512m'
ORA-00312: online log 5 thread 2: '/dev/dcodsvg/rredo2_1b_512m'
Tue Dec 16 20:00:05 EAT 2014
Errors in file /oracle/product/10.2.0/admin/dcods/bdump/dcods2_arc1_7424.trc:
ORA-16038: log 5 sequence# 85869 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 5 thread 2: '/dev/dcodsvg/rredo2_1a_512m'
ORA-00312: online log 5 thread 2: '/dev/dcodsvg/rredo2_1b_512m'
Tue Dec 16 20:00:44 EAT 2014
Errors in file /oracle/product/10.2.0/admin/dcods/bdump/dcods2_arc0_7418.trc:
ORA-19504: failed to create file "/backup2/2_85869_823635785.dbf"
ORA-27086: unable to lock file - already in use
HPUX-ia64 Error: 13: Permission denied
.......

分享0

收藏0 回复只看该作者道具举报

rongshiyuan

2^#

发表于 2014-12-17 17:21:13

HP 11.31 IA 64bit Oracle 10.2.0.5 RAC 节点2 奇怪的报错：ORA-19504 两个节点数据库awr和alert日志。。。

回复只看该作者道具举报

rongshiyuan

3^#

发表于 2014-12-17 17:21:47

HP 11.31 IA 64bit Oracle 10.2.0.5 RAC 节点2 奇怪的报错：ORA-19504 两个节点日志

ods_awr_log.rar

4.04 MB, 下载次数: 541

回复只看该作者道具举报

Liu Maclean(刘相兵

4^#

发表于 2014-12-17 19:23:05

Errors in file /oracle/product/10.2.0/admin/dcods/bdump/dcods2_arc1_7424.trc:
ORA-16038: log 5 sequence# 85869 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 5 thread 2: '/dev/dcodsvg/rredo2_1a_512m'
ORA-00312: online log 5 thread 2: '/dev/dcodsvg/rredo2_1b_512m'
Tue Dec 16 20:00:44 EAT 2014
Errors in file /oracle/product/10.2.0/admin/dcods/bdump/dcods2_arc0_7418.trc:
ORA-19504: failed to create file "/backup2/2_85869_823635785.dbf"
ORA-27086: unable to lock file - already in use

确认 oracle用户能

touch /backup2/2_85869_823635785.dbf1

回复只看该作者道具举报