课程第30次

botang

2019-07-22

闪回区里头不能放一模一样的东西。

1. RMAN> run {
   
2. 2> allocate channel c1 device type disk ;
   
3. 3> allocate channel c2 device type disk;
   
4. 4> backup copies 2 datafile 4;
   
5. 5> release channel c1;
   
6. 6> release channel c2;
   
7. 7> }
   
8. 
   
9. allocated channel: c1
   
10. channel c1: SID=46 device type=DISK
    
11. 
    
12. allocated channel: c2
    
13. channel c2: SID=47 device type=DISK
    
14. 
    
15. Starting backup at 2019-07-22:20:19:03
    
16. channel c1: starting full datafile backup set
    
17. channel c1: specifying datafile(s) in backup set
    
18. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.1013960885
    
19. channel c1: starting piece 1 at 2019-07-22:20:19:03
    
20. released channel: c1
    
21. released channel: c2
    
22. RMAN-00571: ===========================================================
    
23. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    
24. RMAN-00571: ===========================================================
    
25. RMAN-03009: failure of backup command on c1 channel at 07/22/2019 20:19:04
    
26. ORA-19806: cannot make duplex backups in recovery area
    
27. 
    
28. RMAN>
    

复制代码

1. RMAN>  run {
   
2. 2>  allocate channel c1 device type disk format '/home/oracle/backup1/%U';
   
3. 3> allocate channel c2  device type disk format '/home/oracle/backup2/%U';
   
4. 4> backup copies 2 datafile 4;
   
5. 5> release channel c1;
   
6. 6>  release channel c2;
   
7. 7> }
   
8. 
   
9. allocated channel: c1
   
10. channel c1: SID=46 device type=DISK
    
11. 
    
12. allocated channel: c2
    
13. channel c2: SID=47 device type=DISK
    
14. 
    
15. Starting backup at 2019-07-22:20:25:52
    
16. channel c1: starting full datafile backup set
    
17. channel c1: specifying datafile(s) in backup set
    
18. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.1013960885
    
19. channel c1: starting piece 1 at 2019-07-22:20:25:52
    
20. channel c1: finished piece 1 at 2019-07-22:20:25:53 with 2 copies and tag TAG20190722T202552
    
21. piece handle=/home/oracle/backup1/28u7alug_1_1 comment=NONE
    
22. piece handle=/home/oracle/backup1/28u7alug_1_2 comment=NONE
    
23. channel c1: backup set complete, elapsed time: 00:00:01
    
24. Finished backup at 2019-07-22:20:25:53
    
25. 
    
26. Starting Control File and SPFILE Autobackup at 2019-07-22:20:25:53
    
27. piece handle=+FRA/orcl/autobackup/2019_07_22/s_1014323153.301.1014323155 comment=NONE
    
28. Finished Control File and SPFILE Autobackup at 2019-07-22:20:25:56
    
29. 
    
30. released channel: c1
    
31. 
    
32. released channel: c2
    
33. 
    
34. RMAN>
    

复制代码

------------------------------------------------------------------------------------一个备份集下面两个以上备份片的情况：

1. maxpiecesize
2. copies

1. RMAN> backup copies 2 datafile 4;
   
2. 
   
3. Starting backup at 2019-07-22:20:31:29
   
4. released channel: ORA_DISK_1
   
5. released channel: ORA_DISK_2
   
6. released channel: ORA_DISK_3
   
7. released channel: ORA_DISK_4
   
8. released channel: ORA_DISK_5
   
9. released channel: ORA_DISK_6
   
10. released channel: ORA_DISK_7
    
11. released channel: ORA_DISK_8
    
12. allocated channel: ORA_SBT_TAPE_1
    
13. channel ORA_SBT_TAPE_1: SID=46 device type=SBT_TAPE
    
14. channel ORA_SBT_TAPE_1: Oracle Secure Backup
    
15. allocated channel: ORA_SBT_TAPE_2
    
16. channel ORA_SBT_TAPE_2: SID=47 device type=SBT_TAPE
    
17. channel ORA_SBT_TAPE_2: Oracle Secure Backup
    
18. channel ORA_SBT_TAPE_1: starting full datafile backup set
    
19. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
    
20. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.1013960885
    
21. channel ORA_SBT_TAPE_1: starting piece 1 at 2019-07-22:20:31:40
    
22. channel ORA_SBT_TAPE_1: finished piece 1 at 2019-07-22:20:32:25 with 2 copies and tag TAG20190722T203139
    
23. piece handle=2au7am9c_1_1 comment=API Version 2.0,MMS Version 10.4.0.4
    
24. piece handle=2au7am9c_1_2 comment=API Version 2.0,MMS Version 10.4.0.4
    
25. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:45
    
26. Finished backup at 2019-07-22:20:32:25
    
27. 
    
28. Starting Control File and SPFILE Autobackup at 2019-07-22:20:32:25
    
