The DBV-201 error is a new error due to ‘soft corruption’ which is caused by invalid redo application (eg: after application of NOLOGGING redo).<\/p>\n\n\n\n
To find the object related to the corruption:<\/p>\n\n\n\n
Take one of the DBV outputs and find block and file number with DBA block specified:<\/p>\n\n\n\n
exec dbms_utility.data_block_address_file(37754116); -- block number\nexec dbms_utility.data_block_address_block(37754116); -- file number<\/code><\/pre>\n\n\n\nUsing the file and block number, you can execute the query:<\/p>\n\n\n\n
SELECT tablespace_name, segment_type, owner, segment_name\nFROM dba_extents\nWHERE file_id = <file#>\nand <block#> between block_id AND block_id + blocks - 1;<\/code><\/pre>\n\n\n\nuse file and block number from previous step.<\/p>\n\n\n\n
This will give you the segment\/object name.<\/p>\n\n\n\n
From the object(s) returned in previous query, if they are tables:<\/p>\n\n\n\n
select owner, table_name, logging\nfrom dba_tables\nwhere table_name in\n('<list of tables from previous query>');<\/code><\/pre>\n\n\n\nIf indexes:<\/p>\n\n\n\n
select owner, index_name, logging, table_owner, table_name\nfrom dba_indexes\nwhere index_name in ('<list of indexes from previous query>');<\/code><\/pre>\n\n\n\nThe LOGGING=NO means the object is using the NOLOGGING feature and as expected, the recovery performed on the objects led to the DBV-201 output.<\/p>\n\n\n\n
If you were to query the objects, you would get something like:<\/p>\n\n\n\n
ORA-01578: ORACLE data block corrupted (file #9 , block # 121658)
ORA-26040: Data block was loaded using the NOLOGGING option<\/p>\n\n\n\n
Solution: The object will need to be recreated.<\/p>\n\n\n\n
If you want to ensure the soft corruption does not occur again, ensure tables or indexes are altered so that LOGGING=YES .<\/p>\n","protected":false},"excerpt":{"rendered":"
The DBV-201 error is a new error due to ‘soft corruption’ which is caused by invalid redo application (eg: after application of NOLOGGING redo). To find the object related to the corruption: Take one of the DBV outputs and find block and file number with DBA block specified: Using the file and block number, you … <\/p>\n