课程第17次（2018-07-05星期四）

botang

TDE（默认没打开）：

1. [oracle@station86 ~]$ sqlplus /nolog
   
2. 
   
3. SQL*Plus: Release 11.2.0.1.0 Production on Thu Jul 5 19:33:55 2018
   
4. 
   
5. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
   
6. 
   
7. SQL> conn / as sysdba
   
8. Connected.
   
9. SQL> set linesize 1000
   
10. SQL> select  * from v$encryption_wallet;
    
11. 
    
12. WRL_TYPE
    
13. --------------------
    
14. WRL_PARAMETER
    
15. ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    
16. STATUS
    
17. ------------------
    
18. file
    
19. /u01/app/oracle/admin/orcl/wallet
    
20. CLOSED
    
21. 
    
22. 
    
23. SQL>
    

复制代码

制造主密钥：

1. [oracle@station86 wallet]$ sqlplus /nolog
   
2. 
   
3. SQL*Plus: Release 11.2.0.1.0 Production on Thu Jul 5 19:37:47 2018
   
4. 
   
5. Copyright (c) 1982, 2009, 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> exit
    
14. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
    
15. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
    
16. and Real Application Testing options
    
17. [oracle@station86 wallet]$ ls
    
18. ewallet.p12
    
19. [oracle@station86 wallet]$ file ewallet.p12
    
20. ewallet.p12: data
    
21. [oracle@station86 wallet]$ du -sh ewallet.p12
    
22. 4.0K        ewallet.p12
    
23. [oracle@station86 wallet]$
    

复制代码

1. [oracle@station86 wallet]$ sqlplus /nolog
   
2. 
   
3. SQL*Plus: Release 11.2.0.1.0 Production on Thu Jul 5 19:40:11 2018
   
4. 
   
5. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
   
6. 
   
7. SQL> conn / as sysdba
   
8. Connected.
   
9. SQL> select  * from v$encryption_wallet;
   
10. 
    
11. WRL_TYPE
    
12. --------------------
    
13. WRL_PARAMETER
    
14. --------------------------------------------------------------------------------
    
15. STATUS
    
16. ------------------
    
17. file
    
18. /u01/app/oracle/admin/orcl/wallet
    
19. OPEN
    
20. 
    

复制代码

1. SQL> conn hr/oracle_4U
   
2. Connected.
   
3. SQL> create table t05304_a ( a  number encrypt  using '3des168' ) ;
   
4. 
   
5. Table created.
   
6. 
   
7. SQL> insert into t05304_a values (1) ;
   
8. 
   
9. 1 row created.
   
10. 
    
11. SQL> commit;
    
12. 
    
13. Commit complete.
    
14. 
    
15. SQL> select  * from t05304_a;
    
16. 
    
17.          A
    
18. ----------
    
19.          1
    
20. 
    
21. SQL>
    

复制代码

打开和关闭主密钥：

1. SQL> conn / as sysdba
   
2. Connected.
   
3. SQL> alter system set encryption wallet close identified by "oracle1234";
   
4. alter system set encryption wallet close identified by "oracle1234"
   
5. *
   
6. ERROR at line 1:
   
7. ORA-28391: cannot close wallet or HSM, password mismatch
   
8. 
   
9. 
   
10. SQL> alter system set encryption wallet close identified by "oracle123";
    
11. 
    
12. System altered.
    
13. 
    
14. SQL> select  * from v$encryption_wallet;
    
15. 
    
16. WRL_TYPE
    
17. --------------------
    
18. WRL_PARAMETER
    
19. --------------------------------------------------------------------------------
    
20. STATUS
    
21. ------------------
    
22. file
    
23. /u01/app/oracle/admin/orcl/wallet
    
24. CLOSED
    
25. 
    
26. 
    
27. SQL> conn hr/oracle_4U
    
28. Connected.
    
29. SQL> select  * from t05304_a;
    
30. select        * from t05304_a
    
31.                *
    
