开启辅助访问

Bo's Oracle Station

Bo's Oracle Station»社区 › 培训进行时（结课后图标变灰，但是欢迎继续发帖！） › 4078-11g管理类OCP认证班第五期（WDP提速） › 课程第13次（2018-06-19星期二）
返回列表 发新帖
查看: 2206|回复: 0

课程第13次（2018-06-19星期二）

[复制链接]
botang

1005

主题

1469

帖子

1万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
12012
发表于 2018-6-19 20:07:31 | 显示全部楼层 |阅读模式
Oracle Suggested Backup策略：
a.png

b.png


要做实验，请把weekli备份放在第4天：

c.png

第一天：
  1. Recovery Manager: Release 11.2.0.1.0 - Production on Tue Jun 19 20:15:23 2018

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

  5. RMAN>
  6. connected to target database: ORCL (DBID=1359978017)
  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=station86)';
  19. 7> allocate channel oem_sbt_backup2 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station86)';
  20. 8> backup archivelog all not backed up;
  21. 9> }
  22. allocated channel: oem_disk_backup
  23. channel oem_disk_backup: SID=197 device type=DISK

  25. Starting recover at 2018-06-19:20:15:24
  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. no copy of datafile 6 found to recover
  32. no copy of datafile 7 found to recover
  33. Finished recover at 2018-06-19:20:15:24

  35. Starting backup at 2018-06-19:20:15:25
  36. no parent backup or copy of datafile 1 found
  37. no parent backup or copy of datafile 2 found
  38. no parent backup or copy of datafile 3 found
  39. no parent backup or copy of datafile 5 found
  40. no parent backup or copy of datafile 4 found
  41. no parent backup or copy of datafile 6 found
  42. no parent backup or copy of datafile 7 found
  43. channel oem_disk_backup: starting datafile copy
  44. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.978643425
  45. output file name=+FRA/orcl/datafile/system.304.979244125 tag=ORA_OEM_LEVEL_0 RECID=11 STAMP=979244151
  46. channel oem_disk_backup: datafile copy complete, elapsed time: 00:00:35
  47. channel oem_disk_backup: starting datafile copy
  48. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.258.978643425
  49. output file name=+FRA/orcl/datafile/sysaux.305.979244161 tag=ORA_OEM_LEVEL_0 RECID=12 STAMP=979244182
  50. channel oem_disk_backup: datafile copy complete, elapsed time: 00:00:25
  51. channel oem_disk_backup: starting datafile copy
  52. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.259.978643423
  53. output file name=+FRA/orcl/datafile/undotbs1.357.979244187 tag=ORA_OEM_LEVEL_0 RECID=13 STAMP=979244197
  54. channel oem_disk_backup: datafile copy complete, elapsed time: 00:00:15
  55. channel oem_disk_backup: starting datafile copy
  56. input datafile file number=00005 name=+DATA/orcl/datafile/example.257.978643425
  57. output file name=+FRA/orcl/datafile/example.358.979244201 tag=ORA_OEM_LEVEL_0 RECID=14 STAMP=979244209
  58. channel oem_disk_backup: datafile copy complete, elapsed time: 00:00:15
  59. channel oem_disk_backup: starting datafile copy
  60. input datafile file number=00004 name=+DATA/orcl/datafile/users.265.978645015
  61. output file name=+FRA/orcl/datafile/users.356.979244217 tag=ORA_OEM_LEVEL_0 RECID=15 STAMP=979244216
  62. channel oem_disk_backup: datafile copy complete, elapsed time: 00:00:01
  63. channel oem_disk_backup: starting datafile copy
  64. input datafile file number=00006 name=+DATA/orcl/datafile/tbs1.267.978952849
  65. output file name=+FRA/orcl/datafile/tbs1.359.979244217 tag=ORA_OEM_LEVEL_0 RECID=16 STAMP=979244218
  66. channel oem_disk_backup: datafile copy complete, elapsed time: 00:00:01
  67. channel oem_disk_backup: starting datafile copy
  68. input datafile file number=00007 name=+DATA/orcl/datafile/tbs2.268.978952865
  69. output file name=+FRA/orcl/datafile/tbs2.352.979244219 tag=ORA_OEM_LEVEL_0 RECID=17 STAMP=979244219
  70. channel oem_disk_backup: datafile copy complete, elapsed time: 00:00:01
  71. Finished backup at 2018-06-19:20:16:59

  73. Starting Control File and SPFILE Autobackup at 2018-06-19:20:17:00
  74. piece handle=+FRA/orcl/autobackup/2018_06_19/s_979244220.351.979244221 comment=NONE
  75. Finished Control File and SPFILE Autobackup at 2018-06-19:20:17:03

  77. released channel: oem_disk_backup

  79. allocated channel: oem_sbt_backup1
  80. channel oem_sbt_backup1: SID=197 device type=SBT_TAPE
  81. channel oem_sbt_backup1: Oracle Secure Backup

  83. allocated channel: oem_sbt_backup2
  84. channel oem_sbt_backup2: SID=144 device type=SBT_TAPE
  85. channel oem_sbt_backup2: Oracle Secure Backup

  87. Starting backup at 2018-06-19:20:17:04
  88. current log archived
  89. channel oem_sbt_backup1: starting archived log backup set
  90. channel oem_sbt_backup1: specifying archived log(s) in backup set
  91. input archived log thread=1 sequence=3 RECID=104 STAMP=978944162
  92. channel oem_sbt_backup1: starting piece 1 at 2018-06-19:20:17:05
  93. channel oem_sbt_backup2: starting archived log backup set
  94. channel oem_sbt_backup2: specifying archived log(s) in backup set
  95. input archived log thread=1 sequence=12 RECID=113 STAMP=979244225
  96. channel oem_sbt_backup2: starting piece 1 at 2018-06-19:20:17:05
  97. channel oem_sbt_backup1: finished piece 1 at 2018-06-19:20:18:30
  98. piece handle=39t5s561_1_1 tag=TAG20180619T201705 comment=API Version 2.0,MMS Version 10.3.0.2
  99. channel oem_sbt_backup1: backup set complete, elapsed time: 00:01:25
  100. channel oem_sbt_backup2: finished piece 1 at 2018-06-19:20:18:30
  101. piece handle=3at5s561_1_1 tag=TAG20180619T201705 comment=API Version 2.0,MMS Version 10.3.0.2
  102. channel oem_sbt_backup2: backup set complete, elapsed time: 00:01:25
  103. Finished backup at 2018-06-19:20:18:30

  105. Starting Control File and SPFILE Autobackup at 2018-06-19:20:18:30
  106. piece handle=c-1359978017-20180619-01 comment=API Version 2.0,MMS Version 10.3.0.2
  107. Finished Control File and SPFILE Autobackup at 2018-06-19:20:19:06
  108. released channel: oem_sbt_backup1
  109. released channel: oem_sbt_backup2


  112. RMAN> allocate channel for maintenance device type 'SBT_TAPE' parms 'ENV=(OB_MEDIA_FAMILY=station86)';
  113. allocated channel: ORA_MAINT_SBT_TAPE_1
  114. channel ORA_MAINT_SBT_TAPE_1: SID=197 device type=SBT_TAPE
  115. channel ORA_MAINT_SBT_TAPE_1: Oracle Secure Backup


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


  122. RMAN> exit;

  124. Recovery Manager complete.
复制代码
d.png
第二天：

  1. Recovery Manager: Release 11.2.0.1.0 - Production on Wed Jun 20 20:15:27 2018

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

  5. RMAN>
  6. connected to target database: ORCL (DBID=1359978017)
  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=station86)';
  19. 7> allocate channel oem_sbt_backup2 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station86)';
  20. 8> backup archivelog all not backed up;
  21. 9> }
  22. allocated channel: oem_disk_backup
  23. channel oem_disk_backup: SID=12 device type=DISK

  25. Starting recover at 2018-06-20:20:15:29
  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. no copy of datafile 6 found to recover
  32. no copy of datafile 7 found to recover
  33. Finished recover at 2018-06-20:20:15:29

  35. Starting backup at 2018-06-20:20:15:29
  36. channel oem_disk_backup: starting incremental level 1 datafile backup set
  37. channel oem_disk_backup: specifying datafile(s) in backup set
  38. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.978643425
  39. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.258.978643425
  40. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.259.978643423
  41. input datafile file number=00005 name=+DATA/orcl/datafile/example.257.978643425
  42. input datafile file number=00004 name=+DATA/orcl/datafile/users.265.978645015
  43. input datafile file number=00006 name=+DATA/orcl/datafile/tbs1.267.978952849
  44. input datafile file number=00007 name=+DATA/orcl/datafile/tbs2.268.978952865
  45. channel oem_disk_backup: starting piece 1 at 2018-06-20:20:15:29
  46. channel oem_disk_backup: finished piece 1 at 2018-06-20:20:15:36
  47. piece handle=+FRA/orcl/backupset/2018_06_20/nnndn1_ora_oem_level_0_0.323.979330531 tag=ORA_OEM_LEVEL_0 comment=NONE
  48. channel oem_disk_backup: backup set complete, elapsed time: 00:00:07
  49. Finished backup at 2018-06-20:20:15:36

  51. Starting Control File and SPFILE Autobackup at 2018-06-20:20:15:36
  52. piece handle=+FRA/orcl/autobackup/2018_06_20/s_979330536.355.979330537 comment=NONE
  53. Finished Control File and SPFILE Autobackup at 2018-06-20:20:15:39

  55. released channel: oem_disk_backup

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

  61. allocated channel: oem_sbt_backup2
  62. channel oem_sbt_backup2: SID=17 device type=SBT_TAPE
  63. channel oem_sbt_backup2: Oracle Secure Backup

  65. Starting backup at 2018-06-20:20:15:41
  66. current log archived
  67. skipping archived log file +FRA/orcl/archivelog/2018_06_16/thread_1_seq_3.346.978944161; already backed on 2018-06-19:20:18:28
  68. skipping archived log file +FRA/orcl/archivelog/2018_06_19/thread_1_seq_12.267.979244225; already backed on 2018-06-19:20:18:24
  69. channel oem_sbt_backup1: starting archived log backup set
  70. channel oem_sbt_backup1: specifying archived log(s) in backup set
  71. input archived log thread=1 sequence=13 RECID=114 STAMP=979330541
  72. channel oem_sbt_backup1: starting piece 1 at 2018-06-20:20:15:42
  73. channel oem_sbt_backup1: finished piece 1 at 2018-06-20:20:16:47
  74. piece handle=3et5upfe_1_1 tag=TAG20180620T201541 comment=API Version 2.0,MMS Version 10.3.0.2
  75. channel oem_sbt_backup1: backup set complete, elapsed time: 00:01:05
  76. Finished backup at 2018-06-20:20:16:47

  78. Starting Control File and SPFILE Autobackup at 2018-06-20:20:16:47
  79. piece handle=c-1359978017-20180620-01 comment=API Version 2.0,MMS Version 10.3.0.2
  80. Finished Control File and SPFILE Autobackup at 2018-06-20:20:17:22
  81. released channel: oem_sbt_backup1
  82. released channel: oem_sbt_backup2


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


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


  95. RMAN> exit;

  97. Recovery Manager complete.
