今天闲来用用BBED工具，

谁知道由于操作不当导致数据文件损坏，

启动数据库报：

SQL> alter database open;

alter database open

*

ERROR at line 1:

ORA-01122: database file 7 failed verification check

ORA-01110: data file 7: '/u02/oradata/crmdb/test01.dbf'

ORA-01251: Unknown File Header Version read for file number 7

由于是测试库，所以也就没有任何形式的备份了，于是乎就只有把文件删除重新编写control文件了，

备份control文件：

alter database backup controlfile to trace;

修改控制文件，将那个数据文件删除：

CREATE CONTROLFILE REUSE DATABASE "ORCL" NORESETLOGS FORCE LOGGING ARCHIVELOG

MAXLOGFILES 16

MAXLOGMEMBERS 3

MAXDATAFILES 100

MAXINSTANCES 8

MAXLOGHISTORY 292

LOGFILE

GROUP 1 '/u02/oradata/crmdb/redo01.log'  SIZE 50M,

GROUP 2 '/u02/oradata/crmdb/redo02.log'  SIZE 50M,

GROUP 3 '/u02/oradata/crmdb/redo03.log'  SIZE 50M

-- STANDBY LOGFILE

DATAFILE

'/u02/oradata/crmdb/system01.dbf',

'/u02/oradata/crmdb/undotbs01.dbf',

'/u02/oradata/crmdb/sysaux01.dbf',

'/u02/oradata/crmdb/users01.dbf',

'/u02/oradata/crmdb/test01.dbf'---删掉CHARACTER SET UTF8

;

SQL> alter database open;

alter database open

*

ERROR at line 1:

ORA-01113: file 1 needs media recovery

ORA-01110: data file 1: '/u02/oradata/crmdb/system01.dbf'

SQL> recover database;

Media recovery complete.

SQL> alter database open;

Database altered.

SQL> select count(*) from test1;

select count(*) from test1

*

ERROR at line 1:

ORA-00376: file 7 cannot be read at this time

ORA-01111: name for data file 7 is unknown - rename to correct file

ORA-01110: data file 7: '/u01/app/oracle/dbs/MISSING00007'

SQL> drop tablespace test;

drop tablespace test

*

ERROR at line 1:

ORA-01549: tablespace not empty, use INCLUDING CONTENTS option

SQL> drop tablespace test including contents;

Tablespace dropped.

SQL>

PS;:

备份很重要，备份很重要，备份真的很重要。。。。。。。