Добро пожаловать в форум, Guest  >>   Войти | Регистрация | Поиск | Правила | В избранное | Подписаться
Все форумы / Oracle Новый топик    Ответить
 Corrupt data  [new]
simneo
Member

Откуда:
Сообщений: 72
Проблема появилась после того как я закрыл консоль на котором выполнялась накрутка архивлогов.

Случайно закрыл. Затем заного открываю попытался сделать продолжение recover на что мне в ответ:

archive log filename=/ud01/arh/1_110280_638555827.dbf thread=1 sequence=110280
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00601: fatal error in recovery manager
RMAN-03004: fatal error during execution of command
ORA-01092: ORACLE instance terminated. Disconnection forced
RMAN-03002: failure of recover command at 06/25/2010 12:02:23
RMAN-11003: failure during parse/execution of SQL statement: alter database recover logfile '/ud01/arh/1_110280_638555827.dbf'
ORA-01041: internal error. hostdef extension doesn't exist

В алерт логе примерно вот такая картина:
Reread of rdba: 0x03055147 (file 12, block 348487) found same corrupted data
Hex dump of (file 13, block 237673) in trace file /ud01/oradata/billing/bdump/billing_p005_740.trc
Corrupt block relative dba: 0x0343a069 (file 13, block 237673)
Bad header found during media recovery
Data in bad block:
 type: 1 format: 6 rdba: 0x0000a206
 last change scn: 0x71e4.0343a069 seq: 0xd4 flg: 0xc2
 spare1: 0xbe spare2: 0x81 spare3: 0x401
 consistency value in tail: 0x02c1021f
 check value in block header: 0x2
 block checksum disabled
Reread of rdba: 0x0343a069 (file 13, block 237673) found same corrupted data
Hex dump of (file 13, block 237735) in trace file /ud01/oradata/billing/bdump/billing_p005_740.trc
Corrupt block relative dba: 0x0343a0a7 (file 13, block 237735)
Bad header found during media recovery
Data in bad block:
 type: 1 format: 2 rdba: 0x0000a206
 last change scn: 0x62d0.0343a0a7 seq: 0xd4 flg: 0xc2
 spare1: 0xbd spare2: 0x44 spare3: 0x401
 consistency value in tail: 0x80018001
 check value in block header: 0x2
 block checksum disabled
Reread of rdba: 0x0343a0a7 (file 13, block 237735) found same corrupted data
Fri Jun 25 12:01:44 2010
Hex dump of (file 9, block 123871) in trace file /ud01/oradata/billing/bdump/billing_p012_754.trc
Corrupt block relative dba: 0x0241e3df (file 9, block 123871)
Bad header found during media recovery
Data in bad block:
 type: 1 format: 6 rdba: 0x0000a206
 last change scn: 0x29f6.0241e3df seq: 0xd4 flg: 0xc2
 spare1: 0xe spare2: 0x39 spare3: 0x401
 consistency value in tail: 0x0125111f
 check value in block header: 0x2
 block checksum disabled
Reread of rdba: 0x0241e3df (file 9, block 123871) found same corrupted data
Fri Jun 25 12:01:50 2010
Hex dump of (file 10, block 237664) in trace file /ud01/oradata/billing/bdump/billing_p003_736.trc

По инструкции select * from V$DATABASE_BLOCK_CORRUPTION ничего не выдает.

Пытаюсь выполнить (выдает):

BLOCKRECOVER CORRUPTION LIST;

Starting blockrecover at 2010-06-25 13:06:47
using channel ORA_DISK_1

channel ORA_DISK_1: restoring block(s)
channel ORA_DISK_1: specifying block(s) to restore from backup set
restoring blocks of datafile 00005
restoring blocks of datafile 00008
restoring blocks of datafile 00009
restoring blocks of datafile 00010
restoring blocks of datafile 00012
restoring blocks of datafile 00013
channel ORA_DISK_1: reading from backup piece /ud01/ud/BILLING/backupset/2010_05_21/o1_mf_nnndf_TAG20100521T094207_5zd79l0h_.bkp
channel ORA_DISK_1: restored block(s) from backup piece 1
piece handle=/ud01/ud/BILLING/backupset/2010_05_21/o1_mf_nnndf_TAG20100521T094207_5zd79l0h_.bkp tag=TAG20100521T094207
channel ORA_DISK_1: block restore complete, elapsed time: 00:07:37

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of blockrecover command at 06/25/2010 13:14:25
RMAN-06067: RECOVER DATABASE required with a backup or created control file