32. ERROR at line 1:
    
33. ORA-28365: wallet is not open
    
34. 
    
35. 
    
36. SQL> conn / as sysdba
    
37. Connected.
    
38. SQL> alter system set encryption wallet open identified by "oracle1234";
    
39. alter system set encryption wallet open identified by "oracle1234"
    
40. *
    
41. ERROR at line 1:
    
42. ORA-28353: failed to open wallet
    
43. 
    
44. 
    
45. SQL> alter system set encryption wallet open identified by "oracle123";
    
46. 
    
47. System altered.
    
48. 
    
49. SQL> conn hr/oracle_4U
    
50. Connected.
    
51. SQL> select  * from t05304_a;
    
52. 
    
53.          A
    
54. ----------
    
55.          1
    
56. 
    
57. SQL>
    
58. 
    

复制代码

双重加密模式：

1. RMAN> set encryption identified by "oracle456"  ;
   
2. 
   
3. executing command: SET encryption
   
4. using target database control file instead of recovery catalog
   
5. 
   
6. RMAN> backup tag '5TEP_USERS_FULL' tablespace users;
   
7. 
   
8. Starting backup at 2018-07-05:20:12:12
   
9. allocated channel: ORA_SBT_TAPE_1
   
10. channel ORA_SBT_TAPE_1: SID=52 device type=SBT_TAPE
    
11. channel ORA_SBT_TAPE_1: Oracle Secure Backup
    
12. allocated channel: ORA_SBT_TAPE_2
    
13. channel ORA_SBT_TAPE_2: SID=57 device type=SBT_TAPE
    
14. channel ORA_SBT_TAPE_2: Oracle Secure Backup
    
15. channel ORA_SBT_TAPE_1: starting full datafile backup set
    
16. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
    
17. input datafile file number=00004 name=+DATA/orcl/datafile/users.265.980712241
    
18. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-07-05:20:12:24
    
19. RMAN-00571: ===========================================================
    
20. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    
21. RMAN-00571: ===========================================================
    
22. RMAN-03009: failure of backup command on ORA_SBT_TAPE_1 channel at 07/05/2018 20:12:25
    
23. ORA-19914: unable to encrypt backup
    
24. ORA-28365: wallet is not open
    
25. 
    
26. RMAN> backup tag '5TEP_USERS_FULL' tablespace users;
    
27. 
    
28. Starting backup at 2018-07-05:20:12:42
    
29. using channel ORA_SBT_TAPE_1
    
30. using channel ORA_SBT_TAPE_2
    
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=00004 name=+DATA/orcl/datafile/users.265.980712241
    
34. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-07-05:20:12:42
    
35. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-07-05:20:13:47
    
36. piece handle=45t78v9q_1_1 tag=5TEP_USERS_FULL comment=API Version 2.0,MMS Version 10.3.0.2
    
37. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:01:05
    
38. Finished backup at 2018-07-05:20:13:47
    
39. 
    
40. Starting Control File and SPFILE Autobackup at 2018-07-05:20:13:48
    
41. piece handle=c-1359978017-20180705-01 comment=API Version 2.0,MMS Version 10.3.0.2
    
42. Finished Control File and SPFILE Autobackup at 2018-07-05:20:14:23
    
43. 
    
44. RMAN>
    

复制代码

用口令解密：

1. [oracle@station86 wallet]$ rman target /
   
2. 
   
3. Recovery Manager: Release 11.2.0.1.0 - Production on Thu Jul 5 20:18:19 2018
   
4. 
   
5. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
   
6. 
   
7. connected to target database: ORCL (DBID=1359978017)
   
8. 
   
9. RMAN> restore datafile 4;
   
10. 
    
11. Starting restore at 2018-07-05:20:18:25
    
12. using target database control file instead of recovery catalog
    
13. allocated channel: ORA_DISK_1
    
14. channel ORA_DISK_1: SID=143 device type=DISK
    
15. allocated channel: ORA_DISK_2
    
