How to back up Oracle Database using EXPORT Utilities

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

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:

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

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

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.

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.

yes - stop using exp for backups

the command you are looking for is rman