自己写的一个备份脚本
full.sh
export PATH
unset USERNAME
export LD_ASSUME_KERNEL=2.4.19
export ORACLE_BASE=/opt/oracle
export ORACLE_HOME=$ORACLE_BASE/product/9.2.0.4
export ORACLE_SID=orcl
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export NLS_LANG=AMERICAN.ZHS16GBK
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib
export PATH=$PATH:$ORACLE_HOME/bin
/opt/oracle/product/9.2.0.4/bin/rman target sys/klmtklmt@orcl.32 cmdfile=/opt/full.rman
log /opt/backup/full.log
full.rman
delete noprompt obsolete;
run{
configure retention policy to redundancy 3;
configure backup optimization on;
configure controlfile autobackup on;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/opt/backup/%F';
allocate channel ch1 device type disk;
allocate channel ch2 device type disk;
backup
incremental level=0
filesperset 20
format '/opt/backup/%U'
database
plus archivelog filesperset 20
delete all input;
release channel ch1;
release channel ch2;
}
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/14870673/viewspace-578132/ ，如需转载，请注明出处，否则将追究法律责任。
