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.
Printable View
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
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:
>imp help=y
Good luck
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.
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...
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.