Oracle backup with expdp

If you run into an: "EXP-00104: datatype (BINARY_DOUBLE) of column" on a normal oracle exp backup you should consider expdp to run your backup.

To backup oracle databases with the expdp tool use the following steps:

Create a directory on the filesystem and ensure access for oracle
```
mkdir /oradata/dump
chown oracle:oinstall /oradata/dump
```

Create a directory access from the DB

create directory dumpdir as '/oradata/dump';

Allow backup user acces to directory

grant read,write on directory dumpdir to expdpuser;

Perform backup with
```
expdp system/system dumpfile=dumpdir:YOURDUMPFILE.dmp logfile=dumpdir:YOURDUMPFILE.log schemas=SCHEMANAME
```
expdp in contrast to exp util does NOT overwrite, so move your old dump BEFORE running a new backup/export

Labels