复制代码

第三天（把0级镜像拷贝的时间向前推动）：

d.png

  1. Recovery Manager: Release 11.2.0.1.0 - Production on Thu Jun 21 20:15:29 2018

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

  5. RMAN>
  6. connected to target database: ORCL (DBID=1359978017)
  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=station86)';
  19. 7> allocate channel oem_sbt_backup2 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station86)';
  20. 8> backup archivelog all not backed up;
  21. 9> }
  22. allocated channel: oem_disk_backup
  23. channel oem_disk_backup: SID=79 device type=DISK

  25. Starting recover at 2018-06-21:20:15:30
  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.304.979244125
  29. recovering datafile copy file number=00002 name=+FRA/orcl/datafile/sysaux.305.979244161
  30. recovering datafile copy file number=00003 name=+FRA/orcl/datafile/undotbs1.357.979244187
  31. recovering datafile copy file number=00004 name=+FRA/orcl/datafile/users.356.979244217
  32. recovering datafile copy file number=00005 name=+FRA/orcl/datafile/example.358.979244201
  33. recovering datafile copy file number=00006 name=+FRA/orcl/datafile/tbs1.359.979244217
  34. recovering datafile copy file number=00007 name=+FRA/orcl/datafile/tbs2.352.979244219
  35. channel oem_disk_backup: reading from backup piece +FRA/orcl/backupset/2018_06_20/nnndn1_ora_oem_level_0_0.323.979330531
  36. channel oem_disk_backup: piece handle=+FRA/orcl/backupset/2018_06_20/nnndn1_ora_oem_level_0_0.323.979330531 tag=ORA_OEM_LEVEL_0
  37. channel oem_disk_backup: restored backup piece 1
  38. channel oem_disk_backup: restore complete, elapsed time: 00:00:03
  39. Finished recover at 2018-06-21:20:15:34

  41. Starting backup at 2018-06-21:20:15:34
  42. channel oem_disk_backup: starting incremental level 1 datafile backup set
  43. channel oem_disk_backup: specifying datafile(s) in backup set
  44. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.978643425
  45. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.258.978643425
  46. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.259.978643423
  47. input datafile file number=00005 name=+DATA/orcl/datafile/example.257.978643425
  48. input datafile file number=00004 name=+DATA/orcl/datafile/users.265.978645015
  49. input datafile file number=00006 name=+DATA/orcl/datafile/tbs1.267.978952849
  50. input datafile file number=00007 name=+DATA/orcl/datafile/tbs2.268.978952865
  51. channel oem_disk_backup: starting piece 1 at 2018-06-21:20:15:35
  52. channel oem_disk_backup: finished piece 1 at 2018-06-21:20:15:42
  53. piece handle=+FRA/orcl/backupset/2018_06_21/nnndn1_ora_oem_level_0_0.345.979416935 tag=ORA_OEM_LEVEL_0 comment=NONE
  54. channel oem_disk_backup: backup set complete, elapsed time: 00:00:07
  55. Finished backup at 2018-06-21:20:15:42

  57. Starting Control File and SPFILE Autobackup at 2018-06-21:20:15:42
  58. piece handle=+FRA/orcl/autobackup/2018_06_21/s_979416942.286.979416943 comment=NONE
  59. Finished Control File and SPFILE Autobackup at 2018-06-21:20:15:45

  61. released channel: oem_disk_backup

  63. allocated channel: oem_sbt_backup1
  64. channel oem_sbt_backup1: SID=79 device type=SBT_TAPE
  65. channel oem_sbt_backup1: Oracle Secure Backup

  67. allocated channel: oem_sbt_backup2
  68. channel oem_sbt_backup2: SID=78 device type=SBT_TAPE
  69. channel oem_sbt_backup2: Oracle Secure Backup

  71. Starting backup at 2018-06-21:20:15:46
  72. current log archived
  73. skipping archived log file +FRA/orcl/archivelog/2018_06_16/thread_1_seq_3.346.978944161; already backed on 2018-06-19:20:18:28
  74. skipping archived log file +FRA/orcl/archivelog/2018_06_19/thread_1_seq_12.267.979244225; already backed on 2018-06-19:20:18:24
  75. skipping archived log file +FRA/orcl/archivelog/2018_06_20/thread_1_seq_13.354.979330541; already backed on 2018-06-20:20:16:37
  76. channel oem_sbt_backup1: starting archived log backup set
  77. channel oem_sbt_backup1: specifying archived log(s) in backup set
  78. input archived log thread=1 sequence=14 RECID=115 STAMP=979416947
  79. channel oem_sbt_backup1: starting piece 1 at 2018-06-21:20:15:47
  80. channel oem_sbt_backup1: finished piece 1 at 2018-06-21:20:16:52
  81. piece handle=3it61drj_1_1 tag=TAG20180621T201547 comment=API Version 2.0,MMS Version 10.3.0.2
  82. channel oem_sbt_backup1: backup set complete, elapsed time: 00:01:05
  83. Finished backup at 2018-06-21:20:16:52

  85. Starting Control File and SPFILE Autobackup at 2018-06-21:20:16:52
  86. piece handle=c-1359978017-20180621-01 comment=API Version 2.0,MMS Version 10.3.0.2
  87. Finished Control File and SPFILE Autobackup at 2018-06-21:20:17:27
  88. released channel: oem_sbt_backup1
  89. released channel: oem_sbt_backup2


  92. RMAN> allocate channel for maintenance device type 'SBT_TAPE' parms 'ENV=(OB_MEDIA_FAMILY=station86)';
  93. allocated channel: ORA_MAINT_SBT_TAPE_1
  94. channel ORA_MAINT_SBT_TAPE_1: SID=79 device type=SBT_TAPE
  95. channel ORA_MAINT_SBT_TAPE_1: Oracle Secure Backup


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


  102. RMAN> exit;

  104. Recovery Manager complete.
