How to import a FULL oracle 11.1  exp.exe export file to get the database at the state it was the time of export?

Posted on 2011-10-17
Last Modified: 2012-06-09
fter a hardware issue on a windows 2003 server I decided to re-install the database (version 11.1).
Here are the steps I did:
1. created a full database export (FULL=Y) using exp.exe utility used user system). No errors.
2. Unistall the database including all registry keys
3. Re-install a fresh copy of the oracle server and created a new database using the same exactly SID name as the one I exported.
4. imported the export file using the utility imp FULL=Y
5. I realized I had 800 invalid objects. Recompiled several times to get down to 400 invalid objects
6. I am not able to recompile properly all objects (that were valid at the time of export).

What I did wrong?

I can't find a step by step guide on how to restore a database using a full export file.

Any help will be appreciated
Question by:yannis_r
    LVL 76

    Expert Comment

    by:slightwv (䄆 Netminder)
    Exports are consistent at the time it started.

    You are 100% sure the objects were valid?

    What schemas are the invalid objects in?

    Maybe you missed a product on the second install and the objects arw related to those.

    Author Comment

    Exports are consistent at the time it started. - Correct

    You are 100% sure the objects were valid? - YES

    What schemas are the invalid objects in?

    and 3-4 other non system schemas

    Maybe you missed a product on the second install and the objects arw related to those.
    - you may be right!
    is there a way to find out the missing feature using the dmp file?
    LVL 76

    Expert Comment

    by:slightwv (䄆 Netminder)
    The apex schemas are Application Express.  Verify you have it installed.

    I'll need to know the other schemas before I can comment on those objects.
    LVL 47

    Accepted Solution

    You have to do the export in RESTRICTED mode of the instance after shutdown and restart.
    So you will avoid the running changes of the Database.

    Ful Export/Import is not the best way in your situation. But if you decide to do so turn off APEX (via the port number).
    Make sure that there are no external connections to the Database.

    In Oracle 11g the preferd utility is Data Pump (expdp/impdp).


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
    Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now