RedHat 常用备份脚脚本示例
———-全备————-#!/bin/bash#edit by hsxiao 2010-03-30
dateecho ‘begin backup database…….’echo ‘***********************************************’export Oracle_BASE=/opt/ora10gexport ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1export ORACLE_SID=HSXIAOexport PATH=/usr/sbin:$ORACLE_HOME/bin:$PATHrman target / <<EOFbackup database plus archivelog delete all input;#backup tablespace crawler;EOFdateecho ‘***********************************************’echo ‘end! backup database successfull!’
————-单备表空间—————————-#!/bin/bash#edit by hsxiao 2010-03-30
dateecho ‘begin backup database…….’echo ‘***********************************************’export ORACLE_BASE=/opt/ora10gexport ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1export ORACLE_SID=HSXIAOexport PATH=/usr/sbin:$ORACLE_HOME/bin:$PATHrman target / <<EOF#backup database plus archivelog;backup tablespace crawler format ‘/usr/datafile/backup/crawler_%U.dbf’;EOFdateecho ‘***********************************************’echo ‘end! backup database successfull!’
————清除失效备份——————–
#!/bin/bash#edit by hsxiao 2010-03-30
dateecho ‘begin backup database…….’echo ‘***********************************************’export ORACLE_BASE=/opt/ora10gexport ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1export ORACLE_SID=HSXIAOexport PATH=/usr/sbin:$ORACLE_HOME/bin:$PATHrman target / <<EOF# crosscheck and delete expired or obsolete backup;
crosscheck backup;delete noprompt obsolete;EOFdateecho ‘***********************************************’echo ‘clear backup for database successfull!’
,只想到处流浪人生就像一场旅行,不必在乎目的地,