复制代码
第四天（周备份）：
e.png

  1. Recovery Manager: Release 11.2.0.1.0 - Production on Fri Jun 22 20:15:27 2018

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

  5. RMAN>
  6. connected to target database: ORCL (DBID=1359978017)
  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=station86)';
  19. 7> allocate channel oem_sbt_backup2 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station86)';
  20. 8> backup recovery area;
  21. 9> }
  22. allocated channel: oem_disk_backup
  23. channel oem_disk_backup: SID=135 device type=DISK

  25. Starting recover at 2018-06-22:20:15:28
  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.304.979244125
  29. recovering datafile copy file number=00002 name=+FRA/orcl/datafile/sysaux.305.979244161
  30. recovering datafile copy file number=00003 name=+FRA/orcl/datafile/undotbs1.357.979244187
  31. recovering datafile copy file number=00004 name=+FRA/orcl/datafile/users.356.979244217
  32. recovering datafile copy file number=00005 name=+FRA/orcl/datafile/example.358.979244201
  33. recovering datafile copy file number=00006 name=+FRA/orcl/datafile/tbs1.359.979244217
  34. recovering datafile copy file number=00007 name=+FRA/orcl/datafile/tbs2.352.979244219
  35. channel oem_disk_backup: reading from backup piece +FRA/orcl/backupset/2018_06_21/nnndn1_ora_oem_level_0_0.345.979416935
  36. channel oem_disk_backup: piece handle=+FRA/orcl/backupset/2018_06_21/nnndn1_ora_oem_level_0_0.345.979416935 tag=ORA_OEM_LEVEL_0
  37. channel oem_disk_backup: restored backup piece 1
  38. channel oem_disk_backup: restore complete, elapsed time: 00:00:03
  39. Finished recover at 2018-06-22:20:15:32

  41. Starting backup at 2018-06-22:20:15:33
  42. channel oem_disk_backup: starting incremental level 1 datafile backup set
  43. channel oem_disk_backup: specifying datafile(s) in backup set
  44. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.978643425
  45. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.258.978643425
  46. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.259.978643423
  47. input datafile file number=00005 name=+DATA/orcl/datafile/example.257.978643425
  48. input datafile file number=00004 name=+DATA/orcl/datafile/users.265.978645015
  49. input datafile file number=00006 name=+DATA/orcl/datafile/tbs1.267.978952849
  50. input datafile file number=00007 name=+DATA/orcl/datafile/tbs2.268.978952865
  51. channel oem_disk_backup: starting piece 1 at 2018-06-22:20:15:34
  52. channel oem_disk_backup: finished piece 1 at 2018-06-22:20:15:41
  53. piece handle=+FRA/orcl/backupset/2018_06_22/nnndn1_ora_oem_level_0_0.337.979503335 tag=ORA_OEM_LEVEL_0 comment=NONE
  54. channel oem_disk_backup: backup set complete, elapsed time: 00:00:07
  55. Finished backup at 2018-06-22:20:15:41

  57. Starting Control File and SPFILE Autobackup at 2018-06-22:20:15:41
  58. piece handle=+FRA/orcl/autobackup/2018_06_22/s_979503341.336.979503341 comment=NONE
  59. Finished Control File and SPFILE Autobackup at 2018-06-22:20:15:44

  61. released channel: oem_disk_backup

  63. allocated channel: oem_sbt_backup1
  64. channel oem_sbt_backup1: SID=135 device type=SBT_TAPE
  65. channel oem_sbt_backup1: Oracle Secure Backup

  67. allocated channel: oem_sbt_backup2
  68. channel oem_sbt_backup2: SID=140 device type=SBT_TAPE
  69. channel oem_sbt_backup2: Oracle Secure Backup

  71. Starting backup at 2018-06-22:20:15:45
  72. skipping archived log file +FRA/orcl/archivelog/2018_06_16/thread_1_seq_3.346.978944161; already backed up 1 time(s)
  73. skipping archived log file +FRA/orcl/archivelog/2018_06_19/thread_1_seq_12.267.979244225; already backed up 1 time(s)
  74. skipping archived log file +FRA/orcl/archivelog/2018_06_20/thread_1_seq_13.354.979330541; already backed up 1 time(s)
  75. skipping archived log file +FRA/orcl/archivelog/2018_06_21/thread_1_seq_14.338.979416947; already backed up 1 time(s)
  76. channel oem_sbt_backup1: starting full datafile backup set
  77. channel oem_sbt_backup1: including datafile copy of datafile 00002 in backup set
  78. input file name=+FRA/orcl/datafile/sysaux.305.979244161
  79. channel oem_sbt_backup1: including datafile copy of datafile 00003 in backup set
  80. input file name=+FRA/orcl/datafile/undotbs1.357.979244187
  81. channel oem_sbt_backup1: including datafile copy of datafile 00005 in backup set
  82. input file name=+FRA/orcl/datafile/example.358.979244201
  83. channel oem_sbt_backup1: starting piece 1 at 2018-06-22:20:15:46
  84. channel oem_sbt_backup2: starting full datafile backup set
  85. channel oem_sbt_backup2: including datafile copy of datafile 00001 in backup set
  86. input file name=+FRA/orcl/datafile/system.304.979244125
  87. channel oem_sbt_backup2: including datafile copy of datafile 00004 in backup set
  88. input file name=+FRA/orcl/datafile/users.356.979244217
  89. channel oem_sbt_backup2: including datafile copy of datafile 00006 in backup set
  90. input file name=+FRA/orcl/datafile/tbs1.359.979244217
  91. channel oem_sbt_backup2: including datafile copy of datafile 00007 in backup set
  92. input file name=+FRA/orcl/datafile/tbs2.352.979244219
  93. channel oem_sbt_backup2: starting piece 1 at 2018-06-22:20:15:46
  94. channel oem_sbt_backup2: finished piece 1 at 2018-06-22:20:17:41
  95. piece handle=3nt6427i_1_1 tag=TAG20180622T201545 comment=API Version 2.0,MMS Version 10.3.0.2
  96. channel oem_sbt_backup2: backup set complete, elapsed time: 00:01:55
  97. channel oem_sbt_backup2: input backup set: count=104, stamp=979244220, piece=1
  98. channel oem_sbt_backup2: starting piece 1 at 2018-06-22:20:17:42
  99. channel oem_sbt_backup2: backup piece +FRA/orcl/autobackup/2018_06_19/s_979244220.351.979244221
  100. channel oem_sbt_backup1: finished piece 1 at 2018-06-22:20:18:07
  101. piece handle=3mt6427h_1_1 tag=TAG20180622T201545 comment=API Version 2.0,MMS Version 10.3.0.2
  102. channel oem_sbt_backup1: backup set complete, elapsed time: 00:02:21
  103. channel oem_sbt_backup1: input backup set: count=108, stamp=979330529, piece=1
  104. channel oem_sbt_backup1: starting piece 1 at 2018-06-22:20:18:07
  105. channel oem_sbt_backup1: backup piece +FRA/orcl/backupset/2018_06_20/nnndn1_ora_oem_level_0_0.323.979330531
  106. piece handle=c-1359978017-20180619-00 comment=API Version 2.0,MMS Version 10.3.0.2
  107. channel oem_sbt_backup2: finished piece 1 at 2018-06-22:20:18:32
  108. channel oem_sbt_backup2: backup piece complete, elapsed time: 00:00:50
  109. channel oem_sbt_backup2: input backup set: count=109, stamp=979330536, piece=1
  110. channel oem_sbt_backup2: starting piece 1 at 2018-06-22:20:18:32
  111. channel oem_sbt_backup2: backup piece +FRA/orcl/autobackup/2018_06_20/s_979330536.355.979330537
  112. piece handle=3ct5upf1_1_2 comment=API Version 2.0,MMS Version 10.3.0.2
  113. channel oem_sbt_backup1: finished piece 1 at 2018-06-22:20:18:57
  114. channel oem_sbt_backup1: backup piece complete, elapsed time: 00:00:50
  115. channel oem_sbt_backup1: input backup set: count=112, stamp=979416935, piece=1
  116. channel oem_sbt_backup1: starting piece 1 at 2018-06-22:20:18:57
  117. channel oem_sbt_backup1: backup piece +FRA/orcl/backupset/2018_06_21/nnndn1_ora_oem_level_0_0.345.979416935
  118. piece handle=c-1359978017-20180620-00 comment=API Version 2.0,MMS Version 10.3.0.2
  119. channel oem_sbt_backup2: finished piece 1 at 2018-06-22:20:19:04
  120. channel oem_sbt_backup2: backup piece complete, elapsed time: 00:00:32
  121. channel oem_sbt_backup2: input backup set: count=113, stamp=979416942, piece=1
  122. channel oem_sbt_backup2: starting piece 1 at 2018-06-22:20:19:04
  123. channel oem_sbt_backup2: backup piece +FRA/orcl/autobackup/2018_06_21/s_979416942.286.979416943
  124. piece handle=3gt61dr7_1_2 comment=API Version 2.0,MMS Version 10.3.0.2
  125. channel oem_sbt_backup1: finished piece 1 at 2018-06-22:20:19:40
  126. channel oem_sbt_backup1: backup piece complete, elapsed time: 00:00:43
  127. channel oem_sbt_backup1: input backup set: count=116, stamp=979503333, piece=1
  128. channel oem_sbt_backup1: starting piece 1 at 2018-06-22:20:19:40
  129. channel oem_sbt_backup1: backup piece +FRA/orcl/backupset/2018_06_22/nnndn1_ora_oem_level_0_0.337.979503335
  130. piece handle=c-1359978017-20180621-00 comment=API Version 2.0,MMS Version 10.3.0.2
  131. channel oem_sbt_backup2: finished piece 1 at 2018-06-22:20:19:43
  132. channel oem_sbt_backup2: backup piece complete, elapsed time: 00:00:39
  133. channel oem_sbt_backup2: input backup set: count=117, stamp=979503341, piece=1
  134. channel oem_sbt_backup2: starting piece 1 at 2018-06-22:20:19:43
  135. channel oem_sbt_backup2: backup piece +FRA/orcl/autobackup/2018_06_22/s_979503341.336.979503341
  136. piece handle=3kt64275_1_2 comment=API Version 2.0,MMS Version 10.3.0.2
  137. channel oem_sbt_backup1: finished piece 1 at 2018-06-22:20:20:28
  138. channel oem_sbt_backup1: backup piece complete, elapsed time: 00:00:48
  139. piece handle=c-1359978017-20180622-00 comment=API Version 2.0,MMS Version 10.3.0.2
  140. channel oem_sbt_backup2: finished piece 1 at 2018-06-22:20:20:28
  141. channel oem_sbt_backup2: backup piece complete, elapsed time: 00:00:45
  142. Finished backup at 2018-06-22:20:20:28

  144. Starting Control File and SPFILE Autobackup at 2018-06-22:20:20:28
  145. piece handle=c-1359978017-20180622-01 comment=API Version 2.0,MMS Version 10.3.0.2
  146. Finished Control File and SPFILE Autobackup at 2018-06-22:20:21:03
  147. released channel: oem_sbt_backup1
  148. released channel: oem_sbt_backup2


  151. RMAN> allocate channel for maintenance device type 'SBT_TAPE' parms 'ENV=(OB_MEDIA_FAMILY=station86)';
  152. allocated channel: ORA_MAINT_SBT_TAPE_1
  153. channel ORA_MAINT_SBT_TAPE_1: SID=135 device type=SBT_TAPE
  154. channel ORA_MAINT_SBT_TAPE_1: Oracle Secure Backup


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


  161. RMAN> exit;

  163. Recovery Manager complete.
