OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Corrupt objects.

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

Corrupt objects. [message #330088]

Fri, 27 June 2008 10:05

ArvindBhope
Messages: 55
Registered: June 2008

Member

How can we determine or log a Corrupted object?

Report message to a moderator

Re: Corrupt objects. [message #330092 is a reply to message #330088]

Fri, 27 June 2008 10:10

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

ArvindBhope wrote on Fri, 27 June 2008 08:05

How can we determine or log a Corrupted object?

Oracle will report corruption when it finds it.
You can scan database files using the "dbv" utility.

Report message to a moderator

Re: Corrupt objects. [message #330093 is a reply to message #330088]

Fri, 27 June 2008 10:18

ArvindBhope
Messages: 55
Registered: June 2008

Member

yeah thanks !!
How do we DBA's can log it out ?

Report message to a moderator

Re: Corrupt objects. [message #330104 is a reply to message #330093]

Fri, 27 June 2008 10:37

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Redirecting dbv output to a file.

Regards
Michel

Report message to a moderator

Re: Corrupt objects. [message #330117 is a reply to message #330088]

Fri, 27 June 2008 10:54

ArvindBhope
Messages: 55
Registered: June 2008

Member

Looks like either the question wasn't clear ...

.......

Thazz the secondary part logging the dbv to ...
Any parrticular way to get logged into either from sqlplus .. or alert log ...

Iam looking from monitoring perspective
plese let me know at the earliest

thanks.

Report message to a moderator

Re: Corrupt objects. [message #330119 is a reply to message #330117]

Fri, 27 June 2008 10:59

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

ArvindBhope wrote on Fri, 27 June 2008 08:54

Looks like either the question wasn't clear

I agree.
What problem are you trying to solve?
How would an independent observer realize that your problem has been solved?

Report message to a moderator

Re: Corrupt objects. [message #330141 is a reply to message #330119]

Fri, 27 June 2008 11:49

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Have a look a the status column in the all_objects view. I guess that's what you are after.

Report message to a moderator

Re: Corrupt objects. [message #330143 is a reply to message #330088]

Fri, 27 June 2008 11:54

ArvindBhope
Messages: 55
Registered: June 2008

Member

I guess that would just state us the status of the object ...i.e (VALID, INVALID, or N/A)

Please let me know if you are aware of any thing else on this

thanks

Report message to a moderator

Re: Corrupt objects. [message #330144 is a reply to message #330143]

Fri, 27 June 2008 11:57

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Maybe you can first tell us what exactly you mean by the word "Corrupted", and what you mean by "Object".

And what the actual reason is for the question.

Report message to a moderator

Re: Corrupt objects. [message #330146 is a reply to message #330088]

Fri, 27 June 2008 11:59

ArvindBhope
Messages: 55
Registered: June 2008

Member

Yeah Sure.

Need to setup a script on a unix box for the corrupted objects in the database, Hence the query.

Report message to a moderator

Re: Corrupt objects. [message #330150 is a reply to message #330146]

Fri, 27 June 2008 12:12

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

That just answers "what", now "why", and the other two questions are also still unanswered. What sort of corruption do you mean, and what sort of objects?

You could detect block level datafile corruptions by doing a full export ( to /dev/null perhaps).

Report message to a moderator

Re: Corrupt objects. [message #330151 is a reply to message #330088]

Fri, 27 June 2008 12:14

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>now "why
The Pointy Haired Boss want to be "proactive";
but given that the corruption has already occurred this is like the search for the Golden Fleece.

Report message to a moderator

Re: Corrupt objects. [message #330152 is a reply to message #330151]

Fri, 27 June 2008 12:19

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

anacedent wrote on Fri, 27 June 2008 19:14

>
The Pointy Haired Boss want to be "proactive";

"Ah, yes. The "Can you write a script that will mail us all the errors that will occur the following week on Monday morning?" approach. Very Happy

Report message to a moderator

Re: Corrupt objects. [message #330210 is a reply to message #330146]

Fri, 27 June 2008 23:19

OracleDisected
Messages: 25
Registered: September 2007
Location: Mexico

Junior Member

Hi,

The STATUS column for DBA/ALL/USER_OBJECTS won't show you when a table or index is corrupted, just the status for the object (i.e. when you move a table to another tablespace, indexes for that table become INVALID because the keys have rowids that point to blocks in another tablespace).

Second, if you have parameters DB_BLOCK_CHECKING and DB_BLOCK_CHECKSUM set to TRUE, the DB already is doing the checking.

If you want to kill two birds with one shot: use RMAN for backups, it will do the block checking stuff AND you will get all the nice features RMAN can provide for backup and recovery.
V$DATABASE_BLOCK_CORRUPTION view will show you the full list.
Smile

Regards
Ignacio

[Updated on: Sat, 28 June 2008 00:52] by Moderator

Report message to a moderator

Previous Topic:	Index rebuild ...Any risk in this ?
Next Topic:	ASM database rebuild

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 22:31:43 CST 2024