开启辅助访问

Bo's Oracle Station

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

课程第28次（2017-09-07星期四）

[复制链接]
botang

1005

主题

1469

帖子

1万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
12012
发表于 2017-9-7 20:56:24 | 显示全部楼层 |阅读模式
Screenshot.png

Screenshot-1.png

注意Oracle的controlfile trace脚本的set2有问题，要加上until cancel：
  1. SQL> conn / as sysdba
  2. Connected.
  3. SQL> recover database using BACKUP CONTROLFILE;
  4. ORA-00279: change 1110115 generated at 09/07/2017 19:44:40 needed for thread 1
  5. ORA-00289: suggestion :
  6. +FRA/orcl/archivelog/2017_09_07/thread_1_seq_33.257.954103659
  7. ORA-00280: change 1110115 for thread 1 is in sequence #33


  10. Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

  12. ORA-00279: change 1110141 generated at 09/07/2017 19:45:05 needed for thread 1
  13. ORA-00289: suggestion :
  14. +FRA/orcl/archivelog/2017_09_07/thread_1_seq_34.275.954100231
  15. ORA-00280: change 1110141 for thread 1 is in sequence #34
  16. ORA-00278: log file
  17. '+FRA/orcl/archivelog/2017_09_07/thread_1_seq_33.257.954103659' no longer
  18. needed for this recovery


  21. Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

  23. ORA-00279: change 1111189 generated at 09/07/2017 19:50:30 needed for thread 1
  24. ORA-00289: suggestion :
  25. +FRA/orcl/archivelog/2017_09_07/thread_1_seq_35.273.954100231
  26. ORA-00280: change 1111189 for thread 1 is in sequence #35
  27. ORA-00278: log file
  28. '+FRA/orcl/archivelog/2017_09_07/thread_1_seq_34.275.954100231' no longer
  29. needed for this recovery


  32. Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

  34. ORA-00279: change 1111206 generated at 09/07/2017 19:50:31 needed for thread 1
  35. ORA-00289: suggestion :
  36. +FRA/orcl/archivelog/2017_09_07/thread_1_seq_36.272.954100233
  37. ORA-00280: change 1111206 for thread 1 is in sequence #36
  38. ORA-00278: log file
  39. '+FRA/orcl/archivelog/2017_09_07/thread_1_seq_35.273.954100231' no longer
  40. needed for this recovery


  43. Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

  45. ORA-00279: change 1111211 generated at 09/07/2017 19:50:32 needed for thread 1
  46. ORA-00289: suggestion :
  47. +FRA/orcl/archivelog/2017_09_07/thread_1_seq_37.271.954100235
  48. ORA-00280: change 1111211 for thread 1 is in sequence #37
  49. ORA-00278: log file
  50. '+FRA/orcl/archivelog/2017_09_07/thread_1_seq_36.272.954100233' no longer
  51. needed for this recovery


  54. Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

  56. ORA-00279: change 1111214 generated at 09/07/2017 19:50:34 needed for thread 1
  57. ORA-00289: suggestion :
  58. +FRA/orcl/archivelog/2017_09_07/thread_1_seq_38.265.954100237
  59. ORA-00280: change 1111214 for thread 1 is in sequence #38
  60. ORA-00278: log file
  61. '+FRA/orcl/archivelog/2017_09_07/thread_1_seq_37.271.954100235' no longer
  62. needed for this recovery


  65. Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

  67. ORA-00279: change 1111220 generated at 09/07/2017 19:50:35 needed for thread 1
  68. ORA-00289: suggestion :
  69. +FRA/orcl/archivelog/2017_09_07/thread_1_seq_39.264.954100237
  70. ORA-00280: change 1111220 for thread 1 is in sequence #39
  71. ORA-00278: log file
  72. '+FRA/orcl/archivelog/2017_09_07/thread_1_seq_38.265.954100237' no longer
  73. needed for this recovery


  76. Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

  78. ORA-00279: change 1111226 generated at 09/07/2017 20:10:31 needed for thread 1
  79. ORA-00289: suggestion :
  80. +FRA/orcl/archivelog/2017_09_07/thread_1_seq_1.261.954102861
  81. ORA-00280: change 1111226 for thread 1 is in sequence #1
  82. ORA-00278: log file
  83. '+FRA/orcl/archivelog/2017_09_07/thread_1_seq_39.264.954100237' no longer
  84. needed for this recovery


  87. Specify log: {<RET>=suggested | filename | AUTO | CANCEL}


  90. ORA-00279: change 1114750 generated at 09/07/2017 20:34:20 needed for thread 1
  91. ORA-00289: suggestion :
  92. +FRA/orcl/archivelog/2017_09_07/thread_1_seq_2.262.954102861
  93. ORA-00280: change 1114750 for thread 1 is in sequence #2
  94. ORA-00278: log file
  95. '+FRA/orcl/archivelog/2017_09_07/thread_1_seq_1.261.954102861' no longer needed
  96. for this recovery


  99. Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
  100. ORA-00279: change 1114767 generated at 09/07/2017 20:34:21 needed for thread 1
  101. ORA-00289: suggestion :
  102. +FRA/orcl/archivelog/2017_09_07/thread_1_seq_3.276.954102863
  103. ORA-00280: change 1114767 for thread 1 is in sequence #3
  104. ORA-00278: log file
  105. '+FRA/orcl/archivelog/2017_09_07/thread_1_seq_2.262.954102861' no longer needed
  106. for this recovery


  109. Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

  111. ORA-00279: change 1114772 generated at 09/07/2017 20:34:21 needed for thread 1
  112. ORA-00289: suggestion :
  113. +FRA/orcl/archivelog/2017_09_07/thread_1_seq_4.277.954102865
  114. ORA-00280: change 1114772 for thread 1 is in sequence #4
  115. ORA-00278: log file
  116. '+FRA/orcl/archivelog/2017_09_07/thread_1_seq_3.276.954102863' no longer needed
  117. for this recovery


  120. Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

  122. ORA-00279: change 1114775 generated at 09/07/2017 20:34:23 needed for thread 1
  123. ORA-00289: suggestion :
  124. +FRA/orcl/archivelog/2017_09_07/thread_1_seq_5.278.954102865
  125. ORA-00280: change 1114775 for thread 1 is in sequence #5
  126. ORA-00278: log file
  127. '+FRA/orcl/archivelog/2017_09_07/thread_1_seq_4.277.954102865' no longer needed
  128. for this recovery


  131. Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

  133. ORA-00279: change 1114781 generated at 09/07/2017 20:34:24 needed for thread 1
  134. ORA-00289: suggestion :
  135. +FRA/orcl/archivelog/2017_09_07/thread_1_seq_6.279.954102867
  136. ORA-00280: change 1114781 for thread 1 is in sequence #6
  137. ORA-00278: log file
  138. '+FRA/orcl/archivelog/2017_09_07/thread_1_seq_5.278.954102865' no longer needed
  139. for this recovery


  142. Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

  144. ORA-00279: change 1114792 generated at 09/07/2017 20:34:26 needed for thread 1
  145. ORA-00289: suggestion : +FRA
  146. ORA-00280: change 1114792 for thread 1 is in sequence #7
  147. ORA-00278: log file
  148. '+FRA/orcl/archivelog/2017_09_07/thread_1_seq_6.279.954102867' no longer needed
  149. for this recovery


  152. Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

  154. ORA-00308: cannot open archived log '+FRA'
  155. ORA-17503: ksfdopn:2 Failed to open file +FRA
  156. ORA-15045: ASM file name '+FRA' is not in reference form


  159. SQL> recover database using BACKUP CONTROLFILE;
  160. ORA-00279: change 1114792 generated at 09/07/2017 20:34:26 needed for thread 1
  161. ORA-00289: suggestion : +FRA
  162. ORA-00280: change 1114792 for thread 1 is in sequence #7


  165. Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
  166. cancel
  167. Media recovery cancelled.
  168. SQL> alter database open ;
  169. alter database open
  170. *
  171. ERROR at line 1:
  172. ORA-01589: must use RESETLOGS or NORESETLOGS option for database open


  175. SQL> alter database open  resetlogs;
  176. alter database open  resetlogs
  177. *
  178. ERROR at line 1:
  179. ORA-01113: file 1 needs media recovery
  180. ORA-01110: data file 1: '+DATA/orcl/datafile/system.256.816169553'


  183. SQL> recover database until cancel using BACKUP CONTROLFILE;
  184. ORA-00279: change 1114792 generated at 09/07/2017 20:34:26 needed for thread 1
  185. ORA-00289: suggestion : +FRA
  186. ORA-00280: change 1114792 for thread 1 is in sequence #7


  189. Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
  190. cancel
  191. Media recovery cancelled.
  192. SQL> alter database open resetlogs;

  194. Database altered.

  196. SQL>

