实战veeam BR 10备份Oracle RAC 19c PDB容器数据库

本文涉及的安装包位于VBR10的ISO内:

"X:\Plugins\Oracle RMAN\Windows\VeeamPluginforOracleRMAN.exe"

大家觉得备份RAC好像很复杂,但实际上复杂的是ASM,也就是ACFS。面对ASM,人机交互的接口变成了RMAN(恢复管理器)。所以各家的备份基本上都是对接RMAN,VBR10也是这样,因为ASM不可见,VBR将自己的plug-in加入到RMAN的备份通道,备份时重定向所有的备份流量到VBR repo服务器,需要恢复时再从VBR一侧取回即可。

开始操作前请确保开启归档模式、RMAN备份与恢复工作正常,可以先行测试一下。准备好后再使用管理员身份安装plug-in到所有的RAC节点:

安装plug-in
如果时AD账号,则设置始终以管理员身份运行,不然会报错;
运行plug-in,并连接VBR服务器;
添加repo;
导出两项配置;
将veeam_config.xml文件copy到上图其它RAC节点目录;
执行命令尽心配置导入同步;
执行PDB2备份测试,这里只进行PDB容器数据库的测试。
回到VBR上可以看到自动生成的RMAN备份任务,最后成功完成;
了解RAC中的ASM配置,其中DATA存放真正的数据文件,FRA是快速恢复区域,OCR是见证选举;
看看备份的数据来自哪些位置;

下一次来看看恢复实战。

安装plug-in之前的测试:
PS C:\app\19.0.0\ogg> rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Sat Feb 22 20:53:03 2020
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
connected to target database: ORCL (DBID=1560843939)
RMAN> backup database plus archivelog;
Starting backup at 22-FEB-20
current log archived
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=26 instance=orcl1 device type=DISK
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=2 RECID=2 STAMP=1033073608
input archived log thread=2 sequence=2 RECID=3 STAMP=1033073609
channel ORA_DISK_1: starting piece 1 at 22-FEB-20
channel ORA_DISK_1: finished piece 1 at 22-FEB-20
piece handle=+FRA/ORCL/BACKUPSET/2020_02_22/annnf0_tag20200222t205330_0.271.1033073611 tag=TAG20200222T205330 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 22-FEB-20
Starting backup at 22-FEB-20
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/ORCL/DATAFILE/system.299.1033063037
input datafile file number=00003 name=+DATA/ORCL/DATAFILE/sysaux.268.1033063073
input datafile file number=00004 name=+DATA/ORCL/DATAFILE/undotbs1.287.1033063087
input datafile file number=00009 name=+DATA/ORCL/DATAFILE/undotbs2.289.1033063555
input datafile file number=00007 name=+DATA/ORCL/DATAFILE/users.296.1033063089
channel ORA_DISK_1: starting piece 1 at 22-FEB-20
channel ORA_DISK_1: finished piece 1 at 22-FEB-20
piece handle=+FRA/ORCL/BACKUPSET/2020_02_22/nnndf0_tag20200222t205334_0.272.1033073615 tag=TAG20200222T205334 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00016 name=+DATA/ORCL/78B60A1B4DCE4CF2BA44C80BDCF9655F/DATAFILE/sysaux.263.1033063979
input datafile file number=00015 name=+DATA/ORCL/78B60A1B4DCE4CF2BA44C80BDCF9655F/DATAFILE/system.262.1033063979
input datafile file number=00017 name=+DATA/ORCL/78B60A1B4DCE4CF2BA44C80BDCF9655F/DATAFILE/undotbs1.276.1033063979
input datafile file number=00018 name=+DATA/ORCL/78B60A1B4DCE4CF2BA44C80BDCF9655F/DATAFILE/undo_2.261.1033063993
input datafile file number=00019 name=+DATA/ORCL/78B60A1B4DCE4CF2BA44C80BDCF9655F/DATAFILE/users.272.1033063993
channel ORA_DISK_1: starting piece 1 at 22-FEB-20
channel ORA_DISK_1: finished piece 1 at 22-FEB-20
piece handle=+FRA/ORCL/78B60A1B4DCE4CF2BA44C80BDCF9655F/BACKUPSET/2020_02_22/nnndf0_tag20200222t205334_0.273.1033073631 tag=TAG20200222
T205334 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00011 name=+DATA/ORCL/4B812A19F59942EF90E985626E303B23/DATAFILE/sysaux.295.1033063955
input datafile file number=00010 name=+DATA/ORCL/4B812A19F59942EF90E985626E303B23/DATAFILE/system.298.1033063955
input datafile file number=00012 name=+DATA/ORCL/4B812A19F59942EF90E985626E303B23/DATAFILE/undotbs1.288.1033063955
input datafile file number=00013 name=+DATA/ORCL/4B812A19F59942EF90E985626E303B23/DATAFILE/undo_2.292.1033063977
input datafile file number=00014 name=+DATA/ORCL/4B812A19F59942EF90E985626E303B23/DATAFILE/users.294.1033063979
channel ORA_DISK_1: starting piece 1 at 22-FEB-20
channel ORA_DISK_1: finished piece 1 at 22-FEB-20
piece handle=+FRA/ORCL/4B812A19F59942EF90E985626E303B23/BACKUPSET/2020_02_22/nnndf0_tag20200222t205334_0.274.1033073637 tag=TAG20200222
T205334 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00006 name=+DATA/ORCL/CDFC9E3806DC4DF49D7662BEF6F93673/DATAFILE/sysaux.264.1033063251
input datafile file number=00005 name=+DATA/ORCL/CDFC9E3806DC4DF49D7662BEF6F93673/DATAFILE/system.271.1033063251
input datafile file number=00008 name=+DATA/ORCL/CDFC9E3806DC4DF49D7662BEF6F93673/DATAFILE/undotbs1.285.1033063251
channel ORA_DISK_1: starting piece 1 at 22-FEB-20
channel ORA_DISK_1: finished piece 1 at 22-FEB-20
piece handle=+FRA/ORCL/5A3EFDE1A95E4EC689D446B0B2BE45BB/BACKUPSET/2020_02_22/nnndf0_tag20200222t205334_0.275.1033073645 tag=TAG20200222
T205334 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
Finished backup at 22-FEB-20

Starting backup at 22-FEB-20
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=3 RECID=4 STAMP=1033073653
input archived log thread=2 sequence=3 RECID=5 STAMP=1033073654
channel ORA_DISK_1: starting piece 1 at 22-FEB-20
channel ORA_DISK_1: finished piece 1 at 22-FEB-20
piece handle=+FRA/ORCL/BACKUPSET/2020_02_22/annnf0_tag20200222t205414_0.278.1033073655 tag=TAG20200222T205414 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 22-FEB-20

Starting Control File and SPFILE Autobackup at 22-FEB-20
piece handle=+FRA/ORCL/AUTOBACKUP/2020_02_22/s_1033073655.279.1033073657 comment=NONE
Finished Control File and SPFILE Autobackup at 22-FEB-20

RMAN>

Done!

https://youtu.be/l0yproDH-F8
https://youtu.be/l0yproDH-F8