Author: mac

I have a customer who want to unload data from a corrupted database with about 1.4TB data by DUL, how much time can we finish the whole steps?     This database is corrupted due to some storage problem and cannot startup, but all datafiles are in the same SCN, so I believe data dictionary is…

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…

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…

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…

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…

  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)…

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…

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:…

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…

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…