课程第16次（2018-07-03星期二）

botang

关于exclude：

1. RMAN> CONFIGURE  exclude for tablespace users;
   
2. 
   
3. Tablespace USERS will be excluded from future whole database backups
   
4. new RMAN configuration parameters are successfully stored
   
5. 
   
6. RMAN> show all;
   
7. 
   
8. RMAN configuration parameters for database with db_unique_name ORCL are:
   
9. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
   
10. CONFIGURE BACKUP OPTIMIZATION ON;
    
11. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
    
12. CONFIGURE CONTROLFILE AUTOBACKUP ON;
    
13. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
    
14. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
    
15. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
    
16. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
    
17. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
    
18. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
    
19. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
    
20. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
    
21. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station86)';
    
22. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station86)';
    
23. CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station86)';
    
24. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
    
25. CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
    
26. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
    
27. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
    
28. CONFIGURE EXCLUDE FOR TABLESPACE 'USERS';
    
29. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
    
30. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default
    
31. 
    
32. RMAN> show EXCLUDE;
    
33. 
    
34. RMAN configuration parameters for database with db_unique_name ORCL are:
    
35. CONFIGURE EXCLUDE FOR TABLESPACE 'USERS';
    
36. 
    
37. RMAN> backup tag 'T7' database;
    
38. 
    
39. Starting backup at 2018-07-02:00:12:34
    
40. using channel ORA_SBT_TAPE_1
    
41. using channel ORA_SBT_TAPE_2
    
42. file 4 is excluded from whole database backup
    
43. channel ORA_SBT_TAPE_1: starting full datafile backup set
    
44. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
    
45. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.267.979847755
    
46. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.979847755
    
47. input datafile file number=00007 name=+DATA/orcl/datafile/tbs2.257.979847755
    
48. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-07-02:00:12:34
    
49. channel ORA_SBT_TAPE_2: starting full datafile backup set
    
50. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
    
51. input datafile file number=00001 name=+DATA/orcl/datafile/system.268.979853699
    
52. input datafile file number=00005 name=+DATA/orcl/datafile/example.259.979847765
    
53. input datafile file number=00006 name=+DATA/orcl/datafile/tbs1.256.979847755
    
54. channel ORA_SBT_TAPE_2: starting piece 1 at 2018-07-02:00:12:34
    
55. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-07-02:00:14:20
    
56. piece handle=3at6urri_1_1 tag=T7 comment=API Version 2.0,MMS Version 10.3.0.2
    
57. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:01:46
    
58. channel ORA_SBT_TAPE_2: finished piece 1 at 2018-07-02:00:14:40
    
59. piece handle=3bt6urri_1_1 tag=T7 comment=API Version 2.0,MMS Version 10.3.0.2
    
60. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:02:06
    
61. Finished backup at 2018-07-02:00:14:40
    
62. 
    
63. Starting Control File and SPFILE Autobackup at 2018-07-02:00:14:40
    
64. piece handle=c-1359978017-20180702-01 comment=API Version 2.0,MMS Version 10.3.0.2
    
65. Finished Control File and SPFILE Autobackup at 2018-07-02:00:15:15
    
66. 
    
67. RMAN> show exclude
    
68. 2> ;
    
69. 
    
70. RMAN configuration parameters for database with db_unique_name ORCL are:
    
71. CONFIGURE EXCLUDE FOR TABLESPACE 'USERS';
    
72. 
    
73. RMAN> CONFIGURE EXCLUDE FOR TABLESPACE 'USERS' clear;
    
74. 
    
75. Tablespace USERS will be included in future whole database backups
    
76. old RMAN configuration parameters are successfully deleted
    
77. 
    
78. RMAN> show exclude;
    
79. 
    
80. RMAN configuration parameters for database with db_unique_name ORCL are:
    
81. RMAN configuration has no stored or default parameters
    
82. 
    
83. RMAN> backup tag 'T8' database;
    
84. 
    
85. Starting backup at 2018-07-02:00:15:51
    
86. using channel ORA_SBT_TAPE_1
    
87. using channel ORA_SBT_TAPE_2
    
88. channel ORA_SBT_TAPE_1: starting full datafile backup set
    
89. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
    
90. input datafile file number=00001 name=+DATA/orcl/datafile/system.268.979853699
    
91. input datafile file number=00005 name=+DATA/orcl/datafile/example.259.979847765
    
92. input datafile file number=00004 name=+DATA/orcl/datafile/users.265.979852989
    
