zhaos2
3 Zinc

Oracle RMAN backup recovery with Avamar

转到解答

Hello Gurus

Anyone has experience on Oracle script for  RMAN backup recovery (full, incremental, hot/cold backup) with Avamar?

谢谢了,春节快乐!

标签 (1)
0 项奖励
1 个已接受解答

已接受的解答
liulei_it
5 Tungsten

Re: Oracle RMAN backup recovery with Avamar

转到解答

一起探讨吧,偶这里只有HP dataprotector自动生成的脚本,您的Avamar应该也是自动生成的吧。

以下是script:

run {
allocate channel 'dev_0' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=xxxxx,OB2BARLIST=BACKUP-xxxxx-ARCH)';
allocate channel 'dev_1' type 'sbt_tape'                   
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=xxxxx,OB2BARLIST=BACKUP-xxxxx-ARCH)';
allocate channel 'dev_2' type 'sbt_tape'                   
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=xxxxx,OB2BARLIST=BACKUP-xxxxx-ARCH)';
allocate channel 'dev_3' type 'sbt_tape'                   
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=xxxxx,OB2BARLIST=BACKUP-xxxxx-ARCH)';
sql 'alter system archive log current';
backup
format 'BACKUP-xxxxx-ARCH<xxxxx_%s:%t:%p>.dbf'
archivelog all
delete input;
}

run {
allocate channel 'dev_0' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=xxxxx,OB2BARLIST=BACKUP-xxxxx-FULL)';
allocate channel 'dev_1' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=xxxxx,OB2BARLIST=BACKUP-xxxxx-FULL)';
allocate channel 'dev_2' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=xxxxx,OB2BARLIST=BACKUP-xxxxx-FULL)';
allocate channel 'dev_3' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=xxxxx,OB2BARLIST=BACKUP-xxxxx-FULL)';
backup incremental level <incr_level>
format 'DB-BACKUP-xxxxx-FULL<xxxxx_%s:%t:%p>.dbf'
database;
sql 'alter system archive log current';
backup
format 'BACKUP-xxxxx-FULL<xxxxx_%s:%t:%p>.dbf'
archivelog all
delete input;
backup
format 'BACKUP-xxxxx-FULL<xxxxx_%s:%t:%p>.dbf'
current controlfile;
}

偶觉得都差不多可能有些地方需要修改一下。

0 项奖励
7 条回复7
liulei_it
5 Tungsten

Re: Oracle RMAN backup recovery with Avamar

转到解答

hi,buddy, I have script for HP DP , maybe they are similar .  Tomorrow

0 项奖励
zhaos2
3 Zinc

Re: Oracle RMAN backup recovery with Avamar

转到解答

多谢大侠,如能有这方面的文档也请介绍一些。

0 项奖励
liulei_it
5 Tungsten

Re: Oracle RMAN backup recovery with Avamar

转到解答

一起探讨吧,偶这里只有HP dataprotector自动生成的脚本,您的Avamar应该也是自动生成的吧。

以下是script:

run {
allocate channel 'dev_0' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=xxxxx,OB2BARLIST=BACKUP-xxxxx-ARCH)';
allocate channel 'dev_1' type 'sbt_tape'                   
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=xxxxx,OB2BARLIST=BACKUP-xxxxx-ARCH)';
allocate channel 'dev_2' type 'sbt_tape'                   
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=xxxxx,OB2BARLIST=BACKUP-xxxxx-ARCH)';
allocate channel 'dev_3' type 'sbt_tape'                   
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=xxxxx,OB2BARLIST=BACKUP-xxxxx-ARCH)';
sql 'alter system archive log current';
backup
format 'BACKUP-xxxxx-ARCH<xxxxx_%s:%t:%p>.dbf'
archivelog all
delete input;
}

run {
allocate channel 'dev_0' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=xxxxx,OB2BARLIST=BACKUP-xxxxx-FULL)';
allocate channel 'dev_1' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=xxxxx,OB2BARLIST=BACKUP-xxxxx-FULL)';
allocate channel 'dev_2' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=xxxxx,OB2BARLIST=BACKUP-xxxxx-FULL)';
allocate channel 'dev_3' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=xxxxx,OB2BARLIST=BACKUP-xxxxx-FULL)';
backup incremental level <incr_level>
format 'DB-BACKUP-xxxxx-FULL<xxxxx_%s:%t:%p>.dbf'
database;
sql 'alter system archive log current';
backup
format 'BACKUP-xxxxx-FULL<xxxxx_%s:%t:%p>.dbf'
archivelog all
delete input;
backup
format 'BACKUP-xxxxx-FULL<xxxxx_%s:%t:%p>.dbf'
current controlfile;
}

偶觉得都差不多可能有些地方需要修改一下。

0 项奖励
zhaos2
3 Zinc

Re: Oracle RMAN backup recovery with Avamar

转到解答

谢谢,非常有帮助!

我也找到一个文档跟你分享一下!

https://community.emc.com/docs/DOC-21527

0 项奖励
liulei_it
5 Tungsten

Re: Oracle RMAN backup recovery with Avamar

转到解答

兄弟客气了,其实关于RMAN更多的还要靠自己多实践和去oracle  form问问,如果您用的是10g及以上版本可以在full backup 做Increasment时候启用ENABLE BLOCK CHANGE TRACKING 效果还是很明显的

0 项奖励
版主
版主

Re: Oracle RMAN backup recovery with Avamar

转到解答

Liulei对RMAN也这么有研究啊!学习了啊~~

0 项奖励
liulei_it
5 Tungsten

Re: Oracle RMAN backup recovery with Avamar

转到解答

过奖了只是平时用的比较多发现还是BCV那个Timefinder爽600GB左右增量十几分钟就OK啦mount起来相当于一个DB的全备份哪,只不过这样并不能阻止数据库本身的逻辑错误。有得有失吧。

0 项奖励