Home » RDBMS Server » Server Utilities » Data Pump throwing errors (11.2.0.4)
Data Pump throwing errors [message #648086] Tue, 16 February 2016 04:34 Go to next message
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
Re: Data Pump throwing errors [message #648088 is a reply to message #648086] Tue, 16 February 2016 05:03 Go to previous messageGo to next message
gazzag
Messages: 1082
Registered: November 2010
Location: Bristol, UK
Senior Member
What are your O/S details? Also, what does the following query return?
SELECT comp_name, status, version
FROM   dba_registry;
Re: Data Pump throwing errors [message #648099 is a reply to message #648088] Tue, 16 February 2016 08:58 Go to previous messageGo to next message
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
Re: Data Pump throwing errors [message #648100 is a reply to message #648099] Tue, 16 February 2016 09:00 Go to previous messageGo to next message
BlackSwan
Messages: 26722
Registered: January 2009
Location: SoCal
Senior Member
what clues exist in alert_SID.log file?
Re: Data Pump throwing errors [message #648105 is a reply to message #648100] Tue, 16 February 2016 10:26 Go to previous messageGo to next message
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
Re: Data Pump throwing errors [message #648107 is a reply to message #648105] Tue, 16 February 2016 11:56 Go to previous messageGo to next message
Michel Cadot
Messages: 67241
Registered: March 2007
Location: Nanterre, France, http://...
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.

Re: Data Pump throwing errors [message #648120 is a reply to message #648107] Tue, 16 February 2016 21:02 Go to previous messageGo to next message
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
Re: Data Pump throwing errors [message #648121 is a reply to message #648120] Tue, 16 February 2016 21:08 Go to previous messageGo to next message
BlackSwan
Messages: 26722
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.
Re: Data Pump throwing errors [message #648122 is a reply to message #648121] Tue, 16 February 2016 21:12 Go to previous messageGo to next message
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
Re: Data Pump throwing errors [message #648130 is a reply to message #648122] Wed, 17 February 2016 01:17 Go to previous message
Michel Cadot
Messages: 67241
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

So they will help you step by step.

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


Current Time: Tue Jul 14 08:23:58 CDT 2020