设为首页收藏本站

Botang唐波's Oracle Station

查看: 358|回复: 0

课程第26次(2018-04-02星期一)

[复制链接]

744

主题

1117

帖子

8077

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
8077
发表于 2018-4-2 19:58:48 | 显示全部楼层 |阅读模式
  1. [root@station90 ~]# su - oracle
  2. [oracle@station90 ~]$ rman target /

  3. Recovery Manager: Release 11.2.0.1.0 - Production on Mon Apr 2 19:42:25 2018

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

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

  6. RMAN> list incarnation of database;

  7. using target database control file instead of recovery catalog

  8. List of Database Incarnations
  9. DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
  10. ------- ------- -------- ---------------- --- ---------- ----------
  11. 1       1       ORCL     1343950367       PARENT  1          15-AUG-09
  12. 2       2       ORCL     1343950367       PARENT  945184     23-MAY-13
  13. 3       3       ORCL     1343950367       ORPHAN  1451975    01-APR-18
  14. 4       4       ORCL     1343950367       PARENT  1451975    01-APR-18
  15. 5       5       ORCL     1343950367       ORPHAN  1456352    01-APR-18
  16. 6       6       ORCL     1343950367       PARENT  1456361    01-APR-18
  17. 7       7       ORCL     1343950367       CURRENT 1464173    01-APR-18

  18. RMAN> shutdown abort

  19. Oracle instance shut down

  20. RMAN> exit


  21. Recovery Manager complete.
  22. [oracle@station90 ~]$ sqlplus /nolog

  23. SQL*Plus: Release 11.2.0.1.0 Production on Mon Apr 2 19:43:36 2018

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

  25. SQL> conn / as sysdba
  26. Connected to an idle instance.
  27. SQL> startup mount
  28. ORACLE instance started.

  29. Total System Global Area 6680915968 bytes
  30. Fixed Size                    2213936 bytes
  31. Variable Size                 3623880656 bytes
  32. Database Buffers         3019898880 bytes
  33. Redo Buffers                   34922496 bytes
  34. Database mounted.
  35. SQL> flashback database to before resetlogs;

  36. Flashback complete.

  37. SQL> alter database open resetlogs;

  38. Database altered.

  39. SQL> exit
  40. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
  41. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
  42. and Real Application Testing options
  43. [oracle@station90 ~]$ rman target /

  44. Recovery Manager: Release 11.2.0.1.0 - Production on Mon Apr 2 19:48:18 2018

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

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

  47. RMAN> list incarnation of database;

  48. using target database control file instead of recovery catalog

  49. List of Database Incarnations
  50. DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
  51. ------- ------- -------- ---------------- --- ---------- ----------
  52. 1       1       ORCL     1343950367       PARENT  1          15-AUG-09
  53. 2       2       ORCL     1343950367       PARENT  945184     23-MAY-13
  54. 3       3       ORCL     1343950367       ORPHAN  1451975    01-APR-18
  55. 4       4       ORCL     1343950367       PARENT  1451975    01-APR-18
  56. 5       5       ORCL     1343950367       ORPHAN  1456352    01-APR-18
  57. 6       6       ORCL     1343950367       PARENT  1456361    01-APR-18
  58. 7       7       ORCL     1343950367       ORPHAN  1464173    01-APR-18
  59. 8       8       ORCL     1343950367       CURRENT 1464173    02-APR-18

  60. RMAN> shutdown abort

  61. Oracle instance shut down

  62. RMAN> exit


  63. Recovery Manager complete.
  64. [oracle@station90 ~]$ sqlplus /nolog

  65. SQL*Plus: Release 11.2.0.1.0 Production on Mon Apr 2 19:51:32 2018

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

  67. SQL> conn / as sysdba
  68. Connected to an idle instance.
  69. SQL> startup mount
  70. ORACLE instance started.

  71. Total System Global Area 6680915968 bytes
  72. Fixed Size                    2213936 bytes
  73. Variable Size                 3623880656 bytes
  74. Database Buffers         3019898880 bytes
  75. Redo Buffers                   34922496 bytes
  76. Database mounted.
  77. SQL> flashback database to before resetlogs;
  78. flashback database to before resetlogs
  79. *
  80. ERROR at line 1:
  81. ORA-38766: cannot flashback data file 5; file resized smaller
  82. ORA-01110: data file 5: '+DATA/orcl/datafile/example.256.972322947'


  83. SQL> alter database datafile 5 offline ;

  84. Database altered.

  85. SQL> flashback database to before resetlogs;

  86. Flashback complete.

  87. SQL> alter database datafile 5 online ;

  88. Database altered.

  89. SQL> alter database open resetlogs;
  90. alter database open resetlogs
  91. *
  92. ERROR at line 1:
  93. ORA-01190: control file or data file 5 is from before the last RESETLOGS
  94. ORA-01110: data file 5: '+DATA/orcl/datafile/example.256.972322947'


  95. SQL> exit
  96. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
  97. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
  98. and Real Application Testing options
  99. [oracle@station90 ~]$ sqlplus /nolog

  100. SQL*Plus: Release 11.2.0.1.0 Production on Mon Apr 2 19:53:39 2018

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

  102. SQL> conn / as sysdba
  103. Connected.
  104. SQL> alter database datafile 5 offline ;

  105. Database altered.

  106. SQL> alter database open ;
  107. alter database open
  108. *
  109. ERROR at line 1:
  110. ORA-01589: must use RESETLOGS or NORESETLOGS option for database open


  111. SQL> alter database open  resetlogs;
  112. alter database open  resetlogs
  113. *
  114. ERROR at line 1:
  115. ORA-01245: offline file 5 will be lost if RESETLOGS is done
  116. ORA-01110: data file 5: '+DATA/orcl/datafile/example.256.972322947'


  117. SQL> exit
  118. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
  119. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
  120. and Real Application Testing options
  121. [oracle@station90 ~]$ sqlplus /nolog

  122. SQL*Plus: Release 11.2.0.1.0 Production on Mon Apr 2 19:54:16 2018

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

  124. SQL> conn / as sysdba
  125. Connected.
  126. SQL> exit
  127. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
  128. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
  129. and Real Application Testing options
  130. [oracle@station90 ~]$ rman target /

  131. Recovery Manager: Release 11.2.0.1.0 - Production on Mon Apr 2 19:54:28 2018

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

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

  134. RMAN> restore datafile 5 ;

  135. Starting restore at 02-APR-18
  136. using target database control file instead of recovery catalog
  137. allocated channel: ORA_DISK_1
  138. channel ORA_DISK_1: SID=131 device type=DISK
  139. allocated channel: ORA_DISK_2
  140. channel ORA_DISK_2: SID=192 device type=DISK
  141. allocated channel: ORA_DISK_3
  142. channel ORA_DISK_3: SID=8 device type=DISK
  143. allocated channel: ORA_DISK_4
  144. channel ORA_DISK_4: SID=69 device type=DISK
  145. allocated channel: ORA_DISK_5
  146. channel ORA_DISK_5: SID=132 device type=DISK
  147. allocated channel: ORA_DISK_6
  148. channel ORA_DISK_6: SID=193 device type=DISK
  149. allocated channel: ORA_DISK_7
  150. channel ORA_DISK_7: SID=9 device type=DISK
  151. allocated channel: ORA_DISK_8
  152. channel ORA_DISK_8: SID=70 device type=DISK
  153. allocated channel: ORA_SBT_TAPE_1
  154. channel ORA_SBT_TAPE_1: SID=133 device type=SBT_TAPE
  155. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  156. allocated channel: ORA_SBT_TAPE_2
  157. channel ORA_SBT_TAPE_2: SID=10 device type=SBT_TAPE
  158. channel ORA_SBT_TAPE_2: Oracle Secure Backup

  159. channel ORA_SBT_TAPE_1: starting datafile backup set restore
  160. channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
  161. channel ORA_SBT_TAPE_1: restoring datafile 00005 to +DATA/orcl/datafile/example.256.972322947
  162. channel ORA_SBT_TAPE_1: reading from backup piece 12s4ih4j_1_1
  163. channel ORA_SBT_TAPE_1: piece handle=12s4ih4j_1_1 tag=0T_INCR0_WHOLE
  164. channel ORA_SBT_TAPE_1: restored backup piece 1
  165. channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:35
  166. Finished restore at 02-APR-18

  167. RMAN> recover datafile 5;

  168. Starting recover at 02-APR-18
  169. using channel ORA_DISK_1
  170. using channel ORA_DISK_2
  171. using channel ORA_DISK_3
  172. using channel ORA_DISK_4
  173. using channel ORA_DISK_5
  174. using channel ORA_DISK_6
  175. using channel ORA_DISK_7
  176. using channel ORA_DISK_8
  177. using channel ORA_SBT_TAPE_1
  178. using channel ORA_SBT_TAPE_2

  179. RMAN-00571: ===========================================================
  180. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  181. RMAN-00571: ===========================================================
  182. RMAN-03002: failure of recover command at 04/02/2018 19:55:42
  183. RMAN-06067: RECOVER DATABASE required with a backup or created control file

  184. RMAN> exit


  185. Recovery Manager complete.
  186. [oracle@station90 ~]$ sqlplus /nolog

  187. SQL*Plus: Release 11.2.0.1.0 Production on Mon Apr 2 19:56:05 2018

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

  189. SQL> conn / as sysdba
  190. Connected.
  191. SQL> alter database open resetlogs;
  192. alter database open resetlogs
  193. *
  194. ERROR at line 1:
  195. ORA-01245: offline file 5 will be lost if RESETLOGS is done
  196. ORA-01110: data file 5: '+DATA/orcl/datafile/example.256.972322947'


  197. SQL> recover datafile 5 ;
  198. ORA-00283: recovery session canceled due to errors
  199. ORA-38798: Cannot perform partial database recovery
  200. ORA-38797: Full database recovery required after a database has been flashed
  201. back


  202. SQL> exit
  203. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
  204. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
  205. and Real Application Testing options
  206. [oracle@station90 ~]$ rman target /

  207. Recovery Manager: Release 11.2.0.1.0 - Production on Mon Apr 2 19:56:37 2018

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

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

  210. RMAN> recover database;

  211. Starting recover at 02-APR-18
  212. using target database control file instead of recovery catalog
  213. allocated channel: ORA_DISK_1
  214. channel ORA_DISK_1: SID=131 device type=DISK
  215. allocated channel: ORA_DISK_2
  216. channel ORA_DISK_2: SID=194 device type=DISK
  217. allocated channel: ORA_DISK_3
  218. channel ORA_DISK_3: SID=10 device type=DISK
  219. allocated channel: ORA_DISK_4
  220. channel ORA_DISK_4: SID=69 device type=DISK
  221. allocated channel: ORA_DISK_5
  222. channel ORA_DISK_5: SID=132 device type=DISK
  223. allocated channel: ORA_DISK_6
  224. channel ORA_DISK_6: SID=193 device type=DISK
  225. allocated channel: ORA_DISK_7
  226. channel ORA_DISK_7: SID=9 device type=DISK
  227. allocated channel: ORA_DISK_8
  228. channel ORA_DISK_8: SID=70 device type=DISK
  229. allocated channel: ORA_SBT_TAPE_1
  230. channel ORA_SBT_TAPE_1: SID=130 device type=SBT_TAPE
  231. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  232. allocated channel: ORA_SBT_TAPE_2
  233. channel ORA_SBT_TAPE_2: SID=8 device type=SBT_TAPE
  234. channel ORA_SBT_TAPE_2: Oracle Secure Backup

  235. starting media recovery

  236. archived log for thread 1 with sequence 19 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_19.392.972323287
  237. archived log for thread 1 with sequence 20 is already on disk as file +FRA/orcl/archivelog/2018_03_29/thread_1_seq_20.262.972060893
  238. archived log for thread 1 with sequence 21 is already on disk as file +FRA/orcl/archivelog/2018_03_29/thread_1_seq_21.261.972060939
  239. archived log for thread 1 with sequence 22 is already on disk as file +FRA/orcl/archivelog/2018_03_29/thread_1_seq_22.263.972070275
  240. archived log for thread 1 with sequence 23 is already on disk as file +FRA/orcl/archivelog/2018_03_29/thread_1_seq_23.264.972071759
  241. archived log for thread 1 with sequence 24 is already on disk as file +FRA/orcl/archivelog/2018_03_29/thread_1_seq_24.265.972072815
  242. archived log for thread 1 with sequence 25 is already on disk as file +FRA/orcl/archivelog/2018_03_29/thread_1_seq_25.266.972072905
  243. archived log for thread 1 with sequence 26 is already on disk as file +FRA/orcl/archivelog/2018_03_29/thread_1_seq_26.267.972073043
  244. archived log for thread 1 with sequence 27 is already on disk as file +FRA/orcl/archivelog/2018_03_29/thread_1_seq_27.268.972073051
  245. archived log for thread 1 with sequence 28 is already on disk as file +FRA/orcl/archivelog/2018_03_29/thread_1_seq_28.269.972073063
  246. archived log for thread 1 with sequence 29 is already on disk as file +FRA/orcl/archivelog/2018_03_29/thread_1_seq_29.270.972079239
  247. archived log for thread 1 with sequence 30 is already on disk as file +FRA/orcl/archivelog/2018_03_29/thread_1_seq_30.271.972079311
  248. archived log for thread 1 with sequence 31 is already on disk as file +FRA/orcl/archivelog/2018_03_29/thread_1_seq_31.272.972079365
  249. archived log for thread 1 with sequence 32 is already on disk as file +FRA/orcl/archivelog/2018_03_30/thread_1_seq_32.273.972119851
  250. archived log for thread 1 with sequence 33 is already on disk as file +FRA/orcl/archivelog/2018_03_30/thread_1_seq_33.274.972120503
  251. archived log for thread 1 with sequence 34 is already on disk as file +FRA/orcl/archivelog/2018_03_30/thread_1_seq_34.275.972126049
  252. archived log for thread 1 with sequence 35 is already on disk as file +FRA/orcl/archivelog/2018_03_30/thread_1_seq_35.276.972134249
  253. archived log for thread 1 with sequence 36 is already on disk as file +FRA/orcl/archivelog/2018_03_30/thread_1_seq_36.277.972142677
  254. archived log for thread 1 with sequence 37 is already on disk as file +FRA/orcl/archivelog/2018_03_30/thread_1_seq_37.278.972161139
  255. archived log for thread 1 with sequence 38 is already on disk as file +FRA/orcl/archivelog/2018_03_30/thread_1_seq_38.279.972162905
  256. archived log for thread 1 with sequence 39 is already on disk as file +FRA/orcl/archivelog/2018_03_30/thread_1_seq_39.280.972165649
  257. archived log for thread 1 with sequence 40 is already on disk as file +FRA/orcl/archivelog/2018_03_30/thread_1_seq_40.281.972166117
  258. archived log for thread 1 with sequence 41 is already on disk as file +FRA/orcl/archivelog/2018_03_31/thread_1_seq_41.282.972206295
  259. archived log for thread 1 with sequence 42 is already on disk as file +FRA/orcl/archivelog/2018_03_31/thread_1_seq_42.283.972208237
  260. archived log for thread 1 with sequence 43 is already on disk as file +FRA/orcl/archivelog/2018_03_31/thread_1_seq_43.284.972212455
  261. archived log for thread 1 with sequence 44 is already on disk as file +FRA/orcl/archivelog/2018_03_31/thread_1_seq_44.285.972224729
  262. archived log for thread 1 with sequence 45 is already on disk as file +FRA/orcl/archivelog/2018_03_31/thread_1_seq_45.286.972231635
  263. archived log for thread 1 with sequence 46 is already on disk as file +FRA/orcl/archivelog/2018_03_31/thread_1_seq_46.287.972237931
  264. archived log for thread 1 with sequence 47 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_47.288.972292287
  265. archived log for thread 1 with sequence 48 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_48.289.972292375
  266. archived log for thread 1 with sequence 49 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_49.290.972292459
  267. archived log for thread 1 with sequence 50 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_50.291.972293883
  268. archived log for thread 1 with sequence 51 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_51.292.972293981
  269. archived log for thread 1 with sequence 52 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_52.293.972294939
  270. archived log for thread 1 with sequence 53 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_53.295.972298807
  271. archived log for thread 1 with sequence 54 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_54.297.972306021
  272. archived log for thread 1 with sequence 55 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_55.299.972307191
  273. archived log for thread 1 with sequence 56 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_56.301.972309643
  274. archived log for thread 1 with sequence 57 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_57.302.972313083
  275. archived log for thread 1 with sequence 58 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_58.303.972313083
  276. archived log for thread 1 with sequence 59 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_59.304.972313093
  277. archived log for thread 1 with sequence 1 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_1.318.972317853
  278. archived log for thread 1 with sequence 2 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_2.319.972317855
  279. archived log for thread 1 with sequence 3 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_3.320.972317859
  280. archived log for thread 1 with sequence 4 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_4.321.972317859
  281. archived log for thread 1 with sequence 5 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_5.322.972317861
  282. archived log for thread 1 with sequence 6 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_6.323.972317861
  283. archived log for thread 1 with sequence 7 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_7.324.972317863
  284. archived log for thread 1 with sequence 8 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_8.325.972317863
  285. archived log for thread 1 with sequence 9 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_9.326.972317865
  286. archived log for thread 1 with sequence 10 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_10.327.972317865
  287. archived log for thread 1 with sequence 11 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_11.328.972317865
  288. archived log for thread 1 with sequence 12 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_12.329.972317865
  289. archived log for thread 1 with sequence 13 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_13.330.972317867
  290. archived log for thread 1 with sequence 14 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_14.331.972317871
  291. archived log for thread 1 with sequence 15 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_15.332.972317873
  292. archived log for thread 1 with sequence 16 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_16.333.972317873
  293. archived log for thread 1 with sequence 17 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_17.334.972317875
  294. archived log for thread 1 with sequence 18 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_18.335.972317875
  295. archived log for thread 1 with sequence 19 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_19.336.972317877
  296. archived log for thread 1 with sequence 20 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_20.337.972317879
  297. archived log for thread 1 with sequence 21 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_21.338.972317879
  298. archived log for thread 1 with sequence 22 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_22.339.972317879
  299. archived log for thread 1 with sequence 23 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_23.340.972317881
  300. archived log for thread 1 with sequence 24 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_24.341.972317883
  301. archived log for thread 1 with sequence 25 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_25.342.972317885
  302. archived log for thread 1 with sequence 26 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_26.343.972317885
  303. archived log for thread 1 with sequence 27 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_27.344.972317889
  304. archived log for thread 1 with sequence 28 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_28.345.972317889
  305. archived log for thread 1 with sequence 29 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_29.346.972317895
  306. archived log for thread 1 with sequence 30 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_30.347.972317895
  307. archived log for thread 1 with sequence 31 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_31.348.972317897
  308. archived log for thread 1 with sequence 32 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_32.349.972317901
  309. archived log for thread 1 with sequence 33 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_33.350.972317901
  310. archived log for thread 1 with sequence 34 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_34.351.972317903
  311. archived log for thread 1 with sequence 35 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_35.352.972317903
  312. archived log for thread 1 with sequence 36 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_36.353.972317905
  313. archived log for thread 1 with sequence 37 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_37.354.972317907
  314. archived log for thread 1 with sequence 38 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_38.355.972317909
  315. archived log for thread 1 with sequence 39 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_39.356.972317913
  316. archived log for thread 1 with sequence 40 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_40.357.972317915
  317. archived log for thread 1 with sequence 41 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_41.358.972317915
  318. archived log for thread 1 with sequence 42 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_42.359.972317917
  319. archived log for thread 1 with sequence 43 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_43.360.972317919
  320. archived log for thread 1 with sequence 44 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_44.361.972318087
  321. archived log for thread 1 with sequence 45 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_45.362.972318089
  322. archived log for thread 1 with sequence 46 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_46.363.972318099
  323. archived log for thread 1 with sequence 47 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_47.364.972318103
  324. archived log for thread 1 with sequence 48 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_48.369.972319355
  325. archived log for thread 1 with sequence 1 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_1.374.972321509
  326. archived log for thread 1 with sequence 2 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_2.375.972321511
  327. archived log for thread 1 with sequence 3 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_3.376.972321513
  328. archived log for thread 1 with sequence 4 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_4.377.972321515
  329. archived log for thread 1 with sequence 5 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_5.378.972321519
  330. archived log for thread 1 with sequence 6 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_6.379.972321519
  331. archived log for thread 1 with sequence 7 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_7.380.972321521
  332. archived log for thread 1 with sequence 8 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_8.381.972321523
  333. archived log for thread 1 with sequence 9 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_9.382.972321525
  334. archived log for thread 1 with sequence 10 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_10.383.972321527
  335. archived log for thread 1 with sequence 11 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_11.384.972321529
  336. archived log for thread 1 with sequence 12 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_12.385.972321531
  337. archived log for thread 1 with sequence 13 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_13.386.972321535
  338. archived log for thread 1 with sequence 14 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_14.387.972321537
  339. archived log for thread 1 with sequence 15 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_15.388.972321815
  340. archived log for thread 1 with sequence 16 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_16.389.972321817
  341. archived log for thread 1 with sequence 17 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_17.391.972321827
  342. archived log for thread 1 with sequence 1 is already on disk as file +DATA/orcl/onlinelog/group_1.261.816169635
  343. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_19.392.972323287 thread=1 sequence=19
  344. archived log file name=+FRA/orcl/archivelog/2018_03_29/thread_1_seq_20.262.972060893 thread=1 sequence=20
  345. archived log file name=+FRA/orcl/archivelog/2018_03_29/thread_1_seq_21.261.972060939 thread=1 sequence=21
  346. archived log file name=+FRA/orcl/archivelog/2018_03_29/thread_1_seq_22.263.972070275 thread=1 sequence=22
  347. archived log file name=+FRA/orcl/archivelog/2018_03_29/thread_1_seq_23.264.972071759 thread=1 sequence=23
  348. archived log file name=+FRA/orcl/archivelog/2018_03_29/thread_1_seq_24.265.972072815 thread=1 sequence=24
  349. archived log file name=+FRA/orcl/archivelog/2018_03_29/thread_1_seq_25.266.972072905 thread=1 sequence=25
  350. archived log file name=+FRA/orcl/archivelog/2018_03_29/thread_1_seq_26.267.972073043 thread=1 sequence=26
  351. archived log file name=+FRA/orcl/archivelog/2018_03_29/thread_1_seq_27.268.972073051 thread=1 sequence=27
  352. archived log file name=+FRA/orcl/archivelog/2018_03_29/thread_1_seq_28.269.972073063 thread=1 sequence=28
  353. archived log file name=+FRA/orcl/archivelog/2018_03_29/thread_1_seq_29.270.972079239 thread=1 sequence=29
  354. archived log file name=+FRA/orcl/archivelog/2018_03_29/thread_1_seq_30.271.972079311 thread=1 sequence=30
  355. archived log file name=+FRA/orcl/archivelog/2018_03_29/thread_1_seq_31.272.972079365 thread=1 sequence=31
  356. archived log file name=+FRA/orcl/archivelog/2018_03_30/thread_1_seq_32.273.972119851 thread=1 sequence=32
  357. archived log file name=+FRA/orcl/archivelog/2018_03_30/thread_1_seq_33.274.972120503 thread=1 sequence=33
  358. archived log file name=+FRA/orcl/archivelog/2018_03_30/thread_1_seq_34.275.972126049 thread=1 sequence=34
  359. archived log file name=+FRA/orcl/archivelog/2018_03_30/thread_1_seq_35.276.972134249 thread=1 sequence=35
  360. archived log file name=+FRA/orcl/archivelog/2018_03_30/thread_1_seq_36.277.972142677 thread=1 sequence=36
  361. archived log file name=+FRA/orcl/archivelog/2018_03_30/thread_1_seq_37.278.972161139 thread=1 sequence=37
  362. archived log file name=+FRA/orcl/archivelog/2018_03_30/thread_1_seq_38.279.972162905 thread=1 sequence=38
  363. archived log file name=+FRA/orcl/archivelog/2018_03_30/thread_1_seq_39.280.972165649 thread=1 sequence=39
  364. archived log file name=+FRA/orcl/archivelog/2018_03_30/thread_1_seq_40.281.972166117 thread=1 sequence=40
  365. archived log file name=+FRA/orcl/archivelog/2018_03_31/thread_1_seq_41.282.972206295 thread=1 sequence=41
  366. archived log file name=+FRA/orcl/archivelog/2018_03_31/thread_1_seq_42.283.972208237 thread=1 sequence=42
  367. archived log file name=+FRA/orcl/archivelog/2018_03_31/thread_1_seq_43.284.972212455 thread=1 sequence=43
  368. archived log file name=+FRA/orcl/archivelog/2018_03_31/thread_1_seq_44.285.972224729 thread=1 sequence=44
  369. archived log file name=+FRA/orcl/archivelog/2018_03_31/thread_1_seq_45.286.972231635 thread=1 sequence=45
  370. archived log file name=+FRA/orcl/archivelog/2018_03_31/thread_1_seq_46.287.972237931 thread=1 sequence=46
  371. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_47.288.972292287 thread=1 sequence=47
  372. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_48.289.972292375 thread=1 sequence=48
  373. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_49.290.972292459 thread=1 sequence=49
  374. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_50.291.972293883 thread=1 sequence=50
  375. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_51.292.972293981 thread=1 sequence=51
  376. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_52.293.972294939 thread=1 sequence=52
  377. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_53.295.972298807 thread=1 sequence=53
  378. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_54.297.972306021 thread=1 sequence=54
  379. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_55.299.972307191 thread=1 sequence=55
  380. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_56.301.972309643 thread=1 sequence=56
  381. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_57.302.972313083 thread=1 sequence=57
  382. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_58.303.972313083 thread=1 sequence=58
  383. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_59.304.972313093 thread=1 sequence=59
  384. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_1.318.972317853 thread=1 sequence=1
  385. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_2.319.972317855 thread=1 sequence=2
  386. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_3.320.972317859 thread=1 sequence=3
  387. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_4.321.972317859 thread=1 sequence=4
  388. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_5.322.972317861 thread=1 sequence=5
  389. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_6.323.972317861 thread=1 sequence=6
  390. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_7.324.972317863 thread=1 sequence=7
  391. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_8.325.972317863 thread=1 sequence=8
  392. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_9.326.972317865 thread=1 sequence=9
  393. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_10.327.972317865 thread=1 sequence=10
  394. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_11.328.972317865 thread=1 sequence=11
  395. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_12.329.972317865 thread=1 sequence=12
  396. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_13.330.972317867 thread=1 sequence=13
  397. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_14.331.972317871 thread=1 sequence=14
  398. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_15.332.972317873 thread=1 sequence=15
  399. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_16.333.972317873 thread=1 sequence=16
  400. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_17.334.972317875 thread=1 sequence=17
  401. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_18.335.972317875 thread=1 sequence=18
  402. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_19.336.972317877 thread=1 sequence=19
  403. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_20.337.972317879 thread=1 sequence=20
  404. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_21.338.972317879 thread=1 sequence=21
  405. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_22.339.972317879 thread=1 sequence=22
  406. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_23.340.972317881 thread=1 sequence=23
  407. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_24.341.972317883 thread=1 sequence=24
  408. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_25.342.972317885 thread=1 sequence=25
  409. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_26.343.972317885 thread=1 sequence=26
  410. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_27.344.972317889 thread=1 sequence=27
  411. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_28.345.972317889 thread=1 sequence=28
  412. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_29.346.972317895 thread=1 sequence=29
  413. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_30.347.972317895 thread=1 sequence=30
  414. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_31.348.972317897 thread=1 sequence=31
  415. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_32.349.972317901 thread=1 sequence=32
  416. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_33.350.972317901 thread=1 sequence=33
  417. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_34.351.972317903 thread=1 sequence=34
  418. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_35.352.972317903 thread=1 sequence=35
  419. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_36.353.972317905 thread=1 sequence=36
  420. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_37.354.972317907 thread=1 sequence=37
  421. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_38.355.972317909 thread=1 sequence=38
  422. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_39.356.972317913 thread=1 sequence=39
  423. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_40.357.972317915 thread=1 sequence=40
  424. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_41.358.972317915 thread=1 sequence=41
  425. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_42.359.972317917 thread=1 sequence=42
  426. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_43.360.972317919 thread=1 sequence=43
  427. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_44.361.972318087 thread=1 sequence=44
  428. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_45.362.972318089 thread=1 sequence=45
  429. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_46.363.972318099 thread=1 sequence=46
  430. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_47.364.972318103 thread=1 sequence=47
  431. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_48.369.972319355 thread=1 sequence=48
  432. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_1.374.972321509 thread=1 sequence=1
  433. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_2.375.972321511 thread=1 sequence=2
  434. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_3.376.972321513 thread=1 sequence=3
  435. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_4.377.972321515 thread=1 sequence=4
  436. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_5.378.972321519 thread=1 sequence=5
  437. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_6.379.972321519 thread=1 sequence=6
  438. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_7.380.972321521 thread=1 sequence=7
  439. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_8.381.972321523 thread=1 sequence=8
  440. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_9.382.972321525 thread=1 sequence=9
  441. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_10.383.972321527 thread=1 sequence=10
  442. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_11.384.972321529 thread=1 sequence=11
  443. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_12.385.972321531 thread=1 sequence=12
  444. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_13.386.972321535 thread=1 sequence=13
  445. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_14.387.972321537 thread=1 sequence=14
  446. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_15.388.972321815 thread=1 sequence=15
  447. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_16.389.972321817 thread=1 sequence=16
  448. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_17.391.972321827 thread=1 sequence=17
  449. media recovery complete, elapsed time: 00:00:22
  450. Finished recover at 02-APR-18

  451. RMAN> alter database open resetlogs;

  452. RMAN-00571: ===========================================================
  453. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  454. RMAN-00571: ===========================================================
  455. RMAN-03002: failure of alter db command at 04/02/2018 19:57:28
  456. ORA-01139: RESETLOGS option only valid after an incomplete database recovery

  457. RMAN> exit


  458. Recovery Manager complete.
  459. [oracle@station90 ~]$ sqlplus /nolog

  460. SQL*Plus: Release 11.2.0.1.0 Production on Mon Apr 2 19:57:39 2018

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

  462. SQL> conn / as sysdba
  463. Connected.
  464. SQL> alter database open ;

  465. Database altered.

  466. SQL> exit
  467. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
  468. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
  469. and Real Application Testing options
  470. [oracle@station90 ~]$ rman target /

  471. Recovery Manager: Release 11.2.0.1.0 - Production on Mon Apr 2 19:58:08 2018

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

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

  474. RMAN> list incarnation of database;

  475. using target database control file instead of recovery catalog

  476. List of Database Incarnations
  477. DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
  478. ------- ------- -------- ---------------- --- ---------- ----------
  479. 1       1       ORCL     1343950367       PARENT  1          15-AUG-09
  480. 2       2       ORCL     1343950367       PARENT  945184     23-MAY-13
  481. 3       3       ORCL     1343950367       ORPHAN  1451975    01-APR-18
  482. 4       4       ORCL     1343950367       PARENT  1451975    01-APR-18
  483. 5       5       ORCL     1343950367       ORPHAN  1456352    01-APR-18
  484. 6       6       ORCL     1343950367       PARENT  1456361    01-APR-18
  485. 7       7       ORCL     1343950367       ORPHAN  1464173    01-APR-18
  486. 8       8       ORCL     1343950367       CURRENT 1464173    02-APR-18

  487. RMAN>
复制代码
  1. select  * from v$restore_point;

  2. create restore point rsp1 ;

  3. create restore point rsp2 as of scn 1000000;



  4. create restore point rsp3
  5. guarantee flashback database;

  6. select  * from v$flashback_database_log;
复制代码


回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2018-11-18 01:11 , Processed in 0.166365 second(s), 24 queries .

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