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

复制代码