93. input datafile file number=00007 name=+DATA/orcl/datafile/tbs2.257.979847755
    
94. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-07-02:00:15:52
    
95. channel ORA_SBT_TAPE_2: starting full datafile backup set
    
96. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
    
97. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.267.979847755
    
98. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.979847755
    
99. input datafile file number=00006 name=+DATA/orcl/datafile/tbs1.256.979847755
    
100. channel ORA_SBT_TAPE_2: starting piece 1 at 2018-07-02:00:15:52
     
101. 
     

复制代码

关于通道里的Multiplexing：

1. RMAN> backup tag 'T9' database;
   
2. 
   
3. Starting backup at 2018-07-02:00:29:33
   
4. allocated channel: ORA_SBT_TAPE_1
   
5. channel ORA_SBT_TAPE_1: SID=15 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=49 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.268.979853699
    
13. input datafile file number=00005 name=+DATA/orcl/datafile/example.259.979847765
    
14. input datafile file number=00004 name=+DATA/orcl/datafile/users.265.979852989
    
15. input datafile file number=00007 name=+DATA/orcl/datafile/tbs2.257.979847755
    
16. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-07-02:00:29:35
    
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=00002 name=+DATA/orcl/datafile/sysaux.267.979847755
    
20. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.979847755
    
21. input datafile file number=00006 name=+DATA/orcl/datafile/tbs1.256.979847755
    
22. channel ORA_SBT_TAPE_2: starting piece 1 at 2018-07-02:00:29:35
    
23. channel ORA_SBT_TAPE_2: finished piece 1 at 2018-07-02:00:31:20
    
24. piece handle=3ht6usrf_1_1 tag=T9 comment=API Version 2.0,MMS Version 10.3.0.2
    
25. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:01:45
    
26. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-07-02:00:31:50
    
27. piece handle=3gt6usre_1_1 tag=T9 comment=API Version 2.0,MMS Version 10.3.0.2
    
28. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:02:15
    
29. Finished backup at 2018-07-02:00:31:50
    
30. 
    
31. Starting Control File and SPFILE Autobackup at 2018-07-02:00:31:50
    
32. piece handle=c-1359978017-20180702-03 comment=API Version 2.0,MMS Version 10.3.0.2
    
33. Finished Control File and SPFILE Autobackup at 2018-07-02:00:32:25
    
34. 
    
35. RMAN> run {
    
36. 2> allocate channel c1 device type sbt PARMS  'ENV=(OB_MEDIA_FAMILY=station86)';
    
37. 3> allocate channel c2 device type sbt PARMS  'ENV=(OB_MEDIA_FAMILY=station86)';
    
38. 4> backup tag 'T10' database filesperset 2;
    
39. 5> }
    
40. 
    
41. released channel: ORA_SBT_TAPE_1
    
42. released channel: ORA_SBT_TAPE_2
    
43. allocated channel: c1
    
44. channel c1: SID=15 device type=SBT_TAPE
    
45. channel c1: Oracle Secure Backup
    
46. 
    
47. allocated channel: c2
    
48. channel c2: SID=49 device type=SBT_TAPE
    
49. channel c2: Oracle Secure Backup
    
50. 
    
51. Starting backup at 2018-07-02:00:33:38
    
52. channel c1: starting full datafile backup set
    
53. channel c1: specifying datafile(s) in backup set
    
54. input datafile file number=00001 name=+DATA/orcl/datafile/system.268.979853699
    
55. channel c1: starting piece 1 at 2018-07-02:00:33:38
    
56. channel c2: starting full datafile backup set
    
57. channel c2: specifying datafile(s) in backup set
    
58. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.267.979847755
    
59. input datafile file number=00007 name=+DATA/orcl/datafile/tbs2.257.979847755
    
60. channel c2: starting piece 1 at 2018-07-02:00:33:38
    
61. channel c1: finished piece 1 at 2018-07-02:00:35:03
    
62. piece handle=3jt6ut32_1_1 tag=T10 comment=API Version 2.0,MMS Version 10.3.0.2
    
63. channel c1: backup set complete, elapsed time: 00:01:25
    
64. channel c1: starting full datafile backup set
    
65. channel c1: specifying datafile(s) in backup set
    
66. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.979847755
    
67. input datafile file number=00006 name=+DATA/orcl/datafile/tbs1.256.979847755
    
68. channel c1: starting piece 1 at 2018-07-02:00:35:03
    
69. channel c2: finished piece 1 at 2018-07-02:00:35:03
    
