AIX环境下数据文件ORA-1113故障处理过程

二、观察实例的ALERT日志，发现存在ORA-1113错误

ALTER DATABASE   MOUNT

Wed Dec  6 00:29:55 2010

This instance was first to mount

Setting recovery target incarnation to 2

Wed Dec  6 00:29:59 2010

Successful mount of redo thread 2, with mount id 3375273859

Wed Dec  6 00:29:59 2010

Database mounted in Shared Mode (CLUSTER_DATABASE=TRUE)

Completed: ALTER DATABASE   MOUNT

Wed Dec  6 00:29:59 2010

ALTER DATABASE OPEN

This instance was first to open

ORA-1113 signalled during: ALTER DATABASE OPEN...

Wed Dec  6 00:30:00 2010

Shutting down instance (abort)

License high water mark = 1

Instance terminated by USER, pid = 1482880

根据ORA-1113初步判断是OPEN过程中发现，数据文件错误

三、为了精确定位，通过SQLPLUS命令行OPEN库

SQL> alter database open;

alter database open

*

ERROR at line 1:

ORA-01113: file 73 needs media recovery

ORA-01110: data file 73: '/home/oracle/database/DEV_DATA'

很显然，数据文件DEV_DATA存在问题

（编辑：源码网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!