{"id":265,"date":"2018-06-13T20:37:07","date_gmt":"2018-06-13T20:37:07","guid":{"rendered":"http:\/\/dbtut.com\/?p=265"},"modified":"2020-01-03T11:14:54","modified_gmt":"2020-01-03T11:14:54","slug":"how-to-fix-block-corruption-on-oracle","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/06\/13\/how-to-fix-block-corruption-on-oracle\/","title":{"rendered":"How To Detect and Repair Block Corruption in Oracle"},"content":{"rendered":"

In this article, we will see how to fix block corruption when there is a block corruption on a data file.<\/p>\n

If Block Corruption is on the index, you can solve the problem by dropping and recreating the index.<\/p>\n

In some cases, block corruption can also be on free pages.<\/p>\n

Detect Corrupt Blocks<\/h2>\n

Block corruption in Oracle databases is not a fearful dream. Block corruption can be easily corrected in databases that are in Archivelog mode and that are regularly backed up by rman.<\/p>\n

Connect to the database which has block corruption and detect the block corruption with the following script.<\/p>\n

if you dont know to connect to Oracle, you may want to read the below articles.<\/p>\n

“How To Connect To Oracle With Toad<\/a>“,<\/p>\n

“How To Connect To Oracle With sqlplus<\/a>“,<\/p>\n

select * from v$database_block_corruption;<\/pre>\n
If we run the query, the screen will appear as below.<\/p>\n
<\/p>\n
For RAC Databases;<\/strong><\/p>\n
select * from gv$database_block_corruption;<\/pre>\n
Repair Block Corruption Using RMAN<\/h2>\n
Then connect to RMAN and repair block corruption with the following script.<\/p>\n
To connect to RMAN you may want to read the article titled “How To Connect To RMAN<\/a>“.<\/p>\n
Write the file number returned from the above script insted of “x” in the below script.<\/p>\n
Write the block number returned from the above script instead of “y” in the below script..<\/p>\n
blockrecover datafile x block y;\nbackup validate check logical datafile x;<\/pre>\n
Find Which Object is Corrupted<\/h3>\n
You can use the following query to determine which objects are on the corrupted blocks.<\/p>\n
SELECT tablespace_name, segment_type, owner, segment_name FROM dba_extents WHERE file_id =x and y \nbetween block_id AND block_id + blocks - 1;<\/pre>\n
or<\/p>\n
SELECT e.owner, e.segment_type, e.segment_name, e.partition_name, c.file#\n, greatest(e.block_id, c.block#) corr_start_block#\n, least(e.block_id+e.blocks-1, c.block#+c.blocks-1) corr_end_block#\n, least(e.block_id+e.blocks-1, c.block#+c.blocks-1)\n- greatest(e.block_id, c.block#) + 1 blocks_corrupted\n, null description\nFROM dba_extents e, v$database_block_corruption c\nWHERE e.file_id = c.file#\nAND e.block_id <= c.block# + c.blocks - 1\nAND e.block_id + e.blocks - 1 >= c.block#\nUNION\nSELECT s.owner, s.segment_type, s.segment_name, s.partition_name, c.file#\n, header_block corr_start_block#\n, header_block corr_end_block#\n, 1 blocks_corrupted\n, 'Segment Header' description\nFROM dba_segments s, v$database_block_corruption c\nWHERE s.header_file = c.file#\nAND s.header_block between c.block# and c.block# + c.blocks - 1\nUNION\nSELECT null owner, null segment_type, null segment_name, null partition_name, c.file#\n, greatest(f.block_id, c.block#) corr_start_block#\n, least(f.block_id+f.blocks-1, c.block#+c.blocks-1) corr_end_block#\n, least(f.block_id+f.blocks-1, c.block#+c.blocks-1)\n- greatest(f.block_id, c.block#) + 1 blocks_corrupted\n, 'Free Block' description\nFROM dba_free_space f, v$database_block_corruption c\nWHERE f.file_id = c.file#\nAND f.block_id <= c.block# + c.blocks - 1\nAND f.block_id + f.blocks - 1 >= c.block#\nORDER BY file#, corr_start_block#;<\/pre>\n
When you run the query, it will tell you where the block corruption is, as shown below.<\/p>\n
<\/p>\n
Repair All Block Corruptions<\/h3>\n
To repair all the corruptions in this list, simply run the following command with RMAN.<\/p>\n
RMAN> blockrecover corruption list;<\/pre>\n
Repair a particular block<\/h3>\n
RMAN> blockrecover datafile 151 block 3454464;<\/pre>\n
You can find the datafile and block number from v$database_block_corruption<\/code>as I mentioned above.<\/p>\n
Finally you need to check the corresponding datafiles. With the following command, you can scan the entire datafile and see if there are problems.<\/p>\n
RMAN> backup validate check logical datafile 151;\n\nStarting backup at 31-MAR-16\nusing channel ORA_DISK_1\nusing channel ORA_DISK_2\nusing channel ORA_DISK_3\nusing channel ORA_DISK_4\nusing channel ORA_DISK_5\nusing channel ORA_DISK_6\nusing channel ORA_DISK_7\nusing channel ORA_DISK_8\nchannel ORA_DISK_1: starting full datafile backup set\nchannel ORA_DISK_1: specifying datafile(s) in backup set\ninput datafile file number=00151 name=+DATA\/orcl\/datafile\/data_ts.1491.871430401\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:01:35\nList of Datafiles\n=================\nFile Status Marked Corrupt Empty Blocks Blocks Examined High SCN\n---- ------ -------------- ------------ --------------- ----------\n151 OK 0 153363 3932160 629800241304\nFile Name: +DATA\/orcl\/datafile\/data_ts.1491.871430401\nBlock Type Blocks Failing Blocks Processed\n---------- -------------- ----------------\nData 0 3718487 \nIndex 0 3829 \nOther 0 56481\n\nFinished backup at 31-MAR-16<\/pre>\n
If the Status OK and Blocks Failing values are zero as in the above output, we can say that the problem is fixed.<\/p>\n
If you want to check the datafile offline, you can also use the DB verify tool<\/strong>. The sample command is as follows.<\/p>\n
dbv file=+DATA\/orcl\/datafile\/users.411.795847253 blocksize=8192 userid=sys\/*****<\/pre>\n\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
In this article, we will see how to fix block corruption when there is a block corruption on a data file. If Block Corruption is on the index, you can solve the problem by dropping and recreating the index. In some cases, block corruption can also be on free pages. Detect Corrupt Blocks Block corruption …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":1,"featured_media":14360,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[4],"tags":[285,272,277,6976,6975,284,6977,6985,6293,286,283,279,282,273,276,6989,287,6990,6993,6966,6967,6958,6948,6947,6982,6962,6963,6944,6943,6983,6956,6979,6986,6957,6980,6941,6940,278,6969,6984,274,6951,6952,6950,6949,6953,6954,6955,6973,6974,6981,6960,6961,275,6988,6959,6968,6946,6945,6991,6992,6964,6965,6987,6971,6972,6970,280,281,6978],"class_list":["post-265","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle","tag-backup-validate","tag-block-corruption","tag-block-corruption-on-oracle","tag-block-corruption-oracle","tag-block-corruption-rman","tag-blockrecover","tag-check-block-corruption-using-rman","tag-check-corrupt-blocks","tag-check-corrupted-blocks","tag-check-logical","tag-connect-to-oracle","tag-connect-to-rman","tag-connect-to-toad","tag-corruption","tag-data-file-corruption","tag-db-verify-tool","tag-dba_extents","tag-dbv","tag-detect-and-fix-block-corruption","tag-detect-and-repair-block-corruption","tag-detect-and-repair-block-corruption-in-oracle","tag-detect-block-corruption","tag-detect-block-corruption-in-oracle","tag-detect-block-corruption-in-oracle-11g","tag-detect-block-corruptions","tag-detect-corrupt-blocks","tag-detect-corrupt-blocks-in-oracle","tag-find-block-corruption","tag-find-block-corruption-oracle-database","tag-find-block-corruptions","tag-find-corrupt-block-oracle","tag-find-corrupt-blocks-in-oracle","tag-find-corrupted-blocks","tag-find-corrupted-blocks-oracle","tag-find-corrupted-objects-in-oracle","tag-finding-block-corruption","tag-finding-block-corruption-in-oracle","tag-fix-block-corruption","tag-fix-block-corruption-using-rman","tag-fix-corrupt-blocks","tag-free-page-corruption","tag-how-to-check-block-corruption-in-oracle","tag-how-to-check-data-block-corruption-in-oracle","tag-how-to-find-corrupt-blocks","tag-how-to-find-corrupt-blocks-in-oracle","tag-how-to-find-out-block-corruption-in-oracle","tag-how-to-find-the-block-corruption-in-oracle","tag-how-to-identify-block-corruption-in-oracle","tag-how-to-recover-block-corruption-in-oracle-11g-using-rman","tag-how-to-recover-block-corruption-in-oracle-12c-using-rman","tag-identify-corrupted-objects-in-oracle","tag-identifying-corrupt-blocks","tag-identifying-corrupt-blocks-in-oracle","tag-index-corruption","tag-oracle-corrupted-blocks","tag-oracle-detect-block-corruption","tag-oracle-repair-block-corruption","tag-query-to-check-block-corruption-in-oracle","tag-query-to-find-block-corruption-in-oracle","tag-repair-a-particular-block","tag-repair-all-the-corruptions","tag-repair-block-corruption","tag-repair-block-corruption-in-oracle","tag-repair-corrupted-blocks","tag-repair-data-block-corruption","tag-repair-data-block-corruption-in-oracle","tag-rman-repair-block-corruption","tag-sqlplus","tag-toad","tag-vdatabase_block_corruption"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":8506,"today_views":0},"yoast_head":"\nHow To Detect and Repair Block Corruption in Oracle - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To Detect and Repair Block Corruption in Oracle\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2018\/06\/13\/how-to-fix-block-corruption-on-oracle\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Detect and Repair Block Corruption in Oracle - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To Detect and Repair Block Corruption in Oracle\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/06\/13\/how-to-fix-block-corruption-on-oracle\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-06-13T20:37:07+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-01-03T11:14:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-26.png\" \/>\n\t<meta property=\"og:image:width\" content=\"514\" \/>\n\t<meta property=\"og:image:height\" content=\"306\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/13\/how-to-fix-block-corruption-on-oracle\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/13\/how-to-fix-block-corruption-on-oracle\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How To Detect and Repair Block Corruption in Oracle\",\"datePublished\":\"2018-06-13T20:37:07+00:00\",\"dateModified\":\"2020-01-03T11:14:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/13\/how-to-fix-block-corruption-on-oracle\/\"},\"wordCount\":366,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/13\/how-to-fix-block-corruption-on-oracle\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-26.png\",\"keywords\":[\"backup validate\",\"block corruption\",\"block corruption on oracle\",\"block corruption oracle\",\"block corruption rman\",\"blockrecover\",\"check block corruption using rman\",\"check corrupt blocks\",\"check corrupted blocks\",\"check logical\",\"connect to oracle\",\"connect to rman\",\"connect to toad\",\"corruption\",\"data file corruption\",\"DB verify tool\",\"dba_extents\",\"dbv\",\"Detect and Fix Block Corruption\",\"detect and repair block corruption\",\"detect and repair block corruption in oracle\",\"detect block corruption\",\"detect block corruption in oracle\",\"detect block corruption in oracle 11g\",\"detect block corruptions\",\"Detect Corrupt Blocks\",\"Detect Corrupt Blocks in Oracle\",\"find block corruption\",\"find block corruption oracle database\",\"find block corruptions\",\"find corrupt block oracle\",\"Find corrupt blocks in Oracle\",\"find corrupted blocks\",\"find corrupted blocks oracle\",\"find corrupted objects in oracle\",\"finding block corruption\",\"finding block corruption in oracle\",\"fix block corruption\",\"fix block corruption using rman\",\"fix corrupt blocks\",\"free page corruption\",\"how to check block corruption in oracle\",\"how to check data block corruption in oracle\",\"how to find corrupt blocks\",\"how to find corrupt blocks in oracle\",\"how to find out block corruption in oracle\",\"how to find the block corruption in oracle\",\"how to identify block corruption in oracle\",\"how to recover block corruption in oracle 11g using rman\",\"how to recover block corruption in oracle 12c using rman\",\"identify corrupted objects in oracle\",\"Identifying Corrupt Blocks\",\"Identifying Corrupt Blocks in oracle\",\"index corruption\",\"oracle corrupted blocks\",\"oracle detect block corruption\",\"oracle repair block corruption\",\"query to check block corruption in oracle\",\"query to find block corruption in oracle\",\"repair a particular block\",\"repair all the corruptions\",\"repair block corruption\",\"repair block corruption in oracle\",\"repair corrupted blocks\",\"repair data block corruption\",\"repair data block corruption in oracle\",\"rman repair block corruption\",\"sqlplus\",\"toad\",\"v$database_block_corruption\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/06\/13\/how-to-fix-block-corruption-on-oracle\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/13\/how-to-fix-block-corruption-on-oracle\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/13\/how-to-fix-block-corruption-on-oracle\/\",\"name\":\"How To Detect and Repair Block Corruption in Oracle - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/13\/how-to-fix-block-corruption-on-oracle\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/13\/how-to-fix-block-corruption-on-oracle\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-26.png\",\"datePublished\":\"2018-06-13T20:37:07+00:00\",\"dateModified\":\"2020-01-03T11:14:54+00:00\",\"description\":\"How To Detect and Repair Block Corruption in Oracle\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/13\/how-to-fix-block-corruption-on-oracle\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/06\/13\/how-to-fix-block-corruption-on-oracle\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/13\/how-to-fix-block-corruption-on-oracle\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-26.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-26.png\",\"width\":514,\"height\":306},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/13\/how-to-fix-block-corruption-on-oracle\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Detect and Repair Block Corruption in Oracle\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Detect and Repair Block Corruption in Oracle - Database Tutorials","description":"How To Detect and Repair Block Corruption in Oracle","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2018\/06\/13\/how-to-fix-block-corruption-on-oracle\/","og_locale":"en_US","og_type":"article","og_title":"How To Detect and Repair Block Corruption in Oracle - Database Tutorials","og_description":"How To Detect and Repair Block Corruption in Oracle","og_url":"https:\/\/dbtut.com\/index.php\/2018\/06\/13\/how-to-fix-block-corruption-on-oracle\/","og_site_name":"Database Tutorials","article_published_time":"2018-06-13T20:37:07+00:00","article_modified_time":"2020-01-03T11:14:54+00:00","og_image":[{"width":514,"height":306,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-26.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/13\/how-to-fix-block-corruption-on-oracle\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/13\/how-to-fix-block-corruption-on-oracle\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How To Detect and Repair Block Corruption in Oracle","datePublished":"2018-06-13T20:37:07+00:00","dateModified":"2020-01-03T11:14:54+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/13\/how-to-fix-block-corruption-on-oracle\/"},"wordCount":366,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/13\/how-to-fix-block-corruption-on-oracle\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-26.png","keywords":["backup validate","block corruption","block corruption on oracle","block corruption oracle","block corruption rman","blockrecover","check block corruption using rman","check corrupt blocks","check corrupted blocks","check logical","connect to oracle","connect to rman","connect to toad","corruption","data file corruption","DB verify tool","dba_extents","dbv","Detect and Fix Block Corruption","detect and repair block corruption","detect and repair block corruption in oracle","detect block corruption","detect block corruption in oracle","detect block corruption in oracle 11g","detect block corruptions","Detect Corrupt Blocks","Detect Corrupt Blocks in Oracle","find block corruption","find block corruption oracle database","find block corruptions","find corrupt block oracle","Find corrupt blocks in Oracle","find corrupted blocks","find corrupted blocks oracle","find corrupted objects in oracle","finding block corruption","finding block corruption in oracle","fix block corruption","fix block corruption using rman","fix corrupt blocks","free page corruption","how to check block corruption in oracle","how to check data block corruption in oracle","how to find corrupt blocks","how to find corrupt blocks in oracle","how to find out block corruption in oracle","how to find the block corruption in oracle","how to identify block corruption in oracle","how to recover block corruption in oracle 11g using rman","how to recover block corruption in oracle 12c using rman","identify corrupted objects in oracle","Identifying Corrupt Blocks","Identifying Corrupt Blocks in oracle","index corruption","oracle corrupted blocks","oracle detect block corruption","oracle repair block corruption","query to check block corruption in oracle","query to find block corruption in oracle","repair a particular block","repair all the corruptions","repair block corruption","repair block corruption in oracle","repair corrupted blocks","repair data block corruption","repair data block corruption in oracle","rman repair block corruption","sqlplus","toad","v$database_block_corruption"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/06\/13\/how-to-fix-block-corruption-on-oracle\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/13\/how-to-fix-block-corruption-on-oracle\/","url":"https:\/\/dbtut.com\/index.php\/2018\/06\/13\/how-to-fix-block-corruption-on-oracle\/","name":"How To Detect and Repair Block Corruption in Oracle - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/13\/how-to-fix-block-corruption-on-oracle\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/13\/how-to-fix-block-corruption-on-oracle\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-26.png","datePublished":"2018-06-13T20:37:07+00:00","dateModified":"2020-01-03T11:14:54+00:00","description":"How To Detect and Repair Block Corruption in Oracle","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/13\/how-to-fix-block-corruption-on-oracle\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/06\/13\/how-to-fix-block-corruption-on-oracle\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/13\/how-to-fix-block-corruption-on-oracle\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-26.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-26.png","width":514,"height":306},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/13\/how-to-fix-block-corruption-on-oracle\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Detect and Repair Block Corruption in Oracle"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/265","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=265"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/265\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/14360"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=265"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=265"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=265"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}