Oracle Study/Admin I
exp 백업 날짜 붙여서
미스틱스
2011. 8. 4. 15:21
## for unix
$ _DATE=`date +%y%m%d`
$ _DIR=/data/exp
$ exp asd/asd@asd file = ${_DIR}/file_name_${_DATE}.dmp
## for window
c:\> exp asd/asd@asd file = file_name_"%DATE%".dmp
#################################################################################
crontab 설정 파일
#!/bin/bash
datetime=$(date +%Y%m%d)
exp mediasp/mediasp file="/backup/phoenix/phoenixdb_$datetime.dmp" log="/backup/phoenix/phoenixdb_$datetime.log" full=y direct=y
출처 : http://theone79.tistory.com/