Oracle fixes bad blocks and turns off flashbacks
RMAN repair error:
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 1111 purl 3334.183
* SESSION ID: (292.63641) 2015-10-05 1133 334. 183
* CLIENT ID: () 2015-10-05 11,3334.183
* SERVICE NAME: (SYS$USERS) 2015-10-05 1133 334. 183
* MODULE NAME: (rman@DB2 (TNS V1-V3)) 2015-10-05 11 purl 33purl 34.183
* ACTION NAME: (0000013 STARTED104) 2015-10-05 1133purl 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 1111 purge 3334.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 1111 purge 3334.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: 19max 74859 moved: 0Mb (0%)
Longest LWN: 85Kb, reads: 14531
Last redo scn: 0x000f.c6bc7caa (67758750890)
Change vector header moves = 12979max 167649 (7)
-
* 2015-10-05 1111 purge 333mov 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 1134 motto 57.593
* ACTION NAME: (0000031 STARTED104) 2015-10-05 11140 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 1134 morph 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 1134 morph 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 take 78192 moved: 0Mb (0%)
Longest LWN: 85Kb, reads: 15300
Last redo scn: 0x000f.c6bd3477 (67758797943)
Change vector header moves = 13600max 175275 (7%)
-
* 2015-10-05 1134 motto 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.
Turn off the database flashback:
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
Then turn on the flashback:
SQL > alter database flashback on
Database altered.
