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> 
此条目发表在 backup&recovery, Dataguard 分类目录,贴了 , , 标签。将固定链接加入收藏夹。

发表评论

电子邮件地址不会被公开。 必填项已用 * 标注

您可以使用这些 HTML 标签和属性: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>