设为首页收藏本站

Botang唐波's Oracle Station

查看: 349|回复: 0

课程第28次(2018-04-11星期三)

[复制链接]

719

主题

1081

帖子

7868

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
7868
发表于 2018-4-11 20:13:14 | 显示全部楼层 |阅读模式
  1. RMAN> show all;

  2. using target database control file instead of recovery catalog
  3. RMAN configuration parameters for database with db_unique_name ORCL are:
  4. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
  5. CONFIGURE BACKUP OPTIMIZATION ON;
  6. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
  7. CONFIGURE CONTROLFILE AUTOBACKUP ON;
  8. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
  9. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
  10. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
  11. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
  12. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  13. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  14. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  15. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  16. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  17. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  18. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
  19. CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
  20. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
  21. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
  22. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
  23. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default
复制代码
  1. Daily Script:
  2. run {
  3. allocate channel oem_disk_backup device type disk;
  4. recover copy of database with tag 'ORA_OEM_LEVEL_0';
  5. backup incremental level 1 cumulative  copies=1 for recover of copy with tag 'ORA_OEM_LEVEL_0' database;
  6. release channel oem_disk_backup;
  7. allocate channel oem_sbt_backup1 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
  8. allocate channel oem_sbt_backup2 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
  9. backup archivelog all not backed up;
  10. }
  11. allocate channel for maintenance device type 'SBT_TAPE' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
  12. delete noprompt obsolete recovery window of 31 days device type 'SBT_TAPE';
  13. Weekly Script:
  14. run {
  15. allocate channel oem_disk_backup device type disk;
  16. recover copy of database with tag 'ORA_OEM_LEVEL_0';
  17. backup incremental level 1 cumulative  copies=1 for recover of copy with tag 'ORA_OEM_LEVEL_0' database;
  18. release channel oem_disk_backup;
  19. allocate channel oem_sbt_backup1 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
  20. allocate channel oem_sbt_backup2 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
  21. backup recovery area;
  22. }
  23. allocate channel for maintenance device type 'SBT_TAPE' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
  24. delete noprompt obsolete recovery window of 31 days device type 'SBT_TAPE';
