开启辅助访问

Bo's Oracle Station

Bo's Oracle Station»社区 › 培训进行时（结课后图标变灰，但是欢迎继续发帖！） › 4077-12c管理类OCP认证班第四期 › 课程第26次（2018-04-02星期一）
返回列表 发新帖
查看: 956|回复: 0

课程第26次（2018-04-02星期一）

[复制链接]
botang

1005

主题

1469

帖子

1万

积分

管理员

Rank: 9Rank: 9Rank: 9

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

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

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

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

  10. RMAN> list incarnation of database;

  12. using target database control file instead of recovery catalog

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

  25. RMAN> shutdown abort

  27. Oracle instance shut down

  29. RMAN> exit


  32. Recovery Manager complete.
  33. [oracle@station90 ~]$ sqlplus /nolog

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

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

  39. SQL> conn / as sysdba
  40. Connected to an idle instance.
  41. SQL> startup mount
  42. ORACLE instance started.

  44. Total System Global Area 6680915968 bytes
  45. Fixed Size                    2213936 bytes
  46. Variable Size                 3623880656 bytes
  47. Database Buffers         3019898880 bytes
  48. Redo Buffers                   34922496 bytes
  49. Database mounted.
  50. SQL> flashback database to before resetlogs;

  52. Flashback complete.

  54. SQL> alter database open resetlogs;

  56. Database altered.

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

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

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

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

  70. RMAN> list incarnation of database;

  72. using target database control file instead of recovery catalog

  74. List of Database Incarnations
  75. DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
  76. ------- ------- -------- ---------------- --- ---------- ----------
  77. 1       1       ORCL     1343950367       PARENT  1          15-AUG-09
  78. 2       2       ORCL     1343950367       PARENT  945184     23-MAY-13
  79. 3       3       ORCL     1343950367       ORPHAN  1451975    01-APR-18
  80. 4       4       ORCL     1343950367       PARENT  1451975    01-APR-18
  81. 5       5       ORCL     1343950367       ORPHAN  1456352    01-APR-18
  82. 6       6       ORCL     1343950367       PARENT  1456361    01-APR-18
  83. 7       7       ORCL     1343950367       ORPHAN  1464173    01-APR-18
  84. 8       8       ORCL     1343950367       CURRENT 1464173    02-APR-18

  86. RMAN> shutdown abort

  88. Oracle instance shut down

  90. RMAN> exit


  93. Recovery Manager complete.
  94. [oracle@station90 ~]$ sqlplus /nolog

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

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

  100. SQL> conn / as sysdba
  101. Connected to an idle instance.
  102. SQL> startup mount
  103. ORACLE instance started.

  105. Total System Global Area 6680915968 bytes
  106. Fixed Size                    2213936 bytes
  107. Variable Size                 3623880656 bytes
  108. Database Buffers         3019898880 bytes
  109. Redo Buffers                   34922496 bytes
  110. Database mounted.
  111. SQL> flashback database to before resetlogs;
  112. flashback database to before resetlogs
  113. *
  114. ERROR at line 1:
  115. ORA-38766: cannot flashback data file 5; file resized smaller
  116. ORA-01110: data file 5: '+DATA/orcl/datafile/example.256.972322947'


  119. SQL> alter database datafile 5 offline ;

  121. Database altered.

  123. SQL> flashback database to before resetlogs;

  125. Flashback complete.

  127. SQL> alter database datafile 5 online ;

  129. Database altered.

  131. SQL> alter database open resetlogs;
  132. alter database open resetlogs
  133. *
  134. ERROR at line 1:
  135. ORA-01190: control file or data file 5 is from before the last RESETLOGS
  136. ORA-01110: data file 5: '+DATA/orcl/datafile/example.256.972322947'


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

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

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

  149. SQL> conn / as sysdba
  150. Connected.
  151. SQL> alter database datafile 5 offline ;

  153. Database altered.

  155. SQL> alter database open ;
  156. alter database open
  157. *
  158. ERROR at line 1:
  159. ORA-01589: must use RESETLOGS or NORESETLOGS option for database open


  162. SQL> alter database open  resetlogs;
  163. alter database open  resetlogs
  164. *
  165. ERROR at line 1:
  166. ORA-01245: offline file 5 will be lost if RESETLOGS is done
  167. ORA-01110: data file 5: '+DATA/orcl/datafile/example.256.972322947'


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

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

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

  180. SQL> conn / as sysdba
  181. Connected.
  182. SQL> exit
  183. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
  184. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
  185. and Real Application Testing options
  186. [oracle@station90 ~]$ rman target /

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

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

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

  194. RMAN> restore datafile 5 ;

  196. Starting restore at 02-APR-18
  197. using target database control file instead of recovery catalog
  198. allocated channel: ORA_DISK_1
  199. channel ORA_DISK_1: SID=131 device type=DISK
  200. allocated channel: ORA_DISK_2
  201. channel ORA_DISK_2: SID=192 device type=DISK
  202. allocated channel: ORA_DISK_3
  203. channel ORA_DISK_3: SID=8 device type=DISK
  204. allocated channel: ORA_DISK_4
  205. channel ORA_DISK_4: SID=69 device type=DISK
  206. allocated channel: ORA_DISK_5
  207. channel ORA_DISK_5: SID=132 device type=DISK
  208. allocated channel: ORA_DISK_6
  209. channel ORA_DISK_6: SID=193 device type=DISK
  210. allocated channel: ORA_DISK_7
  211. channel ORA_DISK_7: SID=9 device type=DISK
  212. allocated channel: ORA_DISK_8
  213. channel ORA_DISK_8: SID=70 device type=DISK
  214. allocated channel: ORA_SBT_TAPE_1
  215. channel ORA_SBT_TAPE_1: SID=133 device type=SBT_TAPE
  216. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  217. allocated channel: ORA_SBT_TAPE_2
  218. channel ORA_SBT_TAPE_2: SID=10 device type=SBT_TAPE
  219. channel ORA_SBT_TAPE_2: Oracle Secure Backup

  221. channel ORA_SBT_TAPE_1: starting datafile backup set restore
  222. channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
  223. channel ORA_SBT_TAPE_1: restoring datafile 00005 to +DATA/orcl/datafile/example.256.972322947
  224. channel ORA_SBT_TAPE_1: reading from backup piece 12s4ih4j_1_1
  225. channel ORA_SBT_TAPE_1: piece handle=12s4ih4j_1_1 tag=0T_INCR0_WHOLE
  226. channel ORA_SBT_TAPE_1: restored backup piece 1
  227. channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:35
  228. Finished restore at 02-APR-18

  230. RMAN> recover datafile 5;

  232. Starting recover at 02-APR-18
  233. using channel ORA_DISK_1
  234. using channel ORA_DISK_2
  235. using channel ORA_DISK_3
  236. using channel ORA_DISK_4
  237. using channel ORA_DISK_5
  238. using channel ORA_DISK_6
  239. using channel ORA_DISK_7
  240. using channel ORA_DISK_8
  241. using channel ORA_SBT_TAPE_1
  242. using channel ORA_SBT_TAPE_2

  244. RMAN-00571: ===========================================================
  245. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  246. RMAN-00571: ===========================================================
  247. RMAN-03002: failure of recover command at 04/02/2018 19:55:42
  248. RMAN-06067: RECOVER DATABASE required with a backup or created control file

  250. RMAN> exit


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

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

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

  260. SQL> conn / as sysdba
  261. Connected.
  262. SQL> alter database open resetlogs;
  263. alter database open resetlogs
  264. *
  265. ERROR at line 1:
  266. ORA-01245: offline file 5 will be lost if RESETLOGS is done
  267. ORA-01110: data file 5: '+DATA/orcl/datafile/example.256.972322947'


  270. SQL> recover datafile 5 ;
  271. ORA-00283: recovery session canceled due to errors
  272. ORA-38798: Cannot perform partial database recovery
  273. ORA-38797: Full database recovery required after a database has been flashed
  274. back


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

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

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

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

  289. RMAN> recover database;

  291. Starting recover at 02-APR-18
  292. using target database control file instead of recovery catalog
  293. allocated channel: ORA_DISK_1
  294. channel ORA_DISK_1: SID=131 device type=DISK
  295. allocated channel: ORA_DISK_2
  296. channel ORA_DISK_2: SID=194 device type=DISK
  297. allocated channel: ORA_DISK_3
  298. channel ORA_DISK_3: SID=10 device type=DISK
  299. allocated channel: ORA_DISK_4
  300. channel ORA_DISK_4: SID=69 device type=DISK
  301. allocated channel: ORA_DISK_5
  302. channel ORA_DISK_5: SID=132 device type=DISK
  303. allocated channel: ORA_DISK_6
  304. channel ORA_DISK_6: SID=193 device type=DISK
  305. allocated channel: ORA_DISK_7
  306. channel ORA_DISK_7: SID=9 device type=DISK
  307. allocated channel: ORA_DISK_8
  308. channel ORA_DISK_8: SID=70 device type=DISK
  309. allocated channel: ORA_SBT_TAPE_1
  310. channel ORA_SBT_TAPE_1: SID=130 device type=SBT_TAPE
  311. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  312. allocated channel: ORA_SBT_TAPE_2
  313. channel ORA_SBT_TAPE_2: SID=8 device type=SBT_TAPE
  314. channel ORA_SBT_TAPE_2: Oracle Secure Backup

  316. starting media recovery

  318. 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
  319. 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
  320. 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
  321. 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
  322. 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
  323. 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
  324. 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
  325. 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
  326. 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
  327. 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
  328. 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
  329. 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
  330. 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
  331. 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
  332. 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
  333. 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
  334. 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
  335. 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
  336. 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
  337. 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
  338. 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
  339. 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
  340. 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
  341. 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
  342. 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
  343. 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
  344. 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
  345. 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
  346. 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
  347. 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
  348. 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
  349. 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
  350. 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
  351. 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
  352. 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
  353. 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
  354. 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
  355. 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
  356. 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
  357. 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
  358. 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
  359. 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
  360. 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
  361. 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
  362. 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
  363. 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
  364. 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
  365. 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
  366. 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
  367. 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
  368. 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
  369. 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
  370. 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
  371. 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
  372. 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
  373. 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
  374. 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
  375. 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
  376. 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
  377. 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
  378. 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
  379. 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
  380. 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
  381. 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
  382. 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
  383. 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
  384. 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
  385. 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
  386. 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
  387. 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
  388. 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
  389. 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
  390. 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
  391. 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
  392. 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
  393. 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
  394. 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
  395. 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
  396. 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
  397. 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
  398. 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
  399. 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
  400. 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
  401. 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
  402. 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
  403. 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
  404. 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
  405. 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
  406. 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
  407. 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
  408. 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
  409. 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
  410. 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
  411. 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
  412. 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
  413. 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
  414. 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
  415. 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
  416. 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
  417. 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
  418. 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
  419. 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
  420. 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
  421. 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
  422. 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
  423. 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
  424. archived log for thread 1 with sequence 1 is already on disk as file +DATA/orcl/onlinelog/group_1.261.816169635
  425. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_19.392.972323287 thread=1 sequence=19
  426. archived log file name=+FRA/orcl/archivelog/2018_03_29/thread_1_seq_20.262.972060893 thread=1 sequence=20
  427. archived log file name=+FRA/orcl/archivelog/2018_03_29/thread_1_seq_21.261.972060939 thread=1 sequence=21
  428. archived log file name=+FRA/orcl/archivelog/2018_03_29/thread_1_seq_22.263.972070275 thread=1 sequence=22
  429. archived log file name=+FRA/orcl/archivelog/2018_03_29/thread_1_seq_23.264.972071759 thread=1 sequence=23
  430. archived log file name=+FRA/orcl/archivelog/2018_03_29/thread_1_seq_24.265.972072815 thread=1 sequence=24
  431. archived log file name=+FRA/orcl/archivelog/2018_03_29/thread_1_seq_25.266.972072905 thread=1 sequence=25
  432. archived log file name=+FRA/orcl/archivelog/2018_03_29/thread_1_seq_26.267.972073043 thread=1 sequence=26
  433. archived log file name=+FRA/orcl/archivelog/2018_03_29/thread_1_seq_27.268.972073051 thread=1 sequence=27
  434. archived log file name=+FRA/orcl/archivelog/2018_03_29/thread_1_seq_28.269.972073063 thread=1 sequence=28
  435. archived log file name=+FRA/orcl/archivelog/2018_03_29/thread_1_seq_29.270.972079239 thread=1 sequence=29
  436. archived log file name=+FRA/orcl/archivelog/2018_03_29/thread_1_seq_30.271.972079311 thread=1 sequence=30
  437. archived log file name=+FRA/orcl/archivelog/2018_03_29/thread_1_seq_31.272.972079365 thread=1 sequence=31
  438. archived log file name=+FRA/orcl/archivelog/2018_03_30/thread_1_seq_32.273.972119851 thread=1 sequence=32
  439. archived log file name=+FRA/orcl/archivelog/2018_03_30/thread_1_seq_33.274.972120503 thread=1 sequence=33
  440. archived log file name=+FRA/orcl/archivelog/2018_03_30/thread_1_seq_34.275.972126049 thread=1 sequence=34
  441. archived log file name=+FRA/orcl/archivelog/2018_03_30/thread_1_seq_35.276.972134249 thread=1 sequence=35
  442. archived log file name=+FRA/orcl/archivelog/2018_03_30/thread_1_seq_36.277.972142677 thread=1 sequence=36
  443. archived log file name=+FRA/orcl/archivelog/2018_03_30/thread_1_seq_37.278.972161139 thread=1 sequence=37
  444. archived log file name=+FRA/orcl/archivelog/2018_03_30/thread_1_seq_38.279.972162905 thread=1 sequence=38
  445. archived log file name=+FRA/orcl/archivelog/2018_03_30/thread_1_seq_39.280.972165649 thread=1 sequence=39
  446. archived log file name=+FRA/orcl/archivelog/2018_03_30/thread_1_seq_40.281.972166117 thread=1 sequence=40
  447. archived log file name=+FRA/orcl/archivelog/2018_03_31/thread_1_seq_41.282.972206295 thread=1 sequence=41
  448. archived log file name=+FRA/orcl/archivelog/2018_03_31/thread_1_seq_42.283.972208237 thread=1 sequence=42
  449. archived log file name=+FRA/orcl/archivelog/2018_03_31/thread_1_seq_43.284.972212455 thread=1 sequence=43
  450. archived log file name=+FRA/orcl/archivelog/2018_03_31/thread_1_seq_44.285.972224729 thread=1 sequence=44
  451. archived log file name=+FRA/orcl/archivelog/2018_03_31/thread_1_seq_45.286.972231635 thread=1 sequence=45
  452. archived log file name=+FRA/orcl/archivelog/2018_03_31/thread_1_seq_46.287.972237931 thread=1 sequence=46
  453. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_47.288.972292287 thread=1 sequence=47
  454. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_48.289.972292375 thread=1 sequence=48
  455. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_49.290.972292459 thread=1 sequence=49
  456. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_50.291.972293883 thread=1 sequence=50
  457. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_51.292.972293981 thread=1 sequence=51
  458. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_52.293.972294939 thread=1 sequence=52
  459. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_53.295.972298807 thread=1 sequence=53
  460. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_54.297.972306021 thread=1 sequence=54
  461. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_55.299.972307191 thread=1 sequence=55
  462. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_56.301.972309643 thread=1 sequence=56
  463. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_57.302.972313083 thread=1 sequence=57
  464. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_58.303.972313083 thread=1 sequence=58
  465. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_59.304.972313093 thread=1 sequence=59
  466. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_1.318.972317853 thread=1 sequence=1
  467. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_2.319.972317855 thread=1 sequence=2
  468. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_3.320.972317859 thread=1 sequence=3
  469. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_4.321.972317859 thread=1 sequence=4
  470. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_5.322.972317861 thread=1 sequence=5
  471. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_6.323.972317861 thread=1 sequence=6
  472. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_7.324.972317863 thread=1 sequence=7
  473. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_8.325.972317863 thread=1 sequence=8
  474. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_9.326.972317865 thread=1 sequence=9
  475. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_10.327.972317865 thread=1 sequence=10
  476. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_11.328.972317865 thread=1 sequence=11
  477. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_12.329.972317865 thread=1 sequence=12
  478. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_13.330.972317867 thread=1 sequence=13
  479. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_14.331.972317871 thread=1 sequence=14
  480. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_15.332.972317873 thread=1 sequence=15
  481. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_16.333.972317873 thread=1 sequence=16
  482. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_17.334.972317875 thread=1 sequence=17
  483. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_18.335.972317875 thread=1 sequence=18
  484. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_19.336.972317877 thread=1 sequence=19
  485. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_20.337.972317879 thread=1 sequence=20
  486. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_21.338.972317879 thread=1 sequence=21
  487. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_22.339.972317879 thread=1 sequence=22
  488. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_23.340.972317881 thread=1 sequence=23
  489. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_24.341.972317883 thread=1 sequence=24
  490. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_25.342.972317885 thread=1 sequence=25
  491. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_26.343.972317885 thread=1 sequence=26
  492. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_27.344.972317889 thread=1 sequence=27
  493. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_28.345.972317889 thread=1 sequence=28
  494. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_29.346.972317895 thread=1 sequence=29
  495. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_30.347.972317895 thread=1 sequence=30
  496. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_31.348.972317897 thread=1 sequence=31
  497. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_32.349.972317901 thread=1 sequence=32
  498. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_33.350.972317901 thread=1 sequence=33
  499. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_34.351.972317903 thread=1 sequence=34
  500. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_35.352.972317903 thread=1 sequence=35
  501. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_36.353.972317905 thread=1 sequence=36
  502. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_37.354.972317907 thread=1 sequence=37
  503. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_38.355.972317909 thread=1 sequence=38
  504. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_39.356.972317913 thread=1 sequence=39
  505. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_40.357.972317915 thread=1 sequence=40
  506. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_41.358.972317915 thread=1 sequence=41
  507. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_42.359.972317917 thread=1 sequence=42
  508. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_43.360.972317919 thread=1 sequence=43
  509. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_44.361.972318087 thread=1 sequence=44
  510. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_45.362.972318089 thread=1 sequence=45
  511. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_46.363.972318099 thread=1 sequence=46
  512. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_47.364.972318103 thread=1 sequence=47
  513. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_48.369.972319355 thread=1 sequence=48
  514. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_1.374.972321509 thread=1 sequence=1
  515. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_2.375.972321511 thread=1 sequence=2
  516. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_3.376.972321513 thread=1 sequence=3
  517. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_4.377.972321515 thread=1 sequence=4
  518. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_5.378.972321519 thread=1 sequence=5
  519. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_6.379.972321519 thread=1 sequence=6
  520. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_7.380.972321521 thread=1 sequence=7
  521. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_8.381.972321523 thread=1 sequence=8
  522. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_9.382.972321525 thread=1 sequence=9
  523. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_10.383.972321527 thread=1 sequence=10
  524. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_11.384.972321529 thread=1 sequence=11
  525. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_12.385.972321531 thread=1 sequence=12
  526. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_13.386.972321535 thread=1 sequence=13
  527. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_14.387.972321537 thread=1 sequence=14
  528. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_15.388.972321815 thread=1 sequence=15
  529. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_16.389.972321817 thread=1 sequence=16
  530. archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_17.391.972321827 thread=1 sequence=17
  531. media recovery complete, elapsed time: 00:00:22
  532. Finished recover at 02-APR-18

  534. RMAN> alter database open resetlogs;

  536. RMAN-00571: ===========================================================
  537. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  538. RMAN-00571: ===========================================================
  539. RMAN-03002: failure of alter db command at 04/02/2018 19:57:28
  540. ORA-01139: RESETLOGS option only valid after an incomplete database recovery

  542. RMAN> exit


  545. Recovery Manager complete.
  546. [oracle@station90 ~]$ sqlplus /nolog

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

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

  552. SQL> conn / as sysdba
  553. Connected.
  554. SQL> alter database open ;

  556. Database altered.

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

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

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

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

  570. RMAN> list incarnation of database;

  572. using target database control file instead of recovery catalog

  574. List of Database Incarnations
  575. DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
  576. ------- ------- -------- ---------------- --- ---------- ----------
  577. 1       1       ORCL     1343950367       PARENT  1          15-AUG-09
  578. 2       2       ORCL     1343950367       PARENT  945184     23-MAY-13
  579. 3       3       ORCL     1343950367       ORPHAN  1451975    01-APR-18
  580. 4       4       ORCL     1343950367       PARENT  1451975    01-APR-18
  581. 5       5       ORCL     1343950367       ORPHAN  1456352    01-APR-18
  582. 6       6       ORCL     1343950367       PARENT  1456361    01-APR-18
  583. 7       7       ORCL     1343950367       ORPHAN  1464173    01-APR-18
  584. 8       8       ORCL     1343950367       CURRENT 1464173    02-APR-18

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

  3. create restore point rsp1 ;

  5. create restore point rsp2 as of scn 1000000;



  9. create restore point rsp3
  10. guarantee flashback database;

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


回复

使用道具 举报

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

本版积分规则

QQ|手机版|Bo's Oracle Station   

GMT+8, 2024-4-20 03:11 , Processed in 0.037614 second(s), 24 queries .

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