RE: Help Huge Database Restore using exp/imp !!!! Help Please !!!
- From: "Mark W. Farnham" <mwf@xxxxxxxx>
- To: <bnsarma@xxxxxxxxx>, "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 16 Mar 2006 20:17:13 -0500
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.
www.rsiz.com Oracle Technology and Business
Consulting
Mark W. Farnham
President Rightsizing, Inc.
36 West Street
Lebanon, NH 03766-1239
mwf@xxxxxxxx tel: (603) 448-1803
Want a signature like this?
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]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 !!!
Greetings,
Oracle 9.2.0.6 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
BN
Other related posts:
