RedHat 常用備份腳腳本示例
----------全備-------------
#!/bin/bash
#edit by hsxiao 2010-03-30
date
echo 'begin backup database.......'
echo '***********************************************'
export Oracle_BASE=/opt/ora10g
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export ORACLE_SID=HSXIAO
export PATH=/usr/sbin:$ORACLE_HOME/bin:$PATH
rman target / <<EOF
backup database plus archivelog delete all input;
#backup tablespace crawler;
EOF
date
echo '***********************************************'
echo 'end! backup database successfull!'
-------------單備表空間----------------------------
#!/bin/bash
#edit by hsxiao 2010-03-30
date
echo 'begin backup database.......'
echo '***********************************************'
export ORACLE_BASE=/opt/ora10g
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export ORACLE_SID=HSXIAO
export PATH=/usr/sbin:$ORACLE_HOME/bin:$PATH
rman target / <<EOF
#backup database plus archivelog;
backup tablespace crawler format '/usr/datafile/backup/crawler_%U.dbf';
EOF
date
echo '***********************************************'
echo 'end! backup database successfull!'
------------清除失效備份--------------------
#!/bin/bash
#edit by hsxiao 2010-03-30
date
echo 'begin backup database.......'
echo '***********************************************'
export ORACLE_BASE=/opt/ora10g
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export ORACLE_SID=HSXIAO
export PATH=/usr/sbin:$ORACLE_HOME/bin:$PATH
rman target / <<EOF
# crosscheck and delete expired or obsolete backup;
crosscheck backup;
delete noprompt obsolete;
EOF
date
echo '***********************************************'
echo 'clear backup for database successfull!'
