oracle数据库文件损坏如何恢复,
下面是一次模拟实验,如下
SQL> create tablespace test datafile '/u01/app/oracle/oradata/lhz/test01.dbf' size 10M;
SQL> create table test as select * from dba_objects;
SQL> alter table test move tablespace test;
SQL> select count(*) from test;
COUNT(*)
50881
2. 然后用vi修改数据文件
3.随意输入什么字符,保存
SQL> shutdown immediate;
Database dismounted.
5.发动实例
ORACLE instance started.
Total System Global Area 599785472 bytes
Variable Size 243272768 bytes
Redo Buffers 6287360 bytes
ORA-01157: cannot identify/lock data file 9 - see DBWR trace file
6. 先将损坏数据文件offline,并翻开数据库实例
Database altered.
Database altered.
SQL> alter database create datafile '/u01/app/oracle/oradata/lhz/test01.dbf';
SQL> recover datafile 9;
SQL> alter database datafile 9 online;
8.验证康复结果:
SQL> select count(*) from andylhz.test;
COUNT(*)
50881
恢复完成!