Oracle 10G 删除了system01.dbf，如何恢复？

ALLSTARS_ORACLE

大家好。朋友碰到一个问题，
10G for linux，无任何备份，非归档模式，结果误删除了system01.dbf，有办法恢复吗？

哎

我也知道system01.dbf 的后果啊，不是就想着看看是否还有最后一丝希望嘛。

ALLSTARS_ORACLE

可以使用prm-scan 工具碎片扫描system01.dbf 的数据块并合并成system01.dbf，关于prm-scan工具：
http://www.askmaclean.com/archiv ... B7%A5%E5%85%B7.html
PRMSCAN ORACLE碎片扫描合并工具

biotwang

[oracle@TEST datafiles]$ rm -rf system01.dbf
[oracle@TEST datafiles]$ cd
[oracle@TEST ~]$ exit

-- dd整块盘进行备份

1. SQL> startup;
   
2. ORACLE instance started.
   
3. Total System Global Area 348127232 bytes
   
4. Fixed Size 1219328 bytes
   
5. Variable Size 289408256 bytes
   
6. Database Buffers 50331648 bytes
   
7. Redo Buffers 7168000 bytes
   
8. Database mounted.
   
9. ORA-01157: cannot identify/lock data file 1 – see DBWR trace file
   
10. ORA-01110: data file 1: ‘/home/oracle/AZDB/datafiles/system01.dbf’
    
11. 
    
12. SQL> shutdown immediate;
    
13. ORA-01109: database not open
    
14. Database dismounted.
    
15. ORACLE instance shut down.

复制代码

-- 可联系诗檀救援，使用prm-scan工具碎片扫描system01.dbf的数据块并合并成system01.dbf
[oracle@TEST backup]$ cp system01.dbf /home/oracle/AZDB/datafiles/

1. SQL> startup;
   
2. ORACLE instance started.
   
3. Total System Global Area 348127232 bytes
   
4. Fixed Size 1219328 bytes
   
5. Variable Size 289408256 bytes
   
6. Database Buffers 50331648 bytes
   
7. Redo Buffers 7168000 bytes
   
8. Database mounted.
   
9. ORA-01113: file 1 needs media recovery
   
10. ORA-01110: data file 1: ‘/home/oracle/AZDB/datafiles/system01.dbf’
    
11. 
    
12. SQL> recover datafile 1;
    
13. ORA-00279: change 373322 generated at 10/31/2008 16:30:29 needed for thread 1
    
14. ORA-00289: suggestion : /home/oracle/AZDB/archive/arch_1_669569864_1.arc
    
15. ORA-00280: change 373322 for thread 1 is in sequence #1
    
16. Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
    
17. Log applied.
    
18. Media recovery complete.
    
19. 
    
20. SQL> alter database open;
    
21. Database altered

复制代码