Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- export EDITOR=vi
- $ crontab -e
- 0 * * * * /u01/cron/file_backup.sh > /u01/cron/logs/fback.log 2>&1
- 0 * * * * /u01/cron/dpump.sh > /u01/cron/logs/dpump.log 2>&1
- #!/bin/bash
- ORACLE_BASE=/u01/app/oracle
- export ORACLE_BASE
- ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
- export ORACLE_HOME
- ORACLE_SID=s193130
- export ORACLE_SID
- PATH=$PATH:$ORACLE_HOME/bin
- LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib
- export LD_LIBRARY_PATH
- TMP=/tmp
- export TMP
- TMPDIR=$TMP
- export TMPDIR
- ORATAB=/etc/oratab
- export ORATAB
- CURRDATE=$(date +%Y%m%d-%H.%M)
- export CURRDATE
- exp system/admin
- full=y
- grants=y
- indexes=y
- consistent=y
- rows=y
- file=/u01/cron/backup/exp/$CURRDATE.dmp
- log=/u01/cron/backup/exp/log/$CURRDATE.log statistics=none
- // Скрипт запуска резервного копирования с помощью Data Pump:
- #!/bin/bash
- ORACLE_BASE=/u01/app/oracle
- export ORACLE_BASE
- ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
- export ORACLE_HOME
- ORACLE_SID=s193130
- export ORACLE_SID
- PATH=$PATH:$ORACLE_HOME/bin
- EXPORT_FOLDER=/u01/app/oracle/admin/${ORACLE_SID}/datapump
- export EXPORT_FOLDER
- ORACLE_USER=SYSTEM
- ORACLE_PASSWORD=admin
- DATAPUMP_DIR=/u01/cron/backup/datapump
- export DATAPUMP_DIR
- DATE=(date +%Y%m%d.%H:%M)
- export DATE
- $ORACLE_HOME/bin/expdp $ORACLE_USER/$ORACLE_PASSWORD full=y dumpfile=$DATE.dmp logfile=$DATE.log flashback_time=SYSTIMESTAMP
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement