课程第32次

botang

1. select  * from v$backup_sync_io;
   
2. 
   
3. select  * from v$backup_async_io;

复制代码




调优RMAN控制multiplexing:

1. RMAN> backup tag '10T_WHOLE_FULL' database;
   
2. 
   
3. Starting backup at 2019-12-18:16:32:24
   
4. allocated channel: ORA_SBT_TAPE_1
   
5. channel ORA_SBT_TAPE_1: SID=140 device type=SBT_TAPE
   
6. channel ORA_SBT_TAPE_1: Oracle Secure Backup
   
7. allocated channel: ORA_SBT_TAPE_2
   
8. channel ORA_SBT_TAPE_2: SID=78 device type=SBT_TAPE
   
9. channel ORA_SBT_TAPE_2: Oracle Secure Backup
   
10. channel ORA_SBT_TAPE_1: starting full datafile backup set
    
11. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
    
12. input datafile file number=00001 name=+DATA/orcl/datafile/system.283.1026941797
    
13. input datafile file number=00004 name=+DATA/orcl/datafile/users.265.1026941797
    
14. channel ORA_SBT_TAPE_1: starting piece 1 at 2019-12-18:16:32:36
    
15. channel ORA_SBT_TAPE_2: starting full datafile backup set
    
16. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
    
17. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.282.1026941797
    
18. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.281.1026941797
    
19. channel ORA_SBT_TAPE_2: starting piece 1 at 2019-12-18:16:32:37
    
20. channel ORA_SBT_TAPE_1: finished piece 1 at 2019-12-18:16:33:32
    
21. piece handle=1dujoct4_1_1 tag=10T_WHOLE_FULL comment=API Version 2.0,MMS Version 10.4.0.4
    
22. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:56
    
23. channel ORA_SBT_TAPE_1: starting full datafile backup set
    
24. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
    
25. channel ORA_SBT_TAPE_2: finished piece 1 at 2019-12-18:16:33:32
    
26. piece handle=1eujoct4_1_1 tag=10T_WHOLE_FULL comment=API Version 2.0,MMS Version 10.4.0.4
    
27. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:55
    
28. channel ORA_SBT_TAPE_2: starting full datafile backup set
    
29. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
    
30. including current SPFILE in backup set
    
31. channel ORA_SBT_TAPE_2: starting piece 1 at 2019-12-18:16:33:32
    
32. including current control file in backup set
    
33. channel ORA_SBT_TAPE_1: starting piece 1 at 2019-12-18:16:33:32
    
34. channel ORA_SBT_TAPE_1: finished piece 1 at 2019-12-18:16:33:57
    
35. piece handle=1fujocus_1_1 tag=10T_WHOLE_FULL comment=API Version 2.0,MMS Version 10.4.0.4
    
36. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
    
37. channel ORA_SBT_TAPE_2: finished piece 1 at 2019-12-18:16:33:57
    
38. piece handle=1gujocus_1_1 tag=10T_WHOLE_FULL comment=API Version 2.0,MMS Version 10.4.0.4
    
39. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:25
    
40. Finished backup at 2019-12-18:16:33:57
    

复制代码

------

1. RMAN> backup tag '11T_WHOLE_FULL' filesperset 1 database ;
   
2. 
   
3. Starting backup at 2019-12-18:16:49:40
   
4. using channel ORA_SBT_TAPE_1
   
5. using channel ORA_SBT_TAPE_2
   
6. channel ORA_SBT_TAPE_1: starting full datafile backup set
   
7. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
   
8. input datafile file number=00001 name=+DATA/orcl/datafile/system.283.1026941797
   
9. channel ORA_SBT_TAPE_1: starting piece 1 at 2019-12-18:16:49:42
   
10. channel ORA_SBT_TAPE_2: starting full datafile backup set
    
11. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
    
12. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.282.1026941797
    
13. channel ORA_SBT_TAPE_2: starting piece 1 at 2019-12-18:16:49:42
    
14. channel ORA_SBT_TAPE_2: finished piece 1 at 2019-12-18:16:50:27
    
15. piece handle=1iujodt6_1_1 tag=11T_WHOLE_FULL comment=API Version 2.0,MMS Version 10.4.0.4
    
16. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:45
    
17. channel ORA_SBT_TAPE_2: starting full datafile backup set
    
18. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
    
19. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.281.1026941797
    
20. channel ORA_SBT_TAPE_2: starting piece 1 at 2019-12-18:16:50:27
    
21. channel ORA_SBT_TAPE_1: finished piece 1 at 2019-12-18:16:50:42
    