复制代码
第一天:
  1. Recovery Manager: Release 11.2.0.1.0 - Production on Wed Apr 11 21:15:27 2018

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

  3. RMAN>
  4. connected to target database: ORCL (DBID=1343950367)
  5. using target database control file instead of recovery catalog

  6. RMAN>
  7. echo set on


  8. RMAN> run {
  9. 2> allocate channel oem_disk_backup device type disk;
  10. 3> recover copy of database with tag 'ORA_OEM_LEVEL_0';
  11. 4> backup incremental level 1 cumulative  copies=1 for recover of copy with tag 'ORA_OEM_LEVEL_0' database;
  12. 5> release channel oem_disk_backup;
  13. 6> allocate channel oem_sbt_backup1 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
  14. 7> allocate channel oem_sbt_backup2 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
  15. 8> backup archivelog all not backed up;
  16. 9> }
  17. allocated channel: oem_disk_backup
  18. channel oem_disk_backup: SID=195 device type=DISK

  19. Starting recover at 11-APR-18
  20. no copy of datafile 1 found to recover
  21. no copy of datafile 2 found to recover
  22. no copy of datafile 3 found to recover
  23. no copy of datafile 4 found to recover
  24. no copy of datafile 5 found to recover
  25. Finished recover at 11-APR-18

  26. Starting backup at 11-APR-18
  27. no parent backup or copy of datafile 2 found
  28. no parent backup or copy of datafile 1 found
  29. no parent backup or copy of datafile 3 found
  30. no parent backup or copy of datafile 5 found
  31. no parent backup or copy of datafile 4 found
  32. channel oem_disk_backup: starting datafile copy
  33. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.816169553
  34. output file name=+FRA/orcl/datafile/sysaux.277.973199731 tag=ORA_OEM_LEVEL_0 RECID=2 STAMP=973199735
  35. channel oem_disk_backup: datafile copy complete, elapsed time: 00:00:07
  36. channel oem_disk_backup: starting datafile copy
  37. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.816169553
  38. output file name=+FRA/orcl/datafile/system.267.973199737 tag=ORA_OEM_LEVEL_0 RECID=3 STAMP=973199741
  39. channel oem_disk_backup: datafile copy complete, elapsed time: 00:00:07
  40. channel oem_disk_backup: starting datafile copy
  41. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.972833355
  42. output file name=+FRA/orcl/datafile/undotbs1.262.973199745 tag=ORA_OEM_LEVEL_0 RECID=4 STAMP=973199745
  43. channel oem_disk_backup: datafile copy complete, elapsed time: 00:00:03
  44. channel oem_disk_backup: starting datafile copy
  45. input datafile file number=00005 name=+DATA/orcl/datafile/example.265.816169651
  46. output file name=+FRA/orcl/datafile/example.351.973199747 tag=ORA_OEM_LEVEL_0 RECID=5 STAMP=973199748
  47. channel oem_disk_backup: datafile copy complete, elapsed time: 00:00:03
  48. channel oem_disk_backup: starting datafile copy
  49. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.816169553
  50. output file name=+FRA/orcl/datafile/users.350.973199751 tag=ORA_OEM_LEVEL_0 RECID=6 STAMP=973199751
  51. channel oem_disk_backup: datafile copy complete, elapsed time: 00:00:01
  52. Finished backup at 11-APR-18

  53. Starting Control File and SPFILE Autobackup at 11-APR-18
  54. piece handle=+FRA/orcl/autobackup/2018_04_11/s_973199752.349.973199753 comment=NONE
  55. Finished Control File and SPFILE Autobackup at 11-APR-18

  56. released channel: oem_disk_backup

  57. allocated channel: oem_sbt_backup1
  58. channel oem_sbt_backup1: SID=195 device type=SBT_TAPE
  59. channel oem_sbt_backup1: Oracle Secure Backup

  60. allocated channel: oem_sbt_backup2
  61. channel oem_sbt_backup2: SID=200 device type=SBT_TAPE
  62. channel oem_sbt_backup2: Oracle Secure Backup

  63. Starting backup at 11-APR-18
  64. current log archived
  65. channel oem_sbt_backup1: starting archived log backup set
  66. channel oem_sbt_backup1: specifying archived log(s) in backup set
  67. input archived log thread=1 sequence=81 RECID=95 STAMP=973198807
  68. input archived log thread=1 sequence=82 RECID=96 STAMP=973198817
  69. channel oem_sbt_backup1: starting piece 1 at 11-APR-18
  70. channel oem_sbt_backup2: starting archived log backup set
  71. channel oem_sbt_backup2: specifying archived log(s) in backup set
  72. input archived log thread=1 sequence=83 RECID=97 STAMP=973199765
  73. channel oem_sbt_backup2: starting piece 1 at 11-APR-18
  74. channel oem_sbt_backup1: finished piece 1 at 11-APR-18
  75. piece handle=1gt03mcl_1_1 tag=TAG20180411T211605 comment=API Version 2.0,MMS Version 10.4.0.4
  76. channel oem_sbt_backup1: backup set complete, elapsed time: 00:00:25
  77. channel oem_sbt_backup2: finished piece 1 at 11-APR-18
  78. piece handle=1ht03mcl_1_1 tag=TAG20180411T211605 comment=API Version 2.0,MMS Version 10.4.0.4
  79. channel oem_sbt_backup2: backup set complete, elapsed time: 00:00:25
  80. Finished backup at 11-APR-18

  81. Starting Control File and SPFILE Autobackup at 11-APR-18
  82. piece handle=c-1343950367-20180411-01 comment=API Version 2.0,MMS Version 10.4.0.4
  83. Finished Control File and SPFILE Autobackup at 11-APR-18
  84. released channel: oem_sbt_backup1
  85. released channel: oem_sbt_backup2


  86. RMAN> allocate channel for maintenance device type 'SBT_TAPE' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
  87. allocated channel: ORA_MAINT_SBT_TAPE_1
  88. channel ORA_MAINT_SBT_TAPE_1: SID=195 device type=SBT_TAPE
  89. channel ORA_MAINT_SBT_TAPE_1: Oracle Secure Backup


  90. RMAN> delete noprompt obsolete recovery window of 31 days device type 'SBT_TAPE';
  91. no obsolete backups found


  92. RMAN> exit;

  93. Recovery Manager complete.
