开启辅助访问

Bo's Oracle Station

Bo's Oracle Station»社区 › 培训进行时（结课后图标变灰，但是欢迎继续发帖！） › 10004-11g管理类OCP认证班第三期 › 课程第27次（2016-05-27星期五）：闪回数据库和不完全恢 ...
返回列表 发新帖
查看: 2139|回复: 0

课程第27次（2016-05-27星期五）：闪回数据库和不完全恢复的对比

[复制链接]
admin

75

主题

115

帖子

2772

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
2772
发表于 2016-5-28 09:50:33 | 显示全部楼层 |阅读模式
课程第27次（2016-05-27星期五）：闪回数据库和不完全恢复的对比：

磁带机列出备份：
  1. [root@station90 ~]# crs_stat -t
  2. Name           Type           Target    State     Host        
  3. ------------------------------------------------------------
  4. ora.DATA.dg    ora....up.type ONLINE    ONLINE    station90   
  5. ora.FRA.dg     ora....up.type ONLINE    ONLINE    station90   
  6. ora....ER.lsnr ora....er.type ONLINE    ONLINE    station90   
  7. ora.asm        ora.asm.type   ONLINE    ONLINE    station90   
  8. ora.cssd       ora.cssd.type  ONLINE    ONLINE    station90   
  9. ora.diskmon    ora....on.type ONLINE    ONLINE    station90   
  10. ora.orcl.db    ora....se.type ONLINE    ONLINE    station90   
  11. [root@station90 ~]# lsscsi -g
  12. [0:0:0:0]    disk    ATA      M4-CT128M4SSD2   040H  /dev/sda   /dev/sg0
  13. [6:0:0:0]    mediumx STK      L700             550V  /dev/sch0  /dev/sg9
  14. [6:0:1:0]    tape    IBM      ULT3580-TD5      550V  /dev/st0   /dev/sg1
  15. [6:0:2:0]    tape    IBM      ULT3580-TD5      550V  /dev/st1   /dev/sg2
  16. [6:0:3:0]    tape    IBM      ULT3580-TD4      550V  /dev/st2   /dev/sg3
  17. [6:0:4:0]    tape    IBM      ULT3580-TD4      550V  /dev/st3   /dev/sg4
  18. [6:0:8:0]    mediumx SPECTRA  PYTHON           550V  /dev/sch1  /dev/sg10
  19. [6:0:9:0]    tape    IBM      ULT3580-TD4      550V  /dev/st4   /dev/sg5
  20. [6:0:10:0]   tape    IBM      ULT3580-TD4      550V  /dev/st5   /dev/sg6
  21. [6:0:11:0]   tape    IBM      ULT3580-TD4      550V  /dev/st6   /dev/sg7
  22. [6:0:12:0]   tape    IBM      ULT3580-TD4      550V  /dev/st7   /dev/sg8
  23. [root@station90 ~]# su - oracle
  24. [oracle@station90 ~]$ rman target  /  

  26. Recovery Manager: Release 11.2.0.1.0 - Production on Fri May 27 19:54:32 2016

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

  30. connected to target database: ORCL (DBID=1343950367)

  32. RMAN> list backup of database ;

  34. using target database control file instead of recovery catalog

  36. List of Backup Sets
  37. ===================


  40. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  41. ------- ---- -- ---------- ----------- ------------ ---------------
  42. 2       Incr 0  69.06M     SBT_TAPE    00:00:20     20-OCT-13      
  43.         BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
  44.         Handle: 05omt45l_1_1   Media: station90-000010
  45.   List of Datafiles in backup set 2
  46.   File LV Type Ckp SCN    Ckp Time  Name
  47.   ---- -- ---- ---------- --------- ----
  48.   5    0  Incr 1041758    20-OCT-13 +DATA/orcl/datafile/example.265.816169651

  50. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  51. ------- ---- -- ---------- ----------- ------------ ---------------
  52. 3       Incr 0  588.69M    SBT_TAPE    00:00:40     20-OCT-13      
  53.         BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
  54.         Handle: 02omt45k_1_1   Media: station90-000009
  55.   List of Datafiles in backup set 3
  56.   File LV Type Ckp SCN    Ckp Time  Name
  57.   ---- -- ---- ---------- --------- ----
  58.   1    0  Incr 1041748    20-OCT-13 +DATA/orcl/datafile/system.256.816169553

  60. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  61. ------- ---- -- ---------- ----------- ------------ ---------------
  62. 4       Incr 0  3.31M      SBT_TAPE    00:00:55     20-OCT-13      
  63.         BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
  64.         Handle: 06omt45l_1_1   Media: station90-000009
  65.   List of Datafiles in backup set 4
  66.   File LV Type Ckp SCN    Ckp Time  Name
  67.   ---- -- ---- ---------- --------- ----
  68.   4    0  Incr 1041761    20-OCT-13 +DATA/orcl/datafile/users.259.816169553

  70. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  71. ------- ---- -- ---------- ----------- ------------ ---------------
  72. 5       Incr 0  380.38M    SBT_TAPE    00:01:08     20-OCT-13      
  73.         BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
  74.         Handle: 03omt45k_1_1   Media: station90-000010
  75.   List of Datafiles in backup set 5
  76.   File LV Type Ckp SCN    Ckp Time  Name
  77.   ---- -- ---- ---------- --------- ----
  78.   2    0  Incr 1041751    20-OCT-13 +DATA/orcl/datafile/sysaux.257.816169553

  80. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  81. ------- ---- -- ---------- ----------- ------------ ---------------
  82. 6       Incr 0  94.69M     SBT_TAPE    00:01:22     20-OCT-13      
  83.         BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
  84.         Handle: 04omt45k_1_1   Media: station90-000009
  85.   List of Datafiles in backup set 6
  86.   File LV Type Ckp SCN    Ckp Time  Name
  87.   ---- -- ---- ---------- --------- ----
  88.   3    0  Incr 1041755    20-OCT-13 +DATA/orcl/datafile/undotbs1.258.816169553

  90. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  91. ------- ---- -- ---------- ----------- ------------ ---------------
  92. 10      Incr 1  128.00K    SBT_TAPE    00:00:16     20-OCT-13      
  93.         BP Key: 10   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR1
  94.         Handle: 0aomt4ce_1_1   Media: station90-000009
  95.   List of Datafiles in backup set 10
  96.   File LV Type Ckp SCN    Ckp Time  Name
  97.   ---- -- ---- ---------- --------- ----
  98.   1    1  Incr 1042472    20-OCT-13 +DATA/orcl/datafile/system.256.816169553

  100. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  101. ------- ---- -- ---------- ----------- ------------ ---------------
  102. 11      Incr 1  1.50M      SBT_TAPE    00:00:16     20-OCT-13      
  103.         BP Key: 11   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR1
  104.         Handle: 0comt4ce_1_1   Media: station90-000010
  105.   List of Datafiles in backup set 11
  106.   File LV Type Ckp SCN    Ckp Time  Name
  107.   ---- -- ---- ---------- --------- ----
  108.   3    1  Incr 1042478    20-OCT-13 +DATA/orcl/datafile/undotbs1.258.816169553

  110. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  111. ------- ---- -- ---------- ----------- ------------ ---------------
  112. 12      Incr 1  64.00K     SBT_TAPE    00:00:35     20-OCT-13      
  113.         BP Key: 12   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR1
  114.         Handle: 0eomt4ce_1_1   Media: station90-000010
  115.   List of Datafiles in backup set 12
  116.   File LV Type Ckp SCN    Ckp Time  Name
  117.   ---- -- ---- ---------- --------- ----
  118.   4    1  Incr 1042484    20-OCT-13 +DATA/orcl/datafile/users.259.816169553

  120. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  121. ------- ---- -- ---------- ----------- ------------ ---------------
  122. 13      Incr 1  64.00K     SBT_TAPE    00:00:41     20-OCT-13      
  123.         BP Key: 13   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR1
  124.         Handle: 0domt4ce_1_1   Media: station90-000009
  125.   List of Datafiles in backup set 13
  126.   File LV Type Ckp SCN    Ckp Time  Name
  127.   ---- -- ---- ---------- --------- ----
  128.   5    1  Incr 1042481    20-OCT-13 +DATA/orcl/datafile/example.265.816169651

  130. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  131. ------- ---- -- ---------- ----------- ------------ ---------------
  132. 14      Incr 1  7.44M      SBT_TAPE    00:00:57     20-OCT-13      
  133.         BP Key: 14   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR1
  134.         Handle: 0bomt4ce_1_1   Media: station90-000010
  135.   List of Datafiles in backup set 14
  136.   File LV Type Ckp SCN    Ckp Time  Name
  137.   ---- -- ---- ---------- --------- ----
  138.   2    1  Incr 1042475    20-OCT-13 +DATA/orcl/datafile/sysaux.257.816169553

  140. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  141. ------- ---- -- ---------- ----------- ------------ ---------------
  142. 18      Incr 1  128.00K    SBT_TAPE    00:00:15     20-OCT-13      
  143.         BP Key: 18   Status: AVAILABLE  Compressed: NO  Tag: 3TCUMU_WHOLE_INCR1
  144.         Handle: 0iomt4hq_1_1   Media: station90-000009
  145.   List of Datafiles in backup set 18
  146.   File LV Type Ckp SCN    Ckp Time  Name
  147.   ---- -- ---- ---------- --------- ----
  148.   1    1  Incr 1042619    20-OCT-13 +DATA/orcl/datafile/system.256.816169553

  150. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  151. ------- ---- -- ---------- ----------- ------------ ---------------
  152. 19      Incr 1  7.44M      SBT_TAPE    00:00:24     20-OCT-13      
  153.         BP Key: 19   Status: AVAILABLE  Compressed: NO  Tag: 3TCUMU_WHOLE_INCR1
  154.         Handle: 0jomt4hq_1_1   Media: station90-000010
  155.   List of Datafiles in backup set 19
  156.   File LV Type Ckp SCN    Ckp Time  Name
  157.   ---- -- ---- ---------- --------- ----
  158.   2    1  Incr 1042622    20-OCT-13 +DATA/orcl/datafile/sysaux.257.816169553

  160. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  161. ------- ---- -- ---------- ----------- ------------ ---------------
  162. 20      Incr 1  1.50M      SBT_TAPE    00:00:39     20-OCT-13      
  163.         BP Key: 20   Status: AVAILABLE  Compressed: NO  Tag: 3TCUMU_WHOLE_INCR1
  164.         Handle: 0komt4hq_1_1   Media: station90-000010
  165.   List of Datafiles in backup set 20
  166.   File LV Type Ckp SCN    Ckp Time  Name
  167.   ---- -- ---- ---------- --------- ----
  168.   3    1  Incr 1042625    20-OCT-13 +DATA/orcl/datafile/undotbs1.258.816169553

  170. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  171. ------- ---- -- ---------- ----------- ------------ ---------------
  172. 21      Incr 1  64.00K     SBT_TAPE    00:00:40     20-OCT-13      
  173.         BP Key: 21   Status: AVAILABLE  Compressed: NO  Tag: 3TCUMU_WHOLE_INCR1
  174.         Handle: 0lomt4hq_1_1   Media: station90-000009
  175.   List of Datafiles in backup set 21
  176.   File LV Type Ckp SCN    Ckp Time  Name
  177.   ---- -- ---- ---------- --------- ----
  178.   5    1  Incr 1042629    20-OCT-13 +DATA/orcl/datafile/example.265.816169651

  180. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  181. ------- ---- -- ---------- ----------- ------------ ---------------
  182. 22      Incr 1  64.00K     SBT_TAPE    00:00:53     20-OCT-13      
  183.         BP Key: 22   Status: AVAILABLE  Compressed: NO  Tag: 3TCUMU_WHOLE_INCR1
  184.         Handle: 0momt4hr_1_1   Media: station90-000010
  185.   List of Datafiles in backup set 22
  186.   File LV Type Ckp SCN    Ckp Time  Name
  187.   ---- -- ---- ---------- --------- ----
  188.   4    1  Incr 1042632    20-OCT-13 +DATA/orcl/datafile/users.259.816169553

  190. RMAN>






  197. RMAN>