22. piece handle=1hujodt6_1_1 tag=11T_WHOLE_FULL comment=API Version 2.0,MMS Version 10.4.0.4
    
23. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:01:01
    
24. channel ORA_SBT_TAPE_1: starting full datafile backup set
    
25. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
    
26. including current control file in backup set
    
27. channel ORA_SBT_TAPE_1: starting piece 1 at 2019-12-18:16:50:44
    
28. channel ORA_SBT_TAPE_2: finished piece 1 at 2019-12-18:16:50:44
    
29. piece handle=1jujoduj_1_1 tag=11T_WHOLE_FULL comment=API Version 2.0,MMS Version 10.4.0.4
    
30. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:17
    
31. channel ORA_SBT_TAPE_2: starting full datafile backup set
    
32. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
    
33. input datafile file number=00004 name=+DATA/orcl/datafile/users.265.1026941797
    
34. channel ORA_SBT_TAPE_2: starting piece 1 at 2019-12-18:16:50:44
    
35. channel ORA_SBT_TAPE_2: finished piece 1 at 2019-12-18:16:51:09
    
36. piece handle=1lujodv4_1_1 tag=11T_WHOLE_FULL comment=API Version 2.0,MMS Version 10.4.0.4
    
37. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:25
    
38. channel ORA_SBT_TAPE_2: starting full datafile backup set
    
39. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
    
40. including current SPFILE in backup set
    
41. channel ORA_SBT_TAPE_2: starting piece 1 at 2019-12-18:16:51:10
    
42. channel ORA_SBT_TAPE_1: finished piece 1 at 2019-12-18:16:51:17
    
43. piece handle=1kujodv3_1_1 tag=11T_WHOLE_FULL comment=API Version 2.0,MMS Version 10.4.0.4
    
44. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:33
    
45. channel ORA_SBT_TAPE_2: finished piece 1 at 2019-12-18:16:51:35
    
46. piece handle=1mujodvu_1_1 tag=11T_WHOLE_FULL comment=API Version 2.0,MMS Version 10.4.0.4
    
47. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:25
    
48. Finished backup at 2019-12-18:16:51:35

复制代码

------最佳：

1. RMAN> run {                                   
   
2. 2> allocate channel c1 device type sbt maxopenfiles 3;
   
3. 3> allocate channel c2 device type sbt maxopenfiles 3;
   
4. 4> backup tag '12T_WHOLE_FULL' (datafile 1 channel c1 ) (datafile 2,3,4 channel c2);
   
5. 5> release channel c1;
   
6. 6> release channel c2;
   
7. 7> }
   
8. 
   
9. released channel: ORA_SBT_TAPE_1
   
10. released channel: ORA_SBT_TAPE_2
    
11. allocated channel: c1
    
12. channel c1: SID=140 device type=SBT_TAPE
    
13. channel c1: Oracle Secure Backup
    
14. 
    
15. allocated channel: c2
    
16. channel c2: SID=78 device type=SBT_TAPE
    
17. channel c2: Oracle Secure Backup
    
18. 
    
19. Starting backup at 2019-12-18:16:59:14
    
20. channel c1: starting full datafile backup set
    
21. channel c1: specifying datafile(s) in backup set
    
22. input datafile file number=00001 name=+DATA/orcl/datafile/system.283.1026941797
    
23. channel c1: starting piece 1 at 2019-12-18:16:59:15
    
24. channel c2: starting full datafile backup set
    
25. channel c2: specifying datafile(s) in backup set
    
26. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.282.1026941797
    
27. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.281.1026941797
    
28. input datafile file number=00004 name=+DATA/orcl/datafile/users.265.1026941797
    
29. channel c2: starting piece 1 at 2019-12-18:16:59:16
    

复制代码

-------------------------------

1. RMAN> backup tag '13T_USERS_FULL' tablespace users;
   
2. 
   
3. Starting backup at 2019-12-18:17:02:28
   
4. using target database control file instead of recovery catalog
   
5. allocated channel: ORA_SBT_TAPE_1
   
6. channel ORA_SBT_TAPE_1: SID=195 device type=SBT_TAPE
   
7. channel ORA_SBT_TAPE_1: Oracle Secure Backup
   
8. allocated channel: ORA_SBT_TAPE_2
   
9. channel ORA_SBT_TAPE_2: SID=68 device type=SBT_TAPE
   
10. channel ORA_SBT_TAPE_2: Oracle Secure Backup
    
11. channel ORA_SBT_TAPE_1: starting full datafile backup set
    
12. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
    
13. input datafile file number=00004 name=+DATA/orcl/datafile/users.265.1026941797
    