复制代码
  1. RMAN> list backup;

  2. using target database control file instead of recovery catalog

  3. List of Backup Sets
  4. ===================


  5. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  6. ------- ---- -- ---------- ----------- ------------ ---------------
  7. 42      Full    9.45M      DISK        00:00:00     11-APR-18      
  8.         BP Key: 42   Status: AVAILABLE  Compressed: NO  Tag: TAG20180411T211552
  9.         Piece Name: +FRA/orcl/autobackup/2018_04_11/s_973199752.349.973199753
  10.   SPFILE Included: Modification time: 11-APR-18
  11.   SPFILE db_unique_name: ORCL
  12.   Control File Included: Ckp SCN: 1696024      Ckp time: 11-APR-18

  13. BS Key  Size       Device Type Elapsed Time Completion Time
  14. ------- ---------- ----------- ------------ ---------------
  15. 43      42.00M     SBT_TAPE    00:00:16     11-APR-18      
  16.         BP Key: 43   Status: AVAILABLE  Compressed: NO  Tag: TAG20180411T211605
  17.         Handle: 1gt03mcl_1_1   Media: station90-000003

  18.   List of Archived Logs in backup set 43
  19.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  20.   ---- ------- ---------- --------- ---------- ---------
  21.   1    81      1685025    11-APR-18 1690508    11-APR-18
  22.   1    82      1690508    11-APR-18 1693389    11-APR-18

  23. BS Key  Size       Device Type Elapsed Time Completion Time
  24. ------- ---------- ----------- ------------ ---------------
  25. 44      12.25M     SBT_TAPE    00:00:24     11-APR-18      
  26.         BP Key: 44   Status: AVAILABLE  Compressed: NO  Tag: TAG20180411T211605
  27.         Handle: 1ht03mcl_1_1   Media: station90-000004

  28.   List of Archived Logs in backup set 44
  29.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  30.   ---- ------- ---------- --------- ---------- ---------
  31.   1    83      1693389    11-APR-18 1696105    11-APR-18

  32. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  33. ------- ---- -- ---------- ----------- ------------ ---------------
  34. 45      Full    9.50M      SBT_TAPE    00:00:16     11-APR-18      
  35.         BP Key: 45   Status: AVAILABLE  Compressed: NO  Tag: TAG20180411T211630
  36.         Handle: c-1343950367-20180411-01   Media: station90-000003
  37.   SPFILE Included: Modification time: 11-APR-18
  38.   SPFILE db_unique_name: ORCL
  39.   Control File Included: Ckp SCN: 1696146      Ckp time: 11-APR-18

  40. RMAN>
复制代码
  1. RMAN> list copy;

  2. using target database control file instead of recovery catalog
  3. specification does not match any control file copy in the repository
  4. List of Datafile Copies
  5. =======================

  6. Key     File S Completion Time Ckp SCN    Ckp Time      
  7. ------- ---- - --------------- ---------- ---------------
  8. 3       1    A 11-APR-18       1695966    11-APR-18      
  9.         Name: +FRA/orcl/datafile/system.267.973199737
  10.         Tag: ORA_OEM_LEVEL_0

  11. 2       2    A 11-APR-18       1695929    11-APR-18      
  12.         Name: +FRA/orcl/datafile/sysaux.277.973199731
  13.         Tag: ORA_OEM_LEVEL_0

  14. 4       3    A 11-APR-18       1695977    11-APR-18      
  15.         Name: +FRA/orcl/datafile/undotbs1.262.973199745
  16.         Tag: ORA_OEM_LEVEL_0

  17. 6       4    A 11-APR-18       1696012    11-APR-18      
  18.         Name: +FRA/orcl/datafile/users.350.973199751
  19.         Tag: ORA_OEM_LEVEL_0

  20. 5       5    A 11-APR-18       1695993    11-APR-18      
  21.         Name: +FRA/orcl/datafile/example.351.973199747
  22.         Tag: ORA_OEM_LEVEL_0

  23. List of Archived Log Copies for database with db_unique_name ORCL
  24. =====================================================================

  25. Key     Thrd Seq     S Low Time
  26. ------- ---- ------- - ---------
  27. 95      1    81      A 11-APR-18
  28.         Name: +FRA/orcl/archivelog/2018_04_11/thread_1_seq_81.263.973198807

  29. 96      1    82      A 11-APR-18
  30.         Name: +FRA/orcl/archivelog/2018_04_11/thread_1_seq_82.304.973198817

  31. 97      1    83      A 11-APR-18
  32.         Name: +FRA/orcl/archivelog/2018_04_11/thread_1_seq_83.348.973199765


  33. RMAN>
复制代码

第二天:
  1. RMAN>
  2. connected to target database: ORCL (DBID=1343950367)
  3. using target database control file instead of recovery catalog

  4. RMAN>
  5. echo set on


  6. RMAN> run {
  7. 2> allocate channel oem_disk_backup device type disk;
  8. 3> recover copy of database with tag 'ORA_OEM_LEVEL_0';
  9. 4> backup incremental level 1 cumulative  copies=1 for recover of copy with tag 'ORA_OEM_LEVEL_0' database;
  10. 5> release channel oem_disk_backup;
  11. 6> allocate channel oem_sbt_backup1 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
  12. 7> allocate channel oem_sbt_backup2 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
  13. 8> backup archivelog all not backed up;
  14. 9> }
  15. allocated channel: oem_disk_backup
  16. channel oem_disk_backup: SID=200 device type=DISK

  17. Starting recover at 12-APR-18
  18. no copy of datafile 1 found to recover
  19. no copy of datafile 2 found to recover
  20. no copy of datafile 3 found to recover
  21. no copy of datafile 4 found to recover
  22. no copy of datafile 5 found to recover
  23. Finished recover at 12-APR-18

  24. Starting backup at 12-APR-18
  25. channel oem_disk_backup: starting incremental level 1 datafile backup set
  26. channel oem_disk_backup: specifying datafile(s) in backup set
  27. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.816169553
  28. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.816169553
  29. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.972833355
  30. input datafile file number=00005 name=+DATA/orcl/datafile/example.265.816169651
  31. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.816169553
  32. channel oem_disk_backup: starting piece 1 at 12-APR-18
  33. channel oem_disk_backup: finished piece 1 at 12-APR-18
  34. piece handle=+FRA/orcl/backupset/2018_04_12/nnndn1_ora_oem_level_0_0.345.973286133 tag=ORA_OEM_LEVEL_0 comment=NONE
  35. channel oem_disk_backup: backup set complete, elapsed time: 00:00:08
  36. Finished backup at 12-APR-18

  37. Starting Control File and SPFILE Autobackup at 12-APR-18
  38. piece handle=+FRA/orcl/autobackup/2018_04_12/s_973286135.344.973286135 comment=NONE
  39. Finished Control File and SPFILE Autobackup at 12-APR-18

  40. released channel: oem_disk_backup

  41. allocated channel: oem_sbt_backup1
  42. channel oem_sbt_backup1: SID=200 device type=SBT_TAPE
  43. channel oem_sbt_backup1: Oracle Secure Backup

  44. allocated channel: oem_sbt_backup2
  45. channel oem_sbt_backup2: SID=9 device type=SBT_TAPE
  46. channel oem_sbt_backup2: Oracle Secure Backup

  47. Starting backup at 12-APR-18
  48. current log archived
  49. skipping archived log file +FRA/orcl/archivelog/2018_04_11/thread_1_seq_81.263.973198807; already backed on 11-APR-18
  50. skipping archived log file +FRA/orcl/archivelog/2018_04_11/thread_1_seq_82.304.973198817; already backed on 11-APR-18
  51. skipping archived log file +FRA/orcl/archivelog/2018_04_11/thread_1_seq_83.348.973199765; already backed on 11-APR-18
  52. channel oem_sbt_backup1: starting archived log backup set
  53. channel oem_sbt_backup1: specifying archived log(s) in backup set
  54. input archived log thread=1 sequence=84 RECID=98 STAMP=973285874
  55. input archived log thread=1 sequence=85 RECID=99 STAMP=973286059
  56. channel oem_sbt_backup1: starting piece 1 at 12-APR-18
  57. channel oem_sbt_backup2: starting archived log backup set
  58. channel oem_sbt_backup2: specifying archived log(s) in backup set
  59. input archived log thread=1 sequence=86 RECID=100 STAMP=973286148
  60. channel oem_sbt_backup2: starting piece 1 at 12-APR-18
  61. channel oem_sbt_backup1: finished piece 1 at 12-APR-18
  62. piece handle=1lt06ao4_1_1 tag=TAG20180412T211548 comment=API Version 2.0,MMS Version 10.4.0.4
  63. channel oem_sbt_backup1: backup set complete, elapsed time: 00:00:25
