Manually Back up an Oracle Database

Users with appropriate role permissions can perform a database back up from Windows command prompt or SQL Plus using an expdp command.

  1. Start SQL*Plus or any other tool that is available to run SQL commands.

  2. Enter the following command and press Enter:

expdp system/<password>@<tns_alias> schemas=<schema_user> directory=<%ORACLESERVER_HOME%> dumpfile=<FILE_NAME>.dmp version=<ORACLE_VERSION>

  1. Allow sufficient time for the backup process until the entire database is exported to an output file called dump file. When the command executes successfully, the dump file is archived to the following directory where the Oracle server is installed.

%ORACLESERVER_HOME%\admin\dpdump\<FILE_NAME>.dmp