[oracle@oracle datafile]$ mv portalwebsite_ICMLFQ32_01.dbf portalwebsite_ICMLFQ32_01.dbf.bak
启动数据库时候报错：
SQL> startup
ORACLE instance started.
Total System Global Area 835104768 bytes
Fixed Size 2217952 bytes
Variable Size 578816032 bytes
Database Buffers 247463936 bytes
Redo Buffers 6606848 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 7 - see DBWR trace file
ORA-01110: data file 7:
'/oradata/portaldb/datafile/portalwebsite_ICMLFQ32_01.dbf'
执行恢复
SQL> alter database create datafile '/oradata/portaldb/datafile/portalwebsite_ICMLFQ32_01.dbf' as '/oradata/portaldb/datafile/portalwebsite_ICMLFQ32_01.dbf';
Database altered.
SQL> recover datafile 7;
Media recovery complete.
SQL> alter database open;
Database altered.
查看已经恢复过来的文件：
[oracle@oracle datafile]$ pwd
/oradata/portaldb/datafile
[oracle@oracle datafile]$ ls
portalwebsite_ICMLFQ32_01.dbf portalwebsite_ICMSFQ04_01.dbf
portalwebsite_ICMLFQ32_01.dbf.bak portalwebsite_ICMVFQ04_01.dbf
portalwebsite_ICMLNF32_01.dbf websitedata_01.dbf
portalwebsite_ICMLSNDX_01.dbf
阅读(805) | 评论(0) | 转发(0) |
