I am trying to use DUL unpump to extra data from a corrupted data pump export file. I need some help with getting the
correct DDL from the unpump stream header output.

Questions:
1.) What is the column type of “<TYPE_NUM>101</TYPE_NUM> ” ?
2.) Is the following column Varchar2(255) ? Notice LENGTH=510 and does not match CHARLENGTH.
<NAME>PAYER_ID</NAME><TYPE_NUM>1</TYPE_NUM><LENGTH>510</LENGTH>…..
<CHARLENGTH>255</CHARLENGTH>

 

Type 101 is most likely a binary double, 8 bytes that together are an ieee double, no idea of those are native or in byte comparable order.

Question: what is the 2nd argument? [58759497]
Situation:
No nightly exports/datapumps we have nightly RMAN backups.
There is a known Oracle Bug 11791664 with inconsistent metadata in ASSM segments with NO workarounds listed

 

The object is in a specific tablespace (REPORTING) separate from our main tablespaces

DBMS_REPAIR.CHECK_OBJECT fails with the same error
Exp fails with the same error
create table as select from fails with same error
I know I can restore the production database to a copy on another server but other than that what are my options here? Can I recover just the tablespace or will that regenerate the same problem once the tablespace is recovered?

Any suggestions are much appreciated.

 

I have never seen this error, so everything below are just assumptions:
In case the BUG only affects the write into the data file, but not it’s
corresponding data in redo / archive, you have a chance you can export the
data there. Please
ask Oracle Support for details on this BUG.
there is a tool called BBED to edit blocks in data files directly. I don’t
know if it can handle your problem I’ve
never done it.
there are some DUL (Data UnLoader) [e.g.  http://www.parnassusdata.com/en/emergency-services ] tools
available which export data directly from datafiles. maybe they can unload
data even with broken ASSM data.

 

There are probably more ways to address this problem.

 

I am trying DUL for datafiles on ASM 11.2.0.3.

I have read  http://www.parnassusdata.com/en/node/270

then found there is some “beta version” for ASM 11g ?

If there is a newer version for ASM 11g, could I receive it ?

 

answer:

a few weeks ago the beta stuff was declared production, current DUL supports asm 11g variable extents.

And yes, the current DUL module is working fine with ASM 11.2.0.3 on my test box.

Question for the masses regarding DUL and encrypted tablespaces…I see on the main DUL page “Encryption, had a look at it recently it is discouraging complex” Does this mean that DUL cannot be performed on these types of tablespaces? Interpreting that statement would suggest that it is not but, hey I have to ask….

 

Indeed that means that it cannot be done with DUL.

Tablespace Encryption is in fact designed to stop an intruder from deciphering backups/copies, and it does a pretty good job at that. Also it is difficult to research as the relevant code lacks all tracing, as such tracing would be a big security hole.

You can check in http://www.parnassusdata.com/en/node/270

 

I have a customer heard about DUL tool. The database they have is 11.2.0.2 on Windows 64 bit OS (Single instance, file system) and they are trying to recover database. Corruption came from UPS power failure which corrupted file system.

They have a data pump export which appears to be corrupt according to “DataPump Import (IMPDP) Fails With Errors ORA31694 ORA31644
(Doc ID 1417033.1)”.
Is there any tool (including DUL itself) that can extract some data from corrupt datapump file ?

 

yes there are some unpump capabilities built into DUL. You will probably need some help as the commands are still a bit rough and require some manual steps.

For corrupt file systems, we can also mine the disk to try to retrieve the data blocks directly from the disk itself instead of the file system. If that is possible depends on what repair actions were done, as typically each attempt makes things worse.

 

It will be great if help on DUL and on disk is possible.
At this point, looks like DUL and disk level recovery
Is the only option. The good thing in this case is customer is using VMware and I got one copy where chkdsk has not
Been run yet. We can try any thing and restore VMware
Image after that.

 

You can check in http://www.parnassusdata.com/en/node/270

and use the UNPUMP option of DUL to rescue the file.

A1. When trying the configuration and using sqlldr (utf8) we get quuestion marks in the nvarchar2 column.

A2.describe table ;
From the original table nvarchar2(50)
Dul describe Type
1 varchar2 cs 871(utf8).

Setting EXPORT_MODE= FALSE and LDR_OUTPUT_IN_UTF8 = TRUE is the way to go here, as that is the only
configuration
in which DUL does character set conversion. The idea is that everything is then converted to UTF8 and indicated as
such in the sql*ldr control file.
Q1: If you do this which one is wrong ?
Q2: You can do a describe in DUL of the table, it will then show the columns names and the characterset DUL thinks
it is, can you check if that output matches your expectations

 

yet, instead I have plugged in a relatively new asm i/o in the current
production version.
Please get a fresh executable from the usual place. I expect that this code
can work with asm directly, but the startup perfromance issue has not been
addressed (is on the top of my list)

I have added support for iw8iso8859p8, new executables are in the usual place. Let me know in case of issues.

Oracle DUL for 11.1.0.7 on HP/UX PARisc

 

I need to salvage whatever data I can from a corrupted 11.1.0.7 database on an HP/UX PARisc server.

Unfortunately, in the ‘library’ no version of DUL which is compatible with HP hardware is listed. Does this mean that I

cannot use DUL against this database?

 

 

Answer:

My DUL build environment for HPUX  is broken, and not so easy to repair. What you always can do is to cross unload,use DUL from another type of machine, and DUL executable can unload all platforms.

Hi experts,

 

We need information about this ORACLE DUL Tool, please, can you send us any information about this ORACLE DUL tool??

 

Answer:

everything you need to know about dul is here: http://www.parnassusdata.com/en/node/270

 

 

just checked the DUL beehive workspace. DUL seems not to support data on Exadata Storage Servers.

I think you would have a big problem if you need DUL on Exadata……   But, as you mentioned, better than nothing! And in this case don’t forget to pray

Yes, HCC would be a problem (but this is not an Exadata issue, but a HCC issue, could have this on non-Exadata systems as well)..

And indeed, I have seen customers starting to pray in whatever language you specify as long as they can access their data 🙂

 

Question:

A client of mine has a dev database (11g on linux) that was never backed and due to a controller issue has a corrupted system tablespace.

DBV shows 100 corrupted blocks. Is there a way to open the database just long enough to  export some key tables with some important configuration data? All the tables are in one 2.1gb datafile without corrupted blocks. Are there any free/cheap unloader utilities?

 

 

Answer:

TRY ORACLE PRM-DUL http://www.parnassusdata.com/, it cost 1500 USD every Whole database whatever size.

http://zcdn.parnassusdata.com/DUL5108.zip

 

Hello DUL ,
Can I have the contact name and details of someone with Oracle DUL expertise?
A customer, AS Brazil , has a corrupt DB of 800GB
I have spoken in broad lines regarding what the DUL service is and they would like to proceed.
Questions that have arisen:
1) How must the remote connection be set up?
2) How is the costing formulated and what can they expect?
3) Time frame?

 

Answer:

Pls check this:

http://www.parnassusdata.com/en/emergency-services