oracle10g ocp认证中文与真题精解les dealing with database corruption

确定数据库损坏原因要发现数据库损坏，可通过 比较在cache和blockbuffer中的DBA(datablockaddress)Block-checksum块校验,(或软件) 块损坏症状ORA-ORA-01578:"ORACLEdatablockcorrupted(file%s,block# Blockmedia 实用程序的名称$$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); 使对象可用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 归档日志来管理blockmediarecovery会话RMAN>RMAN>BLOCKRECOVERDATAFILE6BLOCK BLOCKRECOVER用还原类型限制blockmedia 限制blockmedia用时间、SCN、日志限制blockmedia RMANBMRV$DATABASE_BLOCK_CORRUPTION视图显示数据库当前损坏块 RMAN>RMAN>BLOCKRECOVERCORRUPTION2>RESTOREUNTILTIME'sysdate–V$BACKUP_CORRUPTION视图显示数据文件备份中的损坏块 V$COPY_CORRUPTION视图显示镜像文件拷贝中的损坏块 SQL或者PL/SQL把数据输入一个新建的表中 识别数据库损坏的原因用以下工具诊断数据库 练习ThispracticecoversthefollowingD