How to back up Oracle Database using EXPORT Utilities
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 17

Thread: How to back up Oracle Database using EXPORT Utilities

  1. #1
    Join Date
    Aug 2005
    Posts
    5

    How to back up Oracle Database using EXPORT Utilities

    I am new to oracle database administrations. I would like to know "how to backup oracle Database using EXPORT UTILITIES.(I mean full back up).
    The steps to follow on solaris machine.
    Thanks.

  2. #2
    Join Date
    Jul 2005
    Posts
    31
    This documentation should help you:

    http://download-west.oracle.com/docs...1.htm#SUTIL001

    Let me know if you have further questions. It is a real easy utility to use.

    DBA01

  3. #3
    Join Date
    Aug 2005
    Posts
    5

    I cannīt view the link

    Thanks for the reply but I cannot view the link.It requires that I must register which I tried to do but wonīt allow my data.

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Um, don't even waste your time using exp/imp for backup. http://marist89.blogspot.com/2005/05/backup-top-11.html
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Aug 2005
    Posts
    5

    Import Utilities

    I have used the exp utilities to backup my oracle Database but still having problem with using imp.
    I tried to import the exported file that oracle database is in but keep on geting this error
    "failed to open dba.dmp"
    I exported using: exp username/paswd file=dba.dmp full=Y
    and was successfull
    So, I moved on to import the file using:
    imp username/passwd file=dba.dmp fromuser=username
    But keeps on giving error..cannot open the file..
    Can any one help me.

  6. #6
    Join Date
    May 2003
    Location
    Pretoria, Rep of South Africa
    Posts
    191

    Talking

    Is the imp referencing the correct directory where the .dmp resides?

    Use the following command for help:

    >imp help=y

    Good luck
    Able was I ere I saw Elba

  7. #7
    Join Date
    Dec 2000
    Posts
    138
    Is'nt Mr.Hanky around to help

  8. #8
    Join Date
    Apr 2003
    Location
    Gourock, Scotland
    Posts
    102
    As above, check that you are in the correct directory. Also, confirm the permissions on the dmp file.
    If I have to choose between two evils, I always like to choose the one I haven't tried yet.

  9. #9
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    I think Jeff's point seems to have been lost in this discussion. The exp and imp utilities should not be considered as a backup strategy in their own right. They can be a useful addition to a backup strategy, but on their own they are a recipe for disaster.

    You really should consider switching to another form of backups, preferably RMAN. This might help you get to grips with RMAN:

    http://www.oracle-base.com/articles/...er(RMAN)9i.php

    I cannot stress how important it is that you understand the difference between what you can achieve with exp/imp and what is possible with RMAN.

    You really need to read the Backup and Recovery Concepts manual before you take a course of action you will regret:

    http://download-west.oracle.com/docs...a96519/toc.htm

    Cheers

    Tim...
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

  10. #10
    Join Date
    Aug 2005
    Posts
    5

    About Export Utilities

    Thanks for the responses. I will check the permisions on the dmp file. I only want to use export utilities to backup not other method for now.
    Thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width