复制代码


5号实验的恢复过程：
  1. [root@station90 桌面]# su - orace
  2. su: 用户orace 不存在
  3. [root@station90 桌面]# su - oracle
  4. [oracle@station90 ~]$ sqlplus /nolog

  6. SQL*Plus: Release 11.2.0.1.0 Production on Fri May 27 20:33:35 2016

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

  10. SQL> conn hr/oracle_4U
  11. ERROR:
  12. ORA-28002: the password will expire within 7 days


  15. Connected.
  16. SQL> select  * from  hr.t806;
  17. select        * from        hr.t806
  18.                    *
  19. ERROR at line 1:
  20. ORA-00942: table or view does not exist


  23. SQL> conn / as sysdba
  24. Connected.
  25. SQL> select  open_mode from v$database;

  27. OPEN_MODE
  28. --------------------
  29. READ WRITE

  31. SQL> shutdown abort
  32. ORACLE instance shut down.
  33. SQL> startup mount
  34. ORACLE instance started.

  36. Total System Global Area 6680915968 bytes
  37. Fixed Size                    2213936 bytes
  38. Variable Size                 3556771792 bytes
  39. Database Buffers         3087007744 bytes
  40. Redo Buffers                   34922496 bytes
  41. Database mounted.
  42. SQL> exit
  43. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
  44. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
  45. and Real Application Testing options
  46. [oracle@station90 ~]$ rman target /

  48. Recovery Manager: Release 11.2.0.1.0 - Production on Fri May 27 20:36:06 2016

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

  52. connected to target database: ORCL (DBID=1343950367, not open)

  54. RMAN> run {
  55. 2> sql "alter session set nls_date_format=''YYYY-MM-DD:HH24:MI:SS''";
  56. 3> set until time '2016-05-27:20:26:34';
  57. 4> restore database;
  58. 5> recover database;
  59. 6> }

  61. using target database control file instead of recovery catalog
  62. sql statement: alter session set nls_date_format=''YYYY-MM-DD:HH24:MI:SS''

  64. executing command: SET until clause

  66. Starting restore at 27-MAY-16
  67. allocated channel: ORA_DISK_1
  68. channel ORA_DISK_1: SID=7 device type=DISK
  69. allocated channel: ORA_DISK_2
  70. channel ORA_DISK_2: SID=68 device type=DISK
  71. allocated channel: ORA_DISK_3
  72. channel ORA_DISK_3: SID=131 device type=DISK
  73. allocated channel: ORA_DISK_4
  74. channel ORA_DISK_4: SID=192 device type=DISK
  75. allocated channel: ORA_DISK_5
  76. channel ORA_DISK_5: SID=8 device type=DISK
  77. allocated channel: ORA_DISK_6
  78. channel ORA_DISK_6: SID=69 device type=DISK
  79. allocated channel: ORA_DISK_7
  80. channel ORA_DISK_7: SID=132 device type=DISK
  81. allocated channel: ORA_DISK_8
  82. channel ORA_DISK_8: SID=193 device type=DISK
  83. allocated channel: ORA_SBT_TAPE_1
  84. channel ORA_SBT_TAPE_1: SID=9 device type=SBT_TAPE
  85. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  86. allocated channel: ORA_SBT_TAPE_2
  87. channel ORA_SBT_TAPE_2: SID=70 device type=SBT_TAPE
  88. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  89. allocated channel: ORA_SBT_TAPE_3
  90. channel ORA_SBT_TAPE_3: SID=133 device type=SBT_TAPE
  91. channel ORA_SBT_TAPE_3: Oracle Secure Backup
  92. allocated channel: ORA_SBT_TAPE_4
  93. channel ORA_SBT_TAPE_4: SID=194 device type=SBT_TAPE
  94. channel ORA_SBT_TAPE_4: Oracle Secure Backup
  95. allocated channel: ORA_SBT_TAPE_5
  96. channel ORA_SBT_TAPE_5: SID=10 device type=SBT_TAPE
  97. channel ORA_SBT_TAPE_5: Oracle Secure Backup
  98. allocated channel: ORA_SBT_TAPE_6
  99. channel ORA_SBT_TAPE_6: SID=71 device type=SBT_TAPE
  100. channel ORA_SBT_TAPE_6: Oracle Secure Backup
  101. allocated channel: ORA_SBT_TAPE_7
  102. channel ORA_SBT_TAPE_7: SID=134 device type=SBT_TAPE
  103. channel ORA_SBT_TAPE_7: Oracle Secure Backup
  104. allocated channel: ORA_SBT_TAPE_8
  105. channel ORA_SBT_TAPE_8: SID=195 device type=SBT_TAPE
  106. channel ORA_SBT_TAPE_8: Oracle Secure Backup

  108. channel ORA_SBT_TAPE_1: starting datafile backup set restore
  109. channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
  110. channel ORA_SBT_TAPE_1: restoring datafile 00005 to +DATA/orcl/datafile/example.265.816169651
  111. channel ORA_SBT_TAPE_1: reading from backup piece 05omt45l_1_1
  112. channel ORA_SBT_TAPE_2: starting datafile backup set restore
  113. channel ORA_SBT_TAPE_2: specifying datafile(s) to restore from backup set
  114. channel ORA_SBT_TAPE_2: restoring datafile 00001 to +DATA/orcl/datafile/system.256.816169553
  115. channel ORA_SBT_TAPE_2: reading from backup piece 02omt45k_1_1
  116. channel ORA_SBT_TAPE_1: piece handle=05omt45l_1_1 tag=1T_WHOLE_INCR0
  117. channel ORA_SBT_TAPE_1: restored backup piece 1
  118. channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:37
  119. channel ORA_SBT_TAPE_1: starting datafile backup set restore
  120. channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
  121. channel ORA_SBT_TAPE_1: restoring datafile 00002 to +DATA/orcl/datafile/sysaux.257.816169553
  122. channel ORA_SBT_TAPE_1: reading from backup piece 03omt45k_1_1
  123. channel ORA_SBT_TAPE_2: piece handle=02omt45k_1_1 tag=1T_WHOLE_INCR0
  124. channel ORA_SBT_TAPE_2: restored backup piece 1
  125. channel ORA_SBT_TAPE_2: restore complete, elapsed time: 00:00:52
  126. channel ORA_SBT_TAPE_2: starting datafile backup set restore
  127. channel ORA_SBT_TAPE_2: specifying datafile(s) to restore from backup set
  128. channel ORA_SBT_TAPE_2: restoring datafile 00004 to +DATA/orcl/datafile/users.259.816169553
  129. channel ORA_SBT_TAPE_2: reading from backup piece 06omt45l_1_1
  130. channel ORA_SBT_TAPE_1: piece handle=03omt45k_1_1 tag=1T_WHOLE_INCR0
  131. channel ORA_SBT_TAPE_1: restored backup piece 1
  132. channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:40
  133. channel ORA_SBT_TAPE_2: piece handle=06omt45l_1_1 tag=1T_WHOLE_INCR0
  134. channel ORA_SBT_TAPE_2: restored backup piece 1
  135. channel ORA_SBT_TAPE_2: restore complete, elapsed time: 00:00:25
  136. channel ORA_SBT_TAPE_2: starting datafile backup set restore
  137. channel ORA_SBT_TAPE_2: specifying datafile(s) to restore from backup set
  138. channel ORA_SBT_TAPE_2: restoring datafile 00003 to +DATA/orcl/datafile/undotbs1.258.816169553
  139. channel ORA_SBT_TAPE_2: reading from backup piece 04omt45k_1_1
  140. channel ORA_SBT_TAPE_2: piece handle=04omt45k_1_1 tag=1T_WHOLE_INCR0
  141. channel ORA_SBT_TAPE_2: restored backup piece 1
  142. channel ORA_SBT_TAPE_2: restore complete, elapsed time: 00:00:25
  143. Finished restore at 27-MAY-16

  145. Starting recover at 27-MAY-16
  146. using channel ORA_DISK_1
  147. using channel ORA_DISK_2
  148. using channel ORA_DISK_3
  149. using channel ORA_DISK_4
  150. using channel ORA_DISK_5
  151. using channel ORA_DISK_6
  152. using channel ORA_DISK_7
  153. using channel ORA_DISK_8
  154. using channel ORA_SBT_TAPE_1
  155. using channel ORA_SBT_TAPE_2
  156. using channel ORA_SBT_TAPE_3
  157. using channel ORA_SBT_TAPE_4
  158. using channel ORA_SBT_TAPE_5
  159. using channel ORA_SBT_TAPE_6
  160. using channel ORA_SBT_TAPE_7
  161. using channel ORA_SBT_TAPE_8
  162. channel ORA_SBT_TAPE_1: starting incremental datafile backup set restore
  163. channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
  164. destination for restore of datafile 00001: +DATA/orcl/datafile/system.256.816169553
  165. channel ORA_SBT_TAPE_1: reading from backup piece 0iomt4hq_1_1
  166. channel ORA_SBT_TAPE_2: starting incremental datafile backup set restore
  167. channel ORA_SBT_TAPE_2: specifying datafile(s) to restore from backup set
  168. destination for restore of datafile 00002: +DATA/orcl/datafile/sysaux.257.816169553
  169. channel ORA_SBT_TAPE_2: reading from backup piece 0jomt4hq_1_1
  170. channel ORA_SBT_TAPE_1: piece handle=0iomt4hq_1_1 tag=3TCUMU_WHOLE_INCR1
  171. channel ORA_SBT_TAPE_1: restored backup piece 1
  172. channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:35
  173. channel ORA_SBT_TAPE_1: starting incremental datafile backup set restore
  174. channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
  175. destination for restore of datafile 00005: +DATA/orcl/datafile/example.265.816169651
  176. channel ORA_SBT_TAPE_1: reading from backup piece 0lomt4hq_1_1
  177. channel ORA_SBT_TAPE_2: piece handle=0jomt4hq_1_1 tag=3TCUMU_WHOLE_INCR1
  178. channel ORA_SBT_TAPE_2: restored backup piece 1
  179. channel ORA_SBT_TAPE_2: restore complete, elapsed time: 00:00:35
  180. channel ORA_SBT_TAPE_2: starting incremental datafile backup set restore
  181. channel ORA_SBT_TAPE_2: specifying datafile(s) to restore from backup set
  182. destination for restore of datafile 00003: +DATA/orcl/datafile/undotbs1.258.816169553
  183. channel ORA_SBT_TAPE_2: reading from backup piece 0komt4hq_1_1
  184. channel ORA_SBT_TAPE_1: piece handle=0lomt4hq_1_1 tag=3TCUMU_WHOLE_INCR1
  185. channel ORA_SBT_TAPE_1: restored backup piece 1
  186. channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:35
  187. channel ORA_SBT_TAPE_2: piece handle=0komt4hq_1_1 tag=3TCUMU_WHOLE_INCR1
  188. channel ORA_SBT_TAPE_2: restored backup piece 1
  189. channel ORA_SBT_TAPE_2: restore complete, elapsed time: 00:00:36
  190. channel ORA_SBT_TAPE_2: starting incremental datafile backup set restore
  191. channel ORA_SBT_TAPE_2: specifying datafile(s) to restore from backup set
  192. destination for restore of datafile 00004: +DATA/orcl/datafile/users.259.816169553
  193. channel ORA_SBT_TAPE_2: reading from backup piece 0momt4hr_1_1
  194. channel ORA_SBT_TAPE_2: piece handle=0momt4hr_1_1 tag=3TCUMU_WHOLE_INCR1
  195. channel ORA_SBT_TAPE_2: restored backup piece 1
  196. channel ORA_SBT_TAPE_2: restore complete, elapsed time: 00:00:25

  198. starting media recovery

  200. archived log for thread 1 with sequence 15 is already on disk as file +FRA/orcl/archivelog/2013_12_11/thread_1_seq_15.261.833878627
  201. archived log for thread 1 with sequence 16 is already on disk as file +FRA/orcl/archivelog/2013_12_11/thread_1_seq_16.262.833879059
  202. archived log for thread 1 with sequence 17 is already on disk as file +FRA/orcl/archivelog/2016_05_27/thread_1_seq_17.263.912957557
  203. archived log for thread 1 with sequence 18 is already on disk as file +FRA/orcl/archivelog/2016_05_27/thread_1_seq_18.264.912959275
  204. archived log for thread 1 with sequence 19 is already on disk as file +FRA/orcl/archivelog/2016_05_27/thread_1_seq_19.265.912964019
  205. archived log for thread 1 with sequence 20 is already on disk as file +FRA/orcl/archivelog/2016_05_27/thread_1_seq_20.266.912975989
  206. archived log for thread 1 with sequence 21 is already on disk as file +FRA/orcl/archivelog/2016_05_27/thread_1_seq_21.267.912975989
  207. archived log for thread 1 with sequence 22 is already on disk as file +FRA/orcl/archivelog/2016_05_27/thread_1_seq_22.268.912975999
  208. channel ORA_SBT_TAPE_1: starting archived log restore to default destination
  209. channel ORA_SBT_TAPE_1: restoring archived log
  210. archived log thread=1 sequence=14
  211. channel ORA_SBT_TAPE_1: reading from backup piece 0nomt4ji_1_1
  212. channel ORA_SBT_TAPE_1: piece handle=0nomt4ji_1_1 tag=3TCUMU_WHOLE_INCR1
  213. channel ORA_SBT_TAPE_1: restored backup piece 1
  214. channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:24
  215. archived log file name=+FRA/orcl/archivelog/2016_05_27/thread_1_seq_14.272.912977425 thread=1 sequence=14
  216. channel default: deleting archived log(s)
  217. archived log file name=+FRA/orcl/archivelog/2016_05_27/thread_1_seq_14.272.912977425 RECID=18 STAMP=912977425
  218. archived log file name=+FRA/orcl/archivelog/2013_12_11/thread_1_seq_15.261.833878627 thread=1 sequence=15
  219. archived log file name=+FRA/orcl/archivelog/2013_12_11/thread_1_seq_16.262.833879059 thread=1 sequence=16
  220. archived log file name=+FRA/orcl/archivelog/2016_05_27/thread_1_seq_17.263.912957557 thread=1 sequence=17
  221. archived log file name=+FRA/orcl/archivelog/2016_05_27/thread_1_seq_18.264.912959275 thread=1 sequence=18
  222. archived log file name=+FRA/orcl/archivelog/2016_05_27/thread_1_seq_19.265.912964019 thread=1 sequence=19
  223. archived log file name=+FRA/orcl/archivelog/2016_05_27/thread_1_seq_20.266.912975989 thread=1 sequence=20
  224. archived log file name=+FRA/orcl/archivelog/2016_05_27/thread_1_seq_21.267.912975989 thread=1 sequence=21
  225. archived log file name=+FRA/orcl/archivelog/2016_05_27/thread_1_seq_22.268.912975999 thread=1 sequence=22
  226. media recovery complete, elapsed time: 00:00:25
  227. Finished recover at 27-MAY-16

  229. RMAN> alter database open ;

  231. RMAN-00571: ===========================================================
  232. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  233. RMAN-00571: ===========================================================
  234. RMAN-03002: failure of alter db command at 05/27/2016 20:51:47
  235. ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

  237. RMAN> list incarnation of database ;


  240. List of Database Incarnations
  241. DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
  242. ------- ------- -------- ---------------- --- ---------- ----------
  243. 1       1       ORCL     1343950367       PARENT  1          15-AUG-09
  244. 2       2       ORCL     1343950367       CURRENT 945184     23-MAY-13

  246. RMAN> alter database open resetlogs;

  248. database opened

  250. RMAN> exit


  253. Recovery Manager complete.
  254. [oracle@station90 ~]$ sqlplus /nolog

  256. SQL*Plus: Release 11.2.0.1.0 Production on Fri May 27 20:53:46 2016

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

  260. SQL> conn / as sysdba
  261. Connected.
  262. SQL> archive log list;
  263. Database log mode               Archive Mode
  264. Automatic archival               Enabled
  265. Archive destination               USE_DB_RECOVERY_FILE_DEST
  266. Oldest online log sequence     1
  267. Next log sequence to archive   1
  268. Current log sequence               1
  269. SQL> exit
  270. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
  271. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
  272. and Real Application Testing options
  273. [oracle@station90 ~]$ rman target /

  275. Recovery Manager: Release 11.2.0.1.0 - Production on Fri May 27 20:53:57 2016

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

  279. connected to target database: ORCL (DBID=1343950367)

  281. RMAN> list incarnation of database;

  283. using target database control file instead of recovery catalog

  285. List of Database Incarnations
  286. DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
  287. ------- ------- -------- ---------------- --- ---------- ----------
  288. 1       1       ORCL     1343950367       PARENT  1          15-AUG-09
  289. 2       2       ORCL     1343950367       PARENT  945184     23-MAY-13
  290. 3       3       ORCL     1343950367       CURRENT 1068604    27-MAY-16

  292. RMAN> exit
