oracle10g ocp認(rèn)證中文與真題精解les dealing with database corruption

確定數(shù)據(jù)庫(kù)損壞原因要發(fā)現(xiàn)數(shù)據(jù)庫(kù)損壞，可通過(guò) 比較在cache和blockbuffer中的DBA(datablockaddress)Block-checksum塊校驗(yàn),(或軟件) 塊損壞癥狀ORA-ORA-01578:"ORACLEdatablockcorrupted(file%s,block# Blockmedia 實(shí)用程序的名稱(chēng)$$dbvfile=/u01/oradata/users01.dbf\ TotalPages:TotalPages:TotalPagesProcessed(Data):4408TotalPagesFailing (Data):0TotalPagesProcessed(Index):...TotalPagesMarkedCorruptTotalPagesInfluxHighestblock:::654836 YZETABLEYZETABLEtable_name2STRUCTURE YZEINDEXindex_name2 ALTERSESSIONALTERSYSTEMDEFERRED置 $exphr/hrAbouttoexportspecifiedtablesviaConventional..exportingEXP-00056:ORACLE

1578ORA-01578:ORACLEdatablockcorrupted(file#5,block#ORA-01110:datafile5:

Undo SETSERVEROUTPUTDECLAREnum_corruptINT;num_corrupt:=0;DBMS_REPAIR.CHECK_OBJECT(schema_name=>‘HR',object_name=>'DEPARTMENTS',repair_table_name=>corrupt_count=>num_corrupt); 使對(duì)象可用SETSERVEROUTPUTDECLAREnum_fixINT;num_fix:=0;DBMS_REPAIR.FIX_CORRUPT_BLOCKS(schema_name=>'HR',object_name=>'DEPARTMENTS',object_type=>DBMS_REPAIR.TABLE_OBJECT,repair_table_name=>'REPAIR_TABLE',fix_count=>num_fix); SETSERVEROUTPUTDECLAREnum_orphansINT;num_orphans:=0;DBMS_REPAIR.DUMP_ORPHAN_KEYS(schema_name=>'SCOTT',object_name=>'PK_DEPT',object_type=>DBMS_REPAIR.INDEX_OBJECT,repair_table_name=>'REPAIR_TABLE',orphan_table_name=>'ORPHAN_KEY_TABLE',key_count=>num_orphans);DBMS_OUTPUT.PUT_LINE('orphankeycount:' BlockMediaRecoveryBlockmedia 歸檔日志來(lái)管理blockmediarecovery會(huì)話RMAN>RMAN>BLOCKRECOVERDATAFILE6BLOCK BLOCKRECOVER用還原類(lèi)型限制blockmedia 限制blockmedia用時(shí)間、SCN、日志限制blockmedia RMANBMRV$DATABASE_BLOCK_CORRUPTION視圖顯示數(shù)據(jù)庫(kù)當(dāng)前損壞塊 RMAN>RMAN>BLOCKRECOVERCORRUPTION2>RESTOREUNTILTIME'sysdate–V$BACKUP_CORRUPTION視圖顯示數(shù)據(jù)文件備份中的損壞塊 V$COPY_CORRUPTION視圖顯示鏡像文件拷貝中的損壞塊 SQL或者PL/SQL把數(shù)據(jù)輸入一個(gè)新建的表中 識(shí)別數(shù)據(jù)庫(kù)損壞的原因用以下工具診斷數(shù)據(jù)庫(kù) 練習(xí)ThispracticecoversthefollowingD