Home » RDBMS Server » Backup & Recovery » Block Corruption in Expdp (Oracle 11g and Windows 2003 Server)
Block Corruption in Expdp [message #494589] Tue, 15 February 2011 23:00 Go to next message
pradies
Messages: 238
Registered: May 2008
Senior Member
Hi,

I am facing issue of block curruption in my exp backup which I am taking through expdp command. (Refer Attachment of Screen shot of error)

I want to know few things about the block corruption.

1. Why the block corruption occur.
2. How can I resolve this.
3. Can I rosolve this by deleting the same record on which this error is coming. if yes then how can I track that row in a table.

I already tried for DB verify utility. It shows the below result.
===================================================================
C:\Documents and Settings\Administrator>dbv file='E:\ORADATA\AFCCV1\MONETA01.DBF' blocksize=8192

DBVERIFY: Release 11.1.0.6.0 - Production on Wed Feb 16 10:13:11 2011

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

DBVERIFY - Verification starting : FILE = E:\ORADATA\AFCCV1\MONETA01.DBF

DBV-00600: Fatal Error - [28] [27070] [0] [0]

C:\Documents and Settings\Administrator>
================================================================

Kindly suggest if there is any resolution for the above corruption

Thanks and Regards
Pradeep
Re: Block Corruption in Expdp [message #494591 is a reply to message #494589] Tue, 15 February 2011 23:06 Go to previous messageGo to next message
BlackSwan
Messages: 21938
Registered: January 2009
Senior Member
>I am facing issue of block curruption in my exp backup which I am taking through expdp command.

DBV is designed to operate against database files & not file produced by expdp.

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: Block Corruption in Expdp [message #494592 is a reply to message #494589] Tue, 15 February 2011 23:09 Go to previous messageGo to next message
pradies
Messages: 238
Registered: May 2008
Senior Member
Error Screen Shot for above


Reagrds

Pradeep
Re: Block Corruption in Expdp [message #494593 is a reply to message #494592] Tue, 15 February 2011 23:11 Go to previous messageGo to next message
pradies
Messages: 238
Registered: May 2008
Senior Member
Hi Swan,

I am running dbv verify utilty on the database file not on the backup dump file.


Regards

Pradeep
Re: Block Corruption in Expdp [message #494595 is a reply to message #494593] Tue, 15 February 2011 23:21 Go to previous messageGo to next message
BlackSwan
Messages: 21938
Registered: January 2009
Senior Member
>DBV-00600: Fatal Error - [28] [27070] [0] [0]
the dbv utility is blowing up & aborting.

Are you certain that BLOCKSIZE=8192 is correct?
If above is correct, then consider submitting a Service Request.
Re: Block Corruption in Expdp [message #494598 is a reply to message #494595] Tue, 15 February 2011 23:34 Go to previous messageGo to next message
pradies
Messages: 238
Registered: May 2008
Senior Member
Hi Swan,

My db blocksize is 8192.


NAME VALUE
-------------------- ----------
db_block_size 8192
db_name afccv1


One thing I want to ask Can I identify the row which is not readable due to curruption.


Thanks and Reagrds
Pradeep
Re: Block Corruption in Expdp [message #494600 is a reply to message #494598] Tue, 15 February 2011 23:36 Go to previous messageGo to next message
Michel Cadot
Messages: 57603
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Your posts does not show any corruption in the database just an error in DBV execution.
Please post the relevant information.

Regards
Michel

[Updated on: Tue, 15 February 2011 23:37]

Report message to a moderator

Re: Block Corruption in Expdp [message #494601 is a reply to message #494598] Tue, 15 February 2011 23:37 Go to previous messageGo to next message
BlackSwan
Messages: 21938
Registered: January 2009
Senior Member
>One thing I want to ask Can I identify the row which is not readable due to curruption.
I am NOT convinced that any corruption exists.
dbv is aborting.
Re: Block Corruption in Expdp [message #494620 is a reply to message #494601] Wed, 16 February 2011 01:34 Go to previous messageGo to next message
jayraj
Messages: 11
Registered: January 2011
Location: Mumbai
Junior Member
1. Are you using PARALLEL parameter while running "expdp"? If yes, then remove that and run your expdp back again.

2. Are you using same version of database and client? (Downward compatibility is there but not upward.)


Brgds,

Sanjay
Re: Block Corruption in Expdp [message #494622 is a reply to message #494620] Wed, 16 February 2011 01:39 Go to previous messageGo to next message
pradies
Messages: 238
Registered: May 2008
Senior Member
Hi Sanjay,

I am not using parallal option in expdp. and I am trying to export on the DB server expdp utility.


Regards

Pradeep
Re: Block Corruption in Expdp [message #494624 is a reply to message #494622] Wed, 16 February 2011 01:42 Go to previous messageGo to next message
Michel Cadot
Messages: 57603
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And what are the answer to our quesions?

Regards
Michel
Re: Block Corruption in Expdp [message #494627 is a reply to message #494624] Wed, 16 February 2011 01:57 Go to previous messageGo to next message
pradies
Messages: 238
Registered: May 2008
Senior Member
Hi Michal,

As you said "error in DBV execution" I am not able clarify/identify why there is error.

Might be it occurs due to tablespace is in use. or there is some permission error. but I am using windows and dbf file having read write permission. For Is in use I can't take db down right now so I will recheck dbv utility when I will be able to take downtime of db.

If you have any clues regarding this then please tell me.

Regards
Pradeep
Re: Block Corruption in Expdp [message #494633 is a reply to message #494627] Wed, 16 February 2011 02:38 Go to previous message
Michel Cadot
Messages: 57603
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
As you said "error in DBV execution" I am not able clarify/identify why there is error.

DBV-600 => bug => Oracle support

Quote:
Might be it occurs due to tablespace is in use.

No.

Quote:
or there is some permission error.

Maybe.

Quote:
If you have any clues regarding this then please tell me.

DBV-600 => bug => Oracle support

Why did you say there is a "block corruption"?

Regards
Michel

Previous Topic: RMAN-06172: no autobackup found or specified handle is not a valid copy or piece
Next Topic: RMAN backup
Goto Forum:
  


Current Time: Wed Apr 16 20:40:53 CDT 2014

Total time taken to generate the page: 0.12378 seconds