转载

ADG备库由于控制文件,归档损坏等原因,不能switchover,failover和active standby database时

联系: 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> 
正文到此结束
Loading...