Shulou(Shulou.com)06/01 Report--

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.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.