ora 16014，ora16038错误解决

自己的数据库。试验机器。早上出现ora 16014和ora 16038错误

报警日志如下

Errors in file /opt/oracle/admin/ge01/udump/ge01_ora_4513.trc:
ORA-19504: failed to create file "/home/oracle/arc/1_23_676230365.dbf"
ORA-27040: file create error, unable to create file
Linux Error: 13: Permission denied
Sun Feb 15 00:48:16 2009
Errors in file /opt/oracle/admin/ge01/bdump/ge01_arc1_4517.trc:
ORA-19504: failed to create file "/home/oracle/arc/1_24_676230365.dbf"
ORA-27040: file create error, unable to create file
Linux Error: 13: Permission denied
Sun Feb 15 00:48:16 2009
ARCH: Error 19504 Creating archive log file to '/home/oracle/arc/1_23_676230365.dbf'
Sun Feb 15 00:48:16 2009
ARC1: Error 19504 Creating archive log file to '/home/oracle/arc/1_24_676230365.dbf'
Sun Feb 15 00:48:16 2009
ARCH: Failed to archive thread 1 sequence 23 (19504)
ORA-16038 signalled during: ALTER DATABASE OPEN...
Sun Feb 15 00:48:16 2009
ARC2: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC0: Becoming the heartbeat ARCH
ARC2 started with pid=18, OS id=4519
Sun Feb 15 00:48:16 2009
ARC1: Failed to archive thread 1 sequence 24 (19504)
Sun Feb 15 00:48:16 2009
ARC0: Archiving not possible: No primary destinations
Sun Feb 15 00:48:16 2009
ARCH: Archival stopped, error occurred. Will continue retrying
Sun Feb 15 00:48:16 2009
ORACLE Instance ge01 - Archival Error
Sun Feb 15 00:48:16 2009
ORA-16038: log 3 sequence# 24 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 3 thread 1: '/opt/oracle/oradata/ge01/redo03.log'
Sun Feb 15 00:48:16 2009
Errors in file /opt/oracle/admin/ge01/bdump/ge01_arc1_4517.trc:
ORA-16038: log 3 sequence# 24 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 3 thread 1: '/opt/oracle/oradata/ge01/redo03.log'
Sun Feb 15 00:48:16 2009
ARC0: Failed to archive thread 1 sequence 23 (4)
ARCH: Archival stopped, error occurred. Will continue retrying
Sun Feb 15 00:48:16 2009
ORACLE Instance ge01 - Archival Error
Sun Feb 15 00:48:16 2009
ORA-16014: log 1 sequence# 23 not archived, no available destinations
ORA-00312: online log 1 thread 1: '/opt/oracle/oradata/ge01/redo01.log'
Sun Feb 15 00:48:16 2009
Errors in file /opt/oracle/admin/ge01/bdump/ge01_arc0_4515.trc:
ORA-16014: log 1 sequence# 23 not archived, no available destinations
ORA-00312: online log 1 thread 1: '/opt/oracle/oradata/ge01/redo01.log'
Sun Feb 15 00:49:16 2009
ARC0: Archiving not possible: No primary destinations
ARC0: Failed to archive thread 1 sequence 23 (4)
Sun Feb 15 00:50:16 2009
ARC1: Archiving not possible: No primary destinations
ARC1: Failed to archive thread 1 sequence 23 (4)

 

看辅助的ora 00312指出了有日志文件坏掉了。

以sysdba登上数据库。结果出现ora 01012错误。无法登陆数据库。真是祸不单行啊。

01012错误是内存溢出错误。最简单的解决方式就是重启系统。把系统重新启动后。能够以sysdba登陆上去。

登陆上去后。把数据库启动为mount状态。

select * from v$log;

找到出错的日志组，是1号组

alter database clear unarchived logfile group 1；

把该日志组清除；

alter database open;

数据库启动。

 

综合看来。这种错误在生产环境一般不会出现。毕竟生产环境的一个组里有多个成员存在。出现这个错误的几率比较小。