-
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.
-
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
-
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
Jeff Hunter
-
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.
-
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
-
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:
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...
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|