课程第16/17次（2017-04-08星期六上下午）

admin

上完1Z0-052第5章：ASM实例
进行1Z0-053闪回三章
1Z0-052共19章（上完10章），1Z0-053共21章（上完2章）和1Z0-063多租户部分共9章（上完0章）
总共上完全部49章中的12章

如需绑定raw设备：

1. select  * from v$asm_diskgroup;
   
2. 
   
3. create diskgroup highdata high redundancy
   
4. failgroup fgroup1 disk 'ORCL:MYDISK6' name mydisk6
   
5.   failgroup fgroup2 disk 'ORCL:MYDISK7' name mydisk7
   
6.    failgroup fgroup3 disk 'ORCL:MYDISK8' name mydisk8;
   
7. 
   
8. select  * from v$asm_file  where group_number=3;
   
9. 
   
10. select  * from v$asm_operation;
    
11. 
    
12. select  * from v$asm_attribute;
    
13. 
    
14. select  * from v$asm_template where group_number=1;
    
15. 
    
16. select  * from v$asm_alias  where group_number=1  ;
    
17. select  * from v$asm_file where group_number=1 and file_number in (269,270);
    
18. 
    
19. select  * from v$asm_client;
    
20. 
    
21. select  * from v$asm_disk;
    
22. 
    
23. 
    
24. select  * from v$asm_disk where group_number=1;
    
25. 
    
26. alter diskgroup data add failgroup data_0000
    
27. disk '/dev/raw/raw16' size 990M
    
28.    failgroup data_0001  disk
    
29.    '/dev/raw/raw17' size 990M;
    
30.    
    
31.    alter diskgroup data drop disk data_0006 disk data_0007;
    
32. alter diskgroup data undrop disks;
    
33. 
    
34. ---
    
35. create tablespace tbsasmhigh  datafile '+HIGHDATA'
    
36. size 5M  ;
    
37. 
    
38. drop tablespace tbsasmhigh;
    
39. 
    
40. select   * from dba_data_files;
    
41. 
    
42. create tablespace tbsasmhigh2  datafile '+HIGHDATA/orcl/datafile/tbsasmhigh2.dbf'
    
43. size 5M  ;
    
44. 
    
45. alter tablespace tbsasmhigh2 offline;
    
46. 
    
47. alter database rename file '+HIGHDATA/orcl/datafile/tbsasmhigh2.dbf'  to
    
48.   '+HIGHDATA/orcl/datafile/TBSASMHIGH2.257.940778913';
    
49.   
    
50.    alter tablespace tbsasmhigh2 online;
    
51.    
    
52.     create tablespace tbsasmhighfine  datafile '+DATA(mytem1)/orcl/datafile/tbsasmhighfine.dbf'
    
53. size 5M  ;
    
54. 
    
55.      create tablespace tbsasmunfine  datafile '+DATA(mytem2)/orcl/datafile/tbsasmunfine.dbf'
    
56. size 5M  ;
    
57. 
    
58. select  *  from flashback_transaction_query;
    
59. 
    
60. select *  from v$transaction;
    
61. 
    
62. select  *  from flashback_transaction_query f
    
63. where f.logon_user='HR' and f.table_name='EMPLOYEES'
    
64. order by commit_scn
    
65. ;
    
66. 
    
67. select  t.row_movement
    
68.   from dba_tables t
    
69.   where t.owner='HR' and t.table_name='EMPLOYEES';
    
70.   
    
71.   alter system set resource_manager_plan='';
    
72.   
    
73.   select  d.SUPPLEMENTAL_LOG_DATA_MIN,
    
74.              d.SUPPLEMENTAL_LOG_DATA_PK,
    
75.              d.SUPPLEMENTAL_LOG_DATA_UI,
    
76.              d.SUPPLEMENTAL_LOG_DATA_ALL
    
77.     from v_$database  d;
    
78.    
    
79.     alter database add SUPPLEMENTAL   LOG DATA;
    
80. 
    

复制代码