Scheduling the oracle database export
To set up a scheduled Oracle database export refer to the following steps for Linux or Winodws.
Scheduling the Export (Linux)
Switch to user .
su - aptare
Edit or create the crontab file.
crontab -e
Using the following diagram, specify the database export schedule.
:
04 15 * * * /opt/aptare/database/tools/export_database_template.sh 2>&1 >>/tmp/database_export.log
Verify the newly scheduled job:
crontab -l
Scheduling the Export Job (Windows)
Create a new task in the Task Scheduler by specifying the schedule and the script to be run:
c:\opt\oracle\database\tools\expdp_database_template.bat