16. channel ORA_DISK_2: SID=52 device type=DISK
    
17. allocated channel: ORA_DISK_3
    
18. channel ORA_DISK_3: SID=10 device type=DISK
    
19. allocated channel: ORA_DISK_4
    
20. channel ORA_DISK_4: SID=53 device type=DISK
    
21. allocated channel: ORA_DISK_5
    
22. channel ORA_DISK_5: SID=103 device type=DISK
    
23. allocated channel: ORA_DISK_6
    
24. channel ORA_DISK_6: SID=56 device type=DISK
    
25. allocated channel: ORA_DISK_7
    
26. channel ORA_DISK_7: SID=102 device type=DISK
    
27. allocated channel: ORA_DISK_8
    
28. channel ORA_DISK_8: SID=141 device type=DISK
    
29. allocated channel: ORA_SBT_TAPE_1
    
30. channel ORA_SBT_TAPE_1: SID=11 device type=SBT_TAPE
    
31. channel ORA_SBT_TAPE_1: Oracle Secure Backup
    
32. allocated channel: ORA_SBT_TAPE_2
    
33. channel ORA_SBT_TAPE_2: SID=100 device type=SBT_TAPE
    
34. channel ORA_SBT_TAPE_2: Oracle Secure Backup
    
35. 
    
36. channel ORA_SBT_TAPE_1: starting datafile backup set restore
    
37. channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
    
38. channel ORA_SBT_TAPE_1: restoring datafile 00004 to +DATA/orcl/datafile/users.265.980712241
    
39. channel ORA_SBT_TAPE_1: reading from backup piece 45t78v9q_1_1
    
40. RMAN-00571: ===========================================================
    
41. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    
42. RMAN-00571: ===========================================================
    
43. RMAN-03002: failure of restore command at 07/05/2018 20:19:24
    
44. ORA-19870: error while restoring backup piece 45t78v9q_1_1
    
45. ORA-19913: unable to decrypt backup
    
46. ORA-28365: wallet is not open
    
47. 
    
48. RMAN> set decryption identified by "java123","microsoft123","redhat123","oracle123","oracle456";
    
49. 
    
50. executing command: SET decryption
    
51. 
    
52. RMAN> restore datafile 4;
    
53. 
    
54. Starting restore at 2018-07-05:20:21:11
    
55. using channel ORA_DISK_1
    
56. using channel ORA_DISK_2
    
57. using channel ORA_DISK_3
    
58. using channel ORA_DISK_4
    
59. using channel ORA_DISK_5
    
60. using channel ORA_DISK_6
    
61. using channel ORA_DISK_7
    
62. using channel ORA_DISK_8
    
63. using channel ORA_SBT_TAPE_1
    
64. using channel ORA_SBT_TAPE_2
    
65. 
    
66. channel ORA_SBT_TAPE_1: starting datafile backup set restore
    
67. channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
    
68. channel ORA_SBT_TAPE_1: restoring datafile 00004 to +DATA/orcl/datafile/users.265.980712241
    
69. channel ORA_SBT_TAPE_1: reading from backup piece 45t78v9q_1_1
    
70. channel ORA_SBT_TAPE_1: piece handle=45t78v9q_1_1 tag=5TEP_USERS_FULL
    
71. channel ORA_SBT_TAPE_1: restored backup piece 1
    
72. channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:41
    
73. Finished restore at 2018-07-05:20:21:53
    
74. 
    
75. RMAN> recover datafile 4;
    
76. 
    
77. Starting recover at 2018-07-05:20:22:32
    
78. using channel ORA_DISK_1
    
79. using channel ORA_DISK_2
    
80. using channel ORA_DISK_3
    
81. using channel ORA_DISK_4
    
82. using channel ORA_DISK_5
    
83. using channel ORA_DISK_6
    
84. using channel ORA_DISK_7
    
85. using channel ORA_DISK_8
    
86. using channel ORA_SBT_TAPE_1
    