复制代码

ASM迁移（学习使用控制文件脚本set 1进行恢复）：
  1. select  name from v$datafile;

  3. select  * from v$controlfile;

  5. select  member from v$logfile;

  7. --------------------------------------
  8. select  * from v$log;

  10. alter database drop logfile group 1;

  12. alter database add logfile group 1 '/u01/app/oracle/oradata/orcl/redo01.log' size 50M;

  14. alter database drop logfile group 2;

  16. alter database add logfile group 2 '/u01/app/oracle/oradata/orcl/redo02.log' size 50M;

  18. alter system switch logfile;

  20. alter system checkpoint;

  22. alter database drop logfile group 3;

  24. alter database add logfile group 3 '/u01/app/oracle/oradata/orcl/redo03.log' size 50M;

复制代码
  1. RMAN>  run {
  2. 2> allocate channel c1 device type disk format '/u01/app/oracle/oradata/orcl/system01.dbf';
  3. 3> backup as copy datafile 1;
  4. 4> release channel c1;
  5. 5> allocate channel c1 device type disk format '/u01/app/oracle/oradata/orcl/sysaux01.dbf';
  6. 6> backup as copy datafile 2;
  7. 7> release channel c1;
  8. 8> allocate channel c1 device type disk format '/u01/app/oracle/oradata/orcl/undotbs1.dbf';
  9. 9> backup as copy datafile 3;
  10. 10> release channel c1;
  11. 11> allocate channel c1 device type disk format '/u01/app/oracle/oradata/orcl/users01.dbf';
  12. 12> backup as copy datafile 4;
  13. 13> release channel c1;
  14. 14> allocate channel c1 device type disk format '/u01/app/oracle/oradata/orcl/example01.dbf';
  15. 15> backup as copy datafile 5;
  16. 16> release channel c1;
  17. 17>  allocate channel c1 device type disk format '/u01/app/oracle/oradata/orcl/tbs1.dbf';
  18. 18> backup as copy datafile 6;
  19. 19> release channel c1;
  20. 20> allocate channel c1 device type disk format '/u01/app/oracle/oradata/orcl/tbs2.dbf';
  21. 21> backup as copy datafile 7;
  22. 22> release channel c1;
  23. 23> }