14. channel ORA_SBT_TAPE_1: starting piece 1 at 2019-12-18:17:02:39
    
15. channel ORA_SBT_TAPE_1: finished piece 1 at 2019-12-18:17:03:04
    
16. piece handle=1qujoelf_1_1 tag=13T_USERS_FULL comment=API Version 2.0,MMS Version 10.4.0.4
    
17. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
    
18. Finished backup at 2019-12-18:17:03:04
    

复制代码

-----

1. <blockquote>RMAN> backup tag '14T_USERS_FULL'  duration 00:05 minimize load tablespace users;

复制代码

-----开片方法：

1. RMAN> run {
   
2. 2> allocate channel c1 device type sbt maxpiecesize 100M;
   
3. 3> backup tag '15T_SYSTEM_FULL'  tablespace system ;
   
4. 4> }
   
5. 
   
6. allocated channel: c1
   
7. channel c1: SID=20 device type=SBT_TAPE
   
8. channel c1: Oracle Secure Backup
   
9. 
   
10. Starting backup at 2019-12-18:17:12:37
    
11. channel c1: starting full datafile backup set
    
12. channel c1: specifying datafile(s) in backup set
    
13. input datafile file number=00001 name=+DATA/orcl/datafile/system.283.1026941797
    
14. channel c1: starting piece 1 at 2019-12-18:17:12:38
    
15. channel c1: finished piece 1 at 2019-12-18:17:13:13
    
16. piece handle=1sujof86_1_1 tag=15T_SYSTEM_FULL comment=API Version 2.0,MMS Version 10.4.0.4
    
17. channel c1: starting piece 2 at 2019-12-18:17:13:13
    
18. channel c1: finished piece 2 at 2019-12-18:17:13:38
    
19. piece handle=1sujof86_2_1 tag=15T_SYSTEM_FULL comment=API Version 2.0,MMS Version 10.4.0.4
    
20. channel c1: starting piece 3 at 2019-12-18:17:13:38
    
21. channel c1: finished piece 3 at 2019-12-18:17:14:03
    
22. piece handle=1sujof86_3_1 tag=15T_SYSTEM_FULL comment=API Version 2.0,MMS Version 10.4.0.4
    
23. channel c1: starting piece 4 at 2019-12-18:17:14:03
    
24. channel c1: finished piece 4 at 2019-12-18:17:14:38
    
25. piece handle=1sujof86_4_1 tag=15T_SYSTEM_FULL comment=API Version 2.0,MMS Version 10.4.0.4
    
26. channel c1: starting piece 5 at 2019-12-18:17:14:38
    
27. channel c1: finished piece 5 at 2019-12-18:17:15:13
    
28. piece handle=1sujof86_5_1 tag=15T_SYSTEM_FULL comment=API Version 2.0,MMS Version 10.4.0.4
    
29. channel c1: starting piece 6 at 2019-12-18:17:15:13
    
30. channel c1: finished piece 6 at 2019-12-18:17:15:58
    
31. piece handle=1sujof86_6_1 tag=15T_SYSTEM_FULL comment=API Version 2.0,MMS Version 10.4.0.4
    
32. channel c1: starting piece 7 at 2019-12-18:17:15:58
    
33. channel c1: finished piece 7 at 2019-12-18:17:16:23
    
34. piece handle=1sujof86_7_1 tag=15T_SYSTEM_FULL comment=API Version 2.0,MMS Version 10.4.0.4
    
35. channel c1: backup set complete, elapsed time: 00:03:45
    
36. channel c1: starting full datafile backup set
    
37. channel c1: specifying datafile(s) in backup set
    
38. including current control file in backup set
    
39. including current SPFILE in backup set
    
40. channel c1: starting piece 1 at 2019-12-18:17:16:24
    
41. channel c1: finished piece 1 at 2019-12-18:17:16:49
    
42. piece handle=1tujoff7_1_1 tag=15T_SYSTEM_FULL comment=API Version 2.0,MMS Version 10.4.0.4
    
43. channel c1: backup set complete, elapsed time: 00:00:25
    
44. Finished backup at 2019-12-18:17:16:49
    
45. released channel: c1
    
46. 
    
47. RMAN>

复制代码

1. [oracle@station76 ~]$ rman target /
   
2. 
   
3. Recovery Manager: Release 11.2.0.4.0 - Production on Wed Dec 18 17:22:42 2019
   
4. 
   
5. Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
   
6. 
   
7. connected to target database: ORCL (DBID=1554722616)
   
8. 
   
9. RMAN> backup tag '16T_SYSTEM_FULL' section size 100M tablespace system;
   
10. 
    
11. Starting backup at 2019-12-18:17:22:49
    
