热备份---非系统数据文件损坏的恢复

1.删除数据文件

rm -f app1_01.dbf

 

2.启动数据库，并根据错误查看原因

QL> startup
ORACLE instance started.

Total System Global Area  213909504 bytes
Fixed Size                  1218580 bytes
Variable Size              79693804 bytes
Database Buffers          130023424 bytes
Redo Buffers                2973696 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 5 - see DBWR trace file
ORA-01110: data file 5: '/u01/app/oracle/oradata/demo1/app1_01.dbf'

 

3.查看要恢复的表

SQL> select * from v$recover_file;

 

4.offline数据文件

SQL> alter database datafile 5 offline;

 

5.打开数据库

SQL> alter database open;

 

6.拷贝备份文件到相应路径下

cp /u01/ubackup/cold/app1_01.dbf  .

 

7.恢复数据该数据文件

SQL> recover datafile 5;

 

8.online该数据文件

SQL> select file#,status,name from v$datafile;

SQL> alter database datafile 5 online;