复制代码

Screenshot.png


Screenshot-1.png

  1. [oracle@station86 ~]$ sqlplus /nolog

  3. SQL*Plus: Release 11.2.0.1.0 Production on Fri Jun 22 21:14:30 2018

  5. Copyright (c) 1982, 2009, Oracle.  All rights reserved.

  7. SQL> conn / as sysdba
  8. Connected.
  9. SQL> alter database backup controlfile to trace as '/home/oracle/control8c.sql';

  11. Database altered.

  13. SQL>
复制代码

set 1 脚本：
  1. CREATE CONTROLFILE REUSE DATABASE "ORCL" NORESETLOGS  ARCHIVELOG
  2.     MAXLOGFILES 16
  3.     MAXLOGMEMBERS 3
  4.     MAXDATAFILES 100
  5.     MAXINSTANCES 8
  6.     MAXLOGHISTORY 292
  7. LOGFILE
  8.   GROUP 1 '/u01/app/oracle/oradata/orcl/redo01.log'  SIZE 50M BLOCKSIZE 512,
  9.   GROUP 2 '/u01/app/oracle/oradata/orcl/redo02.log'  SIZE 50M BLOCKSIZE 512,
  10.   GROUP 3 '/u01/app/oracle/oradata/orcl/redo03.log'  SIZE 50M BLOCKSIZE 512
  11. DATAFILE
  12.   '/u01/app/oracle/oradata/orcl/system01.dbf',
  13.   '/u01/app/oracle/oradata/orcl/sysaux01.dbf',
  14.   '/u01/app/oracle/oradata/orcl/undotbs1.dbf',
  15.   '/u01/app/oracle/oradata/orcl/users01.dbf',
  16.   '/u01/app/oracle/oradata/orcl/example01.dbf',
  17.   '/u01/app/oracle/oradata/orcl/tbs1.dbf',
  18.   '/u01/app/oracle/oradata/orcl/tbs2.dbf'
  19. CHARACTER SET AL32UTF8
  20. ;

  22. -- Configure RMAN configuration record 1
  23. VARIABLE RECNO NUMBER;
  24. EXECUTE :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('RETENTION POLICY','TO RECOVERY WINDOW OF 1 DAYS');
  25. -- Configure RMAN configuration record 2
  26. VARIABLE RECNO NUMBER;
  27. EXECUTE :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('BACKUP OPTIMIZATION','ON');
  28. -- Configure RMAN configuration record 3
  29. VARIABLE RECNO NUMBER;
  30. EXECUTE :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('CONTROLFILE AUTOBACKUP','ON');
  31. -- Configure RMAN configuration record 4
  32. VARIABLE RECNO NUMBER;
  33. EXECUTE :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('DEVICE TYPE','DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET');
  34. -- Configure RMAN configuration record 5
  35. VARIABLE RECNO NUMBER;
  36. EXECUTE :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('DEFAULT DEVICE TYPE TO','DISK');
  37. -- Configure RMAN configuration record 6
  38. VARIABLE RECNO NUMBER;
  39. EXECUTE :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('DEVICE TYPE','''SBT_TAPE'' PARALLELISM 2 BACKUP TYPE TO BACKUPSET');
  40. -- Configure RMAN configuration record 7
  41. VARIABLE RECNO NUMBER;
  42. EXECUTE :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('CHANNEL','1 DEVICE TYPE ''SBT_TAPE'' PARMS  ''ENV=(OB_MEDIA_FAMILY=station86)''');
  43. -- Configure RMAN configuration record 8
  44. VARIABLE RECNO NUMBER;
  45. EXECUTE :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('CHANNEL','2 DEVICE TYPE ''SBT_TAPE'' PARMS  ''ENV=(OB_MEDIA_FAMILY=station86)''');
  46. -- Configure RMAN configuration record 9
  47. VARIABLE RECNO NUMBER;
  48. EXECUTE :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('CHANNEL','DEVICE TYPE ''SBT_TAPE'' PARMS  ''ENV=(OB_MEDIA_FAMILY=station86)''');
