ODPLAT /bakdata1/SCRIPTS> cat oramdm_level0_backup_rman.sh
#set ORACLE HOME PATH
export ORACLE_HOME=/opt/oramdm/product/10.2.0/db_1
#set rman HOME path
rman_path="/opt/oramdm/product/10.2.0/db_1/bin/"
echo ${rman_path}
#set target database ORACLE_SID
ORACLE_SID=oramdm
export ORACLE_SID
#set catalog database ORACLE_SID or TNSNAME
rman_sid="rman"
echo ${rman_sid}
#set control backup file path
bak_controlfile_path="/bakdata2/rman_oramdm/rmanbak_controlfile_level0"
echo ${bak_controlfile_path}
#set datafile backup path
bak_datafile_path="/bakdata2/rman_oramdm/rmanbak_datafile_level0"
echo ${bak_datafile_path}
#set redolog backup path
bak_redolog_path="/bakdata2/rman_oramdm/rmanbak_redolog_level0"
echo ${bak_redolog_path}
echo 'level0 backup is starting........'
date
${rman_path}rman target/<
CONFIGURE BACKUP OPTIMIZATION ON;
configure device type disk parallelism 2 BACKUP TYPE TO BACKUPSET;
configure default device type to disk;
configure channel device type disk maxpiecesize = 33G;
configure retention policy to recovery window of 32 days;
configure controlfile autobackup on;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '${bak_controlfile_path}/cf_%F';
change archivelog all crosscheck;
backup incremental level 0 format '${bak_datafile_path}/db_%u_%d_%s_%T_%t_%I_%p' tag 'monthly_backup' as compressed backupset database;
change backupset tag monthly_backup nokeep;
sql 'alter system archive log current';
backup full format '${bak_redolog_path}/log_t%t_s%s_%T_%I_p%p' as compressed backupset archivelog all;
#DELETE noprompt ARCHIVELOG until TIME 'SYSDATE-2';
quit;
EOF
echo 'level0 backup ending.............'
date
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/41451/viewspace-1056732/ ,如需转载,请注明出处,否则将追究法律责任。