开启辅助访问

Bo's Oracle Station

Bo's Oracle Station»社区 › SECOUG活动（活动结束图标变灰，但是欢迎继续发帖！） › SECOUG第一期长期技术沙龙 › 第6次活动：2017-08-14（星期一晚上7:00-10:00）
返回列表 发新帖
查看: 1787|回复: 0

第6次活动：2017-08-14（星期一晚上7:00-10:00）

[复制链接]
botang

1005

主题

1469

帖子

1万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
12012
发表于 2017-8-14 21:19:56 | 显示全部楼层 |阅读模式
第6次活动：2017-08-14（星期日晚上7:00-10:00）
脚本：
  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 Mon Aug 14 21:30:24 2017

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

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

  9. RMAN>
  10. echo set on


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

  25. Starting recover at 14-AUG-17
  26. no copy of datafile 1 found to recover
  27. no copy of datafile 2 found to recover
  28. no copy of datafile 3 found to recover
  29. no copy of datafile 4 found to recover
  30. no copy of datafile 5 found to recover
  31. Finished recover at 14-AUG-17

  33. Starting backup at 14-AUG-17
  34. no parent backup or copy of datafile 1 found
  35. no parent backup or copy of datafile 2 found
  36. no parent backup or copy of datafile 3 found
  37. no parent backup or copy of datafile 5 found
  38. no parent backup or copy of datafile 4 found
  39. channel oem_disk_backup: starting datafile copy
  40. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.816169553
  41. output file name=+FRA/orcl/datafile/system.267.952032625 tag=ORA_OEM_LEVEL_0 RECID=2 STAMP=952032629
  42. channel oem_disk_backup: datafile copy complete, elapsed time: 00:00:07
  43. channel oem_disk_backup: starting datafile copy
  44. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.816169553
  45. output file name=+FRA/orcl/datafile/sysaux.266.952032633 tag=ORA_OEM_LEVEL_0 RECID=3 STAMP=952032635
  46. channel oem_disk_backup: datafile copy complete, elapsed time: 00:00:07
  47. channel oem_disk_backup: starting datafile copy
  48. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.816169553
  49. output file name=+FRA/orcl/datafile/undotbs1.265.952032641 tag=ORA_OEM_LEVEL_0 RECID=4 STAMP=952032640
  50. channel oem_disk_backup: datafile copy complete, elapsed time: 00:00:03
  51. channel oem_disk_backup: starting datafile copy
  52. input datafile file number=00005 name=+DATA/orcl/datafile/example.265.816169651
  53. output file name=+FRA/orcl/datafile/example.264.952032643 tag=ORA_OEM_LEVEL_0 RECID=5 STAMP=952032643
  54. channel oem_disk_backup: datafile copy complete, elapsed time: 00:00:01
  55. channel oem_disk_backup: starting datafile copy
  56. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.816169553
  57. output file name=+FRA/orcl/datafile/users.263.952032645 tag=ORA_OEM_LEVEL_0 RECID=6 STAMP=952032644
  58. channel oem_disk_backup: datafile copy complete, elapsed time: 00:00:01
  59. Finished backup at 14-AUG-17

  61. Starting Control File and SPFILE Autobackup at 14-AUG-17
  62. piece handle=+FRA/orcl/autobackup/2017_08_14/s_952032645.261.952032645 comment=NONE
  63. Finished Control File and SPFILE Autobackup at 14-AUG-17

  65. released channel: oem_disk_backup
复制代码

Screenshot.png