复制代码
多了什么?

  1. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  2. ------- ---- -- ---------- ----------- ------------ ---------------
  3. 46      Incr 1  48.75M     DISK        00:00:05     12-APR-18      
  4.         BP Key: 46   Status: AVAILABLE  Compressed: NO  Tag: ORA_OEM_LEVEL_0
  5.         Piece Name: +FRA/orcl/backupset/2018_04_12/nnndn1_ora_oem_level_0_0.345.973286133
  6.   List of Datafiles in backup set 46
  7.   File LV Type Ckp SCN    Ckp Time  Name
  8.   ---- -- ---- ---------- --------- ----
  9.   1    1  Incr 1740881    12-APR-18 +DATA/orcl/datafile/system.256.816169553
  10.   2    1  Incr 1740881    12-APR-18 +DATA/orcl/datafile/sysaux.257.816169553
  11.   3    1  Incr 1740881    12-APR-18 +DATA/orcl/datafile/undotbs1.258.972833355
  12.   4    1  Incr 1740881    12-APR-18 +DATA/orcl/datafile/users.259.816169553
  13.   5    1  Incr 1740881    12-APR-18 +DATA/orcl/datafile/example.265.816169651

  14. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  15. ------- ---- -- ---------- ----------- ------------ ---------------
  16. 47      Full    9.45M      DISK        00:00:00     12-APR-18      
  17.         BP Key: 47   Status: AVAILABLE  Compressed: NO  Tag: TAG20180412T211535
  18.         Piece Name: +FRA/orcl/autobackup/2018_04_12/s_973286135.344.973286135
  19.   SPFILE Included: Modification time: 12-APR-18
  20.   SPFILE db_unique_name: ORCL
  21.   Control File Included: Ckp SCN: 1742573      Ckp time: 12-APR-18

  22. BS Key  Size       Device Type Elapsed Time Completion Time
  23. ------- ---------- ----------- ------------ ---------------
  24. 48      50.00M     SBT_TAPE    00:00:16     12-APR-18      
  25.         BP Key: 48   Status: AVAILABLE  Compressed: NO  Tag: TAG20180412T211548
  26.         Handle: 1lt06ao4_1_1   Media: station90-000003

  27.   List of Archived Logs in backup set 48
  28.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  29.   ---- ------- ---------- --------- ---------- ---------
  30.   1    84      1696105    11-APR-18 1699635    12-APR-18
  31.   1    85      1699635    12-APR-18 1723330    12-APR-18

  32. BS Key  Size       Device Type Elapsed Time Completion Time
  33. ------- ---------- ----------- ------------ ---------------
  34. 49      8.00M      SBT_TAPE    00:00:25     12-APR-18      
  35.         BP Key: 49   Status: AVAILABLE  Compressed: NO  Tag: TAG20180412T211548
  36.         Handle: 1mt06ao5_1_1   Media: station90-000004

  37.   List of Archived Logs in backup set 49
  38.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  39.   ---- ------- ---------- --------- ---------- ---------
  40.   1    86      1723330    12-APR-18 1746108    12-APR-18

  41. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  42. ------- ---- -- ---------- ----------- ------------ ---------------
  43. 50      Full    9.50M      SBT_TAPE    00:00:16     12-APR-18      
  44.         BP Key: 50   Status: AVAILABLE  Compressed: NO  Tag: TAG20180412T211624
  45.         Handle: c-1343950367-20180412-01   Media: station90-000003
  46.   SPFILE Included: Modification time: 12-APR-18
  47.   SPFILE db_unique_name: ORCL
  48.   Control File Included: Ckp SCN: 1755592      Ckp time: 12-APR-18

  49. RMAN>
复制代码
  1. 98      1    84      A 11-APR-18
  2.         Name: +FRA/orcl/archivelog/2018_04_12/thread_1_seq_84.347.973285875

  3. 99      1    85      A 12-APR-18
  4.         Name: +FRA/orcl/archivelog/2018_04_12/thread_1_seq_85.346.973286059

  5. 100     1    86      A 12-APR-18
  6.         Name: +FRA/orcl/archivelog/2018_04_12/thread_1_seq_86.343.973286149

  7. 101     1    87      A 12-APR-18
  8.         Name: +FRA/orcl/archivelog/2018_04_12/thread_1_seq_87.342.973286343
复制代码

第三天:

  1. Recovery Manager: Release 11.2.0.1.0 - Production on Fri Apr 13 21:15:22 2018

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

  3. RMAN>
  4. connected to target database: ORCL (DBID=1343950367)
  5. using target database control file instead of recovery catalog

  6. RMAN>
  7. echo set on


  8. RMAN> run {
  9. 2> allocate channel oem_disk_backup device type disk;
  10. 3> recover copy of database with tag 'ORA_OEM_LEVEL_0';
  11. 4> backup incremental level 1 cumulative  copies=1 for recover of copy with tag 'ORA_OEM_LEVEL_0' database;
  12. 5> release channel oem_disk_backup;
  13. 6> allocate channel oem_sbt_backup1 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
  14. 7> allocate channel oem_sbt_backup2 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
  15. 8> backup archivelog all not backed up;
  16. 9> }
  17. allocated channel: oem_disk_backup
  18. channel oem_disk_backup: SID=199 device type=DISK

  19. Starting recover at 13-APR-18
  20. channel oem_disk_backup: starting incremental datafile backup set restore
  21. channel oem_disk_backup: specifying datafile copies to recover
  22. recovering datafile copy file number=00001 name=+FRA/orcl/datafile/system.267.973199737
  23. recovering datafile copy file number=00002 name=+FRA/orcl/datafile/sysaux.277.973199731
  24. recovering datafile copy file number=00003 name=+FRA/orcl/datafile/undotbs1.262.973199745
  25. recovering datafile copy file number=00004 name=+FRA/orcl/datafile/users.350.973199751
  26. recovering datafile copy file number=00005 name=+FRA/orcl/datafile/example.351.973199747
  27. channel oem_disk_backup: reading from backup piece +FRA/orcl/backupset/2018_04_12/nnndn1_ora_oem_level_0_0.345.973286133
  28. channel oem_disk_backup: piece handle=+FRA/orcl/backupset/2018_04_12/nnndn1_ora_oem_level_0_0.345.973286133 tag=ORA_OEM_LEVEL_0
  29. channel oem_disk_backup: restored backup piece 1
  30. channel oem_disk_backup: restore complete, elapsed time: 00:00:03
  31. Finished recover at 13-APR-18

  32. Starting backup at 13-APR-18
  33. channel oem_disk_backup: starting incremental level 1 datafile backup set
  34. channel oem_disk_backup: specifying datafile(s) in backup set
  35. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.816169553
  36. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.816169553
  37. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.972833355
  38. input datafile file number=00005 name=+DATA/orcl/datafile/example.265.816169651
  39. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.816169553
  40. channel oem_disk_backup: starting piece 1 at 13-APR-18
  41. channel oem_disk_backup: finished piece 1 at 13-APR-18
  42. piece handle=+FRA/orcl/backupset/2018_04_13/nnndn1_ora_oem_level_0_0.340.973372531 tag=ORA_OEM_LEVEL_0 comment=NONE
  43. channel oem_disk_backup: backup set complete, elapsed time: 00:00:03
  44. Finished backup at 13-APR-18

  45. Starting Control File and SPFILE Autobackup at 13-APR-18
  46. piece handle=+FRA/orcl/autobackup/2018_04_13/s_973372532.339.973372533 comment=NONE
  47. Finished Control File and SPFILE Autobackup at 13-APR-18

  48. released channel: oem_disk_backup

  49. allocated channel: oem_sbt_backup1
  50. channel oem_sbt_backup1: SID=199 device type=SBT_TAPE
  51. channel oem_sbt_backup1: Oracle Secure Backup

  52. allocated channel: oem_sbt_backup2
  53. channel oem_sbt_backup2: SID=145 device type=SBT_TAPE
  54. channel oem_sbt_backup2: Oracle Secure Backup

  55. Starting backup at 13-APR-18
  56. current log archived
  57. skipping archived log file +FRA/orcl/archivelog/2018_04_11/thread_1_seq_81.263.973198807; already backed on 11-APR-18
  58. skipping archived log file +FRA/orcl/archivelog/2018_04_11/thread_1_seq_82.304.973198817; already backed on 11-APR-18
  59. skipping archived log file +FRA/orcl/archivelog/2018_04_11/thread_1_seq_83.348.973199765; already backed on 11-APR-18
  60. skipping archived log file +FRA/orcl/archivelog/2018_04_12/thread_1_seq_84.347.973285875; already backed on 12-APR-18
  61. skipping archived log file +FRA/orcl/archivelog/2018_04_12/thread_1_seq_85.346.973286059; already backed on 12-APR-18
  62. skipping archived log file +FRA/orcl/archivelog/2018_04_12/thread_1_seq_86.343.973286149; already backed on 12-APR-18
  63. channel oem_sbt_backup1: starting archived log backup set
  64. channel oem_sbt_backup1: specifying archived log(s) in backup set
  65. input archived log thread=1 sequence=87 RECID=101 STAMP=973286343
  66. input archived log thread=1 sequence=88 RECID=102 STAMP=973372275
  67. channel oem_sbt_backup1: starting piece 1 at 13-APR-18
  68. channel oem_sbt_backup2: starting archived log backup set
  69. channel oem_sbt_backup2: specifying archived log(s) in backup set
  70. input archived log thread=1 sequence=89 RECID=103 STAMP=973372545
  71. channel oem_sbt_backup2: starting piece 1 at 13-APR-18
  72. channel oem_sbt_backup1: finished piece 1 at 13-APR-18
  73. piece handle=1qt08v41_1_1 tag=TAG20180413T211545 comment=API Version 2.0,MMS Version 10.4.0.4
  74. channel oem_sbt_backup1: backup set complete, elapsed time: 00:00:25
  75. channel oem_sbt_backup2: finished piece 1 at 13-APR-18
  76. piece handle=1rt08v41_1_1 tag=TAG20180413T211545 comment=API Version 2.0,MMS Version 10.4.0.4
  77. channel oem_sbt_backup2: backup set complete, elapsed time: 00:00:25
  78. Finished backup at 13-APR-18

  79. Starting Control File and SPFILE Autobackup at 13-APR-18
  80. piece handle=c-1343950367-20180413-01 comment=API Version 2.0,MMS Version 10.4.0.4
  81. Finished Control File and SPFILE Autobackup at 13-APR-18
  82. released channel: oem_sbt_backup1
  83. released channel: oem_sbt_backup2


  84. RMAN> allocate channel for maintenance device type 'SBT_TAPE' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
