今天闲来用用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;:

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