3 Replies Latest reply: Apr 22, 2012 9:17 AM by Srini Chavali-Oracle RSS

    data pump ORA-07445: exception encountered: core dump

    849883
      Hi Experts,

      We were restoring a 11.2.0.2.0 database with historic expdp image and had failed several times all run end with error
      Import job stopped due to fatal error at timestamp.

      From further checking the trace file, we are seeing
      ORA-07445: exception encountered: core dump

      And then logged SR to Oracle Support and be suggested patch to 11.2.0.3 or use exp/imp.

      Due to the internal process of evaluation the new patch level and the urgency of the matter, could anyone suggest a workaround? The source images are taken from expdp so we are unlikely to bypass using data pump utility.

      Thanks
        • 1. Re: data pump ORA-07445: exception encountered: core dump
          sb92075
          rac100g wrote:
          Hi Experts,

          We were restoring a 11.2.0.2.0 database with historic expdp image and had failed several times all run end with error
          Import job stopped due to fatal error at timestamp.

          From further checking the trace file, we are seeing
          ORA-07445: exception encountered: core dump

          And then logged SR to Oracle Support and be suggested patch to 11.2.0.3 or use exp/imp.

          Due to the internal process of evaluation the new patch level and the urgency of the matter, could anyone suggest a workaround? The source images are taken from expdp so we are unlikely to bypass using data pump utility.

          Thanks
          FACT: impdp throws errors

          so you are left with two alternatives:

          1) be suggested patch to 11.2.0.3
          or
          2) use exp/imp

          Understand reality has dealt you a bad hand & your choices are LIMITED!

          Edited by: sb92075 on Apr 20, 2012 8:45 PM
          • 2. Re: data pump ORA-07445: exception encountered: core dump
            849883
            so there is no magical thing that can do imp from a previous expdp dump file?
            • 3. Re: data pump ORA-07445: exception encountered: core dump
              Srini Chavali-Oracle
              Not really - only impdp can read files created by expdp. Could it be possible that the expdp files are corrupted ? Can you perform expdp again and copy the files over in binary mode and retry impdp ?

              HTH
              Srini