Что можете подсказать по этому поводу?
25 июн 10, 13:22    [9001732]     Ответить | Цитировать Сообщить модератору
 Re: Corrupt data  [new]
semenar
Member

Откуда: Днепропетровск
Сообщений: 3308
Блог
Прогоните dbv по файлу 13.
25 июн 10, 13:40    [9001911]     Ответить | Цитировать Сообщить модератору
 Re: Corrupt data  [new]
simneo
Member

Откуда:
Сообщений: 72
DBVERIFY: Release 10.2.0.4.0 - Production on Fri Jun 25 13:53:46 2010

Copyright (c) 1982, 2007, Oracle.  All rights reserved.


DBV-00200: Block, DBA 54693483, already marked corrupt


select * from V$DATABASE_BLOCK_CORRUPTION

5	3869678	1	0	CORRUPT
8	143757	1	0	CORRUPT
8	400152	1	0	CORRUPT
9	123871	1	0	CORRUPT
9	123904	1	0	CORRUPT
10	48979	1	0	CORRUPT
10	49109	1	0	CORRUPT
10	237664	1	0	CORRUPT
10	390567	1	0	CORRUPT
10	393333	1	0	CORRUPT
10	393354	1	0	CORRUPT
10	393492	1	0	CORRUPT
10	393635	1	0	CORRUPT
10	429335	1	0	CORRUPT
10	437585	1	0	CORRUPT
12	340423	1	0	CORRUPT
12	340434	1	0	CORRUPT
12	348294	1	0	CORRUPT
12	348324	1	0	CORRUPT
12	348487	1	0	CORRUPT
12	374182	1	0	CORRUPT
12	398688	1	0	CORRUPT
12	443368	1	0	CORRUPT
12	444815	1	0	CORRUPT
13	167504	1	0	CORRUPT
13	167531	1	0	CORRUPT
13	237673	1	0	CORRUPT
13	237735	1	0	CORRUPT

Записи есть (я видимо на другой БД смотрел, сори).
25 июн 10, 14:22    [9002370]     Ответить | Цитировать Сообщить модератору
 Re: Corrupt data  [new]
simneo
Member

Откуда:
Сообщений: 72
Все равно не хочет:

RMAN> BLOCKRECOVER CORRUPTION LIST;

Starting blockrecover at 2010-06-25 14:05:08
using channel ORA_DISK_1

channel ORA_DISK_1: restoring block(s)
channel ORA_DISK_1: specifying block(s) to restore from backup set
restoring blocks of datafile 00005
restoring blocks of datafile 00008
restoring blocks of datafile 00009
restoring blocks of datafile 00010
restoring blocks of datafile 00012
restoring blocks of datafile 00013
channel ORA_DISK_1: reading from backup piece /ud01/ud/BILLING/backupset/2010_05_21/o1_mf_nnndf_TAG20100521T094207_5zd79l0h_.bkp
channel ORA_DISK_1: restored block(s) from backup piece 1
piece handle=/ud01/ud/BILLING/backupset/2010_05_21/o1_mf_nnndf_TAG20100521T094207_5zd79l0h_.bkp tag=TAG20100521T094207
channel ORA_DISK_1: block restore complete, elapsed time: 00:07:36

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of blockrecover command at 06/25/2010 14:12:46
RMAN-06067: RECOVER DATABASE required with a backup or created control file
25 июн 10, 14:51    [9002699]     Ответить | Цитировать Сообщить модератору
 Re: Corrupt data  [new]
simneo
Member

Откуда:
Сообщений: 72
Кто подскажет что можно еще сделать?
28 июн 10, 08:43    [9009490]     Ответить | Цитировать Сообщить модератору
Все форумы / Oracle Ответить