70. piece handle=3kt6ut32_1_1 tag=T10 comment=API Version 2.0,MMS Version 10.3.0.2
    
71. channel c2: backup set complete, elapsed time: 00:01:26
    
72. channel c2: starting full datafile backup set
    
73. channel c2: specifying datafile(s) in backup set
    
74. input datafile file number=00005 name=+DATA/orcl/datafile/example.259.979847765
    
75. input datafile file number=00004 name=+DATA/orcl/datafile/users.265.979852989
    
76. channel c2: starting piece 1 at 2018-07-02:00:35:04
    
77. channel c1: finished piece 1 at 2018-07-02:00:35:49
    
78. piece handle=3lt6ut5n_1_1 tag=T10 comment=API Version 2.0,MMS Version 10.3.0.2
    
79. channel c1: backup set complete, elapsed time: 00:00:46
    
80. channel c2: finished piece 1 at 2018-07-02:00:36:09
    
81. piece handle=3mt6ut5o_1_1 tag=T10 comment=API Version 2.0,MMS Version 10.3.0.2
    
82. channel c2: backup set complete, elapsed time: 00:01:05
    
83. Finished backup at 2018-07-02:00:36:09
    
84. 
    
85. Starting Control File and SPFILE Autobackup at 2018-07-02:00:36:09
    
86. piece handle=c-1359978017-20180702-04 comment=API Version 2.0,MMS Version 10.3.0.2
    
87. Finished Control File and SPFILE Autobackup at 2018-07-02:00:36:54
    
88. released channel: c1
    
89. released channel: c2
    
90. 
    
91. RMAN>
    
92. 
    

复制代码

关于异步IO和同步IO：
默认值：

1. SQL> show parameter slave
   
2. 
   
3. NAME                                     TYPE         VALUE
   
4. ------------------------------------ ----------- ------------------------------
   
5. backup_tape_io_slaves                     boolean         FALSE
   
6. dbwr_io_slaves                             integer         0
   

复制代码

现象是：

1. RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 2;
   
2. 
   
3. new RMAN configuration parameters:
   
4. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE 'SBT_TAPE' TO 2;
   
5. new RMAN configuration parameters are successfully stored
   
6. 
   
7. RMAN>
   
8. 
   
9. RMAN>
   
10. 
    
11. RMAN> backup tag 'T11' tablespace users;
    
12. 
    
13. Starting backup at 2018-07-02:00:41:49
    
14. allocated channel: ORA_SBT_TAPE_1
    
15. channel ORA_SBT_TAPE_1: SID=15 device type=SBT_TAPE
    
16. channel ORA_SBT_TAPE_1: Oracle Secure Backup
    
17. allocated channel: ORA_SBT_TAPE_2
    
18. channel ORA_SBT_TAPE_2: SID=49 device type=SBT_TAPE
    
19. channel ORA_SBT_TAPE_2: Oracle Secure Backup
    
20. channel ORA_SBT_TAPE_1: starting full datafile backup set
    
21. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
    
22. input datafile file number=00004 name=+DATA/orcl/datafile/users.265.979852989
    
23. RMAN-00571: ===========================================================
    
24. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    
25. RMAN-00571: ===========================================================
    
26. RMAN-03009: failure of backup command on ORA_SBT_TAPE_1 channel at 07/02/2018 00:41:49
    
27. ORA-19565: BACKUP_TAPE_IO_SLAVES not enabled when duplexing to sequential devices
    

复制代码

把backup_tape_io_slaves设为TRUE：



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

第一种一个备份集下面多于一个备份片的情况（copies备份）:

1. BS Key  Type LV Size
   
2. ------- ---- -- ----------
   
3. 77      Full    3.75M
   
4.   List of Datafiles in backup set 77
   
5.   File LV Type Ckp SCN    Ckp Time            Name
   
6.   ---- -- ---- ---------- ------------------- ----
   
7.   4       Full 1505133    2018-07-03:21:03:16 +DATA/orcl/datafile/users.265.979852989
   
8. 
   
9.   Backup Set Copy #1 of backup set 77
   
10.   Device Type Elapsed Time Completion Time     Compressed Tag
    
11.   ----------- ------------ ------------------- ---------- ---
    
12.   SBT_TAPE    00:01:48     2018-07-03:21:05:04 NO         T11
    
13. 
    
14.     List of Backup Pieces for backup set 77 Copy #1
    
15.     BP Key  Pc# Status      Media                   Piece Name
    
16.     ------- --- ----------- ----------------------- ----------
    
