开启辅助访问

Bo's Oracle Station

Bo's Oracle Station»社区 › 培训进行时（结课后图标变灰，但是欢迎继续发帖！） › 4075-12c管理类OCP认证班第三期 › 课程第23/24次（2017-08-26星期六上下午）
返回列表 发新帖
查看: 1862|回复: 0

课程第23/24次（2017-08-26星期六上下午）

[复制链接]
botang

1005

主题

1469

帖子

1万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
12012
发表于 2017-8-26 10:43:37 | 显示全部楼层 |阅读模式
上完1Z0-053第12章
1Z0-052共19章（上完10章），1Z0-053共21章（上完5章）和1Z0-063多租户部分共9章（上完0章）
总共上完全部49章中的15章
  1. select  * from v$flashback_database_log;

  3. select  * from v$restore_point;

  5. create restore point rsp1 ;

  7. create restore point rsp2 as of  scn 1104000;
复制代码

053的12-7幻灯注释里严重错误：

Screenshot.png

  1. RMAN> list incarnation of database;


  4. List of Database Incarnations
  5. DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
  6. ------- ------- -------- ---------------- --- ---------- ----------
  7. 1       1       ORCL     1343950367       PARENT  1          2009-08-15:00:16:43
  8. 2       2       ORCL     1343950367       PARENT  945184     2013-05-23:09:47:15
  9. 3       3       ORCL     1343950367       ORPHAN  1082671    2017-08-24:21:40:38
  10. 4       4       ORCL     1343950367       CURRENT 1082671    2017-08-26:09:25:11

  12. RMAN> shutdown abort

  14. Oracle instance shut down

  16. RMAN> startup mount

  18. connected to target database (not started)
  19. Oracle instance started
  20. database mounted

  22. Total System Global Area    6680915968 bytes

  24. Fixed Size                     2213936 bytes
  25. Variable Size               3556771792 bytes
  26. Database Buffers            3087007744 bytes
  27. Redo Buffers                  34922496 bytes

  29. RMAN> run {
  30. 2> set until sequence  7  thread 1 ;
  31. 3> restore database;
  32. 4> recover database;
  33. 5> }

  35. executing command: SET until clause

  37. Starting restore at 2017-08-26:10:16:45
  38. allocated channel: ORA_DISK_1
  39. channel ORA_DISK_1: SID=131 device type=DISK
  40. allocated channel: ORA_DISK_2
  41. channel ORA_DISK_2: SID=192 device type=DISK
  42. allocated channel: ORA_DISK_3
  43. channel ORA_DISK_3: SID=8 device type=DISK
  44. allocated channel: ORA_DISK_4
  45. channel ORA_DISK_4: SID=69 device type=DISK
  46. allocated channel: ORA_DISK_5
  47. channel ORA_DISK_5: SID=132 device type=DISK
  48. allocated channel: ORA_DISK_6
  49. channel ORA_DISK_6: SID=193 device type=DISK
  50. allocated channel: ORA_DISK_7
  51. channel ORA_DISK_7: SID=9 device type=DISK
  52. allocated channel: ORA_DISK_8
  53. channel ORA_DISK_8: SID=70 device type=DISK
  54. allocated channel: ORA_SBT_TAPE_1
  55. channel ORA_SBT_TAPE_1: SID=133 device type=SBT_TAPE
  56. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  57. allocated channel: ORA_SBT_TAPE_2
  58. channel ORA_SBT_TAPE_2: SID=10 device type=SBT_TAPE
  59. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  60. flashing back control file to SCN 1106318

  62. channel ORA_SBT_TAPE_1: starting datafile backup set restore
  63. channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
  64. channel ORA_SBT_TAPE_1: restoring datafile 00002 to +DATA/orcl/datafile/sysaux.257.816169553
  65. channel ORA_SBT_TAPE_1: restoring datafile 00003 to +DATA/orcl/datafile/undotbs1.258.816169553
  66. channel ORA_SBT_TAPE_1: restoring datafile 00004 to +DATA/orcl/datafile/users.259.816169553
  67. channel ORA_SBT_TAPE_1: reading from backup piece 13s4ih4j_1_1
  68. channel ORA_SBT_TAPE_2: starting datafile backup set restore
  69. channel ORA_SBT_TAPE_2: specifying datafile(s) to restore from backup set
  70. channel ORA_SBT_TAPE_2: restoring datafile 00001 to +DATA/orcl/datafile/system.256.816169553
  71. channel ORA_SBT_TAPE_2: restoring datafile 00005 to +DATA/orcl/datafile/example.265.816169651
  72. channel ORA_SBT_TAPE_2: reading from backup piece 12s4ih4j_1_1
  73. channel ORA_SBT_TAPE_1: piece handle=13s4ih4j_1_1 tag=0T_INCR0_WHOLE
  74. channel ORA_SBT_TAPE_1: restored backup piece 1
  75. channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:45
  76. channel ORA_SBT_TAPE_2: piece handle=12s4ih4j_1_1 tag=0T_INCR0_WHOLE
  77. channel ORA_SBT_TAPE_2: restored backup piece 1
  78. channel ORA_SBT_TAPE_2: restore complete, elapsed time: 00:00:55
  79. Finished restore at 2017-08-26:10:17:56

  81. Starting recover at 2017-08-26:10:17:56
  82. using channel ORA_DISK_1
  83. using channel ORA_DISK_2
  84. using channel ORA_DISK_3
  85. using channel ORA_DISK_4
  86. using channel ORA_DISK_5
  87. using channel ORA_DISK_6
  88. using channel ORA_DISK_7
  89. using channel ORA_DISK_8
  90. using channel ORA_SBT_TAPE_1
  91. using channel ORA_SBT_TAPE_2

  93. starting media recovery

  95. archived log for thread 1 with sequence 20 is already on disk as file +FRA/orcl/archivelog/2017_08_24/thread_1_seq_20.262.952876345
  96. archived log for thread 1 with sequence 21 is already on disk as file +FRA/orcl/archivelog/2017_08_24/thread_1_seq_21.261.952879097
  97. archived log for thread 1 with sequence 22 is already on disk as file +FRA/orcl/archivelog/2017_08_24/thread_1_seq_22.263.952888521
  98. archived log for thread 1 with sequence 23 is already on disk as file +FRA/orcl/archivelog/2017_08_24/thread_1_seq_23.264.952890379
  99. archived log for thread 1 with sequence 24 is already on disk as file +FRA/orcl/archivelog/2017_08_24/thread_1_seq_24.265.952890385
  100. archived log for thread 1 with sequence 25 is already on disk as file +FRA/orcl/archivelog/2017_08_24/thread_1_seq_25.266.952890395
  101. archived log for thread 1 with sequence 26 is already on disk as file +FRA/orcl/archivelog/2017_08_24/thread_1_seq_26.269.952895957
  102. archived log for thread 1 with sequence 27 is already on disk as file +FRA/orcl/archivelog/2017_08_24/thread_1_seq_27.270.952895959
  103. archived log for thread 1 with sequence 28 is already on disk as file +FRA/orcl/archivelog/2017_08_24/thread_1_seq_28.271.952895967
  104. archived log for thread 1 with sequence 1 is already on disk as file +FRA/orcl/archivelog/2017_08_26/thread_1_seq_1.302.953025979
  105. archived log for thread 1 with sequence 2 is already on disk as file +FRA/orcl/archivelog/2017_08_26/thread_1_seq_2.304.953026009
  106. archived log for thread 1 with sequence 3 is already on disk as file +FRA/orcl/archivelog/2017_08_26/thread_1_seq_3.305.953026153
  107. archived log for thread 1 with sequence 4 is already on disk as file +FRA/orcl/archivelog/2017_08_26/thread_1_seq_4.306.953027897
  108. archived log for thread 1 with sequence 5 is already on disk as file +FRA/orcl/archivelog/2017_08_26/thread_1_seq_5.307.953027897
  109. archived log for thread 1 with sequence 6 is already on disk as file +FRA/orcl/archivelog/2017_08_26/thread_1_seq_6.308.953027907
  110. channel ORA_SBT_TAPE_1: starting archived log restore to default destination
  111. channel ORA_SBT_TAPE_1: restoring archived log
  112. archived log thread=1 sequence=19
  113. channel ORA_SBT_TAPE_1: reading from backup piece 14s4ih5n_1_1
  114. channel ORA_SBT_TAPE_1: piece handle=14s4ih5n_1_1 tag=0T_INCR0_WHOLE
  115. channel ORA_SBT_TAPE_1: restored backup piece 1
  116. channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:28
  117. archived log file name=+FRA/orcl/archivelog/2017_08_26/thread_1_seq_19.312.953029095 thread=1 sequence=19
  118. channel default: deleting archived log(s)
  119. archived log file name=+FRA/orcl/archivelog/2017_08_26/thread_1_seq_19.312.953029095 RECID=63 STAMP=953029100
  120. archived log file name=+FRA/orcl/archivelog/2017_08_24/thread_1_seq_20.262.952876345 thread=1 sequence=20
  121. archived log file name=+FRA/orcl/archivelog/2017_08_24/thread_1_seq_21.261.952879097 thread=1 sequence=21
  122. archived log file name=+FRA/orcl/archivelog/2017_08_24/thread_1_seq_22.263.952888521 thread=1 sequence=22
  123. archived log file name=+FRA/orcl/archivelog/2017_08_24/thread_1_seq_23.264.952890379 thread=1 sequence=23
  124. archived log file name=+FRA/orcl/archivelog/2017_08_24/thread_1_seq_24.265.952890385 thread=1 sequence=24
  125. archived log file name=+FRA/orcl/archivelog/2017_08_24/thread_1_seq_25.266.952890395 thread=1 sequence=25
  126. archived log file name=+FRA/orcl/archivelog/2017_08_24/thread_1_seq_26.269.952895957 thread=1 sequence=26
  127. archived log file name=+FRA/orcl/archivelog/2017_08_24/thread_1_seq_27.270.952895959 thread=1 sequence=27
  128. archived log file name=+FRA/orcl/archivelog/2017_08_24/thread_1_seq_28.271.952895967 thread=1 sequence=28
  129. archived log file name=+FRA/orcl/archivelog/2017_08_26/thread_1_seq_1.302.953025979 thread=1 sequence=1
  130. archived log file name=+FRA/orcl/archivelog/2017_08_26/thread_1_seq_2.304.953026009 thread=1 sequence=2
  131. archived log file name=+FRA/orcl/archivelog/2017_08_26/thread_1_seq_3.305.953026153 thread=1 sequence=3
  132. archived log file name=+FRA/orcl/archivelog/2017_08_26/thread_1_seq_4.306.953027897 thread=1 sequence=4
  133. archived log file name=+FRA/orcl/archivelog/2017_08_26/thread_1_seq_5.307.953027897 thread=1 sequence=5
  134. archived log file name=+FRA/orcl/archivelog/2017_08_26/thread_1_seq_6.308.953027907 thread=1 sequence=6
  135. media recovery complete, elapsed time: 00:00:24
  136. Finished recover at 2017-08-26:10:18:51

  138. RMAN> list incarnation of database;

  140. RMAN-06900: WARNING: unable to generate V$RMAN_STATUS or V$RMAN_OUTPUT row
  141. RMAN-06901: WARNING: disabling update of the V$RMAN_STATUS and V$RMAN_OUTPUT rows
  142. ORACLE error from target database:
  143. ORA-03135: connection lost contact
  144. Process ID: 32253
  145. Session ID: 191 Serial number: 7

  147. RMAN-00571: ===========================================================
  148. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  149. RMAN-00571: ===========================================================
  150. RMAN-00601: fatal error in recovery manager
  151. RMAN-03004: fatal error during execution of command
  152. RMAN-04022: target database mount id 1480806535 does not match channel's mount id 1480831473
  153. RMAN-03002: failure of list command at 08/26/2017 10:21:32
  154. ORA-03114: not connected to ORACLE
  155. [oracle@station90 ~]$ rman target  /

  157. Recovery Manager: Release 11.2.0.1.0 - Production on Sat Aug 26 10:21:34 2017

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

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

  163. RMAN> list incarnation of database;

  165. using target database control file instead of recovery catalog

  167. List of Database Incarnations
  168. DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
  169. ------- ------- -------- ---------------- --- ---------- ----------
  170. 1       1       ORCL     1343950367       PARENT  1          2009-08-15:00:16:43
  171. 2       2       ORCL     1343950367       PARENT  945184     2013-05-23:09:47:15
  172. 3       3       ORCL     1343950367       ORPHAN  1082671    2017-08-24:21:40:38
  173. 4       4       ORCL     1343950367       PARENT  1082671    2017-08-26:09:25:11
  174. 5       5       ORCL     1343950367       CURRENT 1106319    2017-08-26:10:21:02

  176. RMAN> list incarnation of database;


  179. List of Database Incarnations
  180. DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
  181. ------- ------- -------- ---------------- --- ---------- ----------
  182. 1       1       ORCL     1343950367       PARENT  1          2009-08-15:00:16:43
  183. 2       2       ORCL     1343950367       PARENT  945184     2013-05-23:09:47:15
  184. 3       3       ORCL     1343950367       ORPHAN  1082671    2017-08-24:21:40:38
  185. 4       4       ORCL     1343950367       PARENT  1082671    2017-08-26:09:25:11
  186. 5       5       ORCL     1343950367       CURRENT 1106319    2017-08-26:10:21:02

  188. RMAN> exit

  190. RMAN-06900: WARNING: unable to generate V$RMAN_STATUS or V$RMAN_OUTPUT row
  191. RMAN-06901: WARNING: disabling update of the V$RMAN_STATUS and V$RMAN_OUTPUT rows
  192. ORACLE error from target database:
  193. ORA-03135: connection lost contact
  194. Process ID: 4457
  195. Session ID: 10 Serial number: 28


  198. Recovery Manager complete.
  199. [oracle@station90 ~]$ rman target  /

  201. Recovery Manager: Release 11.2.0.1.0 - Production on Sat Aug 26 10:35:58 2017

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

  205. connected to target database: ORCL (not mounted)

  207. RMAN> flashback database to sequence 8 thread 1 ;

  209. Starting flashback at 2017-08-26:10:36:50
  210. using target database control file instead of recovery catalog
  211. allocated channel: ORA_DISK_1
  212. channel ORA_DISK_1: SID=192 device type=DISK
  213. allocated channel: ORA_DISK_2
  214. channel ORA_DISK_2: SID=8 device type=DISK
  215. allocated channel: ORA_DISK_3
  216. channel ORA_DISK_3: SID=69 device type=DISK
  217. allocated channel: ORA_DISK_4
  218. channel ORA_DISK_4: SID=132 device type=DISK
  219. allocated channel: ORA_DISK_5
  220. channel ORA_DISK_5: SID=193 device type=DISK
  221. allocated channel: ORA_DISK_6
  222. channel ORA_DISK_6: SID=9 device type=DISK
  223. allocated channel: ORA_DISK_7
  224. channel ORA_DISK_7: SID=70 device type=DISK
  225. allocated channel: ORA_DISK_8
  226. channel ORA_DISK_8: SID=133 device type=DISK
  227. allocated channel: ORA_SBT_TAPE_1
  228. channel ORA_SBT_TAPE_1: SID=194 device type=SBT_TAPE
  229. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  230. allocated channel: ORA_SBT_TAPE_2
  231. channel ORA_SBT_TAPE_2: SID=134 device type=SBT_TAPE
  232. channel ORA_SBT_TAPE_2: Oracle Secure Backup

  234. RMAN-00571: ===========================================================
  235. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  236. RMAN-00571: ===========================================================
  237. RMAN-03002: failure of flashback command at 08/26/2017 10:37:03
  238. RMAN-20206: log sequence not found in the repository

  240. RMAN> list  incarnation of database;


  243. List of Database Incarnations
  244. DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
  245. ------- ------- -------- ---------------- --- ---------- ----------
  246. 1       1       ORCL     1343950367       PARENT  1          2009-08-15:00:16:43
  247. 2       2       ORCL     1343950367       PARENT  945184     2013-05-23:09:47:15
  248. 3       3       ORCL     1343950367       ORPHAN  1082671    2017-08-24:21:40:38
  249. 4       4       ORCL     1343950367       PARENT  1082671    2017-08-26:09:25:11
  250. 5       5       ORCL     1343950367       CURRENT 1106319    2017-08-26:10:21:02

  252. RMAN> reset database to incarnation 4;

  254. database reset to incarnation 4

  256. RMAN> list  incarnation of database;


  259. List of Database Incarnations
  260. DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
  261. ------- ------- -------- ---------------- --- ---------- ----------
  262. 1       1       ORCL     1343950367       PARENT  1          2009-08-15:00:16:43
  263. 2       2       ORCL     1343950367       PARENT  945184     2013-05-23:09:47:15
  264. 3       3       ORCL     1343950367       ORPHAN  1082671    2017-08-24:21:40:38
  265. 4       4       ORCL     1343950367       CURRENT 1082671    2017-08-26:09:25:11
  266. 5       5       ORCL     1343950367       ORPHAN  1106319    2017-08-26:10:21:02

  268. RMAN> flashback database to sequence 8 thread 1 ;

  270. Starting flashback at 2017-08-26:10:38:23
  271. using channel ORA_DISK_1
  272. using channel ORA_DISK_2
  273. using channel ORA_DISK_3
  274. using channel ORA_DISK_4
  275. using channel ORA_DISK_5
  276. using channel ORA_DISK_6
  277. using channel ORA_DISK_7
  278. using channel ORA_DISK_8
  279. using channel ORA_SBT_TAPE_1
  280. using channel ORA_SBT_TAPE_2


  283. starting media recovery

  285. archived log for thread 1 with sequence 1 is already on disk as file +FRA/orcl/archivelog/2017_08_26/thread_1_seq_1.302.953025979
  286. archived log for thread 1 with sequence 2 is already on disk as file +FRA/orcl/archivelog/2017_08_26/thread_1_seq_2.304.953026009
  287. archived log for thread 1 with sequence 3 is already on disk as file +FRA/orcl/archivelog/2017_08_26/thread_1_seq_3.305.953026153
  288. archived log for thread 1 with sequence 4 is already on disk as file +FRA/orcl/archivelog/2017_08_26/thread_1_seq_4.306.953027897
  289. archived log for thread 1 with sequence 5 is already on disk as file +FRA/orcl/archivelog/2017_08_26/thread_1_seq_5.307.953027897
  290. archived log for thread 1 with sequence 6 is already on disk as file +FRA/orcl/archivelog/2017_08_26/thread_1_seq_6.308.953027907
  291. archived log for thread 1 with sequence 7 is already on disk as file +FRA/orcl/archivelog/2017_08_26/thread_1_seq_7.309.953027909
  292. archived log for thread 1 with sequence 8 is already on disk as file +FRA/orcl/archivelog/2017_08_26/thread_1_seq_8.313.953029263
  293. media recovery complete, elapsed time: 00:00:12
  294. Finished flashback at 2017-08-26:10:38:42

  296. RMAN> alter database open resetlogs;

  298. database opened

  300. RMAN>
复制代码
多化身环境下，判断日子断点：
  1. [oracle@station90 ~]$ asmcmd ls +FRA/ORCL/ARCHIVELOG/2017_08_26   > a.txt
复制代码
Screenshot-1.png

UNAMED00004：
Screenshot.png
回复

使用道具 举报

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

本版积分规则

QQ|手机版|Bo's Oracle Station   

GMT+8, 2024-4-28 21:58 , Processed in 0.044319 second(s), 27 queries .

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