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