复制代码

有什么变化:
  1. RMAN> list copy;

  2. specification does not match any control file copy in the repository
  3. List of Datafile Copies
  4. =======================

  5. Key     File S Completion Time Ckp SCN    Ckp Time      
  6. ------- ---- - --------------- ---------- ---------------
  7. 9       1    A 13-APR-18       1740881    12-APR-18      
  8.         Name: +FRA/orcl/datafile/system.267.973199737
  9.         Tag: ORA_OEM_LEVEL_0

  10. 11      2    A 13-APR-18       1740881    12-APR-18      
  11.         Name: +FRA/orcl/datafile/sysaux.277.973199731
  12.         Tag: ORA_OEM_LEVEL_0

  13. 10      3    A 13-APR-18       1740881    12-APR-18      
  14.         Name: +FRA/orcl/datafile/undotbs1.262.973199745
  15.         Tag: ORA_OEM_LEVEL_0

  16. 8       4    A 13-APR-18       1740881    12-APR-18      
  17.         Name: +FRA/orcl/datafile/users.350.973199751
  18.         Tag: ORA_OEM_LEVEL_0

  19. 7       5    A 13-APR-18       1740881    12-APR-18      
  20.         Name: +FRA/orcl/datafile/example.351.973199747
  21.         Tag: ORA_OEM_LEVEL_0
复制代码


回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2018-9-20 12:44 , Processed in 0.170584 second(s), 24 queries .

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