Oracle Cronjob

I’ve setup this cronjob for Oracle export using the new expdp Advertisements

Rate this:

Oracle Cronjob

I’ve setup this cronjob for Oracle export using the new expdp

Rate this:

backup/dump oracle database

Note: Syntax below will have to be setup as a shell script (filename.sh file) The DIRECTORY=dmpdir is setup using the sqlplus (google it)   find /U03/backup/*.gz -mtime +1 -exec rm {} \;find /U03/backup/*.dmp -mtime +1 -exec rm {} \;find /U03/backup/*.log -mtime +1 -exec rm {} \; ORACLE_BASE=/U01/oracleexport ORACLE_BASEORACLE_HOME=/U01/oracle/product/11.1.0/db_1export ORACLE_HOMEORACLE_SID=ffx11gexport ORACLE_SID expdp \’user/password as sysdba\’ FULL=y…

Rate this: