设为首页收藏本站

Botang唐波's Oracle Station

查看: 44|回复: 0

课程第16次(2018-07-03星期二)

[复制链接]

677

主题

1037

帖子

7580

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
7580
发表于 2018-7-3 20:26:31 | 显示全部楼层 |阅读模式
关于exclude:
  1. RMAN> CONFIGURE  exclude for tablespace users;

  2. Tablespace USERS will be excluded from future whole database backups
  3. new RMAN configuration parameters are successfully stored

  4. RMAN> show all;

  5. RMAN configuration parameters for database with db_unique_name ORCL are:
  6. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
  7. CONFIGURE BACKUP OPTIMIZATION ON;
  8. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
  9. CONFIGURE CONTROLFILE AUTOBACKUP ON;
  10. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
  11. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
  12. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
  13. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
  14. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  15. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  16. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  17. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  18. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station86)';
  19. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station86)';
  20. CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station86)';
  21. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
  22. CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
  23. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
  24. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
  25. CONFIGURE EXCLUDE FOR TABLESPACE 'USERS';
  26. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
  27. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default

  28. RMAN> show EXCLUDE;

  29. RMAN configuration parameters for database with db_unique_name ORCL are:
  30. CONFIGURE EXCLUDE FOR TABLESPACE 'USERS';

  31. RMAN> backup tag 'T7' database;

  32. Starting backup at 2018-07-02:00:12:34
  33. using channel ORA_SBT_TAPE_1
  34. using channel ORA_SBT_TAPE_2
  35. file 4 is excluded from whole database backup
  36. channel ORA_SBT_TAPE_1: starting full datafile backup set
  37. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  38. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.267.979847755
  39. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.979847755
  40. input datafile file number=00007 name=+DATA/orcl/datafile/tbs2.257.979847755
  41. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-07-02:00:12:34
  42. channel ORA_SBT_TAPE_2: starting full datafile backup set
  43. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
  44. input datafile file number=00001 name=+DATA/orcl/datafile/system.268.979853699
  45. input datafile file number=00005 name=+DATA/orcl/datafile/example.259.979847765
  46. input datafile file number=00006 name=+DATA/orcl/datafile/tbs1.256.979847755
  47. channel ORA_SBT_TAPE_2: starting piece 1 at 2018-07-02:00:12:34
  48. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-07-02:00:14:20
  49. piece handle=3at6urri_1_1 tag=T7 comment=API Version 2.0,MMS Version 10.3.0.2
  50. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:01:46
  51. channel ORA_SBT_TAPE_2: finished piece 1 at 2018-07-02:00:14:40
  52. piece handle=3bt6urri_1_1 tag=T7 comment=API Version 2.0,MMS Version 10.3.0.2
  53. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:02:06
  54. Finished backup at 2018-07-02:00:14:40

  55. Starting Control File and SPFILE Autobackup at 2018-07-02:00:14:40
  56. piece handle=c-1359978017-20180702-01 comment=API Version 2.0,MMS Version 10.3.0.2
  57. Finished Control File and SPFILE Autobackup at 2018-07-02:00:15:15

  58. RMAN> show exclude
  59. 2> ;

  60. RMAN configuration parameters for database with db_unique_name ORCL are:
  61. CONFIGURE EXCLUDE FOR TABLESPACE 'USERS';

  62. RMAN> CONFIGURE EXCLUDE FOR TABLESPACE 'USERS' clear;

  63. Tablespace USERS will be included in future whole database backups
  64. old RMAN configuration parameters are successfully deleted

  65. RMAN> show exclude;

  66. RMAN configuration parameters for database with db_unique_name ORCL are:
  67. RMAN configuration has no stored or default parameters

  68. RMAN> backup tag 'T8' database;

  69. Starting backup at 2018-07-02:00:15:51
  70. using channel ORA_SBT_TAPE_1
  71. using channel ORA_SBT_TAPE_2
  72. channel ORA_SBT_TAPE_1: starting full datafile backup set
  73. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  74. input datafile file number=00001 name=+DATA/orcl/datafile/system.268.979853699
  75. input datafile file number=00005 name=+DATA/orcl/datafile/example.259.979847765
  76. input datafile file number=00004 name=+DATA/orcl/datafile/users.265.979852989
  77. input datafile file number=00007 name=+DATA/orcl/datafile/tbs2.257.979847755
  78. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-07-02:00:15:52
  79. channel ORA_SBT_TAPE_2: starting full datafile backup set
  80. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
  81. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.267.979847755
  82. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.979847755
  83. input datafile file number=00006 name=+DATA/orcl/datafile/tbs1.256.979847755
  84. channel ORA_SBT_TAPE_2: starting piece 1 at 2018-07-02:00:15:52