复制代码
  1. [oracle@station86 ~]$ sqlplus /nolog

  3. SQL*Plus: Release 11.2.0.1.0 Production on Fri Jun 22 21:17:05 2018

  5. Copyright (c) 1982, 2009, Oracle.  All rights reserved.

  7. SQL> conn / as sysdba
  8. Connected.
  9. SQL> show parameter  control

  11. NAME                                     TYPE         VALUE
  12. ------------------------------------ ----------- ------------------------------
  13. control_file_record_keep_time             integer         7
  14. control_files                             string         +DATA/orcl/controlfile/current
  15.                                                  .260.832197281, +FRA/orcl/cont
  16.                                                  rolfile/current.256.832197283
  17. control_management_pack_access             string         DIAGNOSTIC+TUNING
  18. SQL> alter system set control_files='/u01/app/oracle/oradata/orcl/control01.ctl','/u01/app/oracle/oradata/orcl/control02.ctl','/u01/app/oracle/oradata/orcl/control03.ctl' scope=spfile;

  20. System altered.

  22. SQL> shutdown immmediate
  23. SP2-0717: illegal SHUTDOWN option
  24. SQL> shutdown immediate;
  25. ORA-01109: database not open


  28. Database dismounted.
  29. ORACLE instance shut down.
  30. SQL> startup nomount
  31. ORACLE instance started.

  33. Total System Global Area  820236288 bytes
  34. Fixed Size                    1339628 bytes
  35. Variable Size                  645926676 bytes
  36. Database Buffers          167772160 bytes
  37. Redo Buffers                    5197824 bytes
  38. SQL> @control8c.sql

  40. Control file created.


  43. PL/SQL procedure successfully completed.


  46. PL/SQL procedure successfully completed.


  49. PL/SQL procedure successfully completed.


  52. PL/SQL procedure successfully completed.


  55. PL/SQL procedure successfully completed.


  58. PL/SQL procedure successfully completed.


  61. PL/SQL procedure successfully completed.


  64. PL/SQL procedure successfully completed.


  67. PL/SQL procedure successfully completed.

  69. SQL> alter database open ;

  71. Database altered.

  73. SQL> alter tablespace temp add tempfile '/u01/app/oracle/oradata/orcl/temp01.dbf' size 30M autoextend on;

  75. Tablespace altered.

  77. SQL> show parameter db_recovery

  79. NAME                                     TYPE         VALUE
  80. ------------------------------------ ----------- ------------------------------
  81. db_recovery_file_dest                     string         +FRA
  82. db_recovery_file_dest_size             big integer 3852M
  83. SQL> alter system set db_recovery_file_dest='/u01/app/oracle/fast_recovery_area';

  85. System altered.

  87. SQL> show parameter db_create

  89. NAME                                     TYPE         VALUE
  90. ------------------------------------ ----------- ------------------------------
  91. db_create_file_dest                     string         +DATA
  92. db_create_online_log_dest_1             string
  93. db_create_online_log_dest_2             string
  94. db_create_online_log_dest_3             string
  95. db_create_online_log_dest_4             string
  96. db_create_online_log_dest_5             string
  97. SQL> alter system set db_create_file_dest='';

  99. System altered.

  101. SQL>
复制代码


回复

使用道具 举报

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

本版积分规则

QQ|手机版|Bo's Oracle Station   

GMT+8, 2024-11-22 04:49 , Processed in 0.050228 second(s), 28 queries .

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