OraFAQ Forum: Server Administration » ORA-01498 ... need some help

Home » RDBMS Server » Server Administration » ORA-01498 ... need some help

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01498 ... need some help [message #369366]

Thu, 07 September 2000 04:24

Henrik Bachmann
Messages: 2
Registered: August 1998

Junior Member

Hi there,

anybody out there who can give me a hint for the following problem?

There is an Oracle server 7.3.4 with several schemes and I have detected some data trash and now I am facing with the following error after an ANALYZE TABLE VALIDATE STRUCTURE CASCADE:

ORA-01498 block Check Failure - see trace file
Cause: An error occurred while checking a block with the ANALYZE command.

What I have to do now respectively what can I do now to detect the whole extent of the problem?

How can I determine the affected rows to remove the data trash?

What can I do to fix the problem?

Best regards

Henrik Bachmann mailto:Henrik.Bachmann@bim-consulting.de

B.I.M.-Consulting Magdeburg http://www.bim-consulting.de/
D-39124 Magdeburg

Report message to a moderator

Re: ORA-01498 ... need some help [message #369367 is a reply to message #369366]

Thu, 07 September 2000 04:31

Miki
Messages: 11
Registered: August 2000

Junior Member

What do you have in trace file?

ORA-01498 block Check Failure - see trace file
Cause: An error occurred while checking a block with the ANALYZE command.

Action: Check the trace file for more descriptive messages about the problem. Correct these errors. The name of the trace file is operating system-specific, for example, ORAxxxx.TRC. It is found in the directory specified by the initialization parameter USER_DUMP_DEST. If USER_DUMP_DEST is not set, trace files are not created. It may be necessary to recreate the object. See also your operating system-specific Oracle documentation.

Report message to a moderator

Re: ORA-01498 ... need some help [message #369368 is a reply to message #369367]

Thu, 07 September 2000 04:38

Henrik Bachmann
Messages: 2
Registered: August 1998

Junior Member

I can not find any usefull information in the trace file. Take a look at this extract please:

*** 2000.09.06.14.35.46.627
kdbchk: the amount of space used is not equal to block size
used=6355 fsc=0 avsp=1941 dtl=8120
Block header dump: dba: 0x06000391
Object id on Block? Y
seg/obj: 0x68c csc: 0x00.4f39f4b6 itc: 1 flg: - typ: 1 - DATA
fsl: 0 fnx: 0x0

Itl Xid Uba Flag Lck Scn/Fsc
0x01 0x0002.067.00005aae 0x0300217b.0dc1.0b C--- 0 scn 0x0000.4f39f498

data_block_dump
===============
tsiz: 0x1fb8
hsiz: 0xa4
pbl: 0x03c28044
bdba: 0x06000391
flag=---------
ntab=1
nrow=73
frre=28
fsbo=0xa4
fseo=0x573
avsp=0x795
tosp=0x795
0xe:pti0 nrow=73 offs=0
0x12:pri0 offs=0x1f4d
0x14:pri1 offs=0x1ee3
0x16:pri2 offs=0x1e87
...
...

Report message to a moderator

Re: ORA-01498 ... need some help [message #369369 is a reply to message #369368]

Thu, 07 September 2000 06:55

Miki
Messages: 11
Registered: August 2000

Junior Member

I checked http://metalink.oracle.com
Unfortunatelly there isn't much info about that kind of error.
So, basicly you have to send tracefile to Oracle support.

Here is info from web.

Explanation:
Generally this is a result of an ANALYZE ... VALIDATE ... command.
Send the tracefile to support for analysis.

If the ANALYZE was against an index you should check the whole object. Eg: Find the tablename and execute:

ANALYZE TABLE xxx VALIDATE STRUCTURE CASCADE;

While support are processing the tracefile it may be worth the re-running the ANALYZE after restarting the database to help show if
the corruption is consistent or if it 'moves' !!

Report message to a moderator

Re: ORA-01498 ... need some help [message #369605 is a reply to message #369369]

Thu, 02 November 2000 09:26

simham
Messages: 7
Registered: November 2000

Junior Member

using rowid skip that block and insert other records into a new table.drop the table and rename the new table as original table.

Report message to a moderator

Previous Topic:	Performance Question
Next Topic:	how to store encrypted file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Feb 12 15:14:12 CST 2025