Oracle Database Backup

We can use the Oracle Data Pump technology for Oracle 10g, 11g, 12c, 18c and 19c databases.

First create an Oracle directory BACKUP_DIRECTORY that points to an operating system directory on the database server machine for reading and writing files.

Assume ORCL is the database server name or SID.
‎ Sqlplus.exe / as sysdba
‎ CREATE OR REPLACE DIRECTORY BACKUP_DIRECTORY as '/backups/Oracle';
‎ GRANT read, write ON DIRECTORY BACKUP_DIRECTORY TO MM;

Then use Oracle Data Pump ( expdp , impdp ) to backup and restore the metadata repository.