Crontab export data pump (expdp)
Today i´m going to tell you how to perform an export data pump launched from crontab. If you has a database in noarchivelog mode an do not want to shutdown it first, in order to make and rman backup it can be a good solution to you. However, if you want to backup your database with rman without shutdown it, you´ll have to activate archivelog mode first see this article: activate archivelog mode on database First step to perform an expdp is to select directory in whitch we are going to locate this export: SQL> set linesize 190 col OWNER for a15 col DIRECTORY_NAME for a35 col DIRECTORY_PATH for a70 select OWNER, DIRECTORY_NAME, DIRECTORY_PATH from dba_directories;SQL> SQL> SQL> SQL> OWNER DIRECTORY_NAME DIRECTORY_PATH --------------- ----------------------------------- ---------------------------------------------------------------------- SYS ORACLE_HOME / SYS ORACLE_BASE ...