复制代码
Screenshot.png

  1. [oracle@station90 ~]$ vim control10d-after.sql
  2. [oracle@station90 ~]$ sqlplus /nolog

  4. SQL*Plus: Release 11.2.0.1.0 Production on Thu Sep 7 19:28:08 2017

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

  8. SQL> conn / as sysdba
  9. Connected to an idle instance.
  10. SQL> startup
  11. ORACLE instance started.

  13. Total System Global Area 6680915968 bytes
  14. Fixed Size                    2213936 bytes
  15. Variable Size                 3556771792 bytes
  16. Database Buffers         3087007744 bytes
  17. Redo Buffers                   34922496 bytes
  18. ORA-00205: error in identifying control file, check alert log for more info


  21. SQL> @control10d-after.sql

  23. Control file created.


  26. PL/SQL procedure successfully completed.


  29. PL/SQL procedure successfully completed.


  32. PL/SQL procedure successfully completed.


  35. PL/SQL procedure successfully completed.


  38. PL/SQL procedure successfully completed.


  41. PL/SQL procedure successfully completed.


  44. PL/SQL procedure successfully completed.


  47. PL/SQL procedure successfully completed.

  49. SQL> alter database open ;
  50. alter database open
  51. *
  52. ERROR at line 1:
  53. ORA-01113: file 1 needs media recovery
  54. ORA-01110: data file 1: '+DATA/orcl/datafile/system.256.816169553'


  57. SQL> recover database;
  58. Media recovery complete.
  59. SQL> alter database open ;

  61. Database altered.

  63. SQL> select  name fromv$tempfile;
  64. select        name fromv$tempfile
  65.                           *
  66. ERROR at line 1:
  67. ORA-00923: FROM keyword not found where expected


  70. SQL> select  name from v$tempfile;

  72. no rows selected

  74. SQL> select  file_name from dba_temp_files;

  76. no rows selected

  78. SQL> alter tablespace temp add tempfile '+Data' size 30M autoextend on ;

  80. Tablespace altered.

  82. SQL> exit
  83. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
  84. With the Partitioning, OLAP, Data Mining and Real Application Testing options
  85. [oracle@station90 ~]$ rman target /

  87. Recovery Manager: Release 11.2.0.1.0 - Production on Thu Sep 7 19:40:33 2017

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

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

  93. RMAN> exit


  96. Recovery Manager complete.
  97. [oracle@station90 ~]$ rman target /  catalog u90/oracle_4U@rcat

  99. Recovery Manager: Release 11.2.0.1.0 - Production on Thu Sep 7 19:41:06 2017

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

  103. connected to target database: ORCL (DBID=1343950367)
  104. connected to recovery catalog database

  106. RMAN> backup tag 'NEWBACKUP' incremental level 0  database plus archivelog delete all input;

  108. starting full resync of recovery catalog
  109. full resync complete

  111. Starting backup at 07-SEP-17
  112. current log archived
  113. allocated channel: ORA_SBT_TAPE_1
  114. channel ORA_SBT_TAPE_1: SID=9 device type=SBT_TAPE
  115. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  116. allocated channel: ORA_SBT_TAPE_2
  117. channel ORA_SBT_TAPE_2: SID=71 device type=SBT_TAPE
  118. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  119. channel ORA_SBT_TAPE_1: starting archived log backup set
  120. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
  121. input archived log thread=1 sequence=20 RECID=5 STAMP=954099825
  122. input archived log thread=1 sequence=21 RECID=6 STAMP=954099826
  123. input archived log thread=1 sequence=22 RECID=7 STAMP=954099826
  124. channel ORA_SBT_TAPE_1: starting piece 1 at 07-SEP-17
  125. channel ORA_SBT_TAPE_2: starting archived log backup set
  126. channel ORA_SBT_TAPE_2: specifying archived log(s) in backup set
  127. input archived log thread=1 sequence=23 RECID=8 STAMP=954099826
  128. input archived log thread=1 sequence=24 RECID=9 STAMP=954099826
  129. input archived log thread=1 sequence=29 RECID=1 STAMP=954098976
  130. input archived log thread=1 sequence=30 RECID=2 STAMP=954098976
  131. input archived log thread=1 sequence=31 RECID=3 STAMP=954098977
  132. channel ORA_SBT_TAPE_2: starting piece 1 at 07-SEP-17
  133. channel ORA_SBT_TAPE_1: finished piece 1 at 07-SEP-17
  134. piece handle=02sdsq3i_1_1 tag=NEWBACKUP comment=API Version 2.0,MMS Version 10.4.0.4
  135. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
  136. channel ORA_SBT_TAPE_1: deleting archived log(s)
  137. archived log file name=+FRA/orcl/archivelog/2017_09_07/thread_1_seq_20.262.954073551 RECID=5 STAMP=954099825
  138. archived log file name=+FRA/orcl/archivelog/2017_09_07/thread_1_seq_21.261.954073587 RECID=6 STAMP=954099826
  139. archived log file name=+FRA/orcl/archivelog/2017_09_07/thread_1_seq_22.263.954079971 RECID=7 STAMP=954099826
  140. channel ORA_SBT_TAPE_1: starting archived log backup set
  141. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
  142. input archived log thread=1 sequence=32 RECID=4 STAMP=954099812
  143. channel ORA_SBT_TAPE_1: starting piece 1 at 07-SEP-17
  144. channel ORA_SBT_TAPE_2: finished piece 1 at 07-SEP-17
  145. piece handle=03sdsq3i_1_1 tag=NEWBACKUP comment=API Version 2.0,MMS Version 10.4.0.4
  146. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:26
  147. channel ORA_SBT_TAPE_2: deleting archived log(s)
  148. archived log file name=+FRA/orcl/archivelog/2017_09_07/thread_1_seq_23.264.954088595 RECID=8 STAMP=954099826
  149. archived log file name=+FRA/orcl/archivelog/2017_09_07/thread_1_seq_24.265.954097927 RECID=9 STAMP=954099826
  150. archived log file name=+FRA/orcl/archivelog/2017_09_07/thread_1_seq_29.271.954098977 RECID=1 STAMP=954098976
  151. archived log file name=+FRA/orcl/archivelog/2017_09_07/thread_1_seq_30.272.954098977 RECID=2 STAMP=954098976
  152. archived log file name=+FRA/orcl/archivelog/2017_09_07/thread_1_seq_31.273.954098977 RECID=3 STAMP=954098977
  153. channel ORA_SBT_TAPE_1: finished piece 1 at 07-SEP-17
  154. piece handle=04sdsq4b_1_1 tag=NEWBACKUP comment=API Version 2.0,MMS Version 10.4.0.4
  155. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
  156. channel ORA_SBT_TAPE_1: deleting archived log(s)
  157. archived log file name=+FRA/orcl/archivelog/2017_09_07/thread_1_seq_32.275.954099813 RECID=4 STAMP=954099812
  158. Finished backup at 07-SEP-17

  160. Starting backup at 07-SEP-17
  161. using channel ORA_SBT_TAPE_1
  162. using channel ORA_SBT_TAPE_2
  163. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
  164. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  165. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.816169553
  166. input datafile file number=00005 name=+DATA/orcl/datafile/example.265.816169651
  167. channel ORA_SBT_TAPE_1: starting piece 1 at 07-SEP-17
  168. channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
  169. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
  170. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.816169553
  171. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.816169553
  172. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.816169553
  173. channel ORA_SBT_TAPE_2: starting piece 1 at 07-SEP-17
  174. channel ORA_SBT_TAPE_1: finished piece 1 at 07-SEP-17
  175. piece handle=05sdsq57_1_1 tag=NEWBACKUP comment=API Version 2.0,MMS Version 10.4.0.4
  176. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
  177. channel ORA_SBT_TAPE_2: finished piece 1 at 07-SEP-17
  178. piece handle=06sdsq58_1_1 tag=NEWBACKUP comment=API Version 2.0,MMS Version 10.4.0.4
  179. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:25
  180. Finished backup at 07-SEP-17

  182. Starting backup at 07-SEP-17
  183. current log archived
  184. using channel ORA_SBT_TAPE_1
  185. using channel ORA_SBT_TAPE_2
  186. channel ORA_SBT_TAPE_1: starting archived log backup set
  187. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
  188. input archived log thread=1 sequence=33 RECID=10 STAMP=954099905
  189. channel ORA_SBT_TAPE_1: starting piece 1 at 07-SEP-17
  190. channel ORA_SBT_TAPE_1: finished piece 1 at 07-SEP-17
  191. piece handle=07sdsq63_1_1 tag=NEWBACKUP comment=API Version 2.0,MMS Version 10.4.0.4
  192. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
  193. channel ORA_SBT_TAPE_1: deleting archived log(s)
  194. archived log file name=+FRA/orcl/archivelog/2017_09_07/thread_1_seq_33.275.954099905 RECID=10 STAMP=954099905
  195. Finished backup at 07-SEP-17

  197. Starting Control File and SPFILE Autobackup at 07-SEP-17
  198. piece handle=c-1343950367-20170907-01 comment=API Version 2.0,MMS Version 10.4.0.4
  199. Finished Control File and SPFILE Autobackup at 07-SEP-17

  201. RMAN> exit

  203. RMAN-06900: WARNING: unable to generate V$RMAN_STATUS or V$RMAN_OUTPUT row
  204. RMAN-06901: WARNING: disabling update of the V$RMAN_STATUS and V$RMAN_OUTPUT rows
  205. ORACLE error from target database:
  206. ORA-03135: connection lost contact
  207. Process ID: 21348
  208. Session ID: 75 Serial number: 308


  211. Recovery Manager complete.
  212. [oracle@station90 ~]$ rman target /

  214. Recovery Manager: Release 11.2.0.1.0 - Production on Thu Sep 7 19:55:51 2017

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

  218. connected to target database (not started)

  220. RMAN> startup

  222. Oracle instance started
  223. RMAN-00571: ===========================================================
  224. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  225. RMAN-00571: ===========================================================
  226. RMAN-03002: failure of startup command at 09/07/2017 19:55:58
  227. ORA-00205: error in identifying control file, check alert log for more info

  229. RMAN> list backup of controlfile;

  231. using target database control file instead of recovery catalog
  232. RMAN-00571: ===========================================================
  233. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  234. RMAN-00571: ===========================================================
  235. RMAN-03002: failure of list command at 09/07/2017 19:56:23
  236. ORA-01507: database not mounted

  238. RMAN> exit


  241. Recovery Manager complete.
  242. [oracle@station90 ~]$ rman target / catalog u90/oracle_4U@rcat

  244. Recovery Manager: Release 11.2.0.1.0 - Production on Thu Sep 7 19:56:49 2017

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

  248. connected to target database: ORCL (not mounted)
  249. connected to recovery catalog database

  251. RMAN> list backup of controlfile;


  254. List of Backup Sets
  255. ===================


  258. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  259. ------- ---- -- ---------- ----------- ------------ ---------------
  260. 195     Full    9.67M      DISK        00:00:00     07-SEP-17      
  261.         BP Key: 196   Status: AVAILABLE  Compressed: NO  Tag: TAG20170907T193823
  262.         Piece Name: +FRA/orcl/autobackup/2017_09_07/s_954099503.274.954099503
  263.   Control File Included: Ckp SCN: 1109658      Ckp time: 07-SEP-17

  265. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  266. ------- ---- -- ---------- ----------- ------------ ---------------
  267. 254     Full    9.75M      SBT_TAPE    00:00:16     07-SEP-17      
  268.         BP Key: 256   Status: AVAILABLE  Compressed: NO  Tag: TAG20170907T194534
  269.         Handle: c-1343950367-20170907-01   Media: station90-000003
  270.   Control File Included: Ckp SCN: 1110190      Ckp time: 07-SEP-17

  272. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  273. ------- ---- -- ---------- ----------- ------------ ---------------
  274. 287     Full    9.75M      SBT_TAPE    00:00:16     07-SEP-17      
  275.         BP Key: 291   Status: AVAILABLE  Compressed: NO  Tag: LABS-11A-CONTROLFILE
  276.         Handle: 09sdsqgp_1_1   Media: station90-000001
  277.   Control File Included: Ckp SCN: 1111253      Ckp time: 07-SEP-17

  279. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  280. ------- ---- -- ---------- ----------- ------------ ---------------
  281. 288     Full    9.75M      SBT_TAPE    00:00:15     07-SEP-17      
  282.         BP Key: 292   Status: AVAILABLE  Compressed: NO  Tag: TAG20170907T195115
  283.         Handle: c-1343950367-20170907-02   Media: station90-000001
  284.   Control File Included: Ckp SCN: 1111296      Ckp time: 07-SEP-17

  286. RMAN> restore controlfile from tag 'LABS-11A-CONTROLFILE';

  288. Starting restore at 07-SEP-17
  289. allocated channel: ORA_DISK_1
  290. channel ORA_DISK_1: SID=68 device type=DISK
  291. allocated channel: ORA_DISK_2
  292. channel ORA_DISK_2: SID=131 device type=DISK
  293. allocated channel: ORA_DISK_3
  294. channel ORA_DISK_3: SID=192 device type=DISK
  295. allocated channel: ORA_DISK_4
  296. channel ORA_DISK_4: SID=8 device type=DISK
  297. allocated channel: ORA_DISK_5
  298. channel ORA_DISK_5: SID=69 device type=DISK
  299. allocated channel: ORA_DISK_6
  300. channel ORA_DISK_6: SID=132 device type=DISK
  301. allocated channel: ORA_DISK_7
  302. channel ORA_DISK_7: SID=193 device type=DISK
  303. allocated channel: ORA_DISK_8
  304. channel ORA_DISK_8: SID=9 device type=DISK
  305. allocated channel: ORA_SBT_TAPE_1
  306. channel ORA_SBT_TAPE_1: SID=70 device type=SBT_TAPE
  307. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  308. allocated channel: ORA_SBT_TAPE_2
  309. channel ORA_SBT_TAPE_2: SID=194 device type=SBT_TAPE
  310. channel ORA_SBT_TAPE_2: Oracle Secure Backup

  312. channel ORA_SBT_TAPE_1: starting datafile backup set restore
  313. channel ORA_SBT_TAPE_1: restoring control file
  314. channel ORA_SBT_TAPE_1: reading from backup piece 09sdsqgp_1_1
  315. channel ORA_SBT_TAPE_1: piece handle=09sdsqgp_1_1 tag=LABS-11A-CONTROLFILE
  316. channel ORA_SBT_TAPE_1: restored backup piece 1
  317. channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:35
  318. output file name=+DATA/orcl/controlfile/current.263.954100675
  319. output file name=+FRA/orcl/controlfile/current.259.954100681
  320. Finished restore at 07-SEP-17

  322. RMAN> alter database mount;

  324. database mounted
  325. released channel: ORA_DISK_1
  326. released channel: ORA_DISK_2
  327. released channel: ORA_DISK_3
  328. released channel: ORA_DISK_4
  329. released channel: ORA_DISK_5
  330. released channel: ORA_DISK_6
  331. released channel: ORA_DISK_7
  332. released channel: ORA_DISK_8
  333. released channel: ORA_SBT_TAPE_1
  334. released channel: ORA_SBT_TAPE_2

  336. RMAN> recover database ;

  338. Starting recover at 07-SEP-17
  339. Starting implicit crosscheck backup at 07-SEP-17
  340. allocated channel: ORA_DISK_1
  341. channel ORA_DISK_1: SID=130 device type=DISK
  342. allocated channel: ORA_DISK_2
  343. channel ORA_DISK_2: SID=70 device type=DISK
  344. allocated channel: ORA_DISK_3
  345. channel ORA_DISK_3: SID=133 device type=DISK
  346. allocated channel: ORA_DISK_4
  347. channel ORA_DISK_4: SID=194 device type=DISK
  348. allocated channel: ORA_DISK_5
  349. channel ORA_DISK_5: SID=10 device type=DISK
  350. allocated channel: ORA_DISK_6
  351. channel ORA_DISK_6: SID=69 device type=DISK
  352. allocated channel: ORA_DISK_7
  353. channel ORA_DISK_7: SID=132 device type=DISK
  354. allocated channel: ORA_DISK_8
  355. channel ORA_DISK_8: SID=193 device type=DISK
  356. Crosschecked 1 objects
  357. Finished implicit crosscheck backup at 07-SEP-17

  359. Starting implicit crosscheck copy at 07-SEP-17
  360. using channel ORA_DISK_1
  361. using channel ORA_DISK_2
  362. using channel ORA_DISK_3
  363. using channel ORA_DISK_4
  364. using channel ORA_DISK_5
  365. using channel ORA_DISK_6
  366. using channel ORA_DISK_7
  367. using channel ORA_DISK_8
  368. Finished implicit crosscheck copy at 07-SEP-17

  370. searching for all files in the recovery area
  371. cataloging files...
  372. cataloging done

  374. List of Cataloged Files
  375. =======================
  376. File Name: +fra/ORCL/ARCHIVELOG/2017_09_07/thread_1_seq_25.266.954098709
  377. File Name: +fra/ORCL/ARCHIVELOG/2017_09_07/thread_1_seq_26.267.954098709
  378. File Name: +fra/ORCL/ARCHIVELOG/2017_09_07/thread_1_seq_27.268.954098711
  379. File Name: +fra/ORCL/ARCHIVELOG/2017_09_07/thread_1_seq_28.269.954098711
  380. File Name: +fra/ORCL/ARCHIVELOG/2017_09_07/thread_1_seq_29.270.954098713

  382. using channel ORA_DISK_1
  383. using channel ORA_DISK_2
  384. using channel ORA_DISK_3
  385. using channel ORA_DISK_4
  386. using channel ORA_DISK_5
  387. using channel ORA_DISK_6
  388. using channel ORA_DISK_7
  389. using channel ORA_DISK_8
  390. allocated channel: ORA_SBT_TAPE_1
  391. channel ORA_SBT_TAPE_1: SID=131 device type=SBT_TAPE
  392. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  393. allocated channel: ORA_SBT_TAPE_2
  394. channel ORA_SBT_TAPE_2: SID=8 device type=SBT_TAPE
  395. channel ORA_SBT_TAPE_2: Oracle Secure Backup

  397. starting media recovery

  399. archived log for thread 1 with sequence 38 is already on disk as file +FRA/orcl/archivelog/2017_09_07/thread_1_seq_38.265.954100237
  400. archived log for thread 1 with sequence 39 is already on disk as file +FRA/orcl/archivelog/2017_09_07/thread_1_seq_39.264.954100237
  401. archived log file name=+FRA/orcl/archivelog/2017_09_07/thread_1_seq_38.265.954100237 thread=1 sequence=38
  402. archived log file name=+FRA/orcl/archivelog/2017_09_07/thread_1_seq_39.264.954100237 thread=1 sequence=39
  403. unable to find archived log
  404. archived log thread=1 sequence=40
  405. RMAN-00571: ===========================================================
  406. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  407. RMAN-00571: ===========================================================
  408. RMAN-03002: failure of recover command at 09/07/2017 20:05:00
  409. RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 40 and starting SCN of 1111225

  411. RMAN> run {
  412. 2> set until sequence 40 thread 1;
  413. 3> restore database;
  414. 4> recover database;
  415. 5> }

  417. executing command: SET until clause

  419. Starting restore at 07-SEP-17
  420. using channel ORA_DISK_1
  421. using channel ORA_DISK_2
  422. using channel ORA_DISK_3
  423. using channel ORA_DISK_4
  424. using channel ORA_DISK_5
  425. using channel ORA_DISK_6
  426. using channel ORA_DISK_7
  427. using channel ORA_DISK_8
  428. using channel ORA_SBT_TAPE_1
  429. using channel ORA_SBT_TAPE_2

  431. channel ORA_SBT_TAPE_1: starting datafile backup set restore
  432. channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
  433. channel ORA_SBT_TAPE_1: restoring datafile 00001 to +DATA/orcl/datafile/system.256.816169553
  434. channel ORA_SBT_TAPE_1: restoring datafile 00005 to +DATA/orcl/datafile/example.265.816169651
  435. channel ORA_SBT_TAPE_1: reading from backup piece 05sdsq57_1_1
  436. channel ORA_SBT_TAPE_2: starting datafile backup set restore
  437. channel ORA_SBT_TAPE_2: specifying datafile(s) to restore from backup set
  438. channel ORA_SBT_TAPE_2: restoring datafile 00002 to +DATA/orcl/datafile/sysaux.257.816169553
  439. channel ORA_SBT_TAPE_2: restoring datafile 00003 to +DATA/orcl/datafile/undotbs1.258.816169553
  440. channel ORA_SBT_TAPE_2: restoring datafile 00004 to +DATA/orcl/datafile/users.259.816169553
  441. channel ORA_SBT_TAPE_2: reading from backup piece 06sdsq58_1_1
  442. channel ORA_SBT_TAPE_1: piece handle=05sdsq57_1_1 tag=NEWBACKUP
  443. channel ORA_SBT_TAPE_1: restored backup piece 1
  444. channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:45
  445. channel ORA_SBT_TAPE_2: piece handle=06sdsq58_1_1 tag=NEWBACKUP
  446. channel ORA_SBT_TAPE_2: restored backup piece 1
  447. channel ORA_SBT_TAPE_2: restore complete, elapsed time: 00:00:45
  448. Finished restore at 07-SEP-17

  450. Starting recover at 07-SEP-17
  451. using channel ORA_DISK_1
  452. using channel ORA_DISK_2
  453. using channel ORA_DISK_3
  454. using channel ORA_DISK_4
  455. using channel ORA_DISK_5
  456. using channel ORA_DISK_6
  457. using channel ORA_DISK_7
  458. using channel ORA_DISK_8
  459. using channel ORA_SBT_TAPE_1
  460. using channel ORA_SBT_TAPE_2

  462. starting media recovery
  463. media recovery failed
  464. RMAN-00571: ===========================================================
  465. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  466. RMAN-00571: ===========================================================
  467. RMAN-03002: failure of recover command at 09/07/2017 20:06:24
  468. RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed
  469. start until cancel using backup controlfile
  470. ORA-00275: media recovery has already been started

  472. RMAN> run {
  473. 2> set until sequence 40 thread 1;
  474. 3>  recover database;
  475. 4> }

  477. executing command: SET until clause

  479. Starting recover at 07-SEP-17
  480. using channel ORA_DISK_1
  481. using channel ORA_DISK_2
  482. using channel ORA_DISK_3
  483. using channel ORA_DISK_4
  484. using channel ORA_DISK_5
  485. using channel ORA_DISK_6
  486. using channel ORA_DISK_7
  487. using channel ORA_DISK_8
  488. using channel ORA_SBT_TAPE_1
  489. using channel ORA_SBT_TAPE_2

  491. starting media recovery
  492. media recovery failed
  493. RMAN-00571: ===========================================================
  494. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  495. RMAN-00571: ===========================================================
  496. RMAN-03002: failure of recover command at 09/07/2017 20:07:05
  497. RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed
  498. start until cancel using backup controlfile
  499. ORA-00275: media recovery has already been started

  501. RMAN> exit


  504. Recovery Manager complete.

  506. [oracle@station90 ~]$ sqlplus /nolog

  508. SQL*Plus: Release 11.2.0.1.0 Production on Thu Sep 7 20:07:26 2017

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

  512. SQL> conn / as sysdba
  513. Connected.
  514. SQL> recover database until cancel ;
  515. ORA-00283: recovery session canceled due to errors
  516. ORA-01610: recovery using the BACKUP CONTROLFILE option must be done


  519. SQL> recover database until cancel   using BACKUP CONTROLFILE ;
  520. ORA-00279: change 1110115 generated at 09/07/2017 19:44:40 needed for thread 1
  521. ORA-00289: suggestion : +FRA
  522. ORA-00280: change 1110115 for thread 1 is in sequence #33


  525. Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

  527. ORA-00308: cannot open archived log '+FRA'
  528. ORA-17503: ksfdopn:2 Failed to open file +FRA
  529. ORA-15045: ASM file name '+FRA' is not in reference form


  532. SQL> exit
  533. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
  534. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
  535. and Real Application Testing options
  536. [oracle@station90 ~]$ crs_stat -t
  537. Name           Type           Target    State     Host        
  538. ------------------------------------------------------------
  539. ora.DATA.dg    ora....up.type ONLINE    ONLINE    station90   
  540. ora.FRA.dg     ora....up.type ONLINE    ONLINE    station90   
  541. ora....ER.lsnr ora....er.type ONLINE    ONLINE    station90   
  542. ora.asm        ora.asm.type   ONLINE    ONLINE    station90   
  543. ora.cssd       ora.cssd.type  ONLINE    ONLINE    station90   
  544. ora.diskmon    ora....on.type ONLINE    ONLINE    station90   
  545. ora.orcl.db    ora....se.type ONLINE    ONLINE    station90   
  546. [oracle@station90 ~]$ sqlplus /nolog

  548. SQL*Plus: Release 11.2.0.1.0 Production on Thu Sep 7 20:08:09 2017

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

  552. SQL> conn / as sysdba
  553. Connected.
  554. SQL> recover database until cancel   using BACKUP CONTROLFILE ;
  555. ORA-00279: change 1110115 generated at 09/07/2017 19:44:40 needed for thread 1
  556. ORA-00289: suggestion : +FRA
  557. ORA-00280: change 1110115 for thread 1 is in sequence #33


  560. Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
  561. quit

  563. SQL> exit
  564. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
  565. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
  566. and Real Application Testing options
  567. [oracle@station90 ~]$ rman target / catalog u90/oracle_4U@rcat

  569. Recovery Manager: Release 11.2.0.1.0 - Production on Thu Sep 7 20:08:57 2017

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

  573. connected to target database: ORCL (DBID=1343950367, not open)
  574. connected to recovery catalog database

  576. RMAN> run {
  577. 2> set until sequence 40 thread 1;
  578. 3> restore database;
  579. 4> }

  581. executing command: SET until clause

  583. Starting restore at 07-SEP-17
  584. allocated channel: ORA_DISK_1
  585. channel ORA_DISK_1: SID=8 device type=DISK
  586. allocated channel: ORA_DISK_2
  587. channel ORA_DISK_2: SID=71 device type=DISK
  588. allocated channel: ORA_DISK_3
  589. channel ORA_DISK_3: SID=133 device type=DISK
  590. allocated channel: ORA_DISK_4
  591. channel ORA_DISK_4: SID=194 device type=DISK
  592. allocated channel: ORA_DISK_5
  593. channel ORA_DISK_5: SID=10 device type=DISK
  594. allocated channel: ORA_DISK_6
  595. channel ORA_DISK_6: SID=70 device type=DISK
  596. allocated channel: ORA_DISK_7
  597. channel ORA_DISK_7: SID=130 device type=DISK
  598. allocated channel: ORA_DISK_8
  599. channel ORA_DISK_8: SID=193 device type=DISK
  600. allocated channel: ORA_SBT_TAPE_1
  601. channel ORA_SBT_TAPE_1: SID=132 device type=SBT_TAPE
  602. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  603. allocated channel: ORA_SBT_TAPE_2
  604. channel ORA_SBT_TAPE_2: SID=7 device type=SBT_TAPE
  605. channel ORA_SBT_TAPE_2: Oracle Secure Backup

  607. skipping datafile 1; already restored to file +DATA/orcl/datafile/system.256.816169553
  608. skipping datafile 5; already restored to file +DATA/orcl/datafile/example.265.816169651
  609. skipping datafile 2; already restored to file +DATA/orcl/datafile/sysaux.257.816169553
  610. skipping datafile 3; already restored to file +DATA/orcl/datafile/undotbs1.258.816169553
  611. skipping datafile 4; already restored to file +DATA/orcl/datafile/users.259.816169553
  612. Finished restore at 07-SEP-17

  614. RMAN> run {
  615. 2> set until sequence 40 thread 1;
  616. 3>  recover database;
  617. 4> }

  619. executing command: SET until clause

  621. Starting recover at 07-SEP-17
  622. using channel ORA_DISK_1
  623. using channel ORA_DISK_2
  624. using channel ORA_DISK_3
  625. using channel ORA_DISK_4
  626. using channel ORA_DISK_5
  627. using channel ORA_DISK_6
  628. using channel ORA_DISK_7
  629. using channel ORA_DISK_8
  630. using channel ORA_SBT_TAPE_1
  631. using channel ORA_SBT_TAPE_2

  633. starting media recovery

  635. archived log for thread 1 with sequence 34 is already on disk as file +FRA/orcl/archivelog/2017_09_07/thread_1_seq_34.275.954100231
  636. archived log for thread 1 with sequence 35 is already on disk as file +FRA/orcl/archivelog/2017_09_07/thread_1_seq_35.273.954100231
  637. archived log for thread 1 with sequence 36 is already on disk as file +FRA/orcl/archivelog/2017_09_07/thread_1_seq_36.272.954100233
  638. archived log for thread 1 with sequence 37 is already on disk as file +FRA/orcl/archivelog/2017_09_07/thread_1_seq_37.271.954100235
  639. archived log for thread 1 with sequence 38 is already on disk as file +FRA/orcl/archivelog/2017_09_07/thread_1_seq_38.265.954100237
  640. archived log for thread 1 with sequence 39 is already on disk as file +FRA/orcl/archivelog/2017_09_07/thread_1_seq_39.264.954100237
  641. channel ORA_SBT_TAPE_1: starting archived log restore to default destination
  642. channel ORA_SBT_TAPE_1: restoring archived log
  643. archived log thread=1 sequence=33
  644. channel ORA_SBT_TAPE_1: reading from backup piece 07sdsq63_1_1
  645. channel ORA_SBT_TAPE_1: piece handle=07sdsq63_1_1 tag=NEWBACKUP
  646. channel ORA_SBT_TAPE_1: restored backup piece 1
  647. channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:25
  648. archived log file name=+FRA/orcl/archivelog/2017_09_07/thread_1_seq_33.258.954101405 thread=1 sequence=33
  649. channel default: deleting archived log(s)
  650. archived log file name=+FRA/orcl/archivelog/2017_09_07/thread_1_seq_33.258.954101405 RECID=22 STAMP=954101405
  651. archived log file name=+FRA/orcl/archivelog/2017_09_07/thread_1_seq_34.275.954100231 thread=1 sequence=34
  652. archived log file name=+FRA/orcl/archivelog/2017_09_07/thread_1_seq_35.273.954100231 thread=1 sequence=35
  653. archived log file name=+FRA/orcl/archivelog/2017_09_07/thread_1_seq_36.272.954100233 thread=1 sequence=36
  654. archived log file name=+FRA/orcl/archivelog/2017_09_07/thread_1_seq_37.271.954100235 thread=1 sequence=37
  655. archived log file name=+FRA/orcl/archivelog/2017_09_07/thread_1_seq_38.265.954100237 thread=1 sequence=38
  656. archived log file name=+FRA/orcl/archivelog/2017_09_07/thread_1_seq_39.264.954100237 thread=1 sequence=39
  657. media recovery complete, elapsed time: 00:00:02
  658. Finished recover at 07-SEP-17

  660. RMAN> alter database open resetlog;s

  662. RMAN-00571: ===========================================================
  663. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  664. RMAN-00571: ===========================================================
  665. RMAN-00558: error encountered while parsing input commands
  666. RMAN-01009: syntax error: found "identifier": expecting one of: "resetlogs, ;"
  667. RMAN-01008: the bad identifier was: resetlog
  668. RMAN-01007: at line 1 column 21 file: standard input

  670. RMAN> alter database open resetlog;

  672. RMAN-00571: ===========================================================
  673. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  674. RMAN-00571: ===========================================================
  675. RMAN-00558: error encountered while parsing input commands
  676. RMAN-01009: syntax error: found "identifier": expecting one of: "resetlogs, ;"
  677. RMAN-01008: the bad identifier was: resetlog
  678. RMAN-01007: at line 1 column 21 file: standard input

  680. RMAN> alter database open resetlogs;

  682. database opened
  683. new incarnation of database registered in recovery catalog
  684. starting full resync of recovery catalog
  685. full resync complete

  687. RMAN> exit

  689. RMAN-06900: WARNING: unable to generate V$RMAN_STATUS or V$RMAN_OUTPUT row
  690. RMAN-06901: WARNING: disabling update of the V$RMAN_STATUS and V$RMAN_OUTPUT rows
  691. ORACLE error from target database:
  692. ORA-03135: connection lost contact
  693. Process ID: 630
  694. Session ID: 131 Serial number: 42


  697. Recovery Manager complete.
  698. [oracle@station90 ~]$ cd /u01/app/oracle/diag/
  699. [oracle@station90 diag]$ ls
  700. asm  rdbms  tnslsnr
  701. [oracle@station90 diag]$ cd rdbms/
  702. [oracle@station90 rdbms]$ ls
  703. orcl  rcat
  704. [oracle@station90 rdbms]$ cd orcl/
  705. [oracle@station90 orcl]$ ls
  706. i_1.mif  orcl
  707. [oracle@station90 orcl]$ cd orcl/
  708. [oracle@station90 orcl]$ ls
  709. alert  cdump  hm  incident  incpkg  ir  lck  metadata  stage  sweep  trace
  710. [oracle@station90 orcl]$ cd trace/
  711. [oracle@station90 trace]$ ls
  712. alert_orcl.log       orcl_dbrm_9303.trm   orcl_mark_17470.trm  orcl_ora_17059.trm  orcl_ora_29771.trm   orcl_pr00_31636.trm
  713. orcl_arc0_1159.trc   orcl_dbw0_16967.trc  orcl_mark_29631.trc  orcl_ora_17106.trc  orcl_ora_30163.trc   orcl_pr00_32335.trc
  714. orcl_arc0_1159.trm   orcl_dbw0_16967.trm  orcl_mark_29631.trm  orcl_ora_17106.trm  orcl_ora_30163.trm   orcl_pr00_32335.trm
  715. orcl_arc0_17773.trc  orcl_dbw0_17186.trc  orcl_mark_3310.trc   orcl_ora_17113.trc  orcl_ora_32301.trc   orcl_pr00_32375.trc
  716. orcl_arc0_17773.trm  orcl_dbw0_17186.trm  orcl_mark_3310.trm   orcl_ora_17113.trm  orcl_ora_32301.trm   orcl_pr00_32375.trm
  717. orcl_arc0_9392.trc   orcl_dbw0_17446.trc  orcl_mark_6222.trc   orcl_ora_17117.trc  orcl_ora_3235.trc    orcl_pr00_32459.trc
  718. orcl_arc0_9392.trm   orcl_dbw0_17446.trm  orcl_mark_6222.trm   orcl_ora_17117.trm  orcl_ora_3235.trm    orcl_pr00_32459.trm
  719. orcl_arc1_9401.trc   orcl_dbw0_3288.trc   orcl_mark_9333.trc   orcl_ora_17128.trc  orcl_ora_32393.trc   orcl_pr00_772.trc
  720. orcl_arc1_9401.trm   orcl_dbw0_3288.trm   orcl_mark_9333.trm   orcl_ora_17128.trm  orcl_ora_32393.trm   orcl_pr00_772.trm
  721. orcl_arc2_1165.trc   orcl_dbw0_6200.trc   orcl_mman_16716.trc  orcl_ora_17134.trc  orcl_ora_32445.trc   orcl_pr01_17753.trc
  722. orcl_arc2_1165.trm   orcl_dbw0_6200.trm   orcl_mman_16716.trm  orcl_ora_17134.trm  orcl_ora_32445.trm   orcl_pr01_17753.trm
  723. orcl_arc2_17777.trc  orcl_j000_10078.trc  orcl_mman_16837.trc  orcl_ora_17135.trc  orcl_ora_3318.trc    orcl_pr01_31638.trc
  724. orcl_arc2_17777.trm  orcl_j000_10078.trm  orcl_mman_16837.trm  orcl_ora_17135.trm  orcl_ora_3318.trm    orcl_pr01_31638.trm
  725. orcl_arc3_1167.trc   orcl_j000_11045.trc  orcl_mman_16965.trc  orcl_ora_17144.trc  orcl_ora_5016.trc    orcl_pr01_32377.trc
  726. orcl_arc3_1167.trm   orcl_j000_11045.trm  orcl_mman_16965.trm  orcl_ora_17144.trm  orcl_ora_5016.trm    orcl_pr01_32377.trm
  727. orcl_arc3_17779.trc  orcl_j000_17643.trc  orcl_mman_17184.trc  orcl_ora_17216.trc  orcl_ora_5020.trc    orcl_pr01_32461.trc
  728. orcl_arc3_17779.trm  orcl_j000_17643.trm  orcl_mman_17184.trm  orcl_ora_17216.trm  orcl_ora_5020.trm    orcl_pr01_32461.trm
  729. orcl_arc3_9405.trc   orcl_j000_17816.trc  orcl_mman_17409.trc  orcl_ora_17262.trc  orcl_ora_5022.trc    orcl_pr01_774.trc
  730. orcl_arc3_9405.trm   orcl_j000_17816.trm  orcl_mman_17409.trm  orcl_ora_17262.trm  orcl_ora_5022.trm    orcl_pr01_774.trm
  731. orcl_asmb_16780.trc  orcl_j000_18834.trc  orcl_mman_17444.trc  orcl_ora_17360.trc  orcl_ora_5024.trc    orcl_pr02_17755.trc
  732. orcl_asmb_16780.trm  orcl_j000_18834.trm  orcl_mman_17444.trm  orcl_ora_17360.trm  orcl_ora_5024.trm    orcl_pr02_17755.trm
  733. orcl_asmb_16879.trc  orcl_j000_26330.trc  orcl_mman_29607.trc  orcl_ora_17365.trc  orcl_ora_5235.trc    orcl_pr02_31640.trc
  734. orcl_asmb_16879.trm  orcl_j000_26330.trm  orcl_mman_29607.trm  orcl_ora_17365.trm  orcl_ora_5235.trm    orcl_pr02_31640.trm
  735. orcl_asmb_17005.trc  orcl_j000_3447.trc   orcl_mman_3286.trc   orcl_ora_17394.trc  orcl_ora_5237.trc    orcl_pr02_32379.trc
  736. orcl_asmb_17005.trm  orcl_j000_3447.trm   orcl_mman_3286.trm   orcl_ora_17394.trm  orcl_ora_5237.trm    orcl_pr02_32379.trm
  737. orcl_asmb_17198.trc  orcl_j000_6299.trc   orcl_mman_6198.trc   orcl_ora_17444.trc  orcl_ora_5249.trc    orcl_pr02_32463.trc
  738. orcl_asmb_17198.trm  orcl_j000_6299.trm   orcl_mman_6198.trm   orcl_ora_17444.trm  orcl_ora_5249.trm    orcl_pr02_32463.trm
  739. orcl_asmb_17424.trc  orcl_j000_7525.trc   orcl_mman_9309.trc   orcl_ora_17522.trc  orcl_ora_5660.trc    orcl_pr02_776.trc
  740. orcl_asmb_17424.trm  orcl_j000_7525.trm   orcl_mman_9309.trm   orcl_ora_17522.trm  orcl_ora_5660.trm    orcl_pr02_776.trm
  741. orcl_asmb_17458.trc  orcl_j001_1251.trc   orcl_mmon_9325.trc   orcl_ora_17639.trc  orcl_ora_5827.trc    orcl_pr03_17757.trc
  742. orcl_asmb_17458.trm  orcl_j001_1251.trm   orcl_mmon_9325.trm   orcl_ora_17639.trm  orcl_ora_5827.trm    orcl_pr03_17757.trm
  743. orcl_asmb_29621.trc  orcl_j001_17080.trc  orcl_ora_10006.trc   orcl_ora_17814.trc  orcl_ora_6147.trc    orcl_pr03_31642.trc
  744. orcl_asmb_29621.trm  orcl_j001_17080.trm  orcl_ora_10006.trm   orcl_ora_17814.trm  orcl_ora_6147.trm    orcl_pr03_31642.trm
  745. orcl_asmb_3300.trc   orcl_j001_31994.trc  orcl_ora_10195.trc   orcl_ora_18201.trc  orcl_ora_6231.trc    orcl_pr03_32381.trc
  746. orcl_asmb_3300.trm   orcl_j001_31994.trm  orcl_ora_10195.trm   orcl_ora_18201.trm  orcl_ora_6231.trm    orcl_pr03_32381.trm
  747. orcl_asmb_6212.trc   orcl_j006_10090.trc  orcl_ora_10242.trc   orcl_ora_18203.trc  orcl_ora_630.trc     orcl_pr03_32465.trc
  748. orcl_asmb_6212.trm   orcl_j006_10090.trm  orcl_ora_10242.trm   orcl_ora_18203.trm  orcl_ora_630.trm     orcl_pr03_32465.trm
  749. orcl_asmb_9323.trc   orcl_lgwr_16969.trc  orcl_ora_10248.trc   orcl_ora_18298.trc  orcl_ora_6851.trc    orcl_pr03_778.trc
  750. orcl_asmb_9323.trm   orcl_lgwr_16969.trm  orcl_ora_10248.trm   orcl_ora_18298.trm  orcl_ora_6851.trm    orcl_pr03_778.trm
  751. orcl_ckpt_16843.trc  orcl_lgwr_17188.trc  orcl_ora_10253.trc   orcl_ora_18709.trc  orcl_ora_7064.trc    orcl_pr04_17759.trc
  752. orcl_ckpt_16843.trm  orcl_lgwr_17188.trm  orcl_ora_10253.trm   orcl_ora_18709.trm  orcl_ora_7064.trm    orcl_pr04_17759.trm
  753. orcl_ckpt_16971.trc  orcl_lgwr_17448.trc  orcl_ora_10255.trc   orcl_ora_21348.trc  orcl_ora_7069.trc    orcl_pr04_31644.trc
  754. orcl_ckpt_16971.trm  orcl_lgwr_17448.trm  orcl_ora_10255.trm   orcl_ora_21348.trm  orcl_ora_7069.trm    orcl_pr04_31644.trm
  755. orcl_ckpt_17190.trc  orcl_lgwr_3290.trc   orcl_ora_10259.trc   orcl_ora_21694.trc  orcl_ora_7072.trc    orcl_pr04_32383.trc
  756. orcl_ckpt_17190.trm  orcl_lgwr_3290.trm   orcl_ora_10259.trm   orcl_ora_21694.trm  orcl_ora_7072.trm    orcl_pr04_32383.trm
  757. orcl_ckpt_17415.trc  orcl_lgwr_6202.trc   orcl_ora_10288.trc   orcl_ora_22780.trc  orcl_ora_7095.trc    orcl_pr04_32467.trc
  758. orcl_ckpt_17415.trm  orcl_lgwr_6202.trm   orcl_ora_10288.trm   orcl_ora_22780.trm  orcl_ora_7095.trm    orcl_pr04_32467.trm
  759. orcl_ckpt_17450.trc  orcl_m000_1153.trc   orcl_ora_10796.trc   orcl_ora_2314.trc   orcl_ora_710.trc     orcl_pr04_780.trc
  760. orcl_ckpt_17450.trm  orcl_m000_1153.trm   orcl_ora_10796.trm   orcl_ora_2314.trm   orcl_ora_710.trm     orcl_pr04_780.trm
  761. orcl_ckpt_29613.trc  orcl_m000_17048.trc  orcl_ora_10910.trc   orcl_ora_24127.trc  orcl_ora_7130.trc    orcl_smon_29615.trc
  762. orcl_ckpt_29613.trm  orcl_m000_17048.trm  orcl_ora_10910.trm   orcl_ora_24127.trm  orcl_ora_7130.trm    orcl_smon_29615.trm
  763. orcl_ckpt_3292.trc   orcl_m000_17495.trc  orcl_ora_1245.trc    orcl_ora_24796.trc  orcl_ora_7864.trc    orcl_vktm_16702.trc
  764. orcl_ckpt_3292.trm   orcl_m000_17495.trm  orcl_ora_1245.trm    orcl_ora_24796.trm  orcl_ora_7864.trm    orcl_vktm_16702.trm
  765. orcl_ckpt_6204.trc   orcl_m000_17729.trc  orcl_ora_13937.trc   orcl_ora_24932.trc  orcl_ora_7871.trc    orcl_vktm_16823.trc
  766. orcl_ckpt_6204.trm   orcl_m000_17729.trm  orcl_ora_13937.trm   orcl_ora_24932.trm  orcl_ora_7871.trm    orcl_vktm_16823.trm
  767. orcl_ckpt_9315.trc   orcl_m000_20797.trc  orcl_ora_1563.trc    orcl_ora_24938.trc  orcl_ora_8107.trc    orcl_vktm_16951.trc
  768. orcl_ckpt_9315.trm   orcl_m000_20797.trm  orcl_ora_1563.trm    orcl_ora_24938.trm  orcl_ora_8107.trm    orcl_vktm_16951.trm
  769. orcl_dbrm_16959.trc  orcl_m000_29689.trc  orcl_ora_15670.trc   orcl_ora_24940.trc  orcl_ora_8621.trc    orcl_vktm_17170.trc
  770. orcl_dbrm_16959.trm  orcl_m000_29689.trm  orcl_ora_15670.trm   orcl_ora_24940.trm  orcl_ora_8621.trm    orcl_vktm_17170.trm
  771. orcl_dbrm_17178.trc  orcl_m000_31651.trc  orcl_ora_16676.trc   orcl_ora_24968.trc  orcl_ora_9254.trc    orcl_vktm_17395.trc
  772. orcl_dbrm_17178.trm  orcl_m000_31651.trm  orcl_ora_16676.trm   orcl_ora_24968.trm  orcl_ora_9254.trm    orcl_vktm_17395.trm
  773. orcl_dbrm_17403.trc  orcl_mark_16786.trc  orcl_ora_16740.trc   orcl_ora_24989.trc  orcl_ora_9342.trc    orcl_vktm_17430.trc
  774. orcl_dbrm_17403.trm  orcl_mark_16786.trm  orcl_ora_16740.trm   orcl_ora_24989.trm  orcl_ora_9342.trm    orcl_vktm_17430.trm
  775. orcl_dbrm_17438.trc  orcl_mark_16912.trc  orcl_ora_16797.trc   orcl_ora_25003.trc  orcl_p000_17767.trc  orcl_vktm_29593.trc
  776. orcl_dbrm_17438.trm  orcl_mark_16912.trm  orcl_ora_16797.trm   orcl_ora_25003.trm  orcl_p000_17767.trm  orcl_vktm_29593.trm
  777. orcl_dbrm_29601.trc  orcl_mark_17012.trc  orcl_ora_16864.trc   orcl_ora_26701.trc  orcl_p001_17769.trc  orcl_vktm_3272.trc
  778. orcl_dbrm_29601.trm  orcl_mark_17012.trm  orcl_ora_16864.trm   orcl_ora_26701.trm  orcl_p001_17769.trm  orcl_vktm_3272.trm
  779. orcl_dbrm_3280.trc   orcl_mark_17213.trc  orcl_ora_16925.trc   orcl_ora_27077.trc  orcl_p002_17771.trc  orcl_vktm_6184.trc
  780. orcl_dbrm_3280.trm   orcl_mark_17213.trm  orcl_ora_16925.trm   orcl_ora_27077.trm  orcl_p002_17771.trm  orcl_vktm_6184.trm
  781. orcl_dbrm_6192.trc   orcl_mark_17436.trc  orcl_ora_16985.trc   orcl_ora_29560.trc  orcl_pr00_17751.trc  orcl_vktm_9295.trc
  782. orcl_dbrm_6192.trm   orcl_mark_17436.trm  orcl_ora_16985.trm   orcl_ora_29560.trm  orcl_pr00_17751.trm  orcl_vktm_9295.trm
  783. orcl_dbrm_9303.trc   orcl_mark_17470.trc  orcl_ora_17059.trc   orcl_ora_29771.trc  orcl_pr00_31636.trc  sbtio.log
  784. [oracle@station90 trace]$ ls -l *7871*
  785. -rw-r----- 1 oracle dba 9675  9月  7 20:34 orcl_ora_7871.trc
  786. -rw-r----- 1 oracle dba   90  9月  7 20:34 orcl_ora_7871.trm
  787. [oracle@station90 trace]$ cp orcl_ora_7871.trc  /home/oracle/control11a.sql
  788. [oracle@station90 trace]$ cd
  789. [oracle@station90 ~]$ ls
  790. control10d-after.sql  create_t04209_uname.sql  osb.txt   revertape-root.sh        ttio.rcv                  公共的  图片  音乐
  791. control11a.sql        mail                     rac_tns   select_t04209_uname.sql  update2_t04209_uname.sql  模板    文档  桌面
  792. copytape-root.sh      oradiag_oracle           rcat.sql  tnsnames.ora             update_t04209_uname.sql   视频    下载
  793. [oracle@station90 ~]$ vim control11a.sql
  794. [oracle@station90 ~]$ ls
  795. control10d-after.sql  create_t04209_uname.sql  osb.txt   revertape-root.sh        ttio.rcv                  公共的  图片  音乐
  796. control11a.sql        mail                     rac_tns   select_t04209_uname.sql  update2_t04209_uname.sql  模板    文档  桌面
  797. copytape-root.sh      oradiag_oracle           rcat.sql  tnsnames.ora             update_t04209_uname.sql   视频    下载
  798. [oracle@station90 ~]$ diff control10d-after.sql   control11a.sql
  799. 1c1
  800. < CREATE CONTROLFILE REUSE DATABASE "ORCL" NORESETLOGS  ARCHIVELOG
  801. ---
  802. > CREATE CONTROLFILE REUSE DATABASE "ORCL" RESETLOGS  ARCHIVELOG
  803. 9,10c9,10
  804. <     '+DATA/orcl/onlinelog/group_1.261.816169635',
  805. <     '+FRA/orcl/onlinelog/group_1.257.816169637'
  806. ---
  807. >     '+DATA/orcl/onlinelog/group_1.262.954101431',
  808. >     '+FRA/orcl/onlinelog/group_1.258.954101433'
  809. 13,14c13,14
  810. <     '+DATA/orcl/onlinelog/group_2.262.816169639',
  811. <     '+FRA/orcl/onlinelog/group_2.258.816169639'
  812. ---
  813. >     '+DATA/orcl/onlinelog/group_2.261.954101433',
  814. >     '+FRA/orcl/onlinelog/group_2.257.954101433'
  815. 17,18c17,18
  816. <     '+DATA/orcl/onlinelog/group_3.263.816169641',
  817. <     '+FRA/orcl/onlinelog/group_3.259.816169641'
  818. ---
  819. >     '+DATA/orcl/onlinelog/group_3.260.954101433',
  820. >     '+FRA/orcl/onlinelog/group_3.256.954101433'
  821. [oracle@station90 ~]$ sqlplus /nolog

  823. SQL*Plus: Release 11.2.0.1.0 Production on Thu Sep 7 20:40:57 2017

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

  827. SQL> conn / as sysdba
  828. Connected to an idle instance.
  829. SQL> startup
  830. ORACLE instance started.

  832. Total System Global Area 6680915968 bytes
  833. Fixed Size                    2213936 bytes
  834. Variable Size                 3556771792 bytes
  835. Database Buffers         3087007744 bytes
  836. Redo Buffers                   34922496 bytes
  837. ORA-00205: error in identifying control file, check alert log for more info


  840. SQL> @control11.sql
  841. SP2-0310: unable to open file "control11.sql"
  842. SQL> @control11a.sql

  844. Control file created.


  847. PL/SQL procedure successfully completed.


  850. PL/SQL procedure successfully completed.


  853. PL/SQL procedure successfully completed.


  856. PL/SQL procedure successfully completed.


  859. PL/SQL procedure successfully completed.


  862. PL/SQL procedure successfully completed.


  865. PL/SQL procedure successfully completed.


  868. PL/SQL procedure successfully completed.

  870. SQL> recover database;
  871. ORA-00283: recovery session canceled due to errors
  872. ORA-01610: recovery using the BACKUP CONTROLFILE option must be done


  875. SQL> recover database using BACKUP CONTROLFILE;
  876. ORA-00279: change 1114775 generated at 09/07/2017 20:34:23 needed for thread 1
  877. ORA-00289: suggestion :
  878. +FRA/orcl/archivelog/2017_09_07/thread_1_seq_5.278.954102865
  879. ORA-00280: change 1114775 for thread 1 is in sequence #5


  882. Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

  884. ORA-00279: change 1114781 generated at 09/07/2017 20:34:24 needed for thread 1
  885. ORA-00289: suggestion :
  886. +FRA/orcl/archivelog/2017_09_07/thread_1_seq_6.279.954102867
  887. ORA-00280: change 1114781 for thread 1 is in sequence #6
  888. ORA-00278: log file
  889. '+FRA/orcl/archivelog/2017_09_07/thread_1_seq_5.278.954102865' no longer needed
  890. for this recovery


  893. Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

  895. ORA-00279: change 1114792 generated at 09/07/2017 20:34:26 needed for thread 1
  896. ORA-00289: suggestion : +FRA
  897. ORA-00280: change 1114792 for thread 1 is in sequence #7
  898. ORA-00278: log file
  899. '+FRA/orcl/archivelog/2017_09_07/thread_1_seq_6.279.954102867' no longer needed
  900. for this recovery


  903. Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

  905. ORA-00308: cannot open archived log '+FRA'
  906. ORA-17503: ksfdopn:2 Failed to open file +FRA
  907. ORA-15045: ASM file name '+FRA' is not in reference form


  910. SQL> recover database using BACKUP CONTROLFILE;
  911. ORA-00279: change 1114792 generated at 09/07/2017 20:34:26 needed for thread 1
  912. ORA-00289: suggestion : +FRA
  913. ORA-00280: change 1114792 for thread 1 is in sequence #7


  916. Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
  917. cancel
  918. Media recovery cancelled.
  919. SQL> alter database open ;
  920. alter database open
  921. *
  922. ERROR at line 1:
  923. ORA-01589: must use RESETLOGS or NORESETLOGS option for database open


  926. SQL> alter database open  resetlogs;
  927. alter database open  resetlogs
  928. *
  929. ERROR at line 1:
  930. ORA-01113: file 1 needs media recovery
  931. ORA-01110: data file 1: '+DATA/orcl/datafile/system.256.816169553'


  934. SQL> exit
  935. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
  936. With the Partitioning, OLAP, Data Mining and Real Application Testing options
  937. [oracle@station90 ~]$ rman target /

  939. Recovery Manager: Release 11.2.0.1.0 - Production on Thu Sep 7 20:43:07 2017

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

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

  945. RMAN> list backup of database;

  947. using target database control file instead of recovery catalog
  948. specification does not match any backup in the repository

  950. RMAN> exit


  953. Recovery Manager complete.
  954. [oracle@station90 ~]$ rman target /  catalog u90/oracle_4U@rcat

  956. Recovery Manager: Release 11.2.0.1.0 - Production on Thu Sep 7 20:43:24 2017

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

  960. connected to target database: ORCL (DBID=1343950367, not open)
  961. connected to recovery catalog database

  963. RMAN> list backup of database;


  966. List of Backup Sets
  967. ===================


  970. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  971. ------- ---- -- ---------- ----------- ------------ ---------------
  972. 77      Incr 0  657.75M    SBT_TAPE    00:00:27     18-MAY-17      
  973.         BP Key: 83   Status: AVAILABLE  Compressed: NO  Tag: 0T_INCR0_WHOLE
  974.         Handle: 12s4ih4j_1_1   Media: station90-000001
  975.   List of Datafiles in backup set 77
  976.   File LV Type Ckp SCN    Ckp Time  Name
  977.   ---- -- ---- ---------- --------- ----
  978.   1    0  Incr 1057421    18-MAY-17 +DATA/orcl/datafile/system.256.816169553
  979.   5    0  Incr 1057421    18-MAY-17 +DATA/orcl/datafile/example.265.816169651

  981. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  982. ------- ---- -- ---------- ----------- ------------ ---------------
  983. 179     Full    3.50M      SBT_TAPE    00:00:15     07-SEP-17      
  984.         BP Key: 181   Status: AVAILABLE  Compressed: NO  Tag: LABS-10D-USERS-BEFORE-RW
  985.         Handle: 16sdsos7_1_1   Media: station90-000001
  986.   List of Datafiles in backup set 179
  987.   File LV Type Ckp SCN    Ckp Time  Name
  988.   ---- -- ---- ---------- --------- ----
  989.   4       Full 1087196    07-SEP-17 +DATA/orcl/datafile/users.259.816169553

  991. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  992. ------- ---- -- ---------- ----------- ------------ ---------------
  993. 180     Full    3.50M      SBT_TAPE    00:00:15     07-SEP-17      
  994.         BP Key: 182   Status: AVAILABLE  Compressed: NO  Tag: LABS-10D-USERS-AFTER-RW
  995.         Handle: 18sdsou6_1_1   Media: station90-000001
  996.   List of Datafiles in backup set 180
  997.   File LV Type Ckp SCN    Ckp Time  Name
  998.   ---- -- ---- ---------- --------- ----
  999.   4       Full 1087321    07-SEP-17 +DATA/orcl/datafile/users.259.816169553

  1001. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  1002. ------- ---- -- ---------- ----------- ------------ ---------------
  1003. 214     Incr 0  445.75M    SBT_TAPE    00:00:19     07-SEP-17      
  1004.         BP Key: 221   Status: AVAILABLE  Compressed: NO  Tag: NEWBACKUP
  1005.         Handle: 06sdsq58_1_1   Media: station90-000003
  1006.   List of Datafiles in backup set 214
  1007.   File LV Type Ckp SCN    Ckp Time  Name
  1008.   ---- -- ---- ---------- --------- ----
  1009.   2    0  Incr 1110116    07-SEP-17 +DATA/orcl/datafile/sysaux.257.816169553
  1010.   3    0  Incr 1110116    07-SEP-17 +DATA/orcl/datafile/undotbs1.258.816169553
  1011.   4    0  Incr 1110116    07-SEP-17 +DATA/orcl/datafile/users.259.816169553

  1013. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  1014. ------- ---- -- ---------- ----------- ------------ ---------------
  1015. 215     Incr 0  658.00M    SBT_TAPE    00:00:20     07-SEP-17      
  1016.         BP Key: 222   Status: AVAILABLE  Compressed: NO  Tag: NEWBACKUP
  1017.         Handle: 05sdsq57_1_1   Media: station90-000001
  1018.   List of Datafiles in backup set 215
  1019.   File LV Type Ckp SCN    Ckp Time  Name
  1020.   ---- -- ---- ---------- --------- ----
  1021.   1    0  Incr 1110115    07-SEP-17 +DATA/orcl/datafile/system.256.816169553
  1022.   5    0  Incr 1110115    07-SEP-17 +DATA/orcl/datafile/example.265.816169651

  1024. RMAN> restore database;

  1026. Starting restore at 07-SEP-17
  1027. allocated channel: ORA_DISK_1
  1028. channel ORA_DISK_1: SID=68 device type=DISK
  1029. allocated channel: ORA_DISK_2
  1030. channel ORA_DISK_2: SID=131 device type=DISK
  1031. allocated channel: ORA_DISK_3
  1032. channel ORA_DISK_3: SID=192 device type=DISK
  1033. allocated channel: ORA_DISK_4
  1034. channel ORA_DISK_4: SID=8 device type=DISK
  1035. allocated channel: ORA_DISK_5
  1036. channel ORA_DISK_5: SID=132 device type=DISK
  1037. allocated channel: ORA_DISK_6
  1038. channel ORA_DISK_6: SID=193 device type=DISK
  1039. allocated channel: ORA_DISK_7
  1040. channel ORA_DISK_7: SID=9 device type=DISK
  1041. allocated channel: ORA_DISK_8
  1042. channel ORA_DISK_8: SID=69 device type=DISK
  1043. allocated channel: ORA_SBT_TAPE_1
  1044. channel ORA_SBT_TAPE_1: SID=133 device type=SBT_TAPE
  1045. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  1046. allocated channel: ORA_SBT_TAPE_2
  1047. channel ORA_SBT_TAPE_2: SID=10 device type=SBT_TAPE
  1048. channel ORA_SBT_TAPE_2: Oracle Secure Backup

  1050. channel ORA_SBT_TAPE_1: starting datafile backup set restore
  1051. channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
  1052. channel ORA_SBT_TAPE_1: restoring datafile 00001 to +DATA/orcl/datafile/system.256.816169553
  1053. channel ORA_SBT_TAPE_1: restoring datafile 00005 to +DATA/orcl/datafile/example.265.816169651
  1054. channel ORA_SBT_TAPE_1: reading from backup piece 05sdsq57_1_1
  1055. channel ORA_SBT_TAPE_2: starting datafile backup set restore
  1056. channel ORA_SBT_TAPE_2: specifying datafile(s) to restore from backup set
  1057. channel ORA_SBT_TAPE_2: restoring datafile 00002 to +DATA/orcl/datafile/sysaux.257.816169553
  1058. channel ORA_SBT_TAPE_2: restoring datafile 00003 to +DATA/orcl/datafile/undotbs1.258.816169553
  1059. channel ORA_SBT_TAPE_2: restoring datafile 00004 to +DATA/orcl/datafile/users.259.816169553
  1060. channel ORA_SBT_TAPE_2: reading from backup piece 06sdsq58_1_1
  1061. channel ORA_SBT_TAPE_2: piece handle=06sdsq58_1_1 tag=NEWBACKUP
  1062. channel ORA_SBT_TAPE_2: restored backup piece 1
  1063. channel ORA_SBT_TAPE_2: restore complete, elapsed time: 00:00:45
  1064. channel ORA_SBT_TAPE_1: piece handle=05sdsq57_1_1 tag=NEWBACKUP
  1065. channel ORA_SBT_TAPE_1: restored backup piece 1
  1066. channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:55
  1067. Finished restore at 07-SEP-17

  1069. RMAN> exit


  1072. Recovery Manager complete.
  1073. [oracle@station90 ~]$ sqlplus /nolog

  1075. SQL*Plus: Release 11.2.0.1.0 Production on Thu Sep 7 20:44:53 2017

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

  1079. SQL> conn / as sysdba
  1080. Connected.
  1081. SQL> recover database using BACKUP CONTROLFILE;
  1082. ORA-00279: change 1110115 generated at 09/07/2017 19:44:40 needed for thread 1
  1083. ORA-00289: suggestion : +FRA
  1084. ORA-00280: change 1110115 for thread 1 is in sequence #33


  1087. Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

  1089. ORA-00308: cannot open archived log '+FRA'
  1090. ORA-17503: ksfdopn:2 Failed to open file +FRA
  1091. ORA-15045: ASM file name '+FRA' is not in reference form


  1094. SQL> exit
  1095. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
  1096. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
  1097. and Real Application Testing options
  1098. [oracle@station90 ~]$ rman target /  catalog u90/oracle_4U@rcat

  1100. Recovery Manager: Release 11.2.0.1.0 - Production on Thu Sep 7 20:45:33 2017

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

  1104. connected to target database: ORCL (DBID=1343950367, not open)
  1105. connected to recovery catalog database

  1107. RMAN> list backup of archivelog sequence 33 thread 1;

  1109. specification does not match any backup in the repository

  1111. RMAN> list incarnation of database;


  1114. List of Database Incarnations
  1115. DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
  1116. ------- ------- -------- ---------------- --- ---------- ----------
  1117. 2       21      ORCL     1343950367       PARENT  1          15-AUG-09
  1118. 2       4       ORCL     1343950367       PARENT  945184     23-MAY-13
  1119. 2       358     ORCL     1343950367       CURRENT 1111226    07-SEP-17

  1121. RMAN> reset database to incarnation 4;

  1123. database reset to incarnation 4

  1125. RMAN> list backup of archivelog sequence 33 thread 1;


  1128. List of Backup Sets
  1129. ===================


  1132. BS Key  Size       Device Type Elapsed Time Completion Time
  1133. ------- ---------- ----------- ------------ ---------------
  1134. 243     256.00K    SBT_TAPE    00:00:16     07-SEP-17      
  1135.         BP Key: 246   Status: AVAILABLE  Compressed: NO  Tag: NEWBACKUP
  1136.         Handle: 07sdsq63_1_1   Media: station90-000003

  1138.   List of Archived Logs in backup set 243
  1139.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  1140.   ---- ------- ---------- --------- ---------- ---------
  1141.   1    33      1110005    07-SEP-17 1110141    07-SEP-17

  1143. RMAN> restore archivelog sequence 33 thread 1;

  1145. Starting restore at 07-SEP-17
  1146. allocated channel: ORA_DISK_1
  1147. channel ORA_DISK_1: SID=71 device type=DISK
  1148. allocated channel: ORA_DISK_2
  1149. channel ORA_DISK_2: SID=133 device type=DISK
  1150. allocated channel: ORA_DISK_3
  1151. channel ORA_DISK_3: SID=192 device type=DISK
  1152. allocated channel: ORA_DISK_4
  1153. channel ORA_DISK_4: SID=9 device type=DISK
  1154. allocated channel: ORA_DISK_5
  1155. channel ORA_DISK_5: SID=131 device type=DISK
  1156. allocated channel: ORA_DISK_6
  1157. channel ORA_DISK_6: SID=193 device type=DISK
  1158. allocated channel: ORA_DISK_7
  1159. channel ORA_DISK_7: SID=8 device type=DISK
  1160. allocated channel: ORA_DISK_8
  1161. channel ORA_DISK_8: SID=68 device type=DISK
  1162. allocated channel: ORA_SBT_TAPE_1
  1163. channel ORA_SBT_TAPE_1: SID=132 device type=SBT_TAPE
  1164. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  1165. allocated channel: ORA_SBT_TAPE_2
  1166. channel ORA_SBT_TAPE_2: SID=7 device type=SBT_TAPE
  1167. channel ORA_SBT_TAPE_2: Oracle Secure Backup

  1169. channel ORA_SBT_TAPE_1: starting archived log restore to default destination
  1170. channel ORA_SBT_TAPE_1: restoring archived log
  1171. archived log thread=1 sequence=33
  1172. channel ORA_SBT_TAPE_1: reading from backup piece 07sdsq63_1_1
  1173. channel ORA_SBT_TAPE_1: piece handle=07sdsq63_1_1 tag=NEWBACKUP
  1174. channel ORA_SBT_TAPE_1: restored backup piece 1
  1175. channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:25
  1176. Finished restore at 07-SEP-17

  1178. RMAN> list incarnation of database;


  1181. List of Database Incarnations
  1182. DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
  1183. ------- ------- -------- ---------------- --- ---------- ----------
  1184. 2       21      ORCL     1343950367       PARENT  1          15-AUG-09
  1185. 2       4       ORCL     1343950367       CURRENT 945184     23-MAY-13
  1186. 2       358     ORCL     1343950367       ORPHAN  1111226    07-SEP-17

  1188. RMAN> reset database to incarnation 358;

  1190. database reset to incarnation 358

  1192. RMAN> list incarnation of database;


  1195. List of Database Incarnations
  1196. DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
  1197. ------- ------- -------- ---------------- --- ---------- ----------
  1198. 2       21      ORCL     1343950367       PARENT  1          15-AUG-09
  1199. 2       4       ORCL     1343950367       PARENT  945184     23-MAY-13
  1200. 2       358     ORCL     1343950367       CURRENT 1111226    07-SEP-17

  1202. RMAN> exit


  1205. Recovery Manager complete.
  1206. [oracle@station90 ~]$ sqlplus /nolog

  1208. SQL*Plus: Release 11.2.0.1.0 Production on Thu Sep 7 20:48:41 2017

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

  1212. SQL> conn / as sysdba
  1213. Connected.
  1214. SQL> recover database using BACKUP CONTROLFILE;
  1215. ORA-00279: change 1110115 generated at 09/07/2017 19:44:40 needed for thread 1
  1216. ORA-00289: suggestion :
  1217. +FRA/orcl/archivelog/2017_09_07/thread_1_seq_33.257.954103659
  1218. ORA-00280: change 1110115 for thread 1 is in sequence #33


  1221. Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

  1223. ORA-00279: change 1110141 generated at 09/07/2017 19:45:05 needed for thread 1
  1224. ORA-00289: suggestion :
  1225. +FRA/orcl/archivelog/2017_09_07/thread_1_seq_34.275.954100231
  1226. ORA-00280: change 1110141 for thread 1 is in sequence #34
  1227. ORA-00278: log file
  1228. '+FRA/orcl/archivelog/2017_09_07/thread_1_seq_33.257.954103659' no longer
  1229. needed for this recovery


  1232. Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

  1234. ORA-00279: change 1111189 generated at 09/07/2017 19:50:30 needed for thread 1
  1235. ORA-00289: suggestion :
  1236. +FRA/orcl/archivelog/2017_09_07/thread_1_seq_35.273.954100231
  1237. ORA-00280: change 1111189 for thread 1 is in sequence #35
  1238. ORA-00278: log file
  1239. '+FRA/orcl/archivelog/2017_09_07/thread_1_seq_34.275.954100231' no longer
  1240. needed for this recovery


  1243. Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

  1245. ORA-00279: change 1111206 generated at 09/07/2017 19:50:31 needed for thread 1
  1246. ORA-00289: suggestion :
  1247. +FRA/orcl/archivelog/2017_09_07/thread_1_seq_36.272.954100233
  1248. ORA-00280: change 1111206 for thread 1 is in sequence #36
  1249. ORA-00278: log file
  1250. '+FRA/orcl/archivelog/2017_09_07/thread_1_seq_35.273.954100231' no longer
  1251. needed for this recovery


  1254. Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

  1256. ORA-00279: change 1111211 generated at 09/07/2017 19:50:32 needed for thread 1
  1257. ORA-00289: suggestion :
  1258. +FRA/orcl/archivelog/2017_09_07/thread_1_seq_37.271.954100235
  1259. ORA-00280: change 1111211 for thread 1 is in sequence #37
  1260. ORA-00278: log file
  1261. '+FRA/orcl/archivelog/2017_09_07/thread_1_seq_36.272.954100233' no longer
  1262. needed for this recovery


  1265. Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

  1267. ORA-00279: change 1111214 generated at 09/07/2017 19:50:34 needed for thread 1
  1268. ORA-00289: suggestion :
  1269. +FRA/orcl/archivelog/2017_09_07/thread_1_seq_38.265.954100237
  1270. ORA-00280: change 1111214 for thread 1 is in sequence #38
  1271. ORA-00278: log file
  1272. '+FRA/orcl/archivelog/2017_09_07/thread_1_seq_37.271.954100235' no longer
  1273. needed for this recovery


  1276. Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

  1278. ORA-00279: change 1111220 generated at 09/07/2017 19:50:35 needed for thread 1
  1279. ORA-00289: suggestion :
  1280. +FRA/orcl/archivelog/2017_09_07/thread_1_seq_39.264.954100237
  1281. ORA-00280: change 1111220 for thread 1 is in sequence #39
  1282. ORA-00278: log file
  1283. '+FRA/orcl/archivelog/2017_09_07/thread_1_seq_38.265.954100237' no longer
  1284. needed for this recovery


  1287. Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

  1289. ORA-00279: change 1111226 generated at 09/07/2017 20:10:31 needed for thread 1
  1290. ORA-00289: suggestion :
  1291. +FRA/orcl/archivelog/2017_09_07/thread_1_seq_1.261.954102861
  1292. ORA-00280: change 1111226 for thread 1 is in sequence #1
  1293. ORA-00278: log file
  1294. '+FRA/orcl/archivelog/2017_09_07/thread_1_seq_39.264.954100237' no longer
  1295. needed for this recovery


  1298. Specify log: {<RET>=suggested | filename | AUTO | CANCEL}


  1301. ORA-00279: change 1114750 generated at 09/07/2017 20:34:20 needed for thread 1
  1302. ORA-00289: suggestion :
  1303. +FRA/orcl/archivelog/2017_09_07/thread_1_seq_2.262.954102861
  1304. ORA-00280: change 1114750 for thread 1 is in sequence #2
  1305. ORA-00278: log file
  1306. '+FRA/orcl/archivelog/2017_09_07/thread_1_seq_1.261.954102861' no longer needed
  1307. for this recovery


  1310. Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
  1311. ORA-00279: change 1114767 generated at 09/07/2017 20:34:21 needed for thread 1
  1312. ORA-00289: suggestion :
  1313. +FRA/orcl/archivelog/2017_09_07/thread_1_seq_3.276.954102863
  1314. ORA-00280: change 1114767 for thread 1 is in sequence #3
  1315. ORA-00278: log file
  1316. '+FRA/orcl/archivelog/2017_09_07/thread_1_seq_2.262.954102861' no longer needed
  1317. for this recovery


  1320. Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

  1322. ORA-00279: change 1114772 generated at 09/07/2017 20:34:21 needed for thread 1
  1323. ORA-00289: suggestion :
  1324. +FRA/orcl/archivelog/2017_09_07/thread_1_seq_4.277.954102865
  1325. ORA-00280: change 1114772 for thread 1 is in sequence #4
  1326. ORA-00278: log file
  1327. '+FRA/orcl/archivelog/2017_09_07/thread_1_seq_3.276.954102863' no longer needed
  1328. for this recovery


  1331. Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

  1333. ORA-00279: change 1114775 generated at 09/07/2017 20:34:23 needed for thread 1
  1334. ORA-00289: suggestion :
  1335. +FRA/orcl/archivelog/2017_09_07/thread_1_seq_5.278.954102865
  1336. ORA-00280: change 1114775 for thread 1 is in sequence #5
  1337. ORA-00278: log file
  1338. '+FRA/orcl/archivelog/2017_09_07/thread_1_seq_4.277.954102865' no longer needed
  1339. for this recovery


  1342. Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

  1344. ORA-00279: change 1114781 generated at 09/07/2017 20:34:24 needed for thread 1
  1345. ORA-00289: suggestion :
  1346. +FRA/orcl/archivelog/2017_09_07/thread_1_seq_6.279.954102867
  1347. ORA-00280: change 1114781 for thread 1 is in sequence #6
  1348. ORA-00278: log file
  1349. '+FRA/orcl/archivelog/2017_09_07/thread_1_seq_5.278.954102865' no longer needed
  1350. for this recovery


  1353. Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

  1355. ORA-00279: change 1114792 generated at 09/07/2017 20:34:26 needed for thread 1
  1356. ORA-00289: suggestion : +FRA
  1357. ORA-00280: change 1114792 for thread 1 is in sequence #7
  1358. ORA-00278: log file
  1359. '+FRA/orcl/archivelog/2017_09_07/thread_1_seq_6.279.954102867' no longer needed
  1360. for this recovery


  1363. Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

  1365. ORA-00308: cannot open archived log '+FRA'
  1366. ORA-17503: ksfdopn:2 Failed to open file +FRA
  1367. ORA-15045: ASM file name '+FRA' is not in reference form


  1370. SQL> recover database using BACKUP CONTROLFILE;
  1371. ORA-00279: change 1114792 generated at 09/07/2017 20:34:26 needed for thread 1
  1372. ORA-00289: suggestion : +FRA
  1373. ORA-00280: change 1114792 for thread 1 is in sequence #7


  1376. Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
  1377. cancel
  1378. Media recovery cancelled.
  1379. SQL> alter database open ;
  1380. alter database open
  1381. *
  1382. ERROR at line 1:
  1383. ORA-01589: must use RESETLOGS or NORESETLOGS option for database open


  1386. SQL> alter database open  resetlogs;
  1387. alter database open  resetlogs
  1388. *
  1389. ERROR at line 1:
  1390. ORA-01113: file 1 needs media recovery
  1391. ORA-01110: data file 1: '+DATA/orcl/datafile/system.256.816169553'


  1394. SQL> recover database until cancel using BACKUP CONTROLFILE;
  1395. ORA-00279: change 1114792 generated at 09/07/2017 20:34:26 needed for thread 1
  1396. ORA-00289: suggestion : +FRA
  1397. ORA-00280: change 1114792 for thread 1 is in sequence #7


  1400. Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
  1401. cancel
  1402. Media recovery cancelled.
  1403. SQL> alter database open resetlogs;

  1405. Database altered.

  1407. SQL> alter tablespace temp add tempfile '+data' size 30M autoextend on ;

  1409. Tablespace altered.

  1411. SQL> select dbid from v$database;

  1413.       DBID
  1414. ----------
  1415. 1343950367

  1417. SQL> exit
  1418. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
  1419. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
  1420. and Real Application Testing options
  1421. [oracle@station90 ~]$ exit
  1422. logout
  1423. [root@station90 tmp]# su - oracle
  1424. [oracle@station90 ~]$ ls
  1425. control10d-after.sql  create_t04209_uname.sql  osb.txt   revertape-root.sh        ttio.rcv                  公共的  图片  音乐
  1426. control11a.sql        mail                     rac_tns   select_t04209_uname.sql  update2_t04209_uname.sql  模板    文档  桌面
  1427. copytape-root.sh      oradiag_oracle           rcat.sql  tnsnames.ora             update_t04209_uname.sql   视频    下载
  1428. [oracle@station90 ~]$ mv control11a.sql control11b.sql
  1429. [oracle@station90 ~]$ ls
  1430. control10d-after.sql  create_t04209_uname.sql  osb.txt   revertape-root.sh        ttio.rcv                  公共的  图片  音乐
  1431. control11b.sql        mail                     rac_tns   select_t04209_uname.sql  update2_t04209_uname.sql  模板    文档  桌面
  1432. copytape-root.sh      oradiag_oracle           rcat.sql  tnsnames.ora             update_t04209_uname.sql   视频    下载
  1433. [oracle@station90 ~]$ cp control11b.sql control11c.sql
  1434. [oracle@station90 ~]$ ls
  1435. control10d-after.sql  create_t04209_uname.sql  rac_tns                  tnsnames.ora              公共的  文档
  1436. control11b.sql        mail                     rcat.sql                 ttio.rcv                  模板    下载
  1437. control11c.sql        oradiag_oracle           revertape-root.sh        update2_t04209_uname.sql  视频    音乐
  1438. copytape-root.sh      osb.txt                  select_t04209_uname.sql  update_t04209_uname.sql   图片    桌面
  1439. [oracle@station90 ~]$ vim control11c.sql
  1440. [oracle@station90 ~]$ sqlplus /nolog

  1442. SQL*Plus: Release 11.2.0.1.0 Production on Thu Sep 7 21:08:11 2017

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

  1446. SQL> conn / as sysdba
  1447. Connected.
  1448. SQL> shutdown immediate
  1449. Database closed.
  1450. Database dismounted.
  1451. ORACLE instance shut down.
  1452. SQL> startup nomount
  1453. ORACLE instance started.

  1455. Total System Global Area 6680915968 bytes
  1456. Fixed Size                    2213936 bytes
  1457. Variable Size                 3556771792 bytes
  1458. Database Buffers         3087007744 bytes
  1459. Redo Buffers                   34922496 bytes
  1460. SQL> @control11c.sql
  1461. CREATE CONTROLFILE SET DATABASE "DOG" RESETLOGS  ARCHIVELOG
  1462. *
  1463. ERROR at line 1:
  1464. ORA-01503: CREATE CONTROLFILE failed
  1465. ORA-01504: database name 'DOG' does not match parameter db_name 'orcl'


  1468. BEGIN :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('RETENTION POLICY','TO RECOVERY WINDOW OF 1 DAYS'); END;

  1470. *
  1471. ERROR at line 1:
  1472. ORA-01507: database not mounted
  1473. ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 5049
  1474. ORA-06512: at line 1


  1477. BEGIN :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('BACKUP OPTIMIZATION','ON'); END;

  1479. *
  1480. ERROR at line 1:
  1481. ORA-01507: database not mounted
  1482. ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 5049
  1483. ORA-06512: at line 1


  1486. BEGIN :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('DEFAULT DEVICE TYPE TO','''SBT_TAPE'''); END;

  1488. *
  1489. ERROR at line 1:
  1490. ORA-01507: database not mounted
  1491. ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 5049
  1492. ORA-06512: at line 1


  1495. BEGIN :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('CONTROLFILE AUTOBACKUP','ON'); END;

  1497. *
  1498. ERROR at line 1:
  1499. ORA-01507: database not mounted
  1500. ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 5049
  1501. ORA-06512: at line 1


  1504. BEGIN :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('DEVICE TYPE','DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET'); END;

  1506. *
  1507. ERROR at line 1:
  1508. ORA-01507: database not mounted
  1509. ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 5049
  1510. ORA-06512: at line 1


  1513. BEGIN :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('DEVICE TYPE','''SBT_TAPE'' PARALLELISM 2 BACKUP TYPE TO BACKUPSET'); END;

  1515. *
  1516. ERROR at line 1:
  1517. ORA-01507: database not mounted
  1518. ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 5049
  1519. ORA-06512: at line 1


  1522. BEGIN :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('CHANNEL','1 DEVICE TYPE ''SBT_TAPE'' PARMS  ''ENV=(OB_MEDIA_FAMILY=station90)'''); END;

  1524. *
  1525. ERROR at line 1:
  1526. ORA-01507: database not mounted
  1527. ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 5049
  1528. ORA-06512: at line 1


  1531. BEGIN :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('CHANNEL','2 DEVICE TYPE ''SBT_TAPE'' PARMS  ''ENV=(OB_MEDIA_FAMILY=station90)'''); END;

  1533. *
  1534. ERROR at line 1:
  1535. ORA-01507: database not mounted
  1536. ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 5049
  1537. ORA-06512: at line 1


  1540. SQL> create pfile='/home/oracle/initdog.ora'  from spfile;

  1542. File created.

  1544. SQL> exit
  1545. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
  1546. With the Partitioning, OLAP, Data Mining and Real Application Testing options
  1547. [oracle@station90 ~]$ sqlplus /nolog

  1549. SQL*Plus: Release 11.2.0.1.0 Production on Thu Sep 7 21:09:40 2017

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

  1553. SQL> conn / as sysdba
  1554. Connected.
  1555. SQL> shutdown immediate
  1556. ORA-01507: database not mounted


  1559. ORACLE instance shut down.
  1560. SQL> exit
  1561. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
  1562. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
  1563. and Real Application Testing options
  1564. [oracle@station90 ~]$ exit
  1565. logout
  1566. [root@station90 tmp]# vim /etc/oratab
  1567. [root@station90 tmp]# su -  oracle
  1568. [oracle@station90 ~]$ . oraenv
  1569. ORACLE_SID = [orcl] ? dog
  1570. The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
  1571. [oracle@station90 ~]$ ls
  1572. control10d-after.sql  create_t04209_uname.sql  osb.txt            select_t04209_uname.sql   update_t04209_uname.sql  图片  桌面
  1573. control11b.sql        initdog.ora              rac_tns            tnsnames.ora              公共的                   文档
  1574. control11c.sql        mail                     rcat.sql           ttio.rcv                  模板                     下载
  1575. copytape-root.sh      oradiag_oracle           revertape-root.sh  update2_t04209_uname.sql  视频                     音乐
  1576. [oracle@station90 ~]$ vim initdog.ora
  1577. [oracle@station90 ~]$ sqlplus /nolog

  1579. SQL*Plus: Release 11.2.0.1.0 Production on Thu Sep 7 21:11:08 2017

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

  1583. SQL> conn / as sysdba
  1584. Connected to an idle instance.
  1585. SQL> create spfile from pfile='/home/oracle/initdog.ora' ;

  1587. File created.

  1589. SQL> startup nomount
  1590. ORACLE instance started.

  1592. Total System Global Area 6680915968 bytes
  1593. Fixed Size                    2213936 bytes
  1594. Variable Size                 3556771792 bytes
  1595. Database Buffers         3087007744 bytes
  1596. Redo Buffers                   34922496 bytes
  1597. SQL> @control11c.sql
  1598. CREATE CONTROLFILE SET DATABASE "DOG" RESETLOGS  ARCHIVELOG
  1599. *
  1600. ERROR at line 1:
  1601. ORA-01503: CREATE CONTROLFILE failed
  1602. ORA-00200: control file could not be created
  1603. ORA-00202: control file: '+DATA/orcl/controlfile/current.260.954103283'
  1604. ORA-17502: ksfdcre:4 Failed to create file
  1605. +DATA/orcl/controlfile/current.260.954103283
  1606. ORA-15046: ASM file name '+DATA/orcl/controlfile/current.260.954103283' is not
  1607. in single-file creation form


  1610. BEGIN :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('RETENTION POLICY','TO RECOVERY WINDOW OF 1 DAYS'); END;

  1612. *
  1613. ERROR at line 1:
  1614. ORA-01507: database not mounted
  1615. ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 5049
  1616. ORA-06512: at line 1


  1619. BEGIN :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('BACKUP OPTIMIZATION','ON'); END;

  1621. *
  1622. ERROR at line 1:
  1623. ORA-01507: database not mounted
  1624. ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 5049
  1625. ORA-06512: at line 1


  1628. BEGIN :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('DEFAULT DEVICE TYPE TO','''SBT_TAPE'''); END;

  1630. *
  1631. ERROR at line 1:
  1632. ORA-01507: database not mounted
  1633. ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 5049
  1634. ORA-06512: at line 1


  1637. BEGIN :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('CONTROLFILE AUTOBACKUP','ON'); END;

  1639. *
  1640. ERROR at line 1:
  1641. ORA-01507: database not mounted
  1642. ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 5049
  1643. ORA-06512: at line 1


  1646. BEGIN :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('DEVICE TYPE','DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET'); END;

  1648. *
  1649. ERROR at line 1:
  1650. ORA-01507: database not mounted
  1651. ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 5049
  1652. ORA-06512: at line 1


  1655. BEGIN :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('DEVICE TYPE','''SBT_TAPE'' PARALLELISM 2 BACKUP TYPE TO BACKUPSET'); END;

  1657. *
  1658. ERROR at line 1:
  1659. ORA-01507: database not mounted
  1660. ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 5049
  1661. ORA-06512: at line 1


  1664. BEGIN :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('CHANNEL','1 DEVICE TYPE ''SBT_TAPE'' PARMS  ''ENV=(OB_MEDIA_FAMILY=station90)'''); END;

  1666. *
  1667. ERROR at line 1:
  1668. ORA-01507: database not mounted
  1669. ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 5049
  1670. ORA-06512: at line 1


  1673. BEGIN :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('CHANNEL','2 DEVICE TYPE ''SBT_TAPE'' PARMS  ''ENV=(OB_MEDIA_FAMILY=station90)'''); END;

  1675. *
  1676. ERROR at line 1:
  1677. ORA-01507: database not mounted
  1678. ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 5049
  1679. ORA-06512: at line 1


  1682. SQL> exit
  1683. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
  1684. With the Partitioning, OLAP, Data Mining and Real Application Testing options
  1685. [oracle@station90 ~]$ sqlplus /nolog

  1687. SQL*Plus: Release 11.2.0.1.0 Production on Thu Sep 7 21:12:36 2017

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

  1691. SQL> conn / as sysdba
  1692. Connected.
  1693. SQL> shutdown immediate
  1694. ORA-01507: database not mounted


  1697. ORACLE instance shut down.
  1698. SQL> exit
  1699. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
  1700. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
  1701. and Real Application Testing options
  1702. [oracle@station90 ~]$ ls
  1703. control10d-after.sql  create_t04209_uname.sql  osb.txt            select_t04209_uname.sql   update_t04209_uname.sql  图片  桌面
  1704. control11b.sql        initdog.ora              rac_tns            tnsnames.ora              公共的                   文档
  1705. control11c.sql        mail                     rcat.sql           ttio.rcv                  模板                     下载
  1706. copytape-root.sh      oradiag_oracle           revertape-root.sh  update2_t04209_uname.sql  视频                     音乐
  1707. [oracle@station90 ~]$ vim initdog.ora
  1708. [oracle@station90 ~]$ sqlplus /nolog

  1710. SQL*Plus: Release 11.2.0.1.0 Production on Thu Sep 7 21:13:30 2017

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

  1714. SQL> conn / as sysdba
  1715. Connected to an idle instance.
  1716. SQL> create spfile from pfile='/home/oracle/initdog.ora' ;

  1718. File created.

  1720. SQL> startup nomount
  1721. ORACLE instance started.

  1723. Total System Global Area 6680915968 bytes
  1724. Fixed Size                    2213936 bytes
  1725. Variable Size                 3556771792 bytes
  1726. Database Buffers         3087007744 bytes
  1727. Redo Buffers                   34922496 bytes
  1728. SQL> @control11c.sql

  1730. Control file created.


  1733. PL/SQL procedure successfully completed.


  1736. PL/SQL procedure successfully completed.


  1739. PL/SQL procedure successfully completed.


  1742. PL/SQL procedure successfully completed.


  1745. PL/SQL procedure successfully completed.


  1748. PL/SQL procedure successfully completed.


  1751. PL/SQL procedure successfully completed.


  1754. PL/SQL procedure successfully completed.

  1756. SQL> alter database open ;
  1757. alter database open
  1758. *
  1759. ERROR at line 1:
  1760. ORA-01589: must use RESETLOGS or NORESETLOGS option for database open


  1763. SQL> alter database open  resetlogs;

  1765. Database altered.

  1767. SQL> select  name , dbid from v$database;

  1769. NAME                DBID
  1770. --------- ----------
  1771. DOG          1343950367

  1773. SQL> shutdown immediate
  1774. Database closed.
  1775. Database dismounted.
  1776. ORACLE instance shut down.
  1777. SQL> exit
  1778. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
  1779. With the Partitioning, OLAP, Data Mining and Real Application Testing options
  1780. [oracle@station90 ~]$ ls
  1781. control10d-after.sql  create_t04209_uname.sql  osb.txt            select_t04209_uname.sql   update_t04209_uname.sql  图片  桌面
  1782. control11b.sql        initdog.ora              rac_tns            tnsnames.ora              公共的                   文档
  1783. control11c.sql        mail                     rcat.sql           ttio.rcv                  模板                     下载
  1784. copytape-root.sh      oradiag_oracle           revertape-root.sh  update2_t04209_uname.sql  视频                     音乐
  1785. [oracle@station90 ~]$ mv initdog.ora initorcl.ora
  1786. [oracle@station90 ~]$ ls
  1787. control10d-after.sql  create_t04209_uname.sql  osb.txt            select_t04209_uname.sql   update_t04209_uname.sql  图片  桌面
  1788. control11b.sql        initorcl.ora             rac_tns            tnsnames.ora              公共的                   文档
  1789. control11c.sql        mail                     rcat.sql           ttio.rcv                  模板                     下载
  1790. copytape-root.sh      oradiag_oracle           revertape-root.sh  update2_t04209_uname.sql  视频                     音乐
  1791. [oracle@station90 ~]$ vim initorcl.ora
  1792. [oracle@station90 ~]$ vim initorcl.ora
  1793. [oracle@station90 ~]$ . oraenv
  1794. ORACLE_SID = [dog] ? orcl
  1795. The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
  1796. [oracle@station90 ~]$ sqlplus /nolog

  1798. SQL*Plus: Release 11.2.0.1.0 Production on Thu Sep 7 21:17:30 2017

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

  1802. SQL> conn / as sysdba
  1803. Connected to an idle instance.
  1804. SQL> startup pfile='/home/oracle/initorcl.ora'  nomount
  1805. ORACLE instance started.

  1807. Total System Global Area 6680915968 bytes
  1808. Fixed Size                    2213936 bytes
  1809. Variable Size                 3556771792 bytes
  1810. Database Buffers         3087007744 bytes
  1811. Redo Buffers                   34922496 bytes
  1812. SQL> exit
  1813. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
  1814. With the Partitioning, OLAP, Data Mining and Real Application Testing options
  1815. [oracle@station90 ~]$ ls
  1816. control10d-after.sql  create_t04209_uname.sql  osb.txt            select_t04209_uname.sql   update_t04209_uname.sql  图片  桌面
  1817. control11b.sql        initorcl.ora             rac_tns            tnsnames.ora              公共的                   文档
  1818. control11c.sql        mail                     rcat.sql           ttio.rcv                  模板                     下载
  1819. copytape-root.sh      oradiag_oracle           revertape-root.sh  update2_t04209_uname.sql  视频                     音乐
  1820. [oracle@station90 ~]$ vim control11c.sql
  1821. [oracle@station90 ~]$ sqlplus /nolog

  1823. SQL*Plus: Release 11.2.0.1.0 Production on Thu Sep 7 21:18:42 2017

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

  1827. SQL> conn / aS SYSDBA
  1828. Connected.
  1829. SQL> @control11c.sql

  1831. Control file created.


  1834. PL/SQL procedure successfully completed.


  1837. PL/SQL procedure successfully completed.


  1840. PL/SQL procedure successfully completed.


  1843. PL/SQL procedure successfully completed.


  1846. PL/SQL procedure successfully completed.


  1849. PL/SQL procedure successfully completed.


  1852. PL/SQL procedure successfully completed.


  1855. PL/SQL procedure successfully completed.

  1857. SQL> alter database open resetlogs;

  1859. Database altered.

  1861. SQL> select  file_name , status from dba_temp_files;

  1863. no rows selected

  1865. SQL> alter tablespace temp add tempfile '+data' size 30M autoextend on ;

  1867. Tablespace altered.

  1869. SQL> select  name , db_id from v$database;
  1870. select        name , db_id from v$database
  1871.                *
  1872. ERROR at line 1:
  1873. ORA-00904: "DB_ID": invalid identifier


  1876. SQL> select  name , dbid from v$database;

  1878. NAME                DBID
  1879. --------- ----------
  1880. ORCL          1343950367

  1882. SQL> exit
  1883. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
  1884. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
  1885. and Real Application Testing options
  1886. [oracle@station90 ~]$ exit
  1887. logout
  1888. [root@station90 tmp]# vim /etc/oratab
  1889. [root@station90 tmp]# su - oracle
  1890. [oracle@station90 ~]$ ls
  1891. control10d-after.sql  create_t04209_uname.sql  osb.txt            select_t04209_uname.sql   update_t04209_uname.sql  图片  桌面
  1892. control11b.sql        initorcl.ora             rac_tns            tnsnames.ora              公共的                   文档
  1893. control11c.sql        mail                     rcat.sql           ttio.rcv                  模板                     下载
  1894. copytape-root.sh      oradiag_oracle           revertape-root.sh  update2_t04209_uname.sql  视频                     音乐
  1895. [oracle@station90 ~]$ sqlplus /nolog

  1897. SQL*Plus: Release 11.2.0.1.0 Production on Thu Sep 7 21:21:31 2017

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

  1901. SQL> exit
  1902. [oracle@station90 ~]$ . oraenv
  1903. ORACLE_SID = [orcl] ?
  1904. The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
  1905. [oracle@station90 ~]$ sqlplus /nolog

  1907. SQL*Plus: Release 11.2.0.1.0 Production on Thu Sep 7 21:21:45 2017

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

  1911. SQL> conn / as sysdba
  1912. Connected.
  1913. SQL> shutdown immediate
  1914. Database closed.
  1915. Database dismounted.
  1916. ORACLE instance shut down.
  1917. SQL> startup  mount
  1918. ORACLE instance started.

  1920. Total System Global Area 6680915968 bytes
  1921. Fixed Size                    2213936 bytes
  1922. Variable Size                 3556771792 bytes
  1923. Database Buffers         3087007744 bytes
  1924. Redo Buffers                   34922496 bytes
  1925. Database mounted.
  1926. SQL> exit
  1927. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
  1928. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
  1929. and Real Application Testing options
  1930. [oracle@station90 ~]$ nid

  1932. DBNEWID: Release 11.2.0.1.0 - Production on Thu Sep 7 21:22:27 2017

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

  1936. Keyword     Description                    (Default)
  1937. ----------------------------------------------------
  1938. TARGET      Username/Password              (NONE)
  1939. DBNAME      New database name              (NONE)
  1940. LOGFILE     Output Log                     (NONE)
  1941. REVERT      Revert failed change           NO
  1942. SETNAME     Set a new database name only   NO
  1943. APPEND      Append to output log           NO
  1944. HELP        Displays these messages        NO

  1946. [oracle@station90 ~]$ nid target=sys/oracle_4U  DBNAME=cat

  1948. DBNEWID: Release 11.2.0.1.0 - Production on Thu Sep 7 21:23:15 2017

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

  1952. Connected to database ORCL (DBID=1343950367)

  1954. Connected to server version 11.2.0

  1956. Control Files in database:
  1957.     +DATA/orcl/controlfile/current.260.954103283
  1958.     +FRA/orcl/controlfile/current.256.954103283


  1961. Cannot read the header of the following datafiles:
  1962.     +DATA/orcl/datafile/system.256.81616955 (1), error: 14
  1963.     +DATA/orcl/datafile/sysaux.257.81616955 (2), error: 14
  1964.     +DATA/orcl/datafile/undotbs1.258.81616955 (3), error: 14
  1965.     +DATA/orcl/datafile/users.259.81616955 (4), error: 14
  1966.     +DATA/orcl/datafile/example.265.81616965 (5), error: 14

  1968. NID-00137: All datafiles that are not dropped should be readable


  1971. Change of database name failed during validation - database is intact.
  1972. DBNEWID - Completed with validation errors.

  1974. [oracle@station90 ~]$ sqlplus /nolog

  1976. SQL*Plus: Release 11.2.0.1.0 Production on Thu Sep 7 21:24:45 2017

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

  1980. SQL> conn / as sysdbas
  1981. SP2-0306: Invalid option.
  1982. Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM}] [edition=value]]
  1983. where <logon> ::= <username>[/<password>][@<connect_identifier>]
  1984.       <proxy> ::= <proxyuser>[<username>][/<password>][@<connect_identifier>]
  1985. SQL> conn / as sysdba
  1986. Connected.
  1987. SQL> alter database open ;
  1988. alter database open
  1989. *
  1990. ERROR at line 1:
  1991. ORA-01190: control file or data file 1 is from before the last RESETLOGS
  1992. ORA-01110: data file 1: '+DATA/orcl/datafile/system.256.816169553'


  1995. SQL> alter database open resetlogs;
  1996. alter database open resetlogs
  1997. *
  1998. ERROR at line 1:
  1999. ORA-01139: RESETLOGS option only valid after an incomplete database recovery


  2002. SQL> recover database ;
  2003. ORA-00283: recovery session canceled due to errors
  2004. ORA-19909: datafile 1 belongs to an orphan incarnation
  2005. ORA-01110: data file 1: '+DATA/orcl/datafile/system.256.816169553'


  2008. SQL> shutdown immediate
  2009. ORA-01109: database not open


  2012. Database dismounted.
  2013. ORACLE instance shut down.
  2014. SQL> startup
  2015. ORACLE instance started.

  2017. Total System Global Area 6680915968 bytes
  2018. Fixed Size                    2213936 bytes
  2019. Variable Size                 3556771792 bytes
  2020. Database Buffers         3087007744 bytes
  2021. Redo Buffers                   34922496 bytes
  2022. [oracle@station90 ~]$ sqlplus /nolog

  2024. SQL*Plus: Release 11.2.0.1.0 Production on Thu Sep 7 21:28:44 2017

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

  2028. SQL> conn / as sysdba
  2029. Connected to an idle instance.
  2030. SQL> create spfile='+data/orcl/spfileorcl.ora' from pfile='/home/oracle/initorcl.ora';

  2032. File created.

  2034. SQL> startup
  2035. ORACLE instance started.

  2037. Total System Global Area 6680915968 bytes
  2038. Fixed Size                    2213936 bytes
  2039. Variable Size                 3556771792 bytes
  2040. Database Buffers         3087007744 bytes
  2041. Redo Buffers                   34922496 bytes
  2042. Database mounted.
  2043. Database opened.
  2044. SQL> shutdown immediate
  2045. Database closed.
  2046. Database dismounted.
  2047. ORACLE instance shut down.
  2048. SQL> startup mount
  2049. ORA-01078: failure in processing system parameters
  2050. ORA-01565: error in identifying file '+DATA/orcl/spfileorcl.ora'
  2051. ORA-17503: ksfdopn:2 Failed to open file +DATA/orcl/spfileorcl.ora
  2052. ORA-15056: additional error message
  2053. ORA-17503: ksfdopn:DGOpenFile05 Failed to open file +DATA/orcl/spfileorcl.ora
  2054. ORA-17503: ksfdopn:2 Failed to open file +DATA/orcl/spfileorcl.ora
  2055. ORA-15173: entry 'spfileorcl.ora' does not exist in directory 'orcl'
  2056. ORA-06512: at line 4
  2057. SQL> exit
  2058. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
  2059. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
  2060. and Real Application Testing options
  2061. [oracle@station90 ~]$ sqlplus /nolog

  2063. SQL*Plus: Release 11.2.0.1.0 Production on Thu Sep 7 21:30:55 2017

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

  2067. SQL> conn / as sysdba
  2068. Connected to an idle instance.
  2069. SQL> startup mount
  2070. ORA-01078: failure in processing system parameters
  2071. ORA-01565: error in identifying file '+DATA/orcl/spfileorcl.ora'
  2072. ORA-17503: ksfdopn:2 Failed to open file +DATA/orcl/spfileorcl.ora
  2073. ORA-15056: additional error message
  2074. ORA-17503: ksfdopn:DGOpenFile05 Failed to open file +DATA/orcl/spfileorcl.ora
  2075. ORA-17503: ksfdopn:2 Failed to open file +DATA/orcl/spfileorcl.ora
  2076. ORA-15173: entry 'spfileorcl.ora' does not exist in directory 'orcl'
  2077. ORA-06512: at line 4
  2078. SQL> create spfile='+DATA/orcl/spfileorcl.ora'  from pfile='/home/oracle/initorcl.ora';

  2080. File created.

  2082. SQL> startup mount
  2083. ORACLE instance started.

  2085. Total System Global Area 6680915968 bytes
  2086. Fixed Size                    2213936 bytes
  2087. Variable Size                 3556771792 bytes
  2088. Database Buffers         3087007744 bytes
  2089. Redo Buffers                   34922496 bytes
  2090. Database mounted.
  2091. SQL> exit
  2092. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
  2093. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
  2094. and Real Application Testing options
  2095. [oracle@station90 ~]$ nid target=sys/oracle_4U  DBNAME=cat

  2097. DBNEWID: Release 11.2.0.1.0 - Production on Thu Sep 7 21:32:08 2017

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

  2101. Connected to database ORCL (DBID=1343950367)

  2103. Connected to server version 11.2.0

  2105. Control Files in database:
  2106.     +DATA/orcl/controlfile/current.273.954105535
  2107.     +FRA/orcl/controlfile/current.286.954105535

  2109. Change database ID and database name ORCL to CAT? (Y/[N]) => Y

  2111. Proceeding with operation
  2112. Changing database ID from 1343950367 to 766562648
  2113. Changing database name from ORCL to CAT
  2114.     Control File +DATA/orcl/controlfile/current.273.954105535 - modified
  2115.     Control File +FRA/orcl/controlfile/current.286.954105535 - modified
  2116.     Datafile +DATA/orcl/datafile/system.256.81616955 - dbid changed, wrote new name
  2117.     Datafile +DATA/orcl/datafile/sysaux.257.81616955 - dbid changed, wrote new name
  2118.     Datafile +DATA/orcl/datafile/undotbs1.258.81616955 - dbid changed, wrote new name
  2119.     Datafile +DATA/orcl/datafile/users.259.81616955 - dbid changed, wrote new name
  2120.     Datafile +DATA/orcl/datafile/example.265.81616965 - dbid changed, wrote new name
  2121.     Datafile +DATA/orcl/tempfile/temp.277.95410557 - dbid changed, wrote new name
  2122.     Control File +DATA/orcl/controlfile/current.273.954105535 - dbid changed, wrote new name
  2123.     Control File +FRA/orcl/controlfile/current.286.954105535 - dbid changed, wrote new name
  2124.     Instance shut down

  2126. Database name changed to CAT.
  2127. Modify parameter file and generate a new password file before restarting.
  2128. Database ID for database CAT changed to 766562648.
  2129. All previous backups and archived redo logs for this database are unusable.
  2130. Database is not aware of previous backups and archived logs in Recovery Area.
  2131. Database has been shutdown, open database with RESETLOGS option.
  2132. Succesfully changed database name and ID.
  2133. DBNEWID - Completed succesfully.

  2135. [oracle@station90 ~]$ sqlplus /nolog

  2137. SQL*Plus: Release 11.2.0.1.0 Production on Thu Sep 7 21:32:56 2017

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

  2141. SQL> conn / as sysdba
  2142. Connected to an idle instance.
  2143. SQL> exit
  2144. Disconnected
  2145. [oracle@station90 ~]$ ls
  2146. control10d-after.sql  create_t04209_uname.sql  osb.txt            select_t04209_uname.sql   update_t04209_uname.sql  图片  桌面
  2147. control11b.sql        initorcl.ora             rac_tns            tnsnames.ora              公共的                   文档
  2148. control11c.sql        mail                     rcat.sql           ttio.rcv                  模板                     下载
  2149. copytape-root.sh      oradiag_oracle           revertape-root.sh  update2_t04209_uname.sql  视频                     音乐
  2150. [oracle@station90 ~]$ mv initorcl.ora initcat.ora
  2151. [oracle@station90 ~]$ ls
  2152. control10d-after.sql  create_t04209_uname.sql  osb.txt            select_t04209_uname.sql   update_t04209_uname.sql  图片  桌面
  2153. control11b.sql        initcat.ora              rac_tns            tnsnames.ora              公共的                   文档
  2154. control11c.sql        mail                     rcat.sql           ttio.rcv                  模板                     下载
  2155. copytape-root.sh      oradiag_oracle           revertape-root.sh  update2_t04209_uname.sql  视频                     音乐
  2156. [oracle@station90 ~]$ vim initcat.ora
  2157. [oracle@station90 ~]$ sqlplus /nolog

  2159. SQL*Plus: Release 11.2.0.1.0 Production on Thu Sep 7 21:33:54 2017

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

  2163. SQL> conn / as sysdba
  2164. Connected to an idle instance.
  2165. SQL> exit
  2166. Disconnected
  2167. [oracle@station90 ~]$ . oraenv
  2168. ORACLE_SID = [orcl] ? cat
  2169. The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
  2170. [oracle@station90 ~]$ sqlplus /nolog

  2172. SQL*Plus: Release 11.2.0.1.0 Production on Thu Sep 7 21:34:09 2017

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

  2176. SQL> conn / as sysdba
  2177. Connected to an idle instance.
  2178. SQL> startup
  2179. ORA-01078: failure in processing system parameters
  2180. LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/initcat.ora'
  2181. SQL> conn / as sysdba
  2182. Connected to an idle instance.
  2183. SQL> startup pfile='/home/oracle/initcat.ora'
  2184. ORACLE instance started.

  2186. Total System Global Area 6680915968 bytes
  2187. Fixed Size                    2213936 bytes
  2188. Variable Size                 3556771792 bytes
  2189. Database Buffers         3087007744 bytes
  2190. Redo Buffers                   34922496 bytes
  2191. Database mounted.
  2192. ORA-01589: must use RESETLOGS or NORESETLOGS option for database open


  2195. SQL> alter database open resetlogs;

  2197. Database altered.

  2199. SQL> select  name, dbid from v$database;

  2201. NAME                DBID
  2202. --------- ----------
  2203. CAT           766562648

  2205. SQL> select file_name , status from dba_temp_files;

  2207. FILE_NAME
  2208. --------------------------------------------------------------------------------
  2209. STATUS
  2210. -------
  2211. +DATA/orcl/tempfile/temp.277.954105579
  2212. ONLINE


  2215. SQL> shutdown immediate
  2216. Database closed.
  2217. Database dismounted.
  2218. ORACLE instance shut down.
  2219. SQL> startup pfile='/home/oracle/initcat.ora'  mount
  2220. ORACLE instance started.

  2222. Total System Global Area 6680915968 bytes
  2223. Fixed Size                    2213936 bytes
  2224. Variable Size                 3556771792 bytes
  2225. Database Buffers         3087007744 bytes
  2226. Redo Buffers                   34922496 bytes
  2227. Database mounted.
  2228. SQL> exit
  2229. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
  2230. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
  2231. and Real Application Testing options
  2232. [oracle@station90 ~]$ nid target=sys/oracle_4U  DBNAME=orcl

  2234. DBNEWID: Release 11.2.0.1.0 - Production on Thu Sep 7 21:36:52 2017

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

  2238. Connected to database CAT (DBID=766562648)

  2240. Connected to server version 11.2.0

  2242. Control Files in database:
  2243.     +DATA/orcl/controlfile/current.273.954105535
  2244.     +FRA/orcl/controlfile/current.286.954105535

  2246. Change database ID and database name CAT to ORCL? (Y/[N]) => Y

  2248. Proceeding with operation
  2249. Changing database ID from 766562648 to 1481917044
  2250. Changing database name from CAT to ORCL
  2251.     Control File +DATA/orcl/controlfile/current.273.954105535 - modified
  2252.     Control File +FRA/orcl/controlfile/current.286.954105535 - modified
  2253.     Datafile +DATA/orcl/datafile/system.256.81616955 - dbid changed, wrote new name
  2254.     Datafile +DATA/orcl/datafile/sysaux.257.81616955 - dbid changed, wrote new name
  2255.     Datafile +DATA/orcl/datafile/undotbs1.258.81616955 - dbid changed, wrote new name
  2256.     Datafile +DATA/orcl/datafile/users.259.81616955 - dbid changed, wrote new name
  2257.     Datafile +DATA/orcl/datafile/example.265.81616965 - dbid changed, wrote new name
  2258.     Datafile +DATA/orcl/tempfile/temp.277.95410557 - dbid changed, wrote new name
  2259.     Control File +DATA/orcl/controlfile/current.273.954105535 - dbid changed, wrote new name
  2260.     Control File +FRA/orcl/controlfile/current.286.954105535 - dbid changed, wrote new name
  2261.     Instance shut down

  2263. Database name changed to ORCL.
  2264. Modify parameter file and generate a new password file before restarting.
  2265. Database ID for database ORCL changed to 1481917044.
  2266. All previous backups and archived redo logs for this database are unusable.
  2267. Database is not aware of previous backups and archived logs in Recovery Area.
  2268. Database has been shutdown, open database with RESETLOGS option.
  2269. Succesfully changed database name and ID.
  2270. DBNEWID - Completed succesfully.

  2272. [oracle@station90 ~]$ ls
  2273. control10d-after.sql  create_t04209_uname.sql  osb.txt            select_t04209_uname.sql   update_t04209_uname.sql  图片  桌面
  2274. control11b.sql        initcat.ora              rac_tns            tnsnames.ora              公共的                   文档
  2275. control11c.sql        mail                     rcat.sql           ttio.rcv                  模板                     下载
  2276. copytape-root.sh      oradiag_oracle           revertape-root.sh  update2_t04209_uname.sql  视频                     音乐
  2277. [oracle@station90 ~]$ sqlplus /nolog

  2279. SQL*Plus: Release 11.2.0.1.0 Production on Thu Sep 7 21:37:19 2017

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

  2283. SQL> conn / as sysdba
  2284. Connected to an idle instance.
  2285. SQL> startup
  2286. ORA-01078: failure in processing system parameters
  2287. LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/initcat.ora'
  2288. SQL> exit
  2289. Disconnected
  2290. [oracle@station90 ~]$ . oraenv
  2291. ORACLE_SID = [cat] ? orcl
  2292. The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
  2293. [oracle@station90 ~]$ sqlplus /nolog

  2295. SQL*Plus: Release 11.2.0.1.0 Production on Thu Sep 7 21:37:35 2017

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

  2299. SQL> conn / as sysdba
  2300. Connected to an idle instance.
  2301. SQL> startup
  2302. ORACLE instance started.

  2304. Total System Global Area 6680915968 bytes
  2305. Fixed Size                    2213936 bytes
  2306. Variable Size                 3556771792 bytes
  2307. Database Buffers         3087007744 bytes
  2308. Redo Buffers                   34922496 bytes
  2309. Database mounted.
  2310. ORA-01589: must use RESETLOGS or NORESETLOGS option for database open


  2313. SQL> alter database open resetlogs;

  2315. Database altered.

  2317. SQL> select  name , dbid from v$database;

  2319. NAME                DBID
  2320. --------- ----------
  2321. ORCL          1481917044

  2323. SQL>
复制代码


回复

使用道具 举报

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

本版积分规则

QQ|手机版|Bo's Oracle Station   

GMT+8, 2024-4-19 14:53 , Processed in 0.049688 second(s), 27 queries .

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