日常導出腳本
----in windows circumstance
@echo off
set year=%date:~10,4%
set month=%date:~4,2%
set day=%date:~7,2%
set mydate=%year%%month%%day%
set hhmmss=%time:~0,2%%time:~3,2%%time:~6,2%
rem if "%hhmmss:~0,1%"==" " set hhmmss=0%time:~1,1%%time:~3,2%%time:~6,2%
rem echo ------------------------------------------------ >> E:\expepd3eco\x.txt
rem echo %mydate%_%hhmmss% >> E:\expepd3eco\x.txt
rem echo ------------------------------------------------ >> E:\expepd3eco\x.txt
echo
set NLS_LANG=AMERICAN_AMERICA.AL32UTF8
exp system/"system$oracle" file=e:\expdata\eco_%mydate%%hhmmss%.dmp log=E:\expdata\log\eco_%mydate%%hhmmss%.log full=y
----in Linux circumstance
#!/bin/sh
cd /data/backup
ORACLE_HOME=/u01/product/oracle;export ORACLE_HOME
ORACLE_SID=esvcabd2;export ORACLE_SID
FILENAME=`date +%Y%m%d%H`
NLS_LANG=american.AL32UTF8;export NLS_LANG
/u01/product/oracle/bin/exp 'system/"system@dbsec"' file='esvcabd2'$FILENAME log='abd2'$FILENAME.log full=y
# wner=eservice
~
@echo off
set year=%date:~10,4%
set month=%date:~4,2%
set day=%date:~7,2%
set mydate=%year%%month%%day%
set hhmmss=%time:~0,2%%time:~3,2%%time:~6,2%
rem if "%hhmmss:~0,1%"==" " set hhmmss=0%time:~1,1%%time:~3,2%%time:~6,2%
rem echo ------------------------------------------------ >> E:\expepd3eco\x.txt
rem echo %mydate%_%hhmmss% >> E:\expepd3eco\x.txt
rem echo ------------------------------------------------ >> E:\expepd3eco\x.txt
echo
set NLS_LANG=AMERICAN_AMERICA.AL32UTF8
exp system/"system$oracle" file=e:\expdata\eco_%mydate%%hhmmss%.dmp log=E:\expdata\log\eco_%mydate%%hhmmss%.log full=y
----in Linux circumstance
#!/bin/sh
cd /data/backup
ORACLE_HOME=/u01/product/oracle;export ORACLE_HOME
ORACLE_SID=esvcabd2;export ORACLE_SID
FILENAME=`date +%Y%m%d%H`
NLS_LANG=american.AL32UTF8;export NLS_LANG
/u01/product/oracle/bin/exp 'system/"system@dbsec"' file='esvcabd2'$FILENAME log='abd2'$FILENAME.log full=y
# wner=eservice
~
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/25198367/viewspace-704255/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
檢查包含LOB類型的表
下一篇：
Linux下自動輪轉監聽日誌
请登录后发表评论
登录
全部评论
