第59次： 2014-11-04, 053第 8和第 9章

botang

物理坏块脚本：

1. #!/bin/sh
   
2. v_dbname=orcl
   
3. su - oracle -c "/u01/app/oracle/product/11.2.0/dbhome_1/bin/srvctl stop database -d $v_dbname"
   
4. su - oracle -c "/u01/app/oracle/product/11.2.0/dbhome_1/bin/sqlplus /nolog" <<EOF
   
5. conn / as sysdba
   
6. startup mount exclusive
   
7. EOF
   
8. 
   
9. rm -f /home/oracle/example01.dbf 2>/dev/null
   
10. 
    
11. su - oracle -c "/u01/app/oracle/product/11.2.0/dbhome_1/bin/rman target /" <<EOF
    
12. backup as copy datafile 5 format '/home/oracle/example01.dbf';
    
13. EOF
    
14. 
    
15. dd if=/dev/zero of=/home/oracle/example01.dbf bs=8192 count=1 seek=175 conv=notrunc
    
16. 
    
17. su - oracle -c "export ORACLE_HOME=/u01/app/oracle/product/11.2.0/grid ; export ORACLE_SID=+ASM ; /u01/app/oracle/product/11.2.0/grid/bin/asmcmd" <<EOF
    
18. rm -f +data/$v_dbname/DATAFILE/example*
    
19. EOF
    
20. 
    
21. su - oracle -c "/u01/app/oracle/product/11.2.0/dbhome_1/bin/rman target /" <<EOF
    
22. run {
    
23. set maxcorrupt for datafile 5 to 1;
    
24. backup as copy  datafilecopy '/home/oracle/example01.dbf' format '+data';
    
25. }
    
26. EOF
    
27. 
    
28. sleep 3
    
29. 
    
30. su - oracle -c "/u01/app/oracle/product/11.2.0/dbhome_1/bin/rman target /" <<EOF
    
31. delete noprompt datafilecopy '/home/oracle/example01.dbf';
    
32. switch datafile 5 to copy;
    
33. EOF
    
34. 
    
35. 
    
36. su - oracle -c "/u01/app/oracle/product/11.2.0/dbhome_1/bin/sqlplus /nolog" <<EOF
    
37. conn / as sysdba
    
38. alter database open;
    
39. EOF

复制代码