17.     78      1   AVAILABLE   RMAN-DEFAULT-000001     3pt73pgk_1_1
    
18. 
    
19.   Backup Set Copy #2 of backup set 77
    
20.   Device Type Elapsed Time Completion Time     Compressed Tag
    
21.   ----------- ------------ ------------------- ---------- ---
    
22.   SBT_TAPE    00:01:48     2018-07-03:21:05:04 NO         T11
    
23. 
    
24.     List of Backup Pieces for backup set 77 Copy #2
    
25.     BP Key  Pc# Status      Media                   Piece Name
    
26.     ------- --- ----------- ----------------------- ----------
    
27.     79      1   AVAILABLE   RMAN-DEFAULT-000002     3pt73pgk_1_2
    
28. 
    
29. BS Key  Type LV Size
    
30. ------- ---- -- ----------
    
31. 78      Full    10.00M
    
32.   SPFILE Included: Modification time: 2018-07-03:21:03:05
    
33.   SPFILE db_unique_name: ORCL
    
34.   Control File Included: Ckp SCN: 1505191      Ckp time: 2018-07-03:21:05:11
    
35. 
    
36.   Backup Set Copy #1 of backup set 78
    
37.   Device Type Elapsed Time Completion Time     Compressed Tag
    
38.   ----------- ------------ ------------------- ---------- ---
    
39.   SBT_TAPE    00:00:54     2018-07-03:21:06:05 NO         TAG20180703T210511
    
40. 
    
41.     List of Backup Pieces for backup set 78 Copy #1
    
42.     BP Key  Pc# Status      Media                   Piece Name
    
43.     ------- --- ----------- ----------------------- ----------
    
44.     80      1   AVAILABLE   RMAN-DEFAULT-000001     c-1359978017-20180703-00
    
45. 
    
46.   Backup Set Copy #2 of backup set 78
    
47.   Device Type Elapsed Time Completion Time     Compressed Tag
    
48.   ----------- ------------ ------------------- ---------- ---
    
49.   SBT_TAPE    00:00:54     2018-07-03:21:06:05 NO         TAG20180703T210511
    
50. 
    
51.     List of Backup Pieces for backup set 78 Copy #2
    
52.     BP Key  Pc# Status      Media                   Piece Name
    
53.     ------- --- ----------- ----------------------- ----------
    
54.     81      1   AVAILABLE   RMAN-DEFAULT-000002     c-1359978017-20180703-01
    
55. 
    
56. RMAN>
    

复制代码

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

克服备份优化的副作用（force）：

1. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
   
2. ------- ---- -- ---------- ----------- ------------ -------------------
   
3. 79      Full    3.53M      DISK        00:00:00     2018-07-03:21:18:33
   
4.         BP Key: 82   Status: AVAILABLE  Compressed: NO  Tag: TAG20180703T211832
   
5.         Piece Name: +FRA/orcl/backupset/2018_07_03/nnndf0_tag20180703t211832_0.333.980543913
   
6.   List of Datafiles in backup set 79
   
7.   File LV Type Ckp SCN    Ckp Time            Name
   
8.   ---- -- ---- ---------- ------------------- ----
   
9.   4       Full 1506314    2018-07-03:21:18:33 +DATA/orcl/datafile/users.265.979852989
   
10. 
    
11. RMAN> backup backupset 79;
    
12. 
    
13. Starting backup at 2018-07-03:21:19:14
    
14. allocated channel: ORA_SBT_TAPE_1
    
15. channel ORA_SBT_TAPE_1: SID=139 device type=SBT_TAPE
    
16. channel ORA_SBT_TAPE_1: Oracle Secure Backup
    
17. allocated channel: ORA_SBT_TAPE_2
    
18. channel ORA_SBT_TAPE_2: SID=12 device type=SBT_TAPE
    
19. channel ORA_SBT_TAPE_2: Oracle Secure Backup
    
20. skipping backup set key 79; already backed up 1 time(s)
    
21. Finished backup at 2018-07-03:21:19:25
    
22. 
    
23. RMAN> backup backupset 79 force  delete input;
    
24. Starting backup at 2018-07-03:21:21:26
    
25. using channel ORA_SBT_TAPE_1
    
26. using channel ORA_SBT_TAPE_2
    
27. channel ORA_SBT_TAPE_1: input backup set: count=123, stamp=980543913, piece=1
    
28. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-07-03:21:21:27
    
29. channel ORA_SBT_TAPE_1: backup piece +FRA/orcl/backupset/2018_07_03/nnndf0_tag20180703t211832_0.333.980543913
    
