课程第42次：2016-07-01星期五

botang

课程第42次：2016-07-01星期五：
select  p.spid
from v_$session s, v_$process p
where s.PADDR=p.ADDR and s.TERMINAL='pts/12';

select  * from v$backup_corruption;

select  * from v$copy_corruption;

select  * from v$database_block_corruption;

---
select  * from v$database_block_corruption;

select * from v$backup_corruption;


physical-block.sh：

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

复制代码