87. using channel ORA_SBT_TAPE_2
    
88. 
    
89. starting media recovery
    
90. 
    
91. archived log for thread 1 with sequence 59 is already on disk as file +FRA/orcl/archivelog/2018_07_05/thread_1_seq_59.313.980713007
    
92. archived log for thread 1 with sequence 60 is already on disk as file +FRA/orcl/archivelog/2018_07_05/thread_1_seq_60.346.980713009
    
93. archived log for thread 1 with sequence 61 is already on disk as file +FRA/orcl/archivelog/2018_07_05/thread_1_seq_61.342.980713009
    
94. archived log for thread 1 with sequence 62 is already on disk as file +FRA/orcl/archivelog/2018_07_05/thread_1_seq_62.353.980713013
    
95. archived log for thread 1 with sequence 63 is already on disk as file +FRA/orcl/archivelog/2018_07_05/thread_1_seq_63.258.980713015
    
96. archived log for thread 1 with sequence 64 is already on disk as file +FRA/orcl/archivelog/2018_07_05/thread_1_seq_64.267.980713015
    
97. archived log file name=+FRA/orcl/archivelog/2018_07_05/thread_1_seq_59.313.980713007 thread=1 sequence=59
    
98. archived log file name=+FRA/orcl/archivelog/2018_07_05/thread_1_seq_60.346.980713009 thread=1 sequence=60
    
99. archived log file name=+FRA/orcl/archivelog/2018_07_05/thread_1_seq_61.342.980713009 thread=1 sequence=61
    
100. archived log file name=+FRA/orcl/archivelog/2018_07_05/thread_1_seq_62.353.980713013 thread=1 sequence=62
     
101. media recovery complete, elapsed time: 00:00:01
     
102. Finished recover at 2018-07-05:20:22:34
     
103. 
     
104. RMAN> sql "alter tablespace users online";
     
105. 
     
106. sql statement: alter tablespace users online
     
107. 
     

复制代码

或者用TDE解密：

1. [oracle@station86 wallet]$ rman target /
   
2. 
   
3. Recovery Manager: Release 11.2.0.1.0 - Production on Thu Jul 5 20:28:01 2018
   
4. 
   
5. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
   
6. 
   
7. connected to target database: ORCL (DBID=1359978017)
   
8. 
   
9. RMAN> restore datafile 4;
   
10. 
    
11. Starting restore at 2018-07-05:20:28:07
    
12. using target database control file instead of recovery catalog
    
13. allocated channel: ORA_DISK_1
    
14. channel ORA_DISK_1: SID=56 device type=DISK
    
15. allocated channel: ORA_DISK_2
    
16. channel ORA_DISK_2: SID=100 device type=DISK
    
17. allocated channel: ORA_DISK_3
    
18. channel ORA_DISK_3: SID=52 device type=DISK
    
19. allocated channel: ORA_DISK_4
    
20. channel ORA_DISK_4: SID=103 device type=DISK
    
21. allocated channel: ORA_DISK_5
    
22. channel ORA_DISK_5: SID=141 device type=DISK
    
23. allocated channel: ORA_DISK_6
    
24. channel ORA_DISK_6: SID=12 device type=DISK
    
25. allocated channel: ORA_DISK_7
    
26. channel ORA_DISK_7: SID=57 device type=DISK
    
27. allocated channel: ORA_DISK_8
    
28. channel ORA_DISK_8: SID=102 device type=DISK
    
29. allocated channel: ORA_SBT_TAPE_1
    
30. channel ORA_SBT_TAPE_1: SID=143 device type=SBT_TAPE
    
31. channel ORA_SBT_TAPE_1: Oracle Secure Backup
    
32. allocated channel: ORA_SBT_TAPE_2
    
33. channel ORA_SBT_TAPE_2: SID=11 device type=SBT_TAPE
    
34. channel ORA_SBT_TAPE_2: Oracle Secure Backup
    
35. 
    
