This content has been marked as final. Show 5 replies
1. What is db version?
how to corrupt a block:
how to detect/repair:
Thanks for you resposes.
I tried to corrupt datablock by editing datafile and remove some data and add some data.
1. Execurted below rman commad
RMAN> backup validate check logical database;
Output show block is corrupted.
Below query is also listing corrupted blocks.
SQL> select * from v$database_block_corruption;
But when i am checking corruption with dbms_repair packges it doesn't list any corruption.
SET SERVEROUTPUT ON
DECLARE num_corrupt INT;
num_corrupt := 0;
SCHEMA_NAME => 'TEST',
OBJECT_NAME => 'TEST1',
REPAIR_TABLE_NAME => 'REPAIR_TABLE',
CORRUPT_COUNT => num_corrupt);
DBMS_OUTPUT.PUT_LINE('number corrupt: ' || TO_CHAR (num_corrupt));
Please let me know any other scenarios to corrupt LOGICAL block.
Other scenario to corrupt LOGICAL block.
First of all take your tablespace offline.
Choose any hex editor software to make changes in your datafile
Now open your datafile using your hex editor software
Change any record entry and close your hex editor
Set tablespace online
You have no any problem to bring to datafile online because file header was not modified
Oracle only complains when you try to access corrupt block.
Note: Don't try it on your production database & applied for Oracle 10g (Release 2)
For Oracle 11g:
Edited by: 948836 on Jul 27, 2012 3:29 AM