RMAN定時全備份指令碼
Rman定時全備份指令碼
1、定時備份任務
DB1-> crontab -l
30 22 * * * /rmanbackup/scripts/rmanbackup.sh
2、指令碼內容
DB1-> more /rmanbackup/scripts/rmanbackup.sh
#/bin/bash
#export ...
export ORACLE_BASE=/oracle/db
export ORACLE_HOME=$ORACLE_BASE/product/db1
export ORA_GRID_HOME=/oracle/crs
export ORACLE_OWNER=oracle
export ORACLE_SID=gzdb1
export ORACLE_UNQNAME=gzdb
export PATH=$PATH:$ORACLE_HOME/bin:/sbin:/usr/sbin:/bin:/usr/local/bin:.
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib
export NLS_LANG=american_america.ZHS16GBK
export ORACLE_PATH=/home/oracle
today=`date +%Y%m%d`
find /rmanbackup/dbbak/ -name "*full*" -mtime +7 -exec rm {} \;
find /rmanbackup/dbbak/ -name "*archivelog*" -mtime +7 -exec rm {} \;
find /rmanbackup/dbbak/ -name "controlfile*" -mtime +7 -exec rm {} \;
find /rmanbackup/dbbak/ -name "spfile*" -mtime +7 -exec rm {} \;
rman target / nocatalog log /rmanbackup/rmanlog/rmanbk_$today.log append <<EOF
run {
crosscheck archivelog all;
delete noprompt expired archivelog all;
allocate channel c1 device type disk;
allocate channel c2 device type disk;
allocate channel c3 device type disk;
allocate channel c4 device type disk;
backup format '/rmanbackup/dbbak/gzdb_full_%T_%d_%s_%p_%u.dbf' database plus archivelog;
sql "ALTER SYSTEM switch logfile";
sql "ALTER SYSTEM switch logfile";
sql "ALTER SYSTEM switch logfile";
sql "ALTER SYSTEM switch logfile";
sql "ALTER SYSTEM switch logfile";
sql "ALTER SYSTEM switch logfile";
delete noprompt archivelog until time 'sysdate-7';
backup current controlfile format '/rmanbackup/dbbak/controlfile_%T_%U_%t.crl';
backup spfile format '/rmanbackup/dbbak/spfile_%T_%U_%t.ora';
release channel c1;
release channel c2;
release channel c3;
release channel c4;
}
exit
EOF
1、定時備份任務
DB1-> crontab -l
30 22 * * * /rmanbackup/scripts/rmanbackup.sh
2、指令碼內容
DB1-> more /rmanbackup/scripts/rmanbackup.sh
#/bin/bash
#export ...
export ORACLE_BASE=/oracle/db
export ORACLE_HOME=$ORACLE_BASE/product/db1
export ORA_GRID_HOME=/oracle/crs
export ORACLE_OWNER=oracle
export ORACLE_SID=gzdb1
export ORACLE_UNQNAME=gzdb
export PATH=$PATH:$ORACLE_HOME/bin:/sbin:/usr/sbin:/bin:/usr/local/bin:.
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib
export NLS_LANG=american_america.ZHS16GBK
export ORACLE_PATH=/home/oracle
today=`date +%Y%m%d`
find /rmanbackup/dbbak/ -name "*full*" -mtime +7 -exec rm {} \;
find /rmanbackup/dbbak/ -name "*archivelog*" -mtime +7 -exec rm {} \;
find /rmanbackup/dbbak/ -name "controlfile*" -mtime +7 -exec rm {} \;
find /rmanbackup/dbbak/ -name "spfile*" -mtime +7 -exec rm {} \;
rman target / nocatalog log /rmanbackup/rmanlog/rmanbk_$today.log append <<EOF
run {
crosscheck archivelog all;
delete noprompt expired archivelog all;
allocate channel c1 device type disk;
allocate channel c2 device type disk;
allocate channel c3 device type disk;
allocate channel c4 device type disk;
backup format '/rmanbackup/dbbak/gzdb_full_%T_%d_%s_%p_%u.dbf' database plus archivelog;
sql "ALTER SYSTEM switch logfile";
sql "ALTER SYSTEM switch logfile";
sql "ALTER SYSTEM switch logfile";
sql "ALTER SYSTEM switch logfile";
sql "ALTER SYSTEM switch logfile";
sql "ALTER SYSTEM switch logfile";
delete noprompt archivelog until time 'sysdate-7';
backup current controlfile format '/rmanbackup/dbbak/controlfile_%T_%U_%t.crl';
backup spfile format '/rmanbackup/dbbak/spfile_%T_%U_%t.ora';
release channel c1;
release channel c2;
release channel c3;
release channel c4;
}
exit
EOF
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/27571661/viewspace-1781718/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle rman 定時備份指令碼Oracle指令碼
- rman 全備份指令碼指令碼
- RMAN全庫備份指令碼指令碼
- rman 備份指令碼指令碼
- rman備份指令碼指令碼
- rman備份和增量備份指令碼指令碼
- rman增量備份指令碼指令碼
- windows rman備份指令碼Windows指令碼
- RMAN常用備份指令碼指令碼
- oracle RMAN備份指令碼Oracle指令碼
- ORACLE常用定時備份指令碼Oracle指令碼
- mysql每天定時備份指令碼MySql指令碼
- mysql定時備份shell指令碼MySql指令碼
- Rman 定時備份crontab
- Mysql定時備份資料指令碼MySql指令碼
- [Oracle] rman備份指令碼(2)Oracle指令碼
- 使用rman備份的指令碼指令碼
- oracle rman備份指令碼收集Oracle指令碼
- Windows下RMAN備份指令碼Windows指令碼
- RMAN備份Shel指令碼示例指令碼
- Rman備份的shell指令碼指令碼
- Linux 平臺下 RMAN 全備 和 增量備份 shell 指令碼Linux指令碼
- WINDOWS下 部署 rman 全備指令碼Windows指令碼
- rman的全備份指令碼和控制檔案安全策略指令碼
- Oracle用指令碼定時執行備份Oracle指令碼
- 【RMAN】RMAN指令碼中使用替換變數--windows 下rman全備指令碼指令碼變數Windows
- 分享Oracle Rman的備份指令碼Oracle指令碼
- 轉貼:RMAN備份指令碼(Unix)指令碼
- [Oracle] rman備份的指令碼(1)Oracle指令碼
- rman 自動備份指令碼-windows指令碼Windows
- rman備份的shell指令碼(例子)指令碼
- ORACLE RMAN備份的指令碼配置Oracle指令碼
- RMAN定時全備份資料庫之簡單例項資料庫單例
- rman 備份 全庫
- RAC模式下的備份策略以及RMAN備份指令碼模式指令碼
- linux mysql定時備份指令碼記錄LinuxMySql指令碼
- 資料庫全備份指令碼資料庫指令碼
- rman的備份檢視的指令碼指令碼