实施基本(Linux+oracle)

1、Linux压缩并打包命令：tar zcvf 压缩文件的名称.tar.gz 压缩文件夹的名称；
2、Linux解压并解包命令：tar zxvf 压缩文件的名称.tar.gz
3、Linux系统进入到oracle sqlplus模式：
先su - oracle 切换到oracle用户模式下，然后sqlplus /nolog就可以进入sqlplus模式下面。如下图所示：



4、oracle在Linux环境自动备份（全库exp）：
A、备份脚本文件内容：
#!/bin/bash
# Commands executed by a login Bourne shell
#[ -d /usr/local/bin -a -x /usr/local/bin ] && PATH=$PATH:/usr/local/bin
ORACLE_BASE=/home/oracle
ORACLE_HOME=/home/oracle/product/10.2.1
ORACLE_OWNER=oracle
ORACLE_SID=ora10g
ORACLE_TERM=xterm
ORA_NLS33=/home/oracle/product/10.2.1/ocommon/nls/admin/data
NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export ORACLE_HOME ORACLE_BASE NLS_LANG
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/lib:/usr/local/lib
export SHLIB_PATH=$ORACLE_HOME/lib:/usr/lib:/lib:/usr/local/lib
export LIBPATH=$ORACLE_HOME/lib:/usr/lib:/lib:/usr/local/lib
OSTYPE=linux-gnu
PATH=$PATH:$ORACLE_HOME/bin:$HOME/bin:.
cd /home/oracle/oraback
file=`date +%j`
let file=10#$file%7
#fil & filelog
filedump='intime_oa'$file'.dmp'
filelog='intime_oa'$file'.log'
rm $filedump
rm $filelog
expdp intimeoa/intime@ora10g directory=dir_dump dumpfile=$filedump logfile=$filelog
chown oracle:dba /home/oracle/oraback/intime_oa*.*
#ftp
echo 'start'
host=192.168.1.123
UserName=backup #ftp user name
Passwd=1111111 #ftp user password
echo 'backup'
cd /home/oracle/oraback/
htfile='intime_oa'$file'.dmp'
htlog='intime_oa'$file'.log'
ftp -i -n <<!
open $host
user $UserName $Passwd
bin
passive
cd /backup/OA/
put $htfile
put $htlog
bye
!
B、添加Linuxcrontab内容：
[root@intimedc001 ~]# crontab -l
0 4 * * * /home/oracle/oraback.sh
0 5 * * * /home/oracle/oraback/oraback_ftp.sh
[root@intimedc001 ~]# crontab -u oracle -l
*/5 * * * * sh /home/oracle/oracle_back.sh >> /home/oracle/oraback/backup.log
[root@intimedc001 ~]#

延伸阅读