课程第22/23次（2017-05-02星期二，2017-05-04星期四）

botang

上完1Z0-053闪回3
1Z0-052共19章（上完10章），1Z0-053共21章（上完5章）和1Z0-063多租户部分共9章（上完0章）
总共上完全部49章中的15章

上课时14号实验忘记收取结果，各个机器对应的表名，请自己核对下：

192.168.0.2	select  * from hr.t18857;
192.168.0.3	select  * from hr.t32439;
192.168.0.4	select  * from hr.t27669;
192.168.0.10	select  * from hr.t10776;
192.168.0.11	select  * from hr.t11427;
192.168.0.13	select  * from hr.t3621;
192.168.0.14	select  * from hr.t23289;
192.168.0.15	select  * from hr.t13986;
192.168.0.16	select  * from hr.t19619;
192.168.0.18	select  * from hr.t8201;
192.168.0.26	select  * from hr.t352;
192.168.0.37	select  * from hr.t22672;
192.168.0.39	select  * from hr.t26138;
192.168.0.61	select  * from hr.t4017;
192.168.0.76	select  * from hr.t18767;
192.168.0.90	select  * from hr.t32361;

1. select  * from v$flashback_database_log;
   
2. 
   
3. flashback database to timestamp
   
4. to_timestamp('2017-05-02:20:11:00','YYYY-MM-DD:HH24:MI:SS');
   
5. --
   
6. select  file_name ,  bytes  from dba_data_files
   
7.    where tablespace_name='USERS';
   
8.    
   
9.    select  sum(bytes)/1024/1024  from dba_free_space  
   
10.      where  tablespace_name='USERS';
    
11. 
    
12. alter database datafile '+DATA/orcl/datafile/users.259.942957531'
    
13.   resize 5000000;
    
14. 
    
15. select  * from v$flashback_database_stat;
    
16. 
    
17. select  * from v$recovery_area_usage;
    
18. 
    
19. select  * from v$restore_point;
    
20. 
    
21. create restore point rsp1  ;
    
22. 
    
23. create restore point rsp2
    
24. guarantee flashback database;
    

复制代码

磁带库配置：

1. ###   3.10 Tape Begin
   
2. ###
   
3. 
   
4. yum -y install zlib-devel
   
5. yum -y install mtx
   
6. yum -y install mt-st
   
7. yum -y install lsscsi
   
8. yum -y install sg3_utils
   
9. yum -y install ncompress
   
10. 
    
11. wget -P /stage -c --tries=100 --wait=5 http://192.168.0.254/pub/O10g/TAPE/mhvtl.tgz
    
12. wget -P /stage -c --tries=100 --wait=5 http://192.168.0.254/pub/O10g/TAPE/osb-10.3.0.3.0_linux32.zip
    
13. wget -P /stage -c --tries=100 --wait=5 http://192.168.0.254/pub/O10g/TAPE/osb.txt
    
14. wget -P /lib -c --tries=100 --wait=5 http://192.168.0.254/pub/O10g/TAPE/ld-2.5.so
    
15. wget -P /stage -c --tries=100 --wait=5 http://192.168.0.254/pub/O10g/TAPE/osb.sh
    
16. wget -P /stage -c --tries=100 --wait=5 http://192.168.0.254/pub/O10g/TAPE/reuseosb.sh
    
17. wget -P /stage -c --tries=100 --wait=5 http://192.168.0.254/pub/O10g/TAPE/lzo-2.02-2.el5.1.i386.rpm
    
18. rpm -ivh /stage/lzo-2.02-2.el5.1.i386.rpm
    
19. wget -P /stage -c --tries=100 --wait=5 http://192.168.0.254/pub/O10g/TAPE/lzo-devel-2.02-2.el5.1.i386.rpm
    
20. rpm -ivh /stage/lzo-devel-2.02-2.el5.1.i386.rpm
    
21. wget -P /stage -c --tries=100 --wait=5 http://192.168.0.254/pub/O10g/TAPE/copytape-root.sh
    
22. wget -P /stage -c --tries=100 --wait=5 http://192.168.0.254/pub/O10g/TAPE/revertape-root.sh
    
23. cd /stage
    
24. tar zxvf mhvtl.tgz
    
25. rm -f /stage/mhvtl.tgz
    
26. cd /stage
    
27. unzip osb-10.3.0.3.0_linux32.zip
    
28. rm -f /stage/osb-10.3.0.3.0_linux32.zip
    
29. cd /stage/mhvtl-1.2
    
30. useradd vtl
    
31. echo oracle | passwd --stdin vtl
    
32. mkdir /opt/mhvtl
    
33. mkdir /etc/mhvtl
    
34. chown -R vtl:vtl /opt/mhvtl
    
35. chown -R vtl:vtl /etc/mhvtl
    
36. make distclean
    
37. cd /stage/mhvtl-1.2/kernel
    
38. make
    
39. make install
    
40. cd /stage/mhvtl-1.2/
    
41. make
    
42. make install
    
43. service mhvtl start
    
44. perl -i -pe 's,CAPACITY=500,CAPACITY=8000,' /etc/mhvtl/mhvtl.conf
    
45. chkconfig mhvtl on
    
46. service mhvtl stop
    
47. service mhvtl start
    
48. mkdir -p /usr/local/oracle/backup
    
49. sed -i.bak 's/192.168.0.254/127.0.0.1/g' /etc/resolv.conf
    
50. 
    
51. ###
    
52. ###   3.9 Tape End

复制代码