Oracle 修復壞塊，關掉閃回

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, p_w_picpath: 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.