温馨提示×

温馨提示×

您好,登录后才能下订单哦!

密码登录×
登录注册×
其他方式登录
点击 登录注册 即表示同意《亿速云用户服务条款》

oracle数据库使用rman备份脚本

发布时间:2020-08-10 17:29:54 来源:ITPUB博客 阅读:152 作者:记录每一次错误 栏目:关系型数据库

关于使用rman备份数据库的脚本

#!/bin/bash 

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/dbhome_1

export ORACLE_SID=yang1

export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH

backtime=`date +"90%y%m%d%H%M%S"`

$ORACLE_HOME/bin/rman target /   log= /home/oracle/ full_backup_$backtime.log 

<<EOF 

run{

allocate channel c1 device type disk;

allocate channel c2 device type disk;

allocate channel c3 device type disk;

allocate channel c4 device type disk;

sql 'alter system archive log current'; 

backup as compressed backupset full database format '/home/oracle/db_%d_%T_%U'; 

sql 'alter system archive log current';

backup archivelog all format '/home/oracle/rman_back/arch_%d_%T_%s_%p.bak' delete input ;

backup current controlfile format '/home/oracle/rman_back/ctl_%d_%T_%s_%p.bak';

release channel c1;

release channel c2;

release channel c3;

release channel c4;

}

EOF

这个是个shell脚本

也可以在rman中执行:

allocate channel c1 device type disk;

allocate channel c2 device type disk;

allocate channel c3 device type disk;

allocate channel c4 device type disk;

sql 'alter system archive log current'; 

backup as compressed backupset full database format '/home/oracle/db_%d_%T_%U'; 

sql 'alter system archive log current';

backup archivelog all format '/home/oracle/rman_back/arch_%d_%T_%s_%p.bak'  delete input ;

backup current controlfile format '/home/oracle/rman_back/ctl_%d_%T_%s_%p.bak';

release channel c1;

release channel c2;

release channel c3;

release channel c4;

其中有一点需要说明的是备份archivelog的是否使用 delete input。 delete input的意思就是备份archivelog完成以后将archivelog删除。

向AI问一下细节

免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。

AI