OraFAQ Forum: Server Administration » dbverfy & block corruption

Home » RDBMS Server » Server Administration » dbverfy & block corruption

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

dbverfy & block corruption [message #62586]

Sun, 01 August 2004 12:01

ramya
Messages: 87
Registered: August 2002

Member

hello
i had block corruption in one of the datafile found when i run
the dbverify i got some pages corrupted.That's one of the reason
when i am not able to select the tables it giving error ora-08103
objects no longer exists.How to recover from this error or how to rectify it .i am using oracle8.1.7 on solaris 8.my database on
non archivelog and so we are not using rman.pls hlp by a solution
with regards
ramya

Report message to a moderator

Re: dbverfy & block corruption [message #62611 is a reply to message #62586]

Tue, 03 August 2004 00:42

Satheesh Babu.S
Messages: 35
Registered: July 2004

Member

dbverify does not scan what is there in the sga. It just checks the datafile. You would droped the table, but that information is not flushed yet to the datafile, in this scenario if you run dbverify it will raise corruption error.

I think probably that's what happening in your case.

Thanks and Regards,
Satheesh Babu.S
Bangalore.

Report message to a moderator

Re: dbverfy & block corruption [message #62615 is a reply to message #62611]

Tue, 03 August 2004 02:32

ramya
Messages: 87
Registered: August 2002

Member

no the tables are still there with more data no deletion is it realted to os block corruption or
have to update any patches.i am using oracle 8.1.7.0.0
no patches applied
with regards

Report message to a moderator

Re: dbverfy & block corruption [message #62618 is a reply to message #62615]

Tue, 03 August 2004 03:43

Satheesh Babu.S
Messages: 35
Registered: July 2004

Member

I think you have a block corruption here,

ANALYZE TABLE .. VALIDATE STRUCTURE CASCADE;
for the table, this is almost equal to dbms_repair command.

Else see 28814.1

Thanks and Regards,
Satheesh Babu.S

Report message to a moderator

Previous Topic:	avoiding fragmentation
Next Topic:	how can i eliminate chained rows

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 23 15:49:29 CST 2025