Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Help Huge Database Restore using exp/imp !!!! Help Please !!!

RE: Help Huge Database Restore using exp/imp !!!! Help Please !!!

From: Mark W. Farnham <>
Date: Thu, 16 Mar 2006 20:17:13 -0500
Message-ID: <>

Well you've got me confused right from the start.

What exactly are you going to export from? Is it the current broken database?

Why do you suppose you would lose data by restoring in RMAN and rolling forward to just before the dictionary corruption?

If the data dictionary is broken, what makes you think that export will pick up all the tables, if you are going to try to export the current broken database?

Depending on the dictionary corruption, you might get lucky in that way. If you are able to complete the export and get all the tables out, your scenario seems okay, but I'm
still confused why a restore from RMAN will not fix your problem.

What exactly IS the dictionary corruption, and do you know what caused it? Do you expect it to happen again in an RMAN restore as opposed to the multi-user race conditions in which it originally happened?

Regardless, good luck.

               Oracle Technology and Business
                        Mark W. Farnham
                        President  Rightsizing, Inc.
                        36 West Street
                        Lebanon, NH 03766-1239
                tel:  (603) 448-1803

            Want a signature like this?

  -----Original Message-----
[]On Behalf Of BN   Sent: Thursday, March 16, 2006 7:12 PM   To: Oracle-L Freelists
  Subject: Help Huge Database Restore using exp/imp !!!! Help Please !!!


  Oracle on HP-UX 11.11, 12 CPU
  Database Size: 600 GB
  Reason: Database Corruption
  Action Plan: Oracle Recommended to go for exp/imp because of Data dictionary Corruption

  We worked with Oracle for 2 days, , the out come is nothing can be done, exp/imp is the only way

  We dont want to goback to our RMAN backups and loose data, clients are not ready for that.

  Planning to start the work on Friday evening and hoping to complete by Sunday evening.

  Stpes in Brief:

  We are getting 800 GB EMC Storage being mounted on to the Same HP server   Create new Filesystems that are required   Create new Database
  Split the tables and schema into multiple PAR files for export   exp and imp over the pipes same time to save time

  I will be using direct=y indexes=n constraints=n recoedlength=65535   Rebuild indexes in parallel after the Data is exported.

  We have 12 schema, 4 to 5 schem are around 20gb in size   one schema is 250 gb in size and it has a partitioned table   Planning to split the partitions for the exp and imp

  For constraints, packages and sps, view etc,

  I am thinking of doing exp of the schema owner with rows=n indexes=n and import it.
  Does this sound goog

  Every bodies eye are on us.

  I appreciate your comments and suggestions.

  Regards & Thanks

Received on Thu Mar 16 2006 - 19:17:13 CST

Original text of this message