- 最后登录
- 2018-11-27
- 在线时间
- 31 小时
- 威望
- 52
- 金钱
- 338
- 注册时间
- 2012-6-3
- 阅读权限
- 50
- 帖子
- 49
- 精华
- 0
- 积分
- 52
- UID
- 475
|
1#
发表于 2012-6-27 15:31:42
|
查看: 5321 |
回复: 3
备份使用的计划任务
su - oracle -c rman target [email=sys/***@e3sdb]sys/***@e3sdb[/email] cmdfile=/usr/tivoli/tsm/script/e3s_backup.sh msglog=/usr/tivoli/tsm/script/e3s_backup.log
备份的脚本为:
run
{
allocate channel t0 type 'SBT_TAPE' connect [email=]'sys/test@e3sdb1'[/email] parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
backup full filesperset 20
format '%d_full_%T_%t_%U'
database;
delete obsolete recovery window of 3 days;
release channel t0;
allocate channel t1 type 'SBT_TAPE' connect [email=]'sys/test@e3sdb1'[/email] parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
allocate channel t2 type 'SBT_TAPE' connect [email=]'sys/test@e3sdb2'[/email] parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
crosscheck archivelog all;
backup
filesperset 10
format 'archive_%s_%p_%u'
archivelog all delete input;
release channel t1;
release channel t2;
}
~
手动发起备份报错见图片
RAC的地址问题
物理机1 IP:10.44.76.1 rac-vip 10.44.76.7
物理机2 IP: 10.44.76.2 rac-vip 10.44.76.8
现在76.8这个IP在两个物理机上都有 |
|