29. piece handle=c-1541741703-20190722-01 comment=API Version 2.0,MMS Version 10.4.0.4
    
30. piece handle=c-1541741703-20190722-02 comment=API Version 2.0,MMS Version 10.4.0.4
    
31. Finished Control File and SPFILE Autobackup at 2019-07-22:20:33:00
    
32. 
    
33. RMAN> list backup;
    
34. 
    
35. 
    
36. List of Backup Sets
    
37. ===================
    
38. 
    
39. 
    
40. BS Key  Type LV Size
    
41. ------- ---- -- ----------
    
42. 70      Full    3.50M
    
43.   List of Datafiles in backup set 70
    
44.   File LV Type Ckp SCN    Ckp Time            Name
    
45.   ---- -- ---- ---------- ------------------- ----
    
46.   4       Full 1228664    2019-07-24:00:04:56 +DATA/orcl/datafile/users.259.1013960885
    
47. 
    
48.   Backup Set Copy #1 of backup set 70
    
49.   Device Type Elapsed Time Completion Time     Compressed Tag
    
50.   ----------- ------------ ------------------- ---------- ---
    
51.   SBT_TAPE    00:00:37     2019-07-22:20:32:17 NO         TAG20190722T203139
    
52. 
    
53.     List of Backup Pieces for backup set 70 Copy #1
    
54.     BP Key  Pc# Status      Media                   Piece Name
    
55.     ------- --- ----------- ----------------------- ----------
    
56.     91      1   AVAILABLE   RMAN-DEFAULT-000001     2au7am9c_1_1
    
57. 
    
58.   Backup Set Copy #2 of backup set 70
    
59.   Device Type Elapsed Time Completion Time     Compressed Tag
    
60.   ----------- ------------ ------------------- ---------- ---
    
61.   SBT_TAPE    00:00:37     2019-07-22:20:32:17 NO         TAG20190722T203139
    
62. 
    
63.     List of Backup Pieces for backup set 70 Copy #2
    
64.     BP Key  Pc# Status      Media                   Piece Name
    
65.     ------- --- ----------- ----------------------- ----------
    
66.     92      1   AVAILABLE   RMAN-DEFAULT-000002     2au7am9c_1_2
    
67. 
    
68. BS Key  Type LV Size
    
69. ------- ---- -- ----------
    
70. 71      Full    9.75M
    
71.   SPFILE Included: Modification time: 2019-07-22:19:58:37
    
72.   SPFILE db_unique_name: ORCL
    
73.   Control File Included: Ckp SCN: 1277835      Ckp time: 2019-07-22:20:32:25
    
74. 
    
75.   Backup Set Copy #1 of backup set 71
    
76.   Device Type Elapsed Time Completion Time     Compressed Tag
    
77.   ----------- ------------ ------------------- ---------- ---
    
78.   SBT_TAPE    00:00:28     2019-07-22:20:32:53 NO         TAG20190722T203225
    
79. 
    
80.     List of Backup Pieces for backup set 71 Copy #1
    
81.     BP Key  Pc# Status      Media                   Piece Name
    
82.     ------- --- ----------- ----------------------- ----------
    
83.     93      1   AVAILABLE   RMAN-DEFAULT-000001     c-1541741703-20190722-01
    
84. 
    
85.   Backup Set Copy #2 of backup set 71
    
86.   Device Type Elapsed Time Completion Time     Compressed Tag
    
87.   ----------- ------------ ------------------- ---------- ---
    
88.   SBT_TAPE    00:00:28     2019-07-22:20:32:53 NO         TAG20190722T203225
    
89. 
    
90.     List of Backup Pieces for backup set 71 Copy #2
    
91.     BP Key  Pc# Status      Media                   Piece Name
    
92.     ------- --- ----------- ----------------------- ----------
    
93.     94      1   AVAILABLE   RMAN-DEFAULT-000002     c-1541741703-20190722-02
    
94. 
    
95. RMAN>
    

复制代码

1. [root@station76 stage]# obtool
   
2. ob> lsvol -L lib01 -l
   
3. Inventory of library lib01:
   
4.     in    1:             vacant
   
5.     in    2:             vacant
   
6.     in    3:             barcode E01003L4, oid 168, 510976 kb remaining
   
7.     in    4:             barcode E01004L4, oid 170, 510976 kb remaining
   
8.     in    5:             barcode E01005L4, oid 172, 510976 kb remaining
   
9.     in    6:             barcode E01006L4, oid 105
   
10.     in    7:             barcode E01007L4, oid 106
    
11.     in    8:             barcode E01008L4, oid 107
    
12.     in    9:             barcode E01009L4, oid 108
    
13.     in    10:            barcode E01010L4, oid 109
    
14.     in    11:            barcode E01011L4, oid 110
    
15.     in    12:            barcode E01012L4, oid 111
    
