Find corrupted objects in Oracle using sql query : When you find block corruption in your database use validate database or validate check logical database command of RMAN, it will populate v$database_block_corruption view with corrupted blocks. Then you can check corrupted segments , its partition name and more details using following script. SELECT e.owner, e.segment_type, […]
Articles Tagged: Recovery – (corrupted data blocks)
Recover corrupted data blocks using DBVERIFY
As we know that SYSTEM – stores the data dictionary. Being an Oracle DBA we all know the importance of SYSTEM tablespace. In these below lines, we can have actual technical knowledge about system’s information. SYSTEM – a tablespace that is always used to store SYSTEM data that includes data about tables, indexes, sequences, and other objects – this metadata […]