Home » RDBMS Server » Server Administration » Corrupt objects.
Corrupt objects. [message #330088] Fri, 27 June 2008 10:05 Go to next message
ArvindBhope
Messages: 55
Registered: June 2008
Member
How can we determine or log a Corrupted object?
Re: Corrupt objects. [message #330092 is a reply to message #330088] Fri, 27 June 2008 10:10 Go to previous messageGo to next message
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.
Re: Corrupt objects. [message #330093 is a reply to message #330088] Fri, 27 June 2008 10:18 Go to previous messageGo to next message
ArvindBhope
Messages: 55
Registered: June 2008
Member
yeah thanks !!
How do we DBA's can log it out ?
Re: Corrupt objects. [message #330104 is a reply to message #330093] Fri, 27 June 2008 10:37 Go to previous messageGo to next message
Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Redirecting dbv output to a file.

Regards
Michel
Re: Corrupt objects. [message #330117 is a reply to message #330088] Fri, 27 June 2008 10:54 Go to previous messageGo to next message
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.
Re: Corrupt objects. [message #330119 is a reply to message #330117] Fri, 27 June 2008 10:59 Go to previous messageGo to next message
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?
Re: Corrupt objects. [message #330141 is a reply to message #330119] Fri, 27 June 2008 11:49 Go to previous messageGo to next message
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.
Re: Corrupt objects. [message #330143 is a reply to message #330088] Fri, 27 June 2008 11:54 Go to previous messageGo to next message
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
Re: Corrupt objects. [message #330144 is a reply to message #330143] Fri, 27 June 2008 11:57 Go to previous messageGo to next message
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.

Re: Corrupt objects. [message #330146 is a reply to message #330088] Fri, 27 June 2008 11:59 Go to previous messageGo to next message
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.
Re: Corrupt objects. [message #330150 is a reply to message #330146] Fri, 27 June 2008 12:12 Go to previous messageGo to next message
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).
Re: Corrupt objects. [message #330151 is a reply to message #330088] Fri, 27 June 2008 12:14 Go to previous messageGo to next message
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.
Re: Corrupt objects. [message #330152 is a reply to message #330151] Fri, 27 June 2008 12:19 Go to previous messageGo to next message
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
icon14.gif  Re: Corrupt objects. [message #330210 is a reply to message #330146] Fri, 27 June 2008 23:19 Go to previous message
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:
  


Current Time: Tue Dec 10 03:34:07 CST 2024