OraFAQ Forum: Server Utilities » Data Pump throwing errors

Home » RDBMS Server » Server Utilities » Data Pump throwing errors (11.2.0.4)

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

Data Pump throwing errors [message #648086]

Tue, 16 February 2016 04:34

manishdba007
Messages: 27
Registered: September 2014
Location: India

Junior Member

Hi all,

Our Dev DB is a bit corrputed and i want to take a dump of it before situation gets worse.
I am trying to estimate dump size of my DB but getting errors . Please find below executed commands and errors -

[oracle@******* dpdump]$ expdp directory=DATA_PUMP_DIR NOLOGFILE=y ESTIMATE_ONLY=y

Export: Release 11.2.0.4.0 - Production on Tue Feb 16 18:30:32 2016

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

Username: / as sysdba

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

UDE-31623: operation generated ORACLE error 31623
ORA-31623: a job is not attached to this session via the specified handle
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3326
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4551
ORA-06512: at line 1

Apart from this i have seen some blogs saying that for DP we need some parameters has to be set -

streams_pool_size , sga_target , memory_target these all are set to 0 right now . Is it true that without these we cant perform any DP operation ? Is there any way to take dump of this DB without bouncing ?

Thanks in advance
Manish sharma

Report message to a moderator

Re: Data Pump throwing errors [message #648088 is a reply to message #648086]

Tue, 16 February 2016 05:03

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

What are your O/S details? Also, what does the following query return?

SELECT comp_name, status, version
FROM   dba_registry;

Report message to a moderator

Re: Data Pump throwing errors [message #648099 is a reply to message #648088]

Tue, 16 February 2016 08:58

manishdba007
Messages: 27
Registered: September 2014
Location: India

Junior Member

Hi,

Please find below os details -

Linux DEV-SMPDB 2.6.32-279.el6.x86_64 #1 SMP Wed Jun 13 18:24:36 EDT 2012 x86_64 x86_64 x86_64 GNU/Linux

COMP_NAME STATUS VERSION
--------------------------------------------- ----------- ------------------------------
OWB VALID 11.2.0.4.0
Oracle Application Express VALID 3.2.1.00.12
OLAP Catalog VALID 11.2.0.4.0
Spatial VALID 11.2.0.4.0
Oracle Multimedia VALID 11.2.0.4.0
Oracle XML Database VALID 11.2.0.4.0
Oracle Text VALID 11.2.0.4.0
Oracle Expression Filter VALID 11.2.0.4.0
Oracle Rules Manager VALID 11.2.0.4.0
Oracle Workspace Manager VALID 11.2.0.4.0
Oracle Database Catalog Views VALID 11.2.0.4.0
Oracle Database Packages and Types VALID 11.2.0.4.0
JServer JAVA Virtual Machine VALID 11.2.0.4.0
Oracle XDK VALID 11.2.0.4.0
Oracle Database Java Packages VALID 11.2.0.4.0
OLAP Analytic Workspace VALID 11.2.0.4.0
Oracle OLAP API VALID 11.2.0.4.0

Regards
Manish

Report message to a moderator

Re: Data Pump throwing errors [message #648100 is a reply to message #648099]

Tue, 16 February 2016 09:00

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

what clues exist in alert_SID.log file?

Report message to a moderator

Re: Data Pump throwing errors [message #648105 is a reply to message #648100]

Tue, 16 February 2016 10:26

manishdba007
Messages: 27
Registered: September 2014
Location: India

Junior Member

Hi,

Alert log is showing below kind of errors -

Thu Feb 11 14:57:30 2016
Corrupt Block Found
TSN = 41, TSNAME = SMP_QA2_DATA
RFN = 39, BLK = 3123, RDBA = 163580979
OBJN = 111813, OBJD = 111813, OBJECT = CALL_CODING, SUBOBJECT =
SEGMENT OWNER = SMP_QA2, SEGMENT TYPE = Table Segment
Corrupt Block Found
TSN = 41, TSNAME = SMP_QA2_DATA
RFN = 39, BLK = 3123, RDBA = 163580979
OBJN = 111813, OBJD = 111813, OBJECT = CALL_CODING, SUBOBJECT =
SEGMENT OWNER = SMP_QA2, SEGMENT TYPE = Table Segment
Errors in file /u01/app/oracle/diag/rdbms/smpdb/SMPDB/trace/SMPDB_ora_59868.trc (incident=41186):
ORA-01578: ORACLE data block corrupted (file # 39, block # 3123)
ORA-01110: data file 39: '/u08/SMPDB/appdata/QA2/SMP_QA2_DATA.ora'

Rgds
Manish

Report message to a moderator

Re: Data Pump throwing errors [message #648107 is a reply to message #648105]

Tue, 16 February 2016 11:56

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

Senior Member
Account Moderator

First ask your DBA to fix the corruption.

Please read How to use [code] tags and make your code easier to read.

Report message to a moderator

Re: Data Pump throwing errors [message #648120 is a reply to message #648107]

Tue, 16 February 2016 21:02

manishdba007
Messages: 27
Registered: September 2014
Location: India

Junior Member

Hi,

I am the DBA here . i just joined a week ago. They do not have any backups and DB is running in No-archivelog. I tried through RMAN

RMAN>RECOVER CORRUPTION LIST;

but error reported --> backup not found

Rgds
Manish

Report message to a moderator

Re: Data Pump throwing errors [message #648121 is a reply to message #648120]

Tue, 16 February 2016 21:08

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

How wide spread is the disk corruption?
Does more than one data file contain corrupted blocks?

Last time I checked here, nobody here can do miracles.

Consider submitting a Service Request.

Report message to a moderator

Re: Data Pump throwing errors [message #648122 is a reply to message #648121]

Tue, 16 February 2016 21:12

manishdba007
Messages: 27
Registered: September 2014
Location: India

Junior Member

Yes more than one datafile has corrpution including system.dbf.
Yes i will raise SR.

Thanks
Manish

Report message to a moderator

Re: Data Pump throwing errors [message #648130 is a reply to message #648122]

Wed, 17 February 2016 01:17

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

Senior Member
Account Moderator

So they will help you step by step.

Report message to a moderator

Previous Topic:	SQLLDR - error loading xml column into xmltype column
Next Topic:	Convert DB2 load scripts to Oracle Load scripts

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 07 01:31:16 CST 2025