oracle 01221,ora

admin管理员组

文章数量:1122927

oracle 01221,ora

数据库是个一般数据库，用于本身实验的，想趁这次机会找出来哪里有问题，谢谢大家伙了。

4G内存，双核CPU，DELL的普通PC服务器

昨天(9月15号)晚上还有过正常的数据库操作

但是今天(9月16号)过来之后发现数据库非正常的宕掉了

重新启动，结果无法起来，具体如下：

SQL> startup

ORACLE instance started.

Total System Global Area  608174080 bytes

Fixed Size                    1220820 bytes

Variable Size                  104861484 bytes

Database Buffers          494927872 bytes

Redo Buffers                    7163904 bytes

Database mounted.

ORA-01221: data file 1 is not the same file to a background process

SQL> alter database open

2  ;

alter database open

*

ERROR at line 1:

ORA-01221: data file 1 is not the same file to a background process

查看编号为1文件

SQL> select * from v$dbfile;

FILE# NAME

---------- ---------------------------------------------

4 /u01/app/oracle/oradata/hunterjk/users01.dbf

3 /u01/app/oracle/oradata/hunterjk/sysaux01.dbf

2 /u01/app/oracle/oradata/hunterjk/undotbs01.dbf

1 /u01/app/oracle/oradata/hunterjk/system01.dbf

...

29 /u01/app/oracle/oradata/rzrq/system02.dbf

30 /u01/app/oracle/oradata/rzrq/sysaux02.dbf

对应的是system01.dbf

查看告警日志，找到报错相应部分如下：

[oracle@localhost bdump]$ vi alert_hunterjk.log

hu Oct 15 13:46:57 2009

ALTER SYSTEM: Flushing buffer cache

Thu Oct 15 23:01:05 2009

Thread 1 advanced to log sequence 81

Current log# 2 seq# 81 mem# 0: /u01/app/oracle/oradata/hunterjk/redo02.log

Thu Oct 15 23:06:09 2009

Errors in file /u01/app/oracle/admin/hunterjk/bdump/hunterjk_ckpt_25953.trc:

ORA-01242: 数据文件出现介质故障: 数据库处于 NOARCHIVELOG 模式

ORA-01122: 数据库文件 1 验证失败

ORA-01110: 数据文件 1: '/u01/app/oracle/oradata/hunterjk/system01.dbf'

ORA-01206: 文件不是此数据库的一部分 - 数据库 ID 错误

Thu Oct 15 23:06:09 2009

Errors in file /u01/app/oracle/admin/hunterjk/bdump/hunterjk_ckpt_25953.trc:

ORA-01242: 数据文件出现介质故障: 数据库处于 NOARCHIVELOG 模式

ORA-01122: 数据库文件 1 验证失败

ORA-01110: 数据文件 1: '/u01/app/oracle/oradata/hunterjk/system01.dbf'

ORA-01206: 文件不是此数据库的一部分 - 数据库 ID 错误

Thu Oct 15 23:06:09 2009

CKPT: terminating instance due to error 1242

Instance terminated by CKPT, pid = 25953

Instance terminated by CKPT, pid = 25953

Fri Oct 16 08:20:58 2009

Starting ORACLE instance (normal)

Cannot determine all dependent dynamic libraries for /proc/self/exe

The open() system call failed for the file /proc/self/exe

Linux Error: 13: Permission denied

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Picked latch-free SCN scheme 2

Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST

Autotune of undo retention is turned on.

IMODE=BR

ILAT =18

LICENSE_MAX_USERS = 0

SYS auditing is disabled

ksdpec: called for event 13740 prior to event group initialization

....

Beginning crash recovery of 1 threads

parallel recovery started with 3 processes

Fri Oct 16 08:21:04 2009

Errors in file /u01/app/oracle/admin/hunterjk/bdump/hunterjk_dbw0_3991.trc:

ORA-01186: ?? 1 ??????

ORA-01122: ????? 1 ????

ORA-01110: ???? 1: '/u01/app/oracle/oradata/hunterjk/system01.dbf'

ORA-01206: ???????????? - ??? ID ??

Fri Oct 16 08:21:04 2009

File 1 not verified due to error ORA-01122

Fri Oct 16 08:21:04 2009

Aborting crash recovery due to error 1221

Fri Oct 16 08:21:04 2009

Errors in file /u01/app/oracle/admin/rzrq/udump/hunterjk_ora_4011.trc:

ORA-01221: data file 1 is not the same file to a background process

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

Fri Oct 16 08:24:09 2009

alter database open

Fri Oct 16 08:24:09 2009

Beginning crash recovery of 1 threads

parallel recovery started with 3 processes

Fri Oct 16 08:24:09 2009

Errors in file /u01/app/oracle/admin/rzrq/bdump/hunterjk_dbw0_3991.trc:

ORA-01186: ?? 1 ??????

ORA-01122: ????? 1 ????

ORA-01110: ???? 1: '/u01/app/oracle/oradata/hunterjk/system01.dbf'

ORA-01206: ???????????? - ??? ID ??

Fri Oct 16 08:24:09 2009

File 1 not verified due to error ORA-01122

。。。

昨晚11点挂掉的，不知道什么原因。而且是system表空间的数据文件不一致了

SQL> recover datafile '/u01/app/oracle/oradata/hunterjk/system01.dbf'

ORA-00283: recovery session canceled due to errors

ORA-00264: no recovery required

目前无法定位问题所在，所以不知道如何处理，还请不吝赐教，谢谢了。

[本帖最后由 hunterjk_cu 于 2009-10-16 14:31 编辑]

本文标签： oracle 01221ORA