12. using target database control file instead of recovery catalog
    
13. allocated channel: ORA_SBT_TAPE_1
    
14. channel ORA_SBT_TAPE_1: SID=143 device type=SBT_TAPE
    
15. channel ORA_SBT_TAPE_1: Oracle Secure Backup
    
16. allocated channel: ORA_SBT_TAPE_2
    
17. channel ORA_SBT_TAPE_2: SID=20 device type=SBT_TAPE
    
18. channel ORA_SBT_TAPE_2: Oracle Secure Backup
    
19. channel ORA_SBT_TAPE_1: starting full datafile backup set
    
20. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
    
21. input datafile file number=00001 name=+DATA/orcl/datafile/system.283.1026941797
    
22. backing up blocks 1 through 12800
    
23. channel ORA_SBT_TAPE_1: starting piece 1 at 2019-12-18:17:23:03
    
24. channel ORA_SBT_TAPE_2: starting full datafile backup set
    
25. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
    
26. including current control file in backup set
    
27. channel ORA_SBT_TAPE_2: starting piece 1 at 2019-12-18:17:23:04
    
28. channel ORA_SBT_TAPE_1: finished piece 1 at 2019-12-18:17:23:29
    
29. piece handle=1uujofrn_1_1 tag=16T_SYSTEM_FULL comment=API Version 2.0,MMS Version 10.4.0.4
    
30. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:26
    
31. channel ORA_SBT_TAPE_1: starting full datafile backup set
    
32. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
    
33. input datafile file number=00001 name=+DATA/orcl/datafile/system.283.1026941797
    
34. backing up blocks 12801 through 25600
    
35. channel ORA_SBT_TAPE_1: starting piece 2 at 2019-12-18:17:23:30
    
36. channel ORA_SBT_TAPE_2: finished piece 1 at 2019-12-18:17:23:30
    
37. piece handle=1vujofrn_1_1 tag=16T_SYSTEM_FULL comment=API Version 2.0,MMS Version 10.4.0.4
    
38. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:26
    
39. channel ORA_SBT_TAPE_2: starting full datafile backup set
    
40. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
    
41. input datafile file number=00001 name=+DATA/orcl/datafile/system.283.1026941797
    
42. backing up blocks 25601 through 38400
    
43. channel ORA_SBT_TAPE_2: starting piece 3 at 2019-12-18:17:23:30
    
44. channel ORA_SBT_TAPE_1: finished piece 2 at 2019-12-18:17:23:55
    
45. piece handle=1uujofrn_2_1 tag=16T_SYSTEM_FULL comment=API Version 2.0,MMS Version 10.4.0.4
    
46. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
    
47. channel ORA_SBT_TAPE_1: starting full datafile backup set
    
48. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
    
49. input datafile file number=00001 name=+DATA/orcl/datafile/system.283.1026941797
    
50. backing up blocks 38401 through 51200
    
51. channel ORA_SBT_TAPE_1: starting piece 4 at 2019-12-18:17:23:56
    
52. channel ORA_SBT_TAPE_2: finished piece 3 at 2019-12-18:17:23:57
    
53. piece handle=1uujofrn_3_1 tag=16T_SYSTEM_FULL comment=API Version 2.0,MMS Version 10.4.0.4
    
54. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:27
    
55. channel ORA_SBT_TAPE_2: starting full datafile backup set
    
56. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
    
57. input datafile file number=00001 name=+DATA/orcl/datafile/system.283.1026941797
    
58. backing up blocks 51201 through 64000
    
59. channel ORA_SBT_TAPE_2: starting piece 5 at 2019-12-18:17:23:57
    
60. channel ORA_SBT_TAPE_1: finished piece 4 at 2019-12-18:17:24:32
    
61. piece handle=1uujofrn_4_1 tag=16T_SYSTEM_FULL comment=API Version 2.0,MMS Version 10.4.0.4
    
62. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:36
    
63. channel ORA_SBT_TAPE_1: starting full datafile backup set
    
64. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
    
65. input datafile file number=00001 name=+DATA/orcl/datafile/system.283.1026941797
    
66. backing up blocks 64001 through 76800
    
67. channel ORA_SBT_TAPE_1: starting piece 6 at 2019-12-18:17:24:33
    
68. channel ORA_SBT_TAPE_2: finished piece 5 at 2019-12-18:17:24:33
    
69. piece handle=1uujofrn_5_1 tag=16T_SYSTEM_FULL comment=API Version 2.0,MMS Version 10.4.0.4
    
70. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:36
    
71. channel ORA_SBT_TAPE_2: starting full datafile backup set
    
72. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
    
