Oracle 修复坏块，关掉闪回

jgfhrt

RMAN 修复报错：
RMAN> recover datafile 2 block 410352;
Starting recover at 05-OCT-15
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=292 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=577 device type=DISK
finished standby search, restored 1 blocks
starting media recovery
some blocks not recovered: See trace file for details
media recovery complete, elapsed time: 00:00:01

$ cat CWFOL_ora_7471310.trc
Trace file /oracle/diag/rdbms/cwfol/CWFOL/trace/CWFOL_ora_7471310.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /oracle/product/11.2/db_2
System name:    AIX
Node name:      DB2
Release:        1
Version:        6
Machine:        00F813C84C00
Instance name: CWFOL
Redo thread mounted by this instance: 1
Oracle process number: 146
Unix process pid: 7471310, image: oracle@DB2 (TNS V1-V3)
*** 2015-10-05 11:33:34.183
*** SESSION ID:(292.63641) 2015-10-05 11:33:34.183
*** CLIENT ID:() 2015-10-05 11:33:34.183
*** SERVICE NAME:(SYS$USERS) 2015-10-05 11:33:34.183
*** MODULE NAME:(rman@DB2 (TNS V1-V3)) 2015-10-05 11:33:34.183
*** ACTION NAME:(0000013 STARTED104) 2015-10-05 11:33:34.183
Begin Media Recovery of 1 blocks
Dumping database incarnation table:
Resetlogs 0 scn and time: 0x000a.ea74a943 02/19/2015 21:16:47
Initial buffer sizes: read 1024K, overflow 832K, change 805K
*** 2015-10-05 11:33:34.214
Media Recovery add redo thread 1
Start recovery at thread 1 ckpt scn 67757762871 logseq 8049 block 2
End recovery at scn 67758750891
*** 2015-10-05 11:33:34.214
Recovery of Online Redo Log: Thread 1 Group 6 Seq 8049 Reading mem 0
----- Redo read statistics for thread 1 -----
Read rate (ASYNC): 32499Kb in 0.05s => 634.76 Mb/sec
Total redo bytes: 34815Kb Longest record: 8Kb, moves: 19/74859 moved: 0Mb (0%)
Longest LWN: 85Kb, reads: 14531
Last redo scn: 0x000f.c6bc7caa (67758750890)
Change vector header moves = 12979/167649 (7%)
----------------------------------------------
*** 2015-10-05 11:33:34.262
Media Recovery drop redo thread 1
Recovery of file 2, block 410352 failed: Flashback was enabled for the data file when the backup data block used for block media recovery had an unlogged change.
*** 2015-10-05 11:34:57.593
*** ACTION NAME:(0000031 STARTED104) 2015-10-05 11:34:57.593
Begin Media Recovery of 1 blocks
Dumping database incarnation table:
Resetlogs 0 scn and time: 0x000a.ea74a943 02/19/2015 21:16:47
Initial buffer sizes: read 1024K, overflow 832K, change 805K
*** 2015-10-05 11:34:57.625
Media Recovery add redo thread 1
Start recovery at thread 1 ckpt scn 67757762871 logseq 8049 block 2
End recovery at scn 67758797944
*** 2015-10-05 11:34:57.626
Recovery of Online Redo Log: Thread 1 Group 6 Seq 8049 Reading mem 0
----- Redo read statistics for thread 1 -----
Read rate (ASYNC): 33970Kb in 0.05s => 663.49 Mb/sec
Total redo bytes: 35839Kb Longest record: 8Kb, moves: 20/78192 moved: 0Mb (0%)
Longest LWN: 85Kb, reads: 15300
Last redo scn: 0x000f.c6bd3477 (67758797943)
Change vector header moves = 13600/175275 (7%)
----------------------------------------------
*** 2015-10-05 11:34:57.675
Media Recovery drop redo thread 1
Recovery of file 2, block 410352 failed: Flashback was enabled for the data file when the backup data block used for block media recovery had an unlogged change.

关掉数据库闪回：

SQL> alter database flashback off;
Database altered.
RMAN> recover datafile 2 block 410352;
Starting recover at 05-OCT-15
using channel ORA_DISK_1
using channel ORA_DISK_2
finished standby search, restored 1 blocks
starting media recovery
media recovery complete, elapsed time: 00:00:01
Finished recover at 05-OCT-15

然后再打开闪回：
SQL> alter database flashback on;
Database altered.