记一次ORA-01122/ORA-01110/ORA-01251

最新推荐文章于 2021-04-04 19:32:51 发布

cuiliao2030

最新推荐文章于 2021-04-04 19:32:51 发布

阅读量149

点赞数

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