ora_rman.sh
#!/bin/bash
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export ORACLE_SID=prod
export PATH=$ORACLE_HOME/bin:$PATH
DATE=`date +%Y%m%d-%H:%M:%S`
rman target / <<EOF log /home/oracle/ora_rman.log
run {
allocate channel c0 type disk;
allocate channel c1 type disk;
allocate channel c2 type disk;
delete noprompt obsolete;
crosscheck backupset of database;
delete noprompt expired backupset;
backup full database format '/u01/backup/full_db_$DATE.bak';
sql 'alter system archive log current';
backup archivelog all format '/u01/backup/arch_$DATE.bak';
release channel c0;
release channel c1;
release channel c2;
}
exit
EOF
创建时间:2022-03-31 20:54
넶浏览量:0