How to back up Oracle Database using EXPORT Utilities

Printable View

08-04-2005, 10:41 AM
david4u

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.
08-04-2005, 11:27 AM
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
08-04-2005, 11:40 AM
david4u

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.
08-04-2005, 11:54 AM
marist89

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

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.
08-05-2005, 09:21 AM
robertbalmer

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

Use the following command for help:

>imp help=y

Good luck
08-05-2005, 06:06 PM
dharma

Is'nt Mr.Hanky around to help ;)
08-06-2005, 03:27 AM
KenCunningham

As above, check that you are in the correct directory. Also, confirm the permissions on the dmp file.
08-06-2005, 07:59 AM
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...
08-06-2005, 01:47 PM
david4u

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.
08-06-2005, 02:50 PM
adewri

Quote:

Originally Posted by 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.

Some people never learn...
08-06-2005, 04:16 PM
marist89

Quote:

Originally Posted by david4u

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

:rolleyes: :rolleyes: :rolleyes: :rolleyes: :rolleyes: :rolleyes: :rolleyes: :rolleyes: :rolleyes: :rolleyes: :rolleyes: :rolleyes: :rolleyes: :rolleyes: :rolleyes: :rolleyes: :rolleyes: :rolleyes: :rolleyes: :rolleyes: :rolleyes: :rolleyes: :rolleyes: :rolleyes: :rolleyes: :rolleyes: :rolleyes: :rolleyes: :rolleyes: :rolleyes: :rolleyes: :rolleyes: :rolleyes: :rolleyes: :rolleyes: :rolleyes: :rolleyes: :rolleyes: :rolleyes: :rolleyes: :rolleyes: :rolleyes: :rolleyes: :rolleyes: :rolleyes: :rolleyes: :rolleyes: :rolleyes:
08-07-2005, 08:52 AM
yls177

From

http://marist89.blogspot.com/2005/05/backup-top-11.html

came the below

10. Export/import is not a primary backup methodology.
Export and Import are fine tools for transferring data between databases as long as you can prevent changes from occurring. People usually setup export as their backup for one of two reasons; they feel "safe" because they have a copy of their data on disk or because it is easy to configure. The drawback is that using export for backup will only give you a single point-in-time to which you can recover. It is very unlikely that your database will crash the moment the export finishes. There are a couple of valid reasons why you want to use export as a secondary backup method, but as your primary backup methodology, forget it. If you do use exp/imp for a secondary backup method, make sure you use the consistent=y option to get a consistent copy of your data and use compress=n to make sure all your data doesn't go into one extent.

SO ? dont use export for backup
08-07-2005, 10:01 AM
davey23uk

no, dont use export for backup seeing as though it isnt a backup method anyway
08-07-2005, 11:42 PM
yls177

Quote:

Originally Posted by davey23uk

no, dont use export for backup seeing as though it isnt a backup method anyway

yup... i think u may mistaken my english when i wrote the below

Quote:

SO ? dont use export for backup

Actually, i meant as below
SO ? -> Therefore, the morale of the story is

and followed by "dont use export for backup"

thanks for your advise emphasied that dont use export/import for backup purposes.
08-08-2005, 05:49 AM
david4u

Export Utilities Executables

Thanks.I understand your point. And I know how to use it now.
I have executed the commands now and the export seems alright except this error that I got on my screen " Oracle Export Utilities executables must be specified"....I have set up the output files, log files and what other executables does it needs.
Can anyone help.
08-08-2005, 05:56 AM
davey23uk

yes - stop using exp for backups

the command you are looking for is rman