第二天：
  1. Recovery Manager: Release 11.2.0.1.0 - Production on Tue Aug 15 21:30:24 2017

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

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

  9. RMAN>
  10. echo set on


  13. RMAN> run {
  14. 2> allocate channel oem_disk_backup device type disk;
  15. 3> recover copy of database with tag 'ORA_OEM_LEVEL_0';
  16. 4> backup incremental level 1 cumulative  copies=1 for recover of copy with tag 'ORA_OEM_LEVEL_0' database;
  17. 5> release channel oem_disk_backup;
  18. 6> allocate channel oem_sbt_backup1 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
  19. 7> allocate channel oem_sbt_backup2 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
  20. 8> backup recovery area;
  21. 9> }
  22. allocated channel: oem_disk_backup
  23. channel oem_disk_backup: SID=196 device type=DISK

  25. Starting recover at 15-AUG-17
  26. no copy of datafile 1 found to recover
  27. no copy of datafile 2 found to recover
  28. no copy of datafile 3 found to recover
  29. no copy of datafile 4 found to recover
  30. no copy of datafile 5 found to recover
  31. Finished recover at 15-AUG-17

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

  47. Starting Control File and SPFILE Autobackup at 15-AUG-17
  48. piece handle=+FRA/orcl/autobackup/2017_08_15/s_952119029.269.952119029 comment=NONE
  49. Finished Control File and SPFILE Autobackup at 15-AUG-17

  51. released channel: oem_disk_backup

  53. allocated channel: oem_sbt_backup1
  54. channel oem_sbt_backup1: SID=196 device type=SBT_TAPE
  55. channel oem_sbt_backup1: Oracle Secure Backup

  57. allocated channel: oem_sbt_backup2
  58. channel oem_sbt_backup2: SID=71 device type=SBT_TAPE
  59. channel oem_sbt_backup2: Oracle Secure Backup

  61. Starting backup at 15-AUG-17
  62. skipping archived log file +FRA/orcl/archivelog/2017_08_14/thread_1_seq_27.262.952032659; already backed up 1 time(s)
  63. channel oem_sbt_backup1: starting full datafile backup set
  64. channel oem_sbt_backup1: including datafile copy of datafile 00001 in backup set
  65. input file name=+FRA/orcl/datafile/system.267.952032625
  66. channel oem_sbt_backup1: including datafile copy of datafile 00005 in backup set
  67. input file name=+FRA/orcl/datafile/example.264.952032643
  68. channel oem_sbt_backup1: starting piece 1 at 15-AUG-17
  69. channel oem_sbt_backup2: starting full datafile backup set
  70. channel oem_sbt_backup2: including datafile copy of datafile 00002 in backup set
  71. input file name=+FRA/orcl/datafile/sysaux.266.952032633
  72. channel oem_sbt_backup2: including datafile copy of datafile 00003 in backup set
  73. input file name=+FRA/orcl/datafile/undotbs1.265.952032641
  74. channel oem_sbt_backup2: including datafile copy of datafile 00004 in backup set
  75. input file name=+FRA/orcl/datafile/users.263.952032645
  76. channel oem_sbt_backup2: starting piece 1 at 15-AUG-17
  77. channel oem_sbt_backup1: finished piece 1 at 15-AUG-17
  78. piece handle=1gsc0bo2_1_1 tag=TAG20170815T213042 comment=API Version 2.0,MMS Version 10.4.0.4
  79. channel oem_sbt_backup1: backup set complete, elapsed time: 00:00:36
  80. channel oem_sbt_backup2: finished piece 1 at 15-AUG-17
  81. piece handle=1hsc0bo2_1_1 tag=TAG20170815T213042 comment=API Version 2.0,MMS Version 10.4.0.4
  82. channel oem_sbt_backup2: backup set complete, elapsed time: 00:00:35
  83. channel oem_sbt_backup1: input backup set: count=43, stamp=952032645, piece=1
  84. channel oem_sbt_backup1: starting piece 1 at 15-AUG-17
  85. channel oem_sbt_backup1: backup piece +FRA/orcl/autobackup/2017_08_14/s_952032645.261.952032645
  86. channel oem_sbt_backup2: input backup set: count=46, stamp=952119026, piece=1
  87. channel oem_sbt_backup2: starting piece 1 at 15-AUG-17
  88. channel oem_sbt_backup2: backup piece +FRA/orcl/backupset/2017_08_15/nnndn1_ora_oem_level_0_0.268.952119027
  89. piece handle=c-1343950367-20170814-00 comment=API Version 2.0,MMS Version 10.4.0.4
  90. channel oem_sbt_backup1: finished piece 1 at 15-AUG-17
  91. channel oem_sbt_backup1: backup piece complete, elapsed time: 00:00:25
  92. channel oem_sbt_backup1: input backup set: count=47, stamp=952119029, piece=1
  93. channel oem_sbt_backup1: starting piece 1 at 15-AUG-17
  94. channel oem_sbt_backup1: backup piece +FRA/orcl/autobackup/2017_08_15/s_952119029.269.952119029
  95. piece handle=1esc0bni_1_2 comment=API Version 2.0,MMS Version 10.4.0.4
  96. channel oem_sbt_backup2: finished piece 1 at 15-AUG-17
  97. channel oem_sbt_backup2: backup piece complete, elapsed time: 00:00:25
  98. piece handle=c-1343950367-20170815-00 comment=API Version 2.0,MMS Version 10.4.0.4
  99. channel oem_sbt_backup1: finished piece 1 at 15-AUG-17
  100. channel oem_sbt_backup1: backup piece complete, elapsed time: 00:00:25
  101. Finished backup at 15-AUG-17

  103. Starting Control File and SPFILE Autobackup at 15-AUG-17
  104. piece handle=c-1343950367-20170815-01 comment=API Version 2.0,MMS Version 10.4.0.4
  105. Finished Control File and SPFILE Autobackup at 15-AUG-17
  106. released channel: oem_sbt_backup1
  107. released channel: oem_sbt_backup2


  110. RMAN> allocate channel for maintenance device type 'SBT_TAPE' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
  111. allocated channel: ORA_MAINT_SBT_TAPE_1
  112. channel ORA_MAINT_SBT_TAPE_1: SID=196 device type=SBT_TAPE
  113. channel ORA_MAINT_SBT_TAPE_1: Oracle Secure Backup


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


  120. RMAN> exit;

  122. Recovery Manager complete.
复制代码
第三天：
  1. Recovery Manager: Release 11.2.0.1.0 - Production on Wed Aug 16 21:30:30 2017

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

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

  9. RMAN>
  10. echo set on


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

  25. Starting recover at 16-AUG-17
  26. channel oem_disk_backup: starting incremental datafile backup set restore
  27. channel oem_disk_backup: specifying datafile copies to recover
  28. recovering datafile copy file number=00001 name=+FRA/orcl/datafile/system.267.952032625
  29. recovering datafile copy file number=00002 name=+FRA/orcl/datafile/sysaux.266.952032633
  30. recovering datafile copy file number=00003 name=+FRA/orcl/datafile/undotbs1.265.952032641
  31. recovering datafile copy file number=00004 name=+FRA/orcl/datafile/users.263.952032645
  32. recovering datafile copy file number=00005 name=+FRA/orcl/datafile/example.264.952032643
  33. channel oem_disk_backup: reading from backup piece +FRA/orcl/backupset/2017_08_15/nnndn1_ora_oem_level_0_0.268.952119027
  34. channel oem_disk_backup: piece handle=+FRA/orcl/backupset/2017_08_15/nnndn1_ora_oem_level_0_0.268.952119027 tag=ORA_OEM_LEVEL_0
  35. channel oem_disk_backup: restored backup piece 1
  36. channel oem_disk_backup: restore complete, elapsed time: 00:00:03
  37. Finished recover at 16-AUG-17

  39. Starting backup at 16-AUG-17
  40. channel oem_disk_backup: starting incremental level 1 datafile backup set
  41. channel oem_disk_backup: specifying datafile(s) in backup set
  42. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.816169553
  43. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.816169553
  44. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.816169553
  45. input datafile file number=00005 name=+DATA/orcl/datafile/example.265.816169651
  46. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.816169553
  47. channel oem_disk_backup: starting piece 1 at 16-AUG-17
  48. channel oem_disk_backup: finished piece 1 at 16-AUG-17
  49. piece handle=+FRA/orcl/backupset/2017_08_16/nnndn1_ora_oem_level_0_0.270.952205439 tag=ORA_OEM_LEVEL_0 comment=NONE
  50. channel oem_disk_backup: backup set complete, elapsed time: 00:00:03
  51. Finished backup at 16-AUG-17

  53. Starting Control File and SPFILE Autobackup at 16-AUG-17
  54. piece handle=+FRA/orcl/autobackup/2017_08_16/s_952205439.271.952205441 comment=NONE
  55. Finished Control File and SPFILE Autobackup at 16-AUG-17

  57. released channel: oem_disk_backup

  59. allocated channel: oem_sbt_backup1
  60. channel oem_sbt_backup1: SID=196 device type=SBT_TAPE
  61. channel oem_sbt_backup1: Oracle Secure Backup

  63. allocated channel: oem_sbt_backup2
  64. channel oem_sbt_backup2: SID=198 device type=SBT_TAPE
  65. channel oem_sbt_backup2: Oracle Secure Backup

  67. Starting backup at 16-AUG-17
  68. current log archived
  69. skipping archived log file +FRA/orcl/archivelog/2017_08_14/thread_1_seq_27.262.952032659; already backed on 14-AUG-17
  70. channel oem_sbt_backup1: starting archived log backup set
  71. channel oem_sbt_backup1: specifying archived log(s) in backup set
  72. input archived log thread=1 sequence=28 RECID=20 STAMP=952205452
  73. channel oem_sbt_backup1: starting piece 1 at 16-AUG-17
  74. channel oem_sbt_backup1: finished piece 1 at 16-AUG-17
  75. piece handle=1lsc304d_1_1 tag=TAG20170816T213053 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. Finished backup at 16-AUG-17

  79. Starting Control File and SPFILE Autobackup at 16-AUG-17
  80. piece handle=c-1343950367-20170816-01 comment=API Version 2.0,MMS Version 10.4.0.4
  81. Finished Control File and SPFILE Autobackup at 16-AUG-17
  82. released channel: oem_sbt_backup1
  83. 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=196 device type=SBT_TAPE
  89. channel ORA_MAINT_SBT_TAPE_1: Oracle Secure Backup


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


  96. RMAN> exit;

  98. Recovery Manager complete.
复制代码
Screenshot-1.png




回复

使用道具 举报

返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|Bo's Oracle Station   

GMT+8, 2024-4-23 23:14 , Processed in 0.151893 second(s), 27 queries .

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