36. channel ORA_SBT_TAPE_1: starting datafile backup set restore
    
37. channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
    
38. channel ORA_SBT_TAPE_1: restoring datafile 00004 to +DATA/orcl/datafile/users.265.980713303
    
39. channel ORA_SBT_TAPE_1: reading from backup piece 45t78v9q_1_1
    
40. channel ORA_SBT_TAPE_1: piece handle=45t78v9q_1_1 tag=5TEP_USERS_FULL
    
41. channel ORA_SBT_TAPE_1: restored backup piece 1
    
42. channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:55
    
43. Finished restore at 2018-07-05:20:29:16
    
44. 
    
45. RMAN> recover datafile 4;
    
46. 
    
47. Starting recover at 2018-07-05:20:29:22
    
48. using channel ORA_DISK_1
    
49. using channel ORA_DISK_2
    
50. using channel ORA_DISK_3
    
51. using channel ORA_DISK_4
    
52. using channel ORA_DISK_5
    
53. using channel ORA_DISK_6
    
54. using channel ORA_DISK_7
    
55. using channel ORA_DISK_8
    
56. using channel ORA_SBT_TAPE_1
    
57. using channel ORA_SBT_TAPE_2
    
58. 
    
59. starting media recovery
    
60. 
    
61. archived log for thread 1 with sequence 59 is already on disk as file +FRA/orcl/archivelog/2018_07_05/thread_1_seq_59.313.980713007
    
62. archived log for thread 1 with sequence 60 is already on disk as file +FRA/orcl/archivelog/2018_07_05/thread_1_seq_60.346.980713009
    
63. archived log for thread 1 with sequence 61 is already on disk as file +FRA/orcl/archivelog/2018_07_05/thread_1_seq_61.342.980713009
    
64. archived log for thread 1 with sequence 62 is already on disk as file +FRA/orcl/archivelog/2018_07_05/thread_1_seq_62.353.980713013
    
65. archived log for thread 1 with sequence 63 is already on disk as file +FRA/orcl/archivelog/2018_07_05/thread_1_seq_63.258.980713015
    
66. archived log for thread 1 with sequence 64 is already on disk as file +FRA/orcl/archivelog/2018_07_05/thread_1_seq_64.267.980713015
    
67. archived log for thread 1 with sequence 65 is already on disk as file +FRA/orcl/archivelog/2018_07_05/thread_1_seq_65.354.980713601
    
68. archived log for thread 1 with sequence 66 is already on disk as file +FRA/orcl/archivelog/2018_07_05/thread_1_seq_66.338.980713603
    
69. archived log for thread 1 with sequence 67 is already on disk as file +FRA/orcl/archivelog/2018_07_05/thread_1_seq_67.330.980713605
    
70. archived log for thread 1 with sequence 68 is already on disk as file +FRA/orcl/archivelog/2018_07_05/thread_1_seq_68.355.980713607
    
71. archived log for thread 1 with sequence 69 is already on disk as file +FRA/orcl/archivelog/2018_07_05/thread_1_seq_69.286.980713611
    
72. archived log for thread 1 with sequence 70 is already on disk as file +FRA/orcl/archivelog/2018_07_05/thread_1_seq_70.257.980713611
    
73. archived log file name=+FRA/orcl/archivelog/2018_07_05/thread_1_seq_59.313.980713007 thread=1 sequence=59
    
74. archived log file name=+FRA/orcl/archivelog/2018_07_05/thread_1_seq_60.346.980713009 thread=1 sequence=60
    
75. archived log file name=+FRA/orcl/archivelog/2018_07_05/thread_1_seq_61.342.980713009 thread=1 sequence=61
    
76. archived log file name=+FRA/orcl/archivelog/2018_07_05/thread_1_seq_62.353.980713013 thread=1 sequence=62
    
77. archived log file name=+FRA/orcl/archivelog/2018_07_05/thread_1_seq_63.258.980713015 thread=1 sequence=63
    
