expdp - Exporting database with date stamp in the dump file name

Exporting database with date stamp in the dump file name

Taking backup of Oracle database using expdp utility.

This creates a dump in the specified directory which can be used to restore in some other server.

Logon to the server using ssh/telnet with user as oracle

           connect as sysdba

            $sqlplus "/as sysdba"             

          Create directory where the backup dump is to be exported.  In this case it is the file system '/datadump' 

             SQL> create directory bkpexp_dir as '/datadump';

            SQL> exit

         Now run export command to take export full backup.

$ expdp /  full=Y  directory=bkpexp_dir dumpfile=export-`date '+%d%m%Y.dmp'`  logfile=export-`date '+%d%m%Y.log'`