Implementation Steps of oracle Timing Backup Compression

1) Need to create a storage directory
mkdir backup

2) Write shell footsteps #!/bin/bash
export ORACLE_BASE=/opt/oracle-The path needs to be changed according to the actual path
export ORACLE_HOME= $ORACLE_BASE/ora10gr2/db_1--The path needs to be changed according to the actual path
export PATH=$ORACLE_HOME/bin:$PATH
d=$(date '+%d')
exp metabase/metabase@dskdb file=/home/oracle/backup/'metabase'$d.dmp
exp data/data@dskdb file=/home/oracle/backup/'data'$d.dmp
zip -m /home/oracle/backup/'metabase'$d.zip /home/oracle/backup/'metabase'$d.dmp
zip -m /home/oracle/backup/'data'$d.zip /home/oracle/backup/'data'$d.dmp

3) Set timed execution commands
crontab-e Enter Edit Page Setting Timing
00 23 * * * sh /home/oracle/data_bash.sh > > /home/oracle/error.log 2 > & 1--The path needs to be changed according to the actual path, and the log can not be output