# Tablespace corruption

**URL:** <https://www.batmunkh.net/t/tablespace-corruption/1097>\
**Category:** Oracle Database\
**Tags:** tablespace\
**Created:** [March 29, 2019, 9:35am UTC](https://www.batmunkh.net/t/tablespace-corruption/1097 "2019-03-29T09:35:17Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Brilliance\_Aura](https://www.batmunkh.net/letter_avatar_proxy/v4/letter/b/96bed5/32.png) [@Brilliance\_Aura](https://www.batmunkh.net/u/Brilliance_Aura)\
**Post date:** [March 29, 2019, 9:35am UTC](https://www.batmunkh.net/t/tablespace-corruption/1097/1 "2019-03-29T09:35:17Z")

</div>

corrupted block болснийг яаж засах вэ  
[net](https://oracle-base.com/articles/misc/detect-and-correct-corruption)-ees harahaar recovery yavaad baih ym oor zasah arga baigaa bolu

SELECT b.name,a.\* FROM v$database\_block\_corruption a  
inner JOIN v$datafile b  
ON a.file#=b.file#;

> Blockquote  
> NAME FILE# BLOCK# BLOCKS CORRUPTION\_CHANGE# CORRUPTION\_TYPE  
> +DATA1/rpt/datafile/rptidx.276.994897817 7 786306 1 0 CHECKSUM

---

<div class="post-metadata">

**Author:** ![batmunkh](https://www.batmunkh.net/user_avatar/www.batmunkh.net/batmunkh/32/297_2.png) [@batmunkh](https://www.batmunkh.net/u/batmunkh)\
**Post date:** [March 29, 2019, 9:37am UTC](https://www.batmunkh.net/t/tablespace-corruption/1097/2 "2019-03-29T09:37:48Z")

</div>

archivelog идэвхтэй юу, backup авсан байгаа юу…

---

<div class="post-metadata">

**Author:** ![Brilliance\_Aura](https://www.batmunkh.net/letter_avatar_proxy/v4/letter/b/96bed5/32.png) [@Brilliance\_Aura](https://www.batmunkh.net/u/Brilliance_Aura)\
**Post date:** [April 1, 2019, 10:49am UTC](https://www.batmunkh.net/t/tablespace-corruption/1097/3 "2019-04-01T10:49:26Z")

</div>

байхгүй байгаа

---

<div class="post-metadata">

**Author:** ![Brilliance\_Aura](https://www.batmunkh.net/letter_avatar_proxy/v4/letter/b/96bed5/32.png) [@Brilliance\_Aura](https://www.batmunkh.net/u/Brilliance_Aura)\
**Post date:** [April 1, 2019, 10:49am UTC](https://www.batmunkh.net/t/tablespace-corruption/1097/4 "2019-04-01T10:49:28Z")

</div>

Байхгүй байгаа

---

<div class="post-metadata">

**Author:** ![tumenjargal](https://www.batmunkh.net/user_avatar/www.batmunkh.net/tumenjargal/32/236_2.png) [@tumenjargal](https://www.batmunkh.net/u/tumenjargal)\
**Post date:** [April 2, 2019, 12:59pm UTC](https://www.batmunkh.net/t/tablespace-corruption/1097/5 "2019-04-02T12:59:07Z")

</div>

- ASM redunduncy type external or internal?
- DBMS\_REPAIR пакежыг ашиглаад, corrupt block - г mark хийж ашигалахгүй болгоод, index - үүдийг бас давхар янзална. DML үйлдэл хийгдэхэд corrupt block - г skip хийх байдлаар тохируулна.
- Дараа нь алдагдсан block дээр байсан датаг олоод, гараараа датаг нь янзалчхад болох байх.

---

<div class="post-metadata">

**Author:** ![Brilliance\_Aura](https://www.batmunkh.net/letter_avatar_proxy/v4/letter/b/96bed5/32.png) [@Brilliance\_Aura](https://www.batmunkh.net/u/Brilliance_Aura)\
**Post date:** [April 5, 2019, 2:57am UTC](https://www.batmunkh.net/t/tablespace-corruption/1097/6 "2019-04-05T02:57:40Z")

</div>

thx  
tablespace deer baisan Table, index-uudiig oor tablespace-ruu uusgeed old\_tablespace-iig delete hiichihle.

> select ‘alter index ‘||owner||’.’||index\_name||’ rebuild tablespace NEW\_TABLESPACE parallel 2 online;’ from dba\_indexes  
> where tablespace\_name = ‘OLD\_TABLESPACE’;

> select ‘alter index ‘||owner||’.’||index\_name||’ noparallel;’ from dba\_indexes  
> where tablespace\_name = ‘OLD\_TABLESPACE’;
