ITPub博客

首页 > 数据库 > Oracle > rman备份脚本

rman备份脚本

原创 Oracle 作者:rewqrewq 时间:2011-12-07 09:55:02 0 删除 编辑

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/<connect catalog rman/rman@${rman_sid};

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

[@more@]

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/41451/viewspace-1056732/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
  • 博文量
    83
  • 访问量
    265470