liunx导出oracle,oracle for linux 备份脚本

1.oracle账号的contab中加入以下,包含dp备份,rman备份和备份删除

########### delete archivelog and database backup #############################

00 07 * * * sh /exp/backup/delete.sh > /exp/backup/delete.log

########### rman backup ##############################################

00 23 * * 0 sh /exp/backup/incr0.sh > /exp/backup/incr0.log

30 23 * * 1,2,3,4,5,6 sh /exp/backup/incr1.sh > /exp/backup/incr1.log

30 11 * * * sh /exp/backup/export.sh > /exp/backup/export.log 2>&1

2.以下文件內容

###########/exp/backup/export.sh

#!/bin/sh

#function:using data pump backup database

export ORACLE_SID=$SID   #$SID 为oracle sid

export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1

export PATH=.:$ORACLE_HOME/bin:$PATH:.

action_time=`date +%Y_%m_%d`

del_time=`date -d "10 day ago"  +%Y_%m_%d`

echo action time:$action_time

filename=$SID_$action_time.dmp    #$SID 为oracle sid

logname=$SID_$action_time.log     #$SID 为oracle sid

#filedir=/u10/dump

expdp system/password content=all full=y  directory=dump dumpfile=$filename logfile=$logname

cd /u10/dump

mv *.gz *.log /u09/hisdp

tar -czvf $SID_$action_time.tar.gz $filename $logname        #$SID 为oracle sid

rm $filename

chmod 755 $SID_$action_time.tar.gz $logname            #$SID 为oracle sid

#del dump data

path="/u09/hisdp"

echo "delete dump data 10 day ago"

rm -rf $path/$SID_$del_time.tar.gz        #$SID 为oracle sid

rm -rf $path/$SID_$del_time.log           #$SID 为oracle sid

echo "delete 10 dump data OK!"

###############/exp/backup/incr0.sh

# RMAN level o backup

#!/bin/sh

export ORACLE_SID=$SID        #$SID 为oracle sid

export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1

export PATH=.:$ORACLE_HOME/bin:$PATH:.

rman target / << EOF

run

{

allocate channel d1 type disk maxpiecesize 4000m;

allocate channel d2 type disk maxpiecesize 4000m;

allocate channel d3 type disk maxpiecesize 4000m;

allocate channel d4 type disk maxpiecesize 4000m;

backup current controlfile format '/u09/orabackup/$SID/full/control/full_1_%d_%s_%p_%c.ctl';

backup incremental level 0 database format '/u09/orabackup/$SID/full/full_db_%d_%s_%p_%c.dbfbk'

plus archivelog delete input format '/u09/orabackup/$SID/full/full_log_%d_%s_%p_%c.dbfbk';

backup current controlfile format '/u09/orabackup/$SID/full/control/full_2_%d_%s_%p_%c.ctl';

release channel d4;

release channel d3;

release channel d2;

release channel d1;

}

exit

EOF

#################/exp/backup/incr1.sh

# RMAN level 1 backup

#!/bin/sh

export ORACLE_SID=$SID        #$SID 为oracle sid

export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1

export PATH=.:$ORACLE_HOME/bin:$PATH:.

rman target / << EOF

run

{

allocate channel d1 type disk maxpiecesize 4000m;

allocate channel d2 type disk maxpiecesize 4000m;

allocate channel d3 type disk maxpiecesize 4000m;

allocate channel d4 type disk maxpiecesize 4000m;

backup current controlfile format '/u09/orabackup/$SID/control/%d_%s_%p_%c.ctl';             #$SID 为oracle sid

sql 'alter system switch logfile';

backup incremental level 1 database FORMAT   '/u09/orabackup/$SID/db_%d_%s_%p_%c.dbfbk'      #$SID 为oracle sid

plus archivelog delete input  FORMAT   '/u09/orabackup/$SID/log_%d_%s_%p_%c.dbfbk';          #$SID 为oracle sid

release channel d4;

release channel d3;

release channel d2;

release channel d1;

}

exit

EOF

##################/exp/backup/delete.sh

#!/bin/bash

export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1

export PATH=.:$ORACLE_HOME/bin:PATH:.

#delete archivelog and database backup on primary database completed before 7 days

rman target sys/password@$SID  << EOF              #$SID 为oracle sid

delete force noprompt backup completed before 'sysdate-7';

delete force noprompt archivelog all completed before 'sysdate-7';

exit;

EOF

#delete archivelog on standby database completed  before 7 days

rman target sys/password@$SB_SID << EOF         #$SB_SID 为standby oracle sid

delete force noprompt archivelog all completed before 'sysdate-7';

exit;

EOF

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/28539951/viewspace-1296700/，如需转载，请注明出处，否则将追究法律责任。