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.