RMAN 修復(fù)報(bào)錯(cuò)：

創(chuàng)新互聯(lián)建站網(wǎng)站建設(shè)由有經(jīng)驗(yàn)的網(wǎng)站設(shè)計(jì)師、開發(fā)人員和項(xiàng)目經(jīng)理組成的專業(yè)建站團(tuán)隊(duì)，負(fù)責(zé)網(wǎng)站視覺設(shè)計(jì)、用戶體驗(yàn)優(yōu)化、交互設(shè)計(jì)和前端開發(fā)等方面的工作，以確保網(wǎng)站外觀精美、成都網(wǎng)站設(shè)計(jì)、成都做網(wǎng)站易于使用并且具有良好的響應(yīng)性。

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.

關(guān)掉數(shù)據(jù)庫(kù)閃回：

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.

網(wǎng)頁(yè)標(biāo)題：Oracle修復(fù)壞塊，關(guān)掉閃回
轉(zhuǎn)載來于：http://jinyejixie.com/article8/pgihop.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供移動(dòng)網(wǎng)站建設(shè)、小程序開發(fā)、網(wǎng)站制作、用戶體驗(yàn)、網(wǎng)站策劃、網(wǎng)站營(yíng)銷

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來源： 創(chuàng)新互聯(lián)