复制代码
关于通道里的Multiplexing:
  1. RMAN> backup tag 'T9' database;

  2. Starting backup at 2018-07-02:00:29:33
  3. allocated channel: ORA_SBT_TAPE_1
  4. channel ORA_SBT_TAPE_1: SID=15 device type=SBT_TAPE
  5. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  6. allocated channel: ORA_SBT_TAPE_2
  7. channel ORA_SBT_TAPE_2: SID=49 device type=SBT_TAPE
  8. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  9. channel ORA_SBT_TAPE_1: starting full datafile backup set
  10. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  11. input datafile file number=00001 name=+DATA/orcl/datafile/system.268.979853699
  12. input datafile file number=00005 name=+DATA/orcl/datafile/example.259.979847765
  13. input datafile file number=00004 name=+DATA/orcl/datafile/users.265.979852989
  14. input datafile file number=00007 name=+DATA/orcl/datafile/tbs2.257.979847755
  15. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-07-02:00:29:35
  16. channel ORA_SBT_TAPE_2: starting full datafile backup set
  17. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
  18. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.267.979847755
  19. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.979847755
  20. input datafile file number=00006 name=+DATA/orcl/datafile/tbs1.256.979847755
  21. channel ORA_SBT_TAPE_2: starting piece 1 at 2018-07-02:00:29:35
  22. channel ORA_SBT_TAPE_2: finished piece 1 at 2018-07-02:00:31:20
  23. piece handle=3ht6usrf_1_1 tag=T9 comment=API Version 2.0,MMS Version 10.3.0.2
  24. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:01:45
  25. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-07-02:00:31:50
  26. piece handle=3gt6usre_1_1 tag=T9 comment=API Version 2.0,MMS Version 10.3.0.2
  27. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:02:15
  28. Finished backup at 2018-07-02:00:31:50

  29. Starting Control File and SPFILE Autobackup at 2018-07-02:00:31:50
  30. piece handle=c-1359978017-20180702-03 comment=API Version 2.0,MMS Version 10.3.0.2
  31. Finished Control File and SPFILE Autobackup at 2018-07-02:00:32:25

  32. RMAN> run {
  33. 2> allocate channel c1 device type sbt PARMS  'ENV=(OB_MEDIA_FAMILY=station86)';
  34. 3> allocate channel c2 device type sbt PARMS  'ENV=(OB_MEDIA_FAMILY=station86)';
  35. 4> backup tag 'T10' database filesperset 2;
  36. 5> }

  37. released channel: ORA_SBT_TAPE_1
  38. released channel: ORA_SBT_TAPE_2
  39. allocated channel: c1
  40. channel c1: SID=15 device type=SBT_TAPE
  41. channel c1: Oracle Secure Backup

  42. allocated channel: c2
  43. channel c2: SID=49 device type=SBT_TAPE
  44. channel c2: Oracle Secure Backup

  45. Starting backup at 2018-07-02:00:33:38
  46. channel c1: starting full datafile backup set
  47. channel c1: specifying datafile(s) in backup set
  48. input datafile file number=00001 name=+DATA/orcl/datafile/system.268.979853699
  49. channel c1: starting piece 1 at 2018-07-02:00:33:38
  50. channel c2: starting full datafile backup set
  51. channel c2: specifying datafile(s) in backup set
  52. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.267.979847755
  53. input datafile file number=00007 name=+DATA/orcl/datafile/tbs2.257.979847755
  54. channel c2: starting piece 1 at 2018-07-02:00:33:38
  55. channel c1: finished piece 1 at 2018-07-02:00:35:03
  56. piece handle=3jt6ut32_1_1 tag=T10 comment=API Version 2.0,MMS Version 10.3.0.2
  57. channel c1: backup set complete, elapsed time: 00:01:25
  58. channel c1: starting full datafile backup set
  59. channel c1: specifying datafile(s) in backup set
  60. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.979847755
  61. input datafile file number=00006 name=+DATA/orcl/datafile/tbs1.256.979847755
  62. channel c1: starting piece 1 at 2018-07-02:00:35:03
  63. channel c2: finished piece 1 at 2018-07-02:00:35:03
  64. piece handle=3kt6ut32_1_1 tag=T10 comment=API Version 2.0,MMS Version 10.3.0.2
  65. channel c2: backup set complete, elapsed time: 00:01:26
  66. channel c2: starting full datafile backup set
  67. channel c2: specifying datafile(s) in backup set
  68. input datafile file number=00005 name=+DATA/orcl/datafile/example.259.979847765
  69. input datafile file number=00004 name=+DATA/orcl/datafile/users.265.979852989
  70. channel c2: starting piece 1 at 2018-07-02:00:35:04
  71. channel c1: finished piece 1 at 2018-07-02:00:35:49
  72. piece handle=3lt6ut5n_1_1 tag=T10 comment=API Version 2.0,MMS Version 10.3.0.2
  73. channel c1: backup set complete, elapsed time: 00:00:46
  74. channel c2: finished piece 1 at 2018-07-02:00:36:09
  75. piece handle=3mt6ut5o_1_1 tag=T10 comment=API Version 2.0,MMS Version 10.3.0.2
  76. channel c2: backup set complete, elapsed time: 00:01:05
  77. Finished backup at 2018-07-02:00:36:09

  78. Starting Control File and SPFILE Autobackup at 2018-07-02:00:36:09
  79. piece handle=c-1359978017-20180702-04 comment=API Version 2.0,MMS Version 10.3.0.2
  80. Finished Control File and SPFILE Autobackup at 2018-07-02:00:36:54
  81. released channel: c1
  82. released channel: c2

  83. RMAN>