73. input datafile file number=00001 name=+DATA/orcl/datafile/system.283.1026941797
    
74. backing up blocks 76801 through 89600
    
75. channel ORA_SBT_TAPE_2: starting piece 7 at 2019-12-18:17:24:33
    
76. channel ORA_SBT_TAPE_1: finished piece 6 at 2019-12-18:17:25:08
    
77. piece handle=1uujofrn_6_1 tag=16T_SYSTEM_FULL comment=API Version 2.0,MMS Version 10.4.0.4
    
78. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:35
    
79. channel ORA_SBT_TAPE_1: starting full datafile backup set
    
80. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
    
81. input datafile file number=00001 name=+DATA/orcl/datafile/system.283.1026941797
    
82. backing up blocks 89601 through 96000
    
83. channel ORA_SBT_TAPE_1: starting piece 8 at 2019-12-18:17:25:08
    
84. channel ORA_SBT_TAPE_2: finished piece 7 at 2019-12-18:17:25:08
    
85. piece handle=1uujofrn_7_1 tag=16T_SYSTEM_FULL comment=API Version 2.0,MMS Version 10.4.0.4
    
86. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:36
    
87. channel ORA_SBT_TAPE_2: starting full datafile backup set
    
88. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
    
89. including current SPFILE in backup set
    
90. channel ORA_SBT_TAPE_2: starting piece 1 at 2019-12-18:17:25:09
    
91. channel ORA_SBT_TAPE_1: finished piece 8 at 2019-12-18:17:25:34
    
92. piece handle=1uujofrn_8_1 tag=16T_SYSTEM_FULL comment=API Version 2.0,MMS Version 10.4.0.4
    
93. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:26
    
94. channel ORA_SBT_TAPE_2: finished piece 1 at 2019-12-18:17:25:34
    
95. piece handle=27ujofvl_1_1 tag=16T_SYSTEM_FULL comment=API Version 2.0,MMS Version 10.4.0.4
    
96. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:25
    
97. Finished backup at 2019-12-18:17:25:34
    
98. 
    
99. RMAN>

复制代码

主密钥默认路径：

1. select  * from v$encryption_wallet;

复制代码

	WRL_TYPE	WRL_PARAMETER	STATUS
1	file	/u01/app/oracle/wallet/orcl/	CLOSED

建目录。

--------
（如果之前有创建过TDE，先删除之前所有的加密表，然后再：truncate  table enc$;）

1. SQL> alter system set encryption key authenticated by "oracleisgreate1";
   
2. 
   
3. System altered.
   
4. 
   
5. SQL>

复制代码

1. SQL> alter system set encryption wallet open identified by "oracleisgreate1";
   
2. 
   
3. System altered.
   
4. 
   
5. SQL>

复制代码

1. 
   

复制代码

1. SQL> conn hr/oracle_4U
   
2. Connected.
   
3. SQL> create table t05304( a  number encrypt ) ;
   
4. 
   
5. Table created.
   
6. 
   
7. SQL>  create table t05304_b ( a  number  encrypt using 'AES256') ;
   
8. 
   
9. Table created.
   
10. 
    
11. SQL> insert into t05304 values (1) ;
    
12. 
    
13. 1 row created.
    
14. 
    
15. SQL> commit;
    
16. 
    
17. Commit complete.
    
18. 
    
19. SQL> insert into t05304_b values (2) ;
    
20. 
    
21. 1 row created.
    
22. 
    
23. SQL> commit;
    
24. 
    
25. Commit complete.
    
26. 
    
27. SQL>

复制代码

1. select  * from dba_encrypted_columns;

复制代码

	OWNER	TABLE_NAME	COLUMN_NAME	ENCRYPTION_ALG	SALT	INTEGRITY_ALG
1	HR	T05304	A	AES 192 bits key	YES	SHA-1
2	HR	T05304_B	A	AES 256 bits key	YES	SHA-1

同一张表，只有一个密钥：

1. SQL>  alter table t05304_b add ( b varchar2(10)  encrypt using 'AES192') ;
   
2. alter table t05304_b add ( b varchar2(10)  encrypt using 'AES192')
   
3.                             *
   
4. ERROR at line 1:
   
5. ORA-28340: a different encryption algorithm has been chosen for the table
   
6. 
   
7. 
   
8. SQL> alter table t05304_b add ( b varchar2(10)  encrypt);
   
9. 
   
10. Table altered.
    
11. 
    
12. SQL>

复制代码

测试：关闭主密钥：

1. SQL> alter system set encryption wallet close identified by "oracleisgreat1";

复制代码

改主密钥密码的时候用OWM：