30. piece handle=3rt73qd9_1_2 comment=API Version 2.0,MMS Version 10.3.0.2
    
31. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-07-03:21:22:22
    
32. channel ORA_SBT_TAPE_1: backup piece complete, elapsed time: 00:00:55
    
33. deleted backup piece
    
34. backup piece handle=+FRA/orcl/backupset/2018_07_03/nnndf0_tag20180703t211832_0.333.980543913 RECID=82 STAMP=980543913
    
35. Finished backup at 2018-07-03:21:22:23
    
36. 
    
37. Starting Control File and SPFILE Autobackup at 2018-07-03:21:22:23
    
38. piece handle=c-1359978017-20180703-03 comment=API Version 2.0,MMS Version 10.3.0.2
    
39. Finished Control File and SPFILE Autobackup at 2018-07-03:21:22:58
    
40. 
    
41. RMAN> list backupset 79;
    
42. 
    
43. 
    
44. List of Backup Sets
    
45. ===================
    
46. 
    
47. 
    
48. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
    
49. ------- ---- -- ---------- ----------- ------------ -------------------
    
50. 79      Full    3.53M      SBT_TAPE    00:00:00     2018-07-03:21:18:33
    
51.         BP Key: 84   Status: AVAILABLE  Compressed: NO  Tag: TAG20180703T211832
    
52.         Handle: 3rt73qd9_1_2   Media: station86-000005
    
53.   List of Datafiles in backup set 79
    
54.   File LV Type Ckp SCN    Ckp Time            Name
    
55.   ---- -- ---- ---------- ------------------- ----
    
56.   4       Full 1506314    2018-07-03:21:18:33 +DATA/orcl/datafile/users.265.979852989
    
57. 
    

复制代码

-------------------------------------------------------------------------------
压缩备份实验：

1. select  bytes/1024/1024  from
   
2. dba_data_files where tablespace_name='SYSTEM';
   
3. 
   
4. select  sum(bytes)/1024/1024  from
   
5. dba_free_space where tablespace_name='SYSTEM';

复制代码

文件本身690M，RMAN不压缩598.5

1. 
   
2. Recovery Manager: Release 11.2.0.1.0 - Production on Tue Jul 3 21:38:48 2018
   
3. 
   
4. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
   
5. 
   
6. connected to target database: ORCL (DBID=1359978017)
   
7. 
   
8. RMAN> backup tag '1T_SYSTEM_FULL'  tablespace system ;
   
9. 
   
10. Starting backup at 2018-07-03:21:38:55
    
11. using target database control file instead of recovery catalog
    
12. allocated channel: ORA_SBT_TAPE_1
    
13. channel ORA_SBT_TAPE_1: SID=93 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=13 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=00001 name=+DATA/orcl/datafile/system.268.979853699
    
21. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-07-03:21:39:06
    
22. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-07-03:21:40:31
    
23. piece handle=3ut73rjq_1_1 tag=1T_SYSTEM_FULL comment=API Version 2.0,MMS Version 10.3.0.2
    
24. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:01:25
    
25. Finished backup at 2018-07-03:21:40:31
    
26. 
    
27. Starting Control File and SPFILE Autobackup at 2018-07-03:21:40:31
    
28. piece handle=c-1359978017-20180703-04 comment=API Version 2.0,MMS Version 10.3.0.2
    
29. Finished Control File and SPFILE Autobackup at 2018-07-03:21:41:06
    
30. 
    
31. RMAN> list backup;
    
32. 
    
33. 
    
34. List of Backup Sets
    
35. ===================
    
36. 
    
37. 
    
38. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
    
39. ------- ---- -- ---------- ----------- ------------ -------------------
    
40. 82      Full    598.50M    SBT_TAPE    00:01:15     2018-07-03:21:40:21
    
41.         BP Key: 86   Status: AVAILABLE  Compressed: NO  Tag: 1T_SYSTEM_FULL
    
42.         Handle: 3ut73rjq_1_1   Media: station86-000007
    
43.   List of Datafiles in backup set 82
    
44.   File LV Type Ckp SCN    Ckp Time            Name
    
45.   ---- -- ---- ---------- ------------------- ----
    
46.   1       Full 1507111    2018-07-03:21:39:06 +DATA/orcl/datafile/system.268.979853699
    
47. 
    
48. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
    
49. ------- ---- -- ---------- ----------- ------------ -------------------
    
50. 83      Full    10.00M     SBT_TAPE    00:00:31     2018-07-03:21:41:02
    