16.     in    13:            barcode E01013L4, oid 112
    
17.     in    14:            barcode E01014L4, oid 113
    
18.     in    15:            barcode E01015L4, oid 114
    
19.     in    16:            barcode E01016L4, oid 115
    
20.     in    17:            barcode E01017L4, oid 116
    
21.     in    18:            barcode E01018L4, oid 117
    
22.     in    19:            barcode E01019L4, oid 118
    
23.     in    20:            barcode E01020L4, oid 119
    
24.     in    21:            vacant
    
25.     in    22:            barcode CLN101L4, oid 120
    
26.     in    23:            barcode CLN102L5, oid 121
    
27.     in    24:            vacant
    
28.     in    25:            vacant
    
29.     in    26:            vacant
    
30.     in    27:            vacant
    
31.     in    28:            vacant
    
32.     in    29:            vacant
    
33.     in    30:            barcode F01030L5, oid 122
    
34.     in    31:            barcode F01031L5, oid 123
    
35.     in    32:            barcode F01032L5, oid 124
    
36.     in    33:            barcode F01033L5, oid 125
    
37.     in    34:            barcode F01034L5, oid 126
    
38.     in    35:            barcode F01035L5, oid 127
    
39.     in    36:            barcode F01036L5, oid 128
    
40.     in    37:            barcode F01037L5, oid 129
    
41.     in    38:            barcode F01038L5, oid 130
    
42.     in    39:            barcode F01039L5, oid 131
    
43.     in    iee1:          vacant
    
44.     in    iee2:          vacant
    
45.     in    iee3:          vacant
    
46.     in    iee4:          vacant
    
47.     in    dte1:          vacant
    
48.     in    dte2:          vacant
    
49.     in    dte3:          volume RMAN-DEFAULT-000001, barcode E01001L4, oid 173,                 510976 kb remaining, content manages reuse, lastse 1
    
50.     in    dte4:          volume RMAN-DEFAULT-000002, barcode E01002L4, oid 174,                 510976 kb remaining, content manages reuse, lastse 2
    
51. ob>
    

复制代码

11.2.0.1钱包的路径在这里：

1. /u01/app/oracle/admin/orcl/wallet

复制代码

11.2.0.4建这个目录：

1. /u01/app/oracle/wallet/orcl/

复制代码

owm（所有问题回答no）
存ewallet.p12到以上目录

1. [oracle@station76 orcl]$ sqlplus /nolog
   
2. 
   
3. SQL*Plus: Release 11.2.0.4.0 Production on Mon Jul 22 21:41:01 2019
   
4. 
   
5. Copyright (c) 1982, 2013, Oracle.  All rights reserved.
   
6. 
   
7. SQL> conn / as sysdba
   
8. Connected.
   
9. SQL> alter system set encryption key identified by "oracle123";
   
10. 
    
11. System altered.
    
12. 
    
13. SQL>
    

复制代码

关闭和打开钱包的命令：

1. SQL> alter system set encryption wallet close ;
   
2. alter system set encryption wallet close
   
3. *
   
4. ERROR at line 1:
   
5. ORA-28390: auto login wallet not open but encryption wallet may be open
   
6. 
   
7. 
   
8. SQL>  alter system set encryption wallet close identified by "oracle1234";
   
9. alter system set encryption wallet close identified by "oracle1234"
   
10. *
    
11. ERROR at line 1:
    
12. ORA-28391: cannot close wallet or HSM, password mismatch
    
13. 
    
14. 
    
15. SQL>  alter system set encryption wallet close identified by "oracle123";
    
16. 
    
17. System altered.
    
18. 
    
19. SQL>  alter system set encryption wallet  open identified by "oracle123";
    
20. 
    
21. System altered.
    
22. 
    

复制代码

整个数据库只有一个密钥（主密钥），列密钥（dba_encryption_columns）的生成和解密都不需要你去干预。

1. SQL> conn hr/oracle_4U
   
2. Connected.
   
3. SQL> create table t05304( a number encrypt ) ;
   
4. 
   
5. Table created.
   
6. 
   
7. SQL> insert into t05304 values (1);
   
8. insert into t05304 values (1)
   
9.             *
   
10. ERROR at line 1:
    
11. ORA-01647: tablespace 'USERS' is read-only, cannot allocate space in it
    
12. 
    
13. 
    
14. SQL>  insert into t05304 values (1);
    
15. 
    
16. 1 row created.
    
17. 
    
18. SQL> commit;
    
19. 
    
20. Commit complete.
    
21. 
    
22. SQL> select * from t05304;
    
23. 
    
24.          A
    
25. ----------
    
26.          1
    
27. 
    
28. SQL>  select * from t05304;
    
29. select * from t05304
    
30.                *
    
31. ERROR at line 1:
    
32. ORA-28365: wallet is not open
    
33. 
    
34. 
    

复制代码