复制代码

刚打开的闪回日志的大小：
[root@station90 mymachine]# watch -n 0.1 "ps aux | grep rvwr"
[root@station90 mymachine]# watch -n 0.1 "ps aux | grep rvwr"
[root@station90 mymachine]# bc
bc 1.06.95
Copyright 1991-1994, 1997, 1998, 2000, 2004, 2006 Free Software Foundation, Inc.
This is free software with ABSOLUTELY NO WARRANTY.
For details type `warranty'.
scale=4
33*1024*1024*8
276824064
33*1024*1024*8/1000000
276.8240（说明闪回日志刚开始时有2亿7千万比特，我叫“基底位图”）



  1. [oracle@station90 ~]$ . oraenv
  2. ORACLE_SID = [orcl] ? +ASM
  3. The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/grid is /u01/app/oracle
  4. [oracle@station90 ~]$ asmcmd
  5. ASMCMD> ls
  6. DATA/
  7. FRA/
  8. ASMCMD> cd FRA/
  9. ASMCMD> ls
  10. ORCL/
  11. ASMCMD> cd ORCL/
  12. ASMCMD> ls
  13. ARCHIVELOG/
  14. AUTOBACKUP/
  15. CHANGETRACKING/
  16. CONTROLFILE/
  17. ONLINELOG/
  18. ASMCMD> ls
  19. ARCHIVELOG/
  20. AUTOBACKUP/
  21. CHANGETRACKING/
  22. CONTROLFILE/
  23. FLASHBACK/
  24. ONLINELOG/
  25. ASMCMD> cd FLASHBACK/
  26. ASMCMD> ls
  27. log_1.274.912980547
  28. ASMCMD> du -sh
  29. Unknown option: s
  30. Unknown option: h
  31. usage: du [-H] [dir]
  32. help:  help du
  33. ASMCMD> du  
  34. Used_MB      Mirror_used_MB
  35.      33                  33
  36. ASMCMD>
复制代码

PL/SQL窗口：

  1. select  * from v$flashback_database_log;

  3. select  * from v$flashback_database_stat;
复制代码


,

相关帖子
回复

使用道具 举报

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

本版积分规则

QQ|手机版|Bo's Oracle Station   

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

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