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.
This documentation should help you:
Let me know if you have further questions. It is a real easy utility to use.
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.
Um, don't even waste your time using exp/imp for backup. http://marist89.blogspot.com/2005/05/backup-top-11.html
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.
Is the imp referencing the correct directory where the .dmp resides?
Use the following command for help:
Able was I ere I saw Elba
Is'nt Mr.Hanky around to help
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.
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:
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:
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.
Click Here to Expand Forum to Full Width