数据库关闭报ORA-01122: database file 6 failed verification check
SQL> shutdown immediate;
ORA-01122: database file 6 failed verification check
ORA-01110: data file 6: '/dev/rlv_test01'
ORA-01203: wrong incarnation of this file - wrong creation SCN
SQL>
SQL> select open_mode from v$database;
OPEN_MODE
--------------------
READ WRITE
SQL> select checkpoint_change# from v$database;
CHECKPOINT_CHANGE#
------------------
3851525
SQL> select name,checkpoint_change# from v$datafile;
NAME
--------------------------------------------------------------------------------
CHECKPOINT_CHANGE#
------------------
/dev/rlv_system
4476975
/dev/rlv_sysaux
4476975
/dev/rlv_undo1
4476975
NAME
--------------------------------------------------------------------------------
CHECKPOINT_CHANGE#
------------------
/dev/rlv_undo2
4476975
/dev/rlv_user
4476975
/dev/rlv_test01
4479461
6 rows selected.
SQL> select name,last_change# from v$datafile;
NAME
--------------------------------------------------------------------------------
LAST_CHANGE#
------------
/dev/rlv_system
/dev/rlv_sysaux
/dev/rlv_undo1
NAME
--------------------------------------------------------------------------------
LAST_CHANGE#
------------
/dev/rlv_undo2
/dev/rlv_user
/dev/rlv_test01
6 rows selected.
SQL> select name,checkpoint_change# from v$datafile_header;
NAME
--------------------------------------------------------------------------------
CHECKPOINT_CHANGE#
------------------
/dev/rlv_system
4476975
/dev/rlv_sysaux
4476975
/dev/rlv_undo1
4476975
NAME
--------------------------------------------------------------------------------
CHECKPOINT_CHANGE#
------------------
/dev/rlv_undo2
4476975
/dev/rlv_user
4476975
/dev/rlv_test01
4475393
6 rows selected.
SQL>
执行下面语句报错。
SQL> create tablespace tbs01 datafile '/dev/rlv_test01';
create tablespace tbs01 datafile '/dev/rlv_test01'
*
ERROR at line 1:
ORA-01543: tablespace 'TBS01' already exists
SQL> select distinct tablespace_name from dba_tables;
TABLESPACE_NAME
------------------------------------------------------------
SYSTEM
SYSAUX
SQL>
启动RAC：
# /sbin/init.d/init.crs start
关闭RAC：
# /sbin/init.d/init.crs stop
做了 其他操作。
首先说明的是 我没有备份。我先建立了一个tbs01表空间。这个表空间是在一台存储上建立的。然后把这个tbs01间drop掉。然后用阵列侧的回滚功能恢复。关闭数据库就报这样的错误。本来想关闭一次 然后打开的数据库的时候数据库会自动恢复的，结果关闭有问题了。
drop 表空间有问题。datafile offline数据文件也出错同样的错啊。
页:
[1]