复制代码
关于异步IO和同步IO:
默认值:
  1. SQL> show parameter slave

  2. NAME                                     TYPE         VALUE
  3. ------------------------------------ ----------- ------------------------------
  4. backup_tape_io_slaves                     boolean         FALSE
  5. dbwr_io_slaves                             integer         0
复制代码
现象是:
  1. RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 2;

  2. new RMAN configuration parameters:
  3. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE 'SBT_TAPE' TO 2;
  4. new RMAN configuration parameters are successfully stored

  5. RMAN>

  6. RMAN>

  7. RMAN> backup tag 'T11' tablespace users;

  8. Starting backup at 2018-07-02:00:41:49
  9. allocated channel: ORA_SBT_TAPE_1
  10. channel ORA_SBT_TAPE_1: SID=15 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=49 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.979852989
  18. RMAN-00571: ===========================================================
  19. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  20. RMAN-00571: ===========================================================
  21. RMAN-03009: failure of backup command on ORA_SBT_TAPE_1 channel at 07/02/2018 00:41:49
  22. ORA-19565: BACKUP_TAPE_IO_SLAVES not enabled when duplexing to sequential devices
复制代码
把backup_tape_io_slaves设为TRUE:

a.png

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

第一种一个备份集下面多于一个备份片的情况(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.   Backup Set Copy #1 of backup set 77
  9.   Device Type Elapsed Time Completion Time     Compressed Tag
  10.   ----------- ------------ ------------------- ---------- ---
  11.   SBT_TAPE    00:01:48     2018-07-03:21:05:04 NO         T11

  12.     List of Backup Pieces for backup set 77 Copy #1
  13.     BP Key  Pc# Status      Media                   Piece Name
  14.     ------- --- ----------- ----------------------- ----------
  15.     78      1   AVAILABLE   RMAN-DEFAULT-000001     3pt73pgk_1_1

  16.   Backup Set Copy #2 of backup set 77
  17.   Device Type Elapsed Time Completion Time     Compressed Tag
  18.   ----------- ------------ ------------------- ---------- ---
  19.   SBT_TAPE    00:01:48     2018-07-03:21:05:04 NO         T11

  20.     List of Backup Pieces for backup set 77 Copy #2
  21.     BP Key  Pc# Status      Media                   Piece Name
  22.     ------- --- ----------- ----------------------- ----------
  23.     79      1   AVAILABLE   RMAN-DEFAULT-000002     3pt73pgk_1_2

  24. BS Key  Type LV Size
  25. ------- ---- -- ----------
  26. 78      Full    10.00M
  27.   SPFILE Included: Modification time: 2018-07-03:21:03:05
  28.   SPFILE db_unique_name: ORCL
  29.   Control File Included: Ckp SCN: 1505191      Ckp time: 2018-07-03:21:05:11

  30.   Backup Set Copy #1 of backup set 78
  31.   Device Type Elapsed Time Completion Time     Compressed Tag
  32.   ----------- ------------ ------------------- ---------- ---
  33.   SBT_TAPE    00:00:54     2018-07-03:21:06:05 NO         TAG20180703T210511

  34.     List of Backup Pieces for backup set 78 Copy #1
  35.     BP Key  Pc# Status      Media                   Piece Name
  36.     ------- --- ----------- ----------------------- ----------
  37.     80      1   AVAILABLE   RMAN-DEFAULT-000001     c-1359978017-20180703-00

  38.   Backup Set Copy #2 of backup set 78
  39.   Device Type Elapsed Time Completion Time     Compressed Tag
  40.   ----------- ------------ ------------------- ---------- ---
  41.   SBT_TAPE    00:00:54     2018-07-03:21:06:05 NO         TAG20180703T210511

  42.     List of Backup Pieces for backup set 78 Copy #2
  43.     BP Key  Pc# Status      Media                   Piece Name
  44.     ------- --- ----------- ----------------------- ----------
  45.     81      1   AVAILABLE   RMAN-DEFAULT-000002     c-1359978017-20180703-01

  46. 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. RMAN> backup backupset 79;

  11. Starting backup at 2018-07-03:21:19:14
  12. allocated channel: ORA_SBT_TAPE_1
  13. channel ORA_SBT_TAPE_1: SID=139 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=12 device type=SBT_TAPE
  17. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  18. skipping backup set key 79; already backed up 1 time(s)
  19. Finished backup at 2018-07-03:21:19:25

  20. RMAN> backup backupset 79 force  delete input;
  21. Starting backup at 2018-07-03:21:21:26
  22. using channel ORA_SBT_TAPE_1
  23. using channel ORA_SBT_TAPE_2
  24. channel ORA_SBT_TAPE_1: input backup set: count=123, stamp=980543913, piece=1
  25. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-07-03:21:21:27
  26. channel ORA_SBT_TAPE_1: backup piece +FRA/orcl/backupset/2018_07_03/nnndf0_tag20180703t211832_0.333.980543913
  27. piece handle=3rt73qd9_1_2 comment=API Version 2.0,MMS Version 10.3.0.2
  28. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-07-03:21:22:22
  29. channel ORA_SBT_TAPE_1: backup piece complete, elapsed time: 00:00:55
  30. deleted backup piece
  31. backup piece handle=+FRA/orcl/backupset/2018_07_03/nnndf0_tag20180703t211832_0.333.980543913 RECID=82 STAMP=980543913
  32. Finished backup at 2018-07-03:21:22:23

  33. Starting Control File and SPFILE Autobackup at 2018-07-03:21:22:23
  34. piece handle=c-1359978017-20180703-03 comment=API Version 2.0,MMS Version 10.3.0.2
  35. Finished Control File and SPFILE Autobackup at 2018-07-03:21:22:58

  36. RMAN> list backupset 79;


  37. List of Backup Sets
  38. ===================


  39. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  40. ------- ---- -- ---------- ----------- ------------ -------------------
  41. 79      Full    3.53M      SBT_TAPE    00:00:00     2018-07-03:21:18:33
  42.         BP Key: 84   Status: AVAILABLE  Compressed: NO  Tag: TAG20180703T211832
  43.         Handle: 3rt73qd9_1_2   Media: station86-000005
  44.   List of Datafiles in backup set 79
  45.   File LV Type Ckp SCN    Ckp Time            Name
  46.   ---- -- ---- ---------- ------------------- ----
  47.   4       Full 1506314    2018-07-03:21:18:33 +DATA/orcl/datafile/users.265.979852989

复制代码
-------------------------------------------------------------------------------
压缩备份实验:
  1. select  bytes/1024/1024  from
  2. dba_data_files where tablespace_name='SYSTEM';

  3. select  sum(bytes)/1024/1024  from
  4. dba_free_space where tablespace_name='SYSTEM';
复制代码
文件本身690M,RMAN不压缩598.5

  1. Recovery Manager: Release 11.2.0.1.0 - Production on Tue Jul 3 21:38:48 2018

  2. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

  3. connected to target database: ORCL (DBID=1359978017)

  4. RMAN> backup tag '1T_SYSTEM_FULL'  tablespace system ;

  5. Starting backup at 2018-07-03:21:38:55
  6. using target database control file instead of recovery catalog
  7. allocated channel: ORA_SBT_TAPE_1
  8. channel ORA_SBT_TAPE_1: SID=93 device type=SBT_TAPE
  9. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  10. allocated channel: ORA_SBT_TAPE_2
  11. channel ORA_SBT_TAPE_2: SID=13 device type=SBT_TAPE
  12. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  13. channel ORA_SBT_TAPE_1: starting full datafile backup set
  14. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  15. input datafile file number=00001 name=+DATA/orcl/datafile/system.268.979853699
  16. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-07-03:21:39:06
  17. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-07-03:21:40:31
  18. piece handle=3ut73rjq_1_1 tag=1T_SYSTEM_FULL comment=API Version 2.0,MMS Version 10.3.0.2
  19. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:01:25
  20. Finished backup at 2018-07-03:21:40:31

  21. Starting Control File and SPFILE Autobackup at 2018-07-03:21:40:31
  22. piece handle=c-1359978017-20180703-04 comment=API Version 2.0,MMS Version 10.3.0.2
  23. Finished Control File and SPFILE Autobackup at 2018-07-03:21:41:06

  24. RMAN> list backup;


  25. List of Backup Sets
  26. ===================


  27. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  28. ------- ---- -- ---------- ----------- ------------ -------------------
  29. 82      Full    598.50M    SBT_TAPE    00:01:15     2018-07-03:21:40:21
  30.         BP Key: 86   Status: AVAILABLE  Compressed: NO  Tag: 1T_SYSTEM_FULL
  31.         Handle: 3ut73rjq_1_1   Media: station86-000007
  32.   List of Datafiles in backup set 82
  33.   File LV Type Ckp SCN    Ckp Time            Name
  34.   ---- -- ---- ---------- ------------------- ----
  35.   1       Full 1507111    2018-07-03:21:39:06 +DATA/orcl/datafile/system.268.979853699

  36. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  37. ------- ---- -- ---------- ----------- ------------ -------------------
  38. 83      Full    10.00M     SBT_TAPE    00:00:31     2018-07-03:21:41:02
  39.         BP Key: 87   Status: AVAILABLE  Compressed: NO  Tag: TAG20180703T214031
  40.         Handle: c-1359978017-20180703-04   Media: station86-000007
  41.   SPFILE Included: Modification time: 2018-07-03:21:38:55
  42.   SPFILE db_unique_name: ORCL
  43.   Control File Included: Ckp SCN: 1507155      Ckp time: 2018-07-03:21:40:31

  44. RMAN>
复制代码
BASIC压缩:
  1. RMAN> backup as compressed backupset  tag '2TC_SYSTEM_FULL'  tablespace system ;

  2. Starting backup at 2018-07-03:21:44:34
  3. using channel ORA_SBT_TAPE_1
  4. using channel ORA_SBT_TAPE_2
  5. channel ORA_SBT_TAPE_1: starting compressed full datafile backup set
  6. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  7. input datafile file number=00001 name=+DATA/orcl/datafile/system.268.979853699
  8. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-07-03:21:44:34
  9. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-07-03:21:45:29
  10. piece handle=40t73ru2_1_1 tag=2TC_SYSTEM_FULL comment=API Version 2.0,MMS Version 10.3.0.2
  11. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:55
  12. Finished backup at 2018-07-03:21:45:29

  13. Starting Control File and SPFILE Autobackup at 2018-07-03:21:45:29
  14. piece handle=c-1359978017-20180703-05 comment=API Version 2.0,MMS Version 10.3.0.2
  15. Finished Control File and SPFILE Autobackup at 2018-07-03:21:46:14
复制代码
  1. RMAN> list backup;


  2. List of Backup Sets
  3. ===================


  4. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  5. ------- ---- -- ---------- ----------- ------------ -------------------
  6. 82      Full    598.50M    SBT_TAPE    00:01:15     2018-07-03:21:40:21
  7.         BP Key: 86   Status: AVAILABLE  Compressed: NO  Tag: 1T_SYSTEM_FULL
  8.         Handle: 3ut73rjq_1_1   Media: station86-000007
  9.   List of Datafiles in backup set 82
  10.   File LV Type Ckp SCN    Ckp Time            Name
  11.   ---- -- ---- ---------- ------------------- ----
  12.   1       Full 1507111    2018-07-03:21:39:06 +DATA/orcl/datafile/system.268.979853699

  13. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  14. ------- ---- -- ---------- ----------- ------------ -------------------
  15. 83      Full    10.00M     SBT_TAPE    00:00:31     2018-07-03:21:41:02
  16.         BP Key: 87   Status: AVAILABLE  Compressed: NO  Tag: TAG20180703T214031
  17.         Handle: c-1359978017-20180703-04   Media: station86-000007
  18.   SPFILE Included: Modification time: 2018-07-03:21:38:55
  19.   SPFILE db_unique_name: ORCL
  20.   Control File Included: Ckp SCN: 1507155      Ckp time: 2018-07-03:21:40:31

  21. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  22. ------- ---- -- ---------- ----------- ------------ -------------------
  23. 84      Full    180.00M    SBT_TAPE    00:00:51     2018-07-03:21:45:25
  24.         BP Key: 88   Status: AVAILABLE  Compressed: YES  Tag: 2TC_SYSTEM_FULL
  25.         Handle: 40t73ru2_1_1   Media: station86-000007
  26.   List of Datafiles in backup set 84
  27.   File LV Type Ckp SCN    Ckp Time            Name
  28.   ---- -- ---- ---------- ------------------- ----
  29.   1       Full 1507336    2018-07-03:21:44:34 +DATA/orcl/datafile/system.268.979853699

  30. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  31. ------- ---- -- ---------- ----------- ------------ -------------------
  32. 85      Full    10.00M     SBT_TAPE    00:00:41     2018-07-03:21:46:10
  33.         BP Key: 89   Status: AVAILABLE  Compressed: NO  Tag: TAG20180703T214529
  34.         Handle: c-1359978017-20180703-05   Media: station86-000007
  35.   SPFILE Included: Modification time: 2018-07-03:21:38:55
  36.   SPFILE db_unique_name: ORCL
  37.   Control File Included: Ckp SCN: 1507369      Ckp time: 2018-07-03:21:45:29

  38. RMAN>
复制代码



回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|Botang唐波's Oracle Station   

GMT+8, 2018-7-16 10:39 , Processed in 0.192670 second(s), 27 queries .

快速回复 返回顶部 返回列表