How to back up Oracle Database using EXPORT Utilities

[david4u]

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.

[dba01]

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

[david4u]

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.

[marist89]

Um, don't even waste your time using exp/imp for backup. http://marist89.blogspot.com/2005/05/backup-top-11.html

[david4u]

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.

[robertbalmer]

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

Use the following command for help:

>imp help=y

Good luck

[dharma]

Is'nt Mr.Hanky around to help

[KenCunningham]

As above, check that you are in the correct directory. Also, confirm the permissions on the dmp file.

[TimHall]

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...

[david4u]

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.