Taking Oracle export backup

[pd77]

Hi All,

We wrote a script to take an export of the oracle and try to take backup of the entire server when the Oracle is live.

Server Partition is:
/, /usr,/d0,/d1......, /etc, /var,...

Oracle owns the partition d0,d1....

My question:
1. If the export file of the oracle exist in /d0, /d1 .Is it possible to take backup of /,/usr and only the export file , when the oracle is up and running.
I think i need to write directive to perform such a backup... am i right...?

2. Can any one please tell me, what are all the other factors, i need to think to implement this process.

Apologies if i miss something ....

 

[hoinz]

Hello,

yes, you are right; you may backup an Oracle exportfile while Oracle is up and running. And a directive will be the way of choice. However I would suggest not only the export file, but the whole directory where the export files (possibly serveral of them, from various dates) are in.

On the other hand, let me point out that there are better ways of backing up Oracle while it is up and running, than just an export file. For this you will need (or have to be yourself) an experienced (well, a bit at least) Oracle database administrator. In case of a crash, you may be able to restore the database to a time shortly before the crash. But with the export method, all you can get is the contents of the tables at the time of the export. You have to decide whether this is sufficient for you.

hope this helps