51.         BP Key: 87   Status: AVAILABLE  Compressed: NO  Tag: TAG20180703T214031
    
52.         Handle: c-1359978017-20180703-04   Media: station86-000007
    
53.   SPFILE Included: Modification time: 2018-07-03:21:38:55
    
54.   SPFILE db_unique_name: ORCL
    
55.   Control File Included: Ckp SCN: 1507155      Ckp time: 2018-07-03:21:40:31
    
56. 
    
57. RMAN>
    

复制代码

BASIC压缩：

1. RMAN> backup as compressed backupset  tag '2TC_SYSTEM_FULL'  tablespace system ;
   
2. 
   
3. Starting backup at 2018-07-03:21:44:34
   
4. using channel ORA_SBT_TAPE_1
   
5. using channel ORA_SBT_TAPE_2
   
6. channel ORA_SBT_TAPE_1: starting compressed 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.268.979853699
   
9. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-07-03:21:44:34
   
10. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-07-03:21:45:29
    
11. piece handle=40t73ru2_1_1 tag=2TC_SYSTEM_FULL comment=API Version 2.0,MMS Version 10.3.0.2
    
12. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:55
    
13. Finished backup at 2018-07-03:21:45:29
    
14. 
    
15. Starting Control File and SPFILE Autobackup at 2018-07-03:21:45:29
    
16. piece handle=c-1359978017-20180703-05 comment=API Version 2.0,MMS Version 10.3.0.2
    
17. Finished Control File and SPFILE Autobackup at 2018-07-03:21:46:14
    

复制代码

1. RMAN> list backup;
   
2. 
   
3. 
   
4. List of Backup Sets
   
5. ===================
   
6. 
   
7. 
   
8. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
   
9. ------- ---- -- ---------- ----------- ------------ -------------------
   
10. 82      Full    598.50M    SBT_TAPE    00:01:15     2018-07-03:21:40:21
    
11.         BP Key: 86   Status: AVAILABLE  Compressed: NO  Tag: 1T_SYSTEM_FULL
    
12.         Handle: 3ut73rjq_1_1   Media: station86-000007
    
13.   List of Datafiles in backup set 82
    
14.   File LV Type Ckp SCN    Ckp Time            Name
    
15.   ---- -- ---- ---------- ------------------- ----
    
16.   1       Full 1507111    2018-07-03:21:39:06 +DATA/orcl/datafile/system.268.979853699
    
17. 
    
18. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
    
19. ------- ---- -- ---------- ----------- ------------ -------------------
    
20. 83      Full    10.00M     SBT_TAPE    00:00:31     2018-07-03:21:41:02
    
21.         BP Key: 87   Status: AVAILABLE  Compressed: NO  Tag: TAG20180703T214031
    
22.         Handle: c-1359978017-20180703-04   Media: station86-000007
    
23.   SPFILE Included: Modification time: 2018-07-03:21:38:55
    
24.   SPFILE db_unique_name: ORCL
    
25.   Control File Included: Ckp SCN: 1507155      Ckp time: 2018-07-03:21:40:31
    
26. 
    
27. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
    
28. ------- ---- -- ---------- ----------- ------------ -------------------
    
29. 84      Full    180.00M    SBT_TAPE    00:00:51     2018-07-03:21:45:25
    
30.         BP Key: 88   Status: AVAILABLE  Compressed: YES  Tag: 2TC_SYSTEM_FULL
    
31.         Handle: 40t73ru2_1_1   Media: station86-000007
    
32.   List of Datafiles in backup set 84
    
33.   File LV Type Ckp SCN    Ckp Time            Name
    
34.   ---- -- ---- ---------- ------------------- ----
    
35.   1       Full 1507336    2018-07-03:21:44:34 +DATA/orcl/datafile/system.268.979853699
    
36. 
    
37. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
    
38. ------- ---- -- ---------- ----------- ------------ -------------------
    
39. 85      Full    10.00M     SBT_TAPE    00:00:41     2018-07-03:21:46:10
    
40.         BP Key: 89   Status: AVAILABLE  Compressed: NO  Tag: TAG20180703T214529
    
41.         Handle: c-1359978017-20180703-05   Media: station86-000007
    
42.   SPFILE Included: Modification time: 2018-07-03:21:38:55
    
43.   SPFILE db_unique_name: ORCL
    
44.   Control File Included: Ckp SCN: 1507369      Ckp time: 2018-07-03:21:45:29
    
45. 
    
46. RMAN>
    

复制代码