联系：QQ(5163721)
标题：ADG备库由于控制文件，归档损坏等原因，不能switchover，failover和active standby database时
作者：Lunar©版权所有[文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.]
昨天损坏的备库，今天准备激活，然后做升级测试。
备库由于归档损坏，已经不能用常规手段switchover和failover，甚至直接激活也不能：
[oracle@lunardb3 trace]$ ss
SQL*Plus: Release 11.2.0.1.0 Production on Wed Apr 15 17:25:08 2015
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
17:25:08 SYS@ lunardb3> recover managed standby database cancel;
ORA-16136: Managed Standby Recovery not active
17:27:11 SYS@ lunardb3> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH FORCE;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH FORCE
*
ERROR at line 1:
ORA-00283: recovery session canceled due to errors
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 2048 change 6194107977662 time 04/13/2015 12:28:54
ORA-00334: archived log: '/u01/oradata/1_775046_804791836.arc'
Elapsed: 00:00:06.26
17:27:31 SYS@ lunardb3> alter database recover managed standby database finish skip standby logfile;
alter database recover managed standby database finish skip standby logfile
*
ERROR at line 1:
ORA-00274: illegal recovery option SKIP STANDBY LOGFILE is an invalid option on RECOVER FINISH
Elapsed: 00:00:00.00
17:27:59 SYS@ lunardb3> SELECT THREAD#, LOW_SEQUENCE#, HIGH_SEQUENCE# FROM V$ARCHIVE_GAP;
no rows selected
Elapsed: 00:00:17.19
17:28:34 SYS@ lunardb3> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;
ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY
*
ERROR at line 1:
ORA-16139: media recovery required
Elapsed: 00:00:00.01
17:28:37 SYS@ lunardb3> recover standby database until cancel;
ORA-00279: change 6194107977643 generated at 04/13/2015 12:28:54 needed for thread 1
ORA-00289: suggestion : /u01/oradata/arch/1_775046_804791836.arc
ORA-00280: change 6194107977643 for thread 1 is in sequence #775046
17:29:22 Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
ORA-10879: error signaled in parallel recovery slave
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/u01/oradata/lunar/system01.dbf'
17:29:37 SYS@ lunardb3> recover standby database until cancel;
ORA-00279: change 6194107977643 generated at 04/13/2015 12:28:54 needed for thread 1
ORA-00289: suggestion : /u01/oradata/arch/1_775046_804791836.arc
ORA-00280: change 6194107977643 for thread 1 is in sequence #775046
17:29:45 Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00283: recovery session canceled due to errors
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 2048 change 6194107977662 time 04/13/2015 12:28:54
ORA-00334: archived log: '/u01/oradata/arch/1_775046_804791836.arc'
ORA-01112: media recovery not started
17:29:48 SYS@ lunardb3> alter database activate standby database;
alter database activate standby database
*
ERROR at line 1:
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/u01/oradata/lunar/system01.dbf'
Elapsed: 00:00:02.14
17:30:00 SYS@ lunardb3>
重启数据库后，重建控制文件，然后open resetlogs：
17:30:00 SYS@ lunardb3> shutdown immediate ORA-01109: database not open Database dismounted. ORACLE instance shut down. 17:32:48 SYS@ lunardb3> STARTUP NOMOUNT ORACLE instance started. Total System Global Area 1.7103E+10 bytes Fixed Size 2220200 bytes Variable Size 2281705304 bytes Database Buffers 1.4764E+10 bytes Redo Buffers 55287808 bytes 17:32:57 SYS@ lunardb3> CREATE CONTROLFILE REUSE DATABASE "lunar" RESETLOGS FORCE LOGGING ARCHIVELOG 17:33:16 2 MAXLOGFILES 80 17:33:16 3 MAXLOGMEMBERS 3 17:33:16 4 MAXDATAFILES 2048 17:33:16 5 MAXINSTANCES 8 17:33:17 6 MAXLOGHISTORY 18688 17:33:17 7 LOGFILE 17:33:17 8 GROUP 1 '/u01/oradata/lunar/redo01.log' SIZE 400M BLOCKSIZE 512, 17:33:17 9 GROUP 2 '/u01/oradata/lunar/redo02.log' SIZE 400M BLOCKSIZE 512, 17:33:17 10 GROUP 3 '/u01/oradata/lunar/redo03.log' SIZE 400M BLOCKSIZE 512, 17:33:17 11 GROUP 4 '/u01/oradata/lunar/redo04.log' SIZE 400M BLOCKSIZE 512, 17:33:17 12 GROUP 5 '/u01/oradata/lunar/redo05.log' SIZE 400M BLOCKSIZE 512, 17:33:17 13 GROUP 6 '/u01/oradata/lunar/redo06.log' SIZE 400M BLOCKSIZE 512, 17:33:17 14 GROUP 7 '/u01/oradata/lunar/redo07.log' SIZE 400M BLOCKSIZE 512, 17:33:17 15 GROUP 8 '/u01/oradata/lunar/redo08.log' SIZE 400M BLOCKSIZE 512, 17:33:17 16 GROUP 50 '/u01/oradata/lunar/redo50.log' SIZE 400M BLOCKSIZE 512, 17:33:17 17 GROUP 51 '/u01/oradata/lunar/redo51.log' SIZE 400M BLOCKSIZE 512, 17:33:17 18 GROUP 52 '/u01/oradata/lunar/redo52.log' SIZE 400M BLOCKSIZE 512, 17:33:17 19 GROUP 53 '/u01/oradata/lunar/redo53.log' SIZE 400M BLOCKSIZE 512, 17:33:17 20 GROUP 54 '/u01/oradata/lunar/redo54.log' SIZE 400M BLOCKSIZE 512, 17:33:17 21 GROUP 55 '/u01/oradata/lunar/redo55.log' SIZE 400M BLOCKSIZE 512, 17:33:17 22 GROUP 56 '/u01/oradata/lunar/redo56.log' SIZE 400M BLOCKSIZE 512, 17:33:18 23 GROUP 57 '/u01/oradata/lunar/redo57.log' SIZE 400M BLOCKSIZE 512 17:33:18 24 -- STANDBY LOGFILE 17:33:18 25 -- GROUP 9 '/u01/oradata/lunar/stdb_redo01.log' SIZE 400M BLOCKSIZE 512, 17:33:18 26 -- GROUP 10 '/u01/oradata/lunar/stdb_redo02.log' SIZE 400M BLOCKSIZE 512, 17:33:18 27 -- GROUP 11 '/u01/oradata/lunar/stdb_redo03.log' SIZE 400M BLOCKSIZE 512, 17:33:18 28 -- GROUP 12 '/u01/oradata/lunar/stdb_redo04.log' SIZE 400M BLOCKSIZE 512, 17:33:18 29 -- GROUP 13 '/u01/oradata/lunar/stdb_redo05.log' SIZE 400M BLOCKSIZE 512, 17:33:18 30 -- GROUP 14 '/u01/oradata/lunar/stdb_redo06.log' SIZE 400M BLOCKSIZE 512, 17:33:18 31 -- GROUP 15 '/u01/oradata/lunar/stdb_redo07.log' SIZE 400M BLOCKSIZE 512 17:33:18 32 DATAFILE 17:33:18 33 '/u01/oradata/lunar/system01.dbf', 17:33:18 34 '/u01/oradata/lunar/sysaux01.dbf', 17:33:18 35 '/u01/oradata/lunar/undotbs01.dbf', 17:33:18 36 '/u01/oradata/lunar/users01.dbf', 17:33:18 37 '/u01/oradata/lunar/undotbs02.dbf', 17:33:18 38 '/u01/oradata/lunar/undotbs03.dbf', 17:33:18 39 '/u01/oradata/lunar/undotbs04.dbf', 17:33:19 40 '/u01/oradata/lunar/lunar_dat_01.dbf', 17:33:19 41 '/u01/oradata/lunar/lunar_idx_01.dbf', 17:33:19 42 '/u01/oradata/lunar/lunar_dat_02.dbf', 17:33:19 43 '/u01/oradata/lunar/lunar_dat_03.dbf', 17:33:19 44 '/u01/oradata/lunar/lunar_dat_04.dbf', 17:33:19 45 '/u01/oradata/lunar/lunar_dat_05.dbf', 17:33:19 46 '/u01/oradata/lunar/lunar_dat_06.dbf', 17:33:19 47 '/u01/oradata/lunar/lunar_dat_07.dbf', 17:33:19 48 '/u01/oradata/lunar/lunar_dat_08.dbf', 17:33:19 49 '/u01/oradata/lunar/lunar_dat_09.dbf', 17:33:19 50 '/u01/oradata/lunar/lunar_dat_10.dbf', 17:33:19 51 '/u01/oradata/lunar/lunar_dat_11.dbf', 17:33:19 52 '/u01/oradata/lunar/lunar_dat_12.dbf', 17:33:19 53 '/u01/oradata/lunar/lunar_dat_13.dbf', 17:33:19 54 '/u01/oradata/lunar/lunar_dat_14.dbf', 17:33:19 55 '/u01/oradata/lunar/lunar_dat_15.dbf', 17:33:19 56 '/u01/oradata/lunar/lunar_dat_16.dbf', 17:33:20 57 '/u01/oradata/lunar/lunar_dat_17.dbf', 17:33:20 58 '/u01/oradata/lunar/lunar_dat_18.dbf', 17:33:20 59 '/u01/oradata/lunar/lunar_dat_19.dbf', 17:33:20 60 '/u01/oradata/lunar/lunar_dat_20.dbf', 17:33:20 61 '/u01/oradata/lunar/lunar_dat_21.dbf', 17:33:20 62 '/u01/oradata/lunar/lunar_dat_22.dbf', 17:33:20 63 '/u01/oradata/lunar/lunar_dat_23.dbf', 17:33:20 64 '/u01/oradata/lunar/lunar_dat_24.dbf', 17:33:20 65 '/u01/oradata/lunar/lunar_dat_25.dbf', 17:33:20 66 '/u01/oradata/lunar/lunar_dat_26.dbf', 17:33:20 67 '/u01/oradata/lunar/lunar_dat_27.dbf', 17:33:20 68 '/u01/oradata/lunar/lunar_dat_28.dbf', 17:33:20 69 '/u01/oradata/lunar/lunar_dat_29.dbf', 17:33:20 70 '/u01/oradata/lunar/lunar_dat_30.dbf', 17:33:20 71 '/u01/oradata/lunar/lunar_dat_31.dbf', 17:33:20 72 '/u01/oradata/lunar/lunar_dat_32.dbf', 17:33:20 73 '/u01/oradata/lunar/lunar_dat_33.dbf', 17:33:21 74 '/u01/oradata/lunar/lunar_dat_34.dbf', 17:33:21 75 '/u01/oradata/lunar/lunar_dat_35.dbf', 17:33:21 76 '/u01/oradata/lunar/lunar_dat_36.dbf', 17:33:21 77 '/u01/oradata/lunar/lunar_dat_37.dbf', 17:33:21 78 '/u01/oradata/lunar/lunar_dat_38.dbf', 17:33:21 79 '/u01/oradata/lunar/lunar_dat_39.dbf', 17:33:21 80 '/u01/oradata/lunar/lunar_dat_40.dbf', 17:33:21 81 '/u01/oradata/lunar/lunar_dat_41.dbf', 17:33:21 82 '/u01/oradata/lunar/lunar_dat_42.dbf', 17:33:21 83 '/u01/oradata/lunar/lunar_dat_43.dbf', 17:33:21 84 '/u01/oradata/lunar/lunar_dat_44.dbf', 17:33:21 85 '/u01/oradata/lunar/lunar_dat_45.dbf', 17:33:21 86 '/u01/oradata/lunar/lunar_dat_46.dbf', 17:33:21 87 '/u01/oradata/lunar/lunar_dat_47.dbf', 17:33:21 88 '/u01/oradata/lunar/lunar_dat_48.dbf', 17:33:21 89 '/u01/oradata/lunar/lunar_dat_49.dbf', 17:33:21 90 '/u01/oradata/lunar/lunar_dat_50.dbf', 17:33:22 91 '/u01/oradata/lunar/lunar_dat_51.dbf', 17:33:22 92 '/u01/oradata/lunar/lunar_dat_52.dbf', 17:33:22 93 '/u01/oradata/lunar/lunar_dat_53.dbf', 17:33:22 94 '/u01/oradata/lunar/lunar_dat_54.dbf', 17:33:22 95 '/u01/oradata/lunar/lunar_dat_55.dbf', 17:33:22 96 '/u01/oradata/lunar/lunar_dat_56.dbf', 17:33:22 97 '/u01/oradata/lunar/lunar_dat_57.dbf', 17:33:22 98 '/u01/oradata/lunar/lunar_dat_58.dbf', 17:33:22 99 '/u01/oradata/lunar/lunar_dat_59.dbf', 17:33:22 100 '/u01/oradata/lunar/lunar_dat_60.dbf', 17:33:22 101 '/u01/oradata/lunar/lunar_dat_61.dbf', 17:33:22 102 '/u01/oradata/lunar/lunar_dat_62.dbf', 17:33:22 103 '/u01/oradata/lunar/lunar_dat_63.dbf', 17:33:22 104 '/u01/oradata/lunar/lunar_dat_64.dbf', 17:33:22 105 '/u01/oradata/lunar/lunar_dat_65.dbf', 17:33:22 106 '/u01/oradata/lunar/lunar_dat_66.dbf', 17:33:22 107 '/u01/oradata/lunar/lunar_dat_67.dbf', 17:33:23 108 '/u01/oradata/lunar/lunar_dat_68.dbf', 17:33:23 109 '/u01/oradata/lunar/lunar_dat_69.dbf', 17:33:23 110 '/u01/oradata/lunar/lunar_dat_70.dbf', 17:33:23 111 '/u01/oradata/lunar/lunar_dat_71.dbf', 17:33:23 112 '/u01/oradata/lunar/lunar_dat_72.dbf', 17:33:23 113 '/u01/oradata/lunar/lunar_dat_73.dbf', 17:33:23 114 '/u01/oradata/lunar/lunar_dat_74.dbf', 17:33:23 115 '/u01/oradata/lunar/lunar_dat_75.dbf', 17:33:23 116 '/u01/oradata/lunar/lunar_dat_76.dbf', 17:33:23 117 '/u01/oradata/lunar/lunar_dat_77.dbf', 17:33:23 118 '/u01/oradata/lunar/lunar_dat_78.dbf', 17:33:23 119 '/u01/oradata/lunar/lunar_dat_79.dbf', 17:33:23 120 '/u01/oradata/lunar/lunar_dat_80.dbf', 17:33:23 121 '/u01/oradata/lunar/undotbs05.dbf', 17:33:23 122 '/u01/oradata/lunar/lunar_car_dat_01.dbf', 17:33:23 123 '/u01/oradata/lunar/lunar_car_dat_02.dbf', 17:33:23 124 '/u01/oradata/lunar/lunar_car_dat_03.dbf', 17:33:24 125 '/u01/oradata/lunar/lunar_car_dat_04.dbf', 17:33:24 126 '/u01/oradata/lunar/lunar_car_dat_05.dbf', 17:33:24 127 '/u01/oradata/lunar/lunar_car_idx_01.dbf', 17:33:24 128 '/u01/oradata/lunar/lunar_car_idx_02.dbf', 17:33:24 129 '/u01/oradata/lunar/lunar_car_idx_03.dbf', 17:33:24 130 '/u01/oradata/lunar/lunar_car_idx_04.dbf', 17:33:24 131 '/u01/oradata/lunar/lunar_car_idx_05.dbf', 17:33:24 132 '/u01/oradata/lunar/lunar_car_dat_06.dbf', 17:33:24 133 '/u01/oradata/lunar/lunar_car_dat_07.dbf', 17:33:24 134 '/u01/oradata/lunar/lunar_car_dat_08.dbf', 17:33:24 135 '/u01/oradata/lunar/lunar_car_dat_09.dbf', 17:33:24 136 '/u01/oradata/lunar/lunar_car_dat_10.dbf', 17:33:24 137 '/u01/oradata/lunar/lunar_car_idx_06.dbf', 17:33:24 138 '/u01/oradata/lunar/lunar_car_idx_07.dbf', 17:33:24 139 '/u01/oradata/lunar/lunar_car_idx_08.dbf', 17:33:24 140 '/u01/oradata/lunar/lunar_car_idx_09.dbf', 17:33:25 141 '/u01/oradata/lunar/lunar_car_idx_10.dbf', 17:33:25 142 '/u01/oradata/lunar/lunar_dat_81.dbf', 17:33:25 143 '/u01/oradata/lunar/lunar_dat_82.dbf', 17:33:25 144 '/u01/oradata/lunar/lunar_dat_83.dbf', 17:33:25 145 '/u01/oradata/lunar/lunar_dat_84.dbf', 17:33:25 146 '/u01/oradata/lunar/lunar_dat_85.dbf', 17:33:25 147 '/u01/oradata/lunar/lunar_dat_86.dbf', 17:33:25 148 '/u01/oradata/lunar/lunar_dat_87.dbf', 17:33:25 149 '/u01/oradata/lunar/lunar_dat_88.dbf', 17:33:25 150 '/u01/oradata/lunar/lunar_dat_89.dbf', 17:33:25 151 '/u01/oradata/lunar/lunar_dat_90.dbf', 17:33:25 152 '/u01/oradata/lunar/lunar_idx_02.dbf', 17:33:25 153 '/u01/oradata/lunar/lunar_idx_03.dbf', 17:33:25 154 '/u01/oradata/lunar/lunar_idx_04.dbf', 17:33:25 155 '/u01/oradata/lunar/lunar_idx_05.dbf', 17:33:25 156 '/u01/oradata/lunar/lunar_idx_06.dbf', 17:33:25 157 '/u01/oradata/lunar/lunar_idx_07.dbf', 17:33:26 158 '/u01/oradata/lunar/lunar_idx_08.dbf', 17:33:26 159 '/u01/oradata/lunar/lunar_idx_09.dbf', 17:33:26 160 '/u01/oradata/lunar/lunar_idx_10.dbf', 17:33:26 161 '/u01/oradata/lunar/lunar_dat_91.dbf', 17:33:26 162 '/u01/oradata/lunar/lunar_dat_92.dbf', 17:33:26 163 '/u01/oradata/lunar/lunar_dat_93.dbf', 17:33:26 164 '/u01/oradata/lunar/lunar_dat_94.dbf', 17:33:26 165 '/u01/oradata/lunar/lunar_dat_95.dbf', 17:33:26 166 '/u01/oradata/lunar/lunar_dat_96.dbf', 17:33:26 167 '/u01/oradata/lunar/lunar_dat_97.dbf', 17:33:26 168 '/u01/oradata/lunar/lunar_dat_98.dbf', 17:33:26 169 '/u01/oradata/lunar/lunar_dat_99.dbf', 17:33:26 170 '/u01/oradata/lunar/lunar_dat_100.dbf', 17:33:26 171 '/u01/oradata/lunar/lunar_dat_101.dbf', 17:33:26 172 '/u01/oradata/lunar/lunar_dat_102.dbf', 17:33:27 173 '/u01/oradata/lunar/lunar_dat_103.dbf', 17:33:27 174 '/u01/oradata/lunar/lunar_dat_104.dbf', 17:33:27 175 '/u01/oradata/lunar/lunar_dat_105.dbf', 17:33:27 176 '/u01/oradata/lunar/lunar_dat_106.dbf', 17:33:27 177 '/u01/oradata/lunar/lunar_dat_107.dbf', 17:33:27 178 '/u01/oradata/lunar/lunar_dat_108.dbf', 17:33:27 179 '/u01/oradata/lunar/lunar_dat_109.dbf', 17:33:27 180 '/u01/oradata/lunar/lunar_dat_110.dbf', 17:33:27 181 '/u01/oradata/lunar/undotbs06.dbf', 17:33:27 182 '/u01/oradata/lunar/undotbs07.dbf', 17:33:27 183 '/u01/oradata/lunar/lunar_dat_111.dbf', 17:33:27 184 '/u01/oradata/lunar/lunar_dat_112.dbf', 17:33:27 185 '/u01/oradata/lunar/lunar_dat_113.dbf', 17:33:27 186 '/u01/oradata/lunar/lunar_dat_114.dbf', 17:33:27 187 '/u01/oradata/lunar/lunar_dat_115.dbf', 17:33:27 188 '/u01/oradata/lunar/lunar_idx_11.dbf', 17:33:27 189 '/u01/oradata/lunar/lunar_idx_12.dbf', 17:33:28 190 '/u01/oradata/lunar/lunar_idx_13.dbf', 17:33:28 191 '/u01/oradata/lunar/lunar_idx_14.dbf', 17:33:28 192 '/u01/oradata/lunar/lunar_idx_15.dbf', 17:33:28 193 '/u01/oradata/lunar/lunar_dat_116.dbf', 17:33:28 194 '/u01/oradata/lunar/lunar_dat_117.dbf', 17:33:28 195 '/u01/oradata/lunar/lunar_dat_118.dbf', 17:33:28 196 '/u01/oradata/lunar/lunar_dat_119.dbf', 17:33:28 197 '/u01/oradata/lunar/lunar_dat_120.dbf', 17:33:28 198 '/u01/oradata/lunar/lunar_dat_121.dbf', 17:33:28 199 '/u01/oradata/lunar/lunar_dat_122.dbf', 17:33:28 200 '/u01/oradata/lunar/lunar_dat_123.dbf', 17:33:28 201 '/u01/oradata/lunar/lunar_dat_124.dbf', 17:33:28 202 '/u01/oradata/lunar/lunar_dat_125.dbf', 17:33:28 203 '/u01/oradata/lunar/lunar_idx_16.dbf', 17:33:28 204 '/u01/oradata/lunar/lunar_idx_17.dbf', 17:33:28 205 '/u01/oradata/lunar/lunar_idx_18.dbf', 17:33:29 206 '/u01/oradata/lunar/lunar_idx_19.dbf', 17:33:29 207 '/u01/oradata/lunar/lunar_idx_20.dbf', 17:33:29 208 '/u01/oradata/lunar/lunar_idx_21.dbf', 17:33:29 209 '/u01/oradata/lunar/lunar_idx_22.dbf', 17:33:29 210 '/u01/oradata/lunar/lunar_idx_23.dbf', 17:33:29 211 '/u01/oradata/lunar/lunar_idx_24.dbf', 17:33:29 212 '/u01/oradata/lunar/lunar_idx_25.dbf', 17:33:29 213 '/u01/oradata/lunar/lunar_dat_126.dbf', 17:33:29 214 '/u01/oradata/lunar/lunar_dat_127.dbf', 17:33:29 215 '/u01/oradata/lunar/lunar_dat_128.dbf', 17:33:29 216 '/u01/oradata/lunar/lunar_dat_129.dbf', 17:33:29 217 '/u01/oradata/lunar/lunar_dat_130.dbf', 17:33:29 218 '/u01/oradata/lunar/lunar_idx_26.dbf', 17:33:29 219 '/u01/oradata/lunar/lunar_idx_27.dbf', 17:33:29 220 '/u01/oradata/lunar/lunar_idx_28.dbf', 17:33:29 221 '/u01/oradata/lunar/lunar_idx_29.dbf', 17:33:29 222 '/u01/oradata/lunar/lunar_idx_30.dbf', 17:33:30 223 '/u01/oradata/lunar/lunar_dat_131.dbf', 17:33:30 224 '/u01/oradata/lunar/lunar_dat_132.dbf', 17:33:30 225 '/u01/oradata/lunar/lunar_dat_133.dbf', 17:33:30 226 '/u01/oradata/lunar/lunar_dat_134.dbf', 17:33:30 227 '/u01/oradata/lunar/lunar_dat_135.dbf', 17:33:30 228 '/u01/oradata/lunar/lunar_idx_31.dbf', 17:33:30 229 '/u01/oradata/lunar/lunar_idx_32.dbf', 17:33:30 230 '/u01/oradata/lunar/lunar_idx_33.dbf', 17:33:30 231 '/u01/oradata/lunar/lunar_idx_34.dbf', 17:33:30 232 '/u01/oradata/lunar/lunar_idx_35.dbf', 17:33:30 233 '/u01/oradata/lunar/lunar_dat_136.dbf', 17:33:30 234 '/u01/oradata/lunar/lunar_dat_137.dbf', 17:33:30 235 '/u01/oradata/lunar/lunar_dat_138.dbf', 17:33:30 236 '/u01/oradata/lunar/lunar_dat_139.dbf', 17:33:30 237 '/u01/oradata/lunar/lunar_idx_36.dbf', 17:33:30 238 '/u01/oradata/lunar/lunar_dat_140', 17:33:31 239 '/u01/oradata/lunar/lunar_dat_141', 17:33:31 240 '/u01/oradata/lunar/lunar_dat_142', 17:33:31 241 '/u01/oradata/lunar/lunar_dat_143', 17:33:31 242 '/u01/oradata/lunar/lunar_dat_144', 17:33:31 243 '/u01/oradata/lunar/lunar_dat_145', 17:33:31 244 '/u01/oradata/lunar/lunar_idx_37.dbf', 17:33:31 245 '/u01/oradata/lunar/lunar_idx_38.dbf', 17:33:31 246 '/u01/oradata/lunar/lunar_idx_39.dbf', 17:33:31 247 '/u01/oradata/lunar/lunar_idx_40.dbf', 17:33:31 248 '/u01/oradata/lunar/lunar_dat_146.dbf', 17:33:31 249 '/u01/oradata/lunar/lunar_dat_147.dbf', 17:33:31 250 '/u01/oradata/lunar/lunar_dat_148.dbf', 17:33:31 251 '/u01/oradata/lunar/lunar_dat_149.dbf', 17:33:31 252 '/u01/oradata/lunar/lunar_dat_150.dbf', 17:33:31 253 '/u01/oradata/lunar/lunar_dat_151.dbf', 17:33:31 254 '/u01/oradata/lunar/lunar_dat_152.dbf', 17:33:31 255 '/u01/oradata/lunar/lunar_dat_153.dbf', 17:33:32 256 '/u01/oradata/lunar/lunar_dat_154.dbf', 17:33:32 257 '/u01/oradata/lunar/lunar_dat_155.dbf', 17:33:32 258 '/u01/oradata/lunar/lunar_dat_156.dbf', 17:33:32 259 '/u01/oradata/lunar/lunar_dat_157.dbf', 17:33:32 260 '/u01/oradata/lunar/lunar_dat_158.dbf', 17:33:32 261 '/u01/oradata/lunar/lunar_dat_159.dbf', 17:33:32 262 '/u01/oradata/lunar/lunar_dat_160.dbf', 17:33:32 263 '/u01/oradata/lunar/lunar_idx_41.dbf', 17:33:32 264 '/u01/oradata/lunar/lunar_car_idx_11.dbf', 17:33:32 265 '/u01/oradata/lunar/lunar_idx_42.dbf', 17:33:32 266 '/u01/oradata/lunar/lunar_idx_43.dbf', 17:33:32 267 '/u01/oradata/lunar/undotbs08.dbf', 17:33:32 268 '/u01/oradata/lunar/lunar_car_dat_11.dbf', 17:33:32 269 '/u01/oradata/lunar/lunar_car_idx_12.dbf', 17:33:32 270 '/u01/oradata/lunar/lunar_car_idx_13.dbf', 17:33:32 271 '/u01/oradata/lunar/undotbs09.dbf', 17:33:33 272 '/u01/oradata/lunar/undotbs10.dbf', 17:33:33 273 '/u01/oradata/lunar/undotbs11.dbf', 17:33:33 274 '/u01/oradata/lunar/undotbs12.dbf', 17:33:33 275 '/u01/oradata/lunar/lunar_car_idx_14.dbf', 17:33:33 276 '/u01/oradata/lunar/lunar_car_idx_15.dbf', 17:33:33 277 '/u01/oradata/lunar/lunar_car_idx_16.dbf', 17:33:33 278 '/u01/oradata/lunar/lunar_car_dat_12.dbf', 17:33:33 279 '/u01/oradata/lunar/lunar_car_dat_13.dbf', 17:33:33 280 '/u01/oradata/lunar/lunar_car_dat_14.dbf', 17:33:33 281 '/u01/oradata/lunar/lunar_dat_161.dbf', 17:33:33 282 '/u01/oradata/lunar/lunar_dat_162.dbf', 17:33:33 283 '/u01/oradata/lunar/lunar_dat_163.dbf', 17:33:33 284 '/u01/oradata/lunar/lunar_dat_164.dbf', 17:33:33 285 '/u01/oradata/lunar/lunar_dat_165.dbf', 17:33:33 286 '/u01/oradata/lunar/lunar_dat_166.dbf', 17:33:33 287 '/u01/oradata/lunar/lunar_dat_167.dbf', 17:33:33 288 '/u01/oradata/lunar/lunar_dat_168.dbf', 17:33:34 289 '/u01/oradata/lunar/undotbs13.dbf', 17:33:34 290 '/u01/oradata/lunar/undotbs14.dbf', 17:33:34 291 '/u01/oradata/lunar/undotbs15.dbf', 17:33:34 292 '/u01/oradata/lunar/undotbs16.dbf', 17:33:34 293 '/u01/oradata/lunar/lunar_car_idx_17.dbf', 17:33:34 294 '/u01/oradata/lunar/lunar_car_idx_18.dbf', 17:33:34 295 '/u01/oradata/lunar/undotbs17.dbf', 17:33:34 296 '/u01/oradata/lunar/undotbs18.dbf', 17:33:34 297 '/u01/oradata/lunar/undotbs19.dbf', 17:33:34 298 '/u01/oradata/lunar/undotbs20.dbf', 17:33:34 299 '/u01/oradata/lunar/lunar_car_dat_15.dbf', 17:33:34 300 '/u01/oradata/lunar/lunar_car_dat_16.dbf', 17:33:34 301 '/u01/oradata/lunar/lunar_car_dat_17.dbf', 17:33:34 302 '/u01/oradata/lunar/lunar_car_idx_19.dbf', 17:33:34 303 '/u01/oradata/lunar/lunar_car_idx_20.dbf', 17:33:34 304 '/u01/oradata/lunar/lunar_car_idx_21.dbf', 17:33:34 305 '/u01/oradata/lunar/lunar_car_idx_22.dbf', 17:33:35 306 '/u01/oradata/lunar/lunar_car_idx_23.dbf', 17:33:35 307 '/u01/oradata/lunar/lunar_car_idx_24.dbf', 17:33:35 308 '/u01/oradata/lunar/lunar_car_idx_25.dbf', 17:33:35 309 '/u01/oradata/lunar/lunar_car_idx_26.dbf', 17:33:35 310 '/u01/oradata/lunar/lunar_car_idx_27.dbf', 17:33:35 311 '/u01/oradata/lunar/lunar_car_dat_18.dbf', 17:33:35 312 '/u01/oradata/lunar/lunar_car_dat_19.dbf', 17:33:35 313 '/u01/oradata/lunar/lunar_car_dat_20.dbf', 17:33:35 314 '/u01/oradata/lunar/lunar_car_dat_21.dbf', 17:33:35 315 '/u01/oradata/lunar/lunar_car_dat_22.dbf', 17:33:35 316 '/u01/oradata/lunar/lunar_idx_44.dbf', 17:33:35 317 '/u01/oradata/lunar/lunar_idx_45.dbf', 17:33:35 318 '/u01/oradata/lunar/lunar_dat_169.dbf', 17:33:35 319 '/u01/oradata/lunar/lunar_dat_170.dbf' 17:33:35 320 CHARACTER SET ZHS16GBK 17:33:35 321 ; Control file created. Elapsed: 00:00:01.35 17:33:43 SYS@ lunardb3>
激活数据库：
17:35:03 SYS@ lunardb3> RECOVER DATABASE USING BACKUP CONTROLFILE until cance;
ORA-00277: illegal option to the UNTIL recovery flag CANCE
17:35:14 SYS@ lunardb3> RECOVER DATABASE USING BACKUP CONTROLFILE until cancel;
ORA-00279: change 6194107977643 generated at needed for thread 1
17:35:50 Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
Media recovery cancelled.
17:35:53 SYS@ lunardb3> ALTER DATABASE OPEN RESETLOGS;
Database altered.
Elapsed: 00:00:06.56
17:36:05 SYS@ lunardb3>
最后在备库添加temp文件：
18:15:26 SYS@ lunardb3> ALTER TABLESPACE TEMP ADD TEMPFILE '/u01/oradata/lunar/temp01.dbf' REUSE;
Tablespace altered.
Elapsed: 00:00:00.08
18:16:19 SYS@ lunardb3>
18:26:26 SYS@ lunardb3> ALTER TABLESPACE TEMP ADD TEMPFILE '/u01/oradata/lunar/temp02.dbf' size 16G;
Tablespace altered.
Elapsed: 00:00:00.13
18:26:32 SYS@ lunardb3> ALTER TABLESPACE TEMP ADD TEMPFILE '/u01/oradata/lunar/temp03.dbf' size 16G;
Tablespace altered.
Elapsed: 00:00:00.07
18:26:46 SYS@ lunardb3> ALTER TABLESPACE TEMP ADD TEMPFILE '/u01/oradata/lunar/temp04.dbf' size 16G;
Tablespace altered.
Elapsed: 00:00:00.06
18:27:02 SYS@ lunardb3> ALTER TABLESPACE TEMP ADD TEMPFILE '/u01/oradata/lunar/temp05.dbf' size 16G;
Tablespace altered.
Elapsed: 00:00:00.06
18:27:07 SYS@ lunardb3> select * from v$tempfile;
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE# STATUS ENABLED BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
---------- ---------------- ------------------- ---------- ---------- ------- ---------- ---------- ---------- ------------ ----------
NAME
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
1 6.1941E+12 2015-04-15 18:16:19 3 1 ONLINE READ WRITE 1.7180E+10 2097152 1.7180E+10 8192
/u01/oradata/lunar/temp01.dbf
2 6.1941E+12 2015-04-15 18:26:32 3 2 ONLINE READ WRITE 1.7180E+10 2097152 1.7180E+10 8192
/u01/oradata/lunar/temp02.dbf
3 6.1941E+12 2015-04-15 18:26:39 3 3 ONLINE READ WRITE 1.7180E+10 2097152 1.7180E+10 8192
/u01/oradata/lunar/temp03.dbf
4 6.1941E+12 2015-04-15 18:27:02 3 4 ONLINE READ WRITE 1.7180E+10 2097152 1.7180E+10 8192
/u01/oradata/lunar/temp04.dbf
5 6.1941E+12 2015-04-15 18:27:07 3 5 ONLINE READ WRITE 1.7180E+10 2097152 1.7180E+10 8192
/u01/oradata/lunar/temp05.dbf
Elapsed: 00:00:00.01
18:27:40 SYS@ lunardb3>