78. archived log file name=+FRA/orcl/archivelog/2018_07_05/thread_1_seq_64.267.980713015 thread=1 sequence=64
    
79. archived log file name=+FRA/orcl/archivelog/2018_07_05/thread_1_seq_65.354.980713601 thread=1 sequence=65
    
80. archived log file name=+FRA/orcl/archivelog/2018_07_05/thread_1_seq_66.338.980713603 thread=1 sequence=66
    
81. archived log file name=+FRA/orcl/archivelog/2018_07_05/thread_1_seq_67.330.980713605 thread=1 sequence=67
    
82. archived log file name=+FRA/orcl/archivelog/2018_07_05/thread_1_seq_68.355.980713607 thread=1 sequence=68
    
83. media recovery complete, elapsed time: 00:00:02
    
84. Finished recover at 2018-07-05:20:29:25
    
85. 
    
86. RMAN> sql "alter tablespace users online";
    
87. 
    
88. sql statement: alter tablespace users online
    
89. 
    
90. RMAN>
    

复制代码

改主密钥：



关于cumulative：

1. RMAN> backup tag '6TE_USERS_INCR0' incremental level 0 tablespace users;
   
2. 
   
3. Starting backup at 2018-07-05:21:14: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. using channel ORA_SBT_TAPE_1
    
13. using channel ORA_SBT_TAPE_2
    
14. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
    
15. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
    
16. input datafile file number=00004 name=+DATA/orcl/datafile/users.265.980714801
    
17. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-07-05:21:14:29
    
18. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-07-05:21:15:24
    
19. piece handle=49t792tl_1_1 tag=6TE_USERS_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
    
20. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:55
    
21. Finished backup at 2018-07-05:21:15:24
    
22. 
    
23. Starting Control File and SPFILE Autobackup at 2018-07-05:21:15:24
    
24. piece handle=c-1359978017-20180705-04 comment=API Version 2.0,MMS Version 10.3.0.2
    
25. Finished Control File and SPFILE Autobackup at 2018-07-05:21:16:09
    
26. 
    
27. RMAN>
    
28. 
    
29. RMAN>
    
30. 
    
31. RMAN> backup tag '7TE_USERS_INCR1' incremental level 1 tablespace users;
    
32. 
    
33. Starting backup at 2018-07-05:21:16:28
    
34. using channel ORA_SBT_TAPE_1
    
35. using channel ORA_SBT_TAPE_2
    
36. channel ORA_SBT_TAPE_1: starting incremental level 1 datafile backup set
    
37. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
    
38. input datafile file number=00004 name=+DATA/orcl/datafile/users.265.980714801
    
39. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-07-05:21:16:28
    
40. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-07-05:21:17:03
    
41. piece handle=4bt7931c_1_1 tag=7TE_USERS_INCR1 comment=API Version 2.0,MMS Version 10.3.0.2
    
42. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:35
    
43. Finished backup at 2018-07-05:21:17:03
    
44. 
    
45. Starting Control File and SPFILE Autobackup at 2018-07-05:21:17:03
    
46. piece handle=c-1359978017-20180705-05 comment=API Version 2.0,MMS Version 10.3.0.2
    
47. Finished Control File and SPFILE Autobackup at 2018-07-05:21:17:48
    
48. 
    
49. RMAN> report need backup  incremental  1;
    
50. 
    
51. Report of files that need more than 1 incrementals during recovery
    
52. File Incrementals Name
    
53. ---- ------------ ----------------------------------------------
    
54. 
    
55. RMAN> report need backup  incremental  0;
    
56. 
    
57. Report of files that need more than 0 incrementals during recovery
    
58. File Incrementals Name
    
59. ---- ------------ ----------------------------------------------
    
60. 4    1            +DATA/orcl/datafile/users.265.980714801
    
61. 
    
62. RMAN> report need backup  incremental  1;
    
63. 
    
64. Report of files that need more than 1 incrementals during recovery
    
65. File Incrementals Name
    
66. ---- ------------ ----------------------------------------------
    
67. 
    
68. RMAN> backup tag '8TE_USERS_INCR1' incremental level 1 tablespace users;
    
69. 
    
70. Starting backup at 2018-07-05:21:19:21
    
71. using channel ORA_SBT_TAPE_1
    
72. using channel ORA_SBT_TAPE_2
    
73. channel ORA_SBT_TAPE_1: starting incremental level 1 datafile backup set
    
74. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
    
75. input datafile file number=00004 name=+DATA/orcl/datafile/users.265.980714801
    
76. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-07-05:21:19:21
    
77. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-07-05:21:19:56
    
78. piece handle=4dt7936p_1_1 tag=8TE_USERS_INCR1 comment=API Version 2.0,MMS Version 10.3.0.2
    
79. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:35
    
80. Finished backup at 2018-07-05:21:19:56
    
81. 
    
82. Starting Control File and SPFILE Autobackup at 2018-07-05:21:19:56
    
83. piece handle=c-1359978017-20180705-06 comment=API Version 2.0,MMS Version 10.3.0.2
    
84. Finished Control File and SPFILE Autobackup at 2018-07-05:21:20:31
    
85. 
    
86. RMAN> report need backup  incremental  1;
    
87. 
    
88. Report of files that need more than 1 incrementals during recovery
    
89. File Incrementals Name
    
90. ---- ------------ ----------------------------------------------
    
91. 4    2            +DATA/orcl/datafile/users.265.980714801
    
92. 
    
93. RMAN> backup tag '9TE_USERS_INCR1' incremental level 1 cumulative tablespace users;
    
94. 
    
95. Starting backup at 2018-07-05:21:22:39
    
96. using channel ORA_SBT_TAPE_1
    
97. using channel ORA_SBT_TAPE_2
    
98. channel ORA_SBT_TAPE_1: starting incremental level 1 datafile backup set
    
99. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
    
100. input datafile file number=00004 name=+DATA/orcl/datafile/users.265.980714801
     
101. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-07-05:21:22:39
     
102. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-07-05:21:23:24
     
103. piece handle=4ft793cv_1_1 tag=9TE_USERS_INCR1 comment=API Version 2.0,MMS Version 10.3.0.2
     
104. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:45
     
105. Finished backup at 2018-07-05:21:23:24
     
106. 
     
107. Starting Control File and SPFILE Autobackup at 2018-07-05:21:23:25
     
108. piece handle=c-1359978017-20180705-07 comment=API Version 2.0,MMS Version 10.3.0.2
     
109. Finished Control File and SPFILE Autobackup at 2018-07-05:21:24:00
     
110. 
     
111. RMAN> report need backup  incremental  1;
     
112. 
     
113. Report of files that need more than 1 incrementals during recovery
     
114. File Incrementals Name
     
115. ---- ------------ ----------------------------------------------
     
116. 
     
117. RMAN> report need backup  incremental  0;
     
118. 
     
119. Report of files that need more than 0 incrementals during recovery
     
120. File Incrementals Name
     
121. ---- ------------ ----------------------------------------------
     
122. 4    1            +DATA/orcl/datafile/users.265.980714801
     
123. 
     
124. RMAN>
     
125. 
     

复制代码

块跟踪：

1. SQL> alter database enable block change tracking using file '+FRA';
   
2. 
   
3. Database altered.
   
4. 
   
5. SQL> select  * from v$block_change_tracking;
   
6. 
   
7. STATUS           FILENAME                                                                                                                          BYTES
   
8. ---------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------
   
9. ENABLED    +FRA/orcl/changetracking/ctf.358.980717365                                                                                               11599872
   
10. 
    
11. SQL>
    
12. SQL>
    

复制代码

chenmd

老师实验0和实验1a的备份是全库备份吗？

botang

chenmd 发表于 2018-7-7 08:58
老师实验0和实验1a的备份是全库备份吗？

实验0的是手工全库冷备份。