热备份 数据库打开状态下非系统表空间损坏的恢复

1.删除掉数据文件

rm -f app1_01.dbf

 

2.显示错误

SQL> create table user1.tt2 as select * from dba_objects;
create table user1.tt2 as select * from dba_objects
                                        *
ERROR at line 1:
ORA-01116: error in opening database file 5
ORA-01110: data file 5: '/u01/app/oracle/oradata/demo1/app1_01.dbf'
ORA-27041: unable to open file
Linux Error: 2: No such file or directory
Additional information: 3

 

3.查看v$recover_file(没有显示任何内容)
SQL> select * from v$recover_file;

 

4.off表空间

SQL> alter database datafile 5 offline;

 

5.拷贝相应备份到相应位置

[oracle@asm demo1]$ cp /u01/ubackup/hot/app1_01.dbf .

 

6.恢复数据文件

SQL> select * from v$recover_file;

SQL> recover datafile 5;

 

7.查看状态

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

 

8.online表空间

SQL> alter database datafile 5 online;

 

 

 

7.