第17和第18次：2015-07-04星期六上下午

botang

第17和第18次：2015-07-04星期六上下午

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

复制代码

1. select  * from dba_tables t where t.owner='HR' and t.table_name='DEPARTMENTS';
   
2. 
   
3. select * from v$datafile;
   
4. 
   
5. '+DATA/orcl/datafile/example.265.816169651'
   
6. 
   
7. '+DATA/orcl/datafile/example.265.884169393'
   
8. 
   
9. select  * from v$rman_configuration;
   
10. 
    
11. select  * from dba_tablespaces;
    
12. 
    
13. alter tablespace users online;
    
14. 
    
15. 
    
16. select  * from dba_data_files;
    
17. 
    
18. select  * from v$block_change_tracking;
    
19. 
    
20. select   d.FILE# ,
    
21.            avg(datafile_blocks),
    
22.             avg(blocks_read),
    
23.             avg(blocks_read/datafile_blocks) * 100 AS PCT_READ_FOR_BACKUP,
    
24.             avg(blocks)
    
25.      from v_$backup_datafile   d
    
26.    where d.USED_CHANGE_TRACKING= 'YES'
    
27.    group by d.FILE#;
    
28. 
    
29. 
    
30. select * from V$DATABASE_BLOCK_CORRUPTION;
    
31. 
    
32. select  * from v$backup_corruption;
    
33. 
    
34. select  * from v$copy_corruption;
    
35. 
    
36. select  file#  , d.SECTION_SIZE   from V_$BACKUP_DATAFILE  d ;
    
37. 
    
38. select * from v$restore_point;
    
39. 
    
40. create restore  point  rsp1 as of scn 884195078;
    

复制代码

上完1Z0-053第4，5章        （52-12）