1500字范文,内容丰富有趣,写作好帮手!
1500字范文 > veeam备份oracle数据库 实战veeam BR 10备份Oracle RAC 19c PDB容器数据库

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

时间:2019-08-07 09:50:14

相关推荐

veeam备份oracle数据库 实战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

Version 19.3.0.0.0

Copyright (c) 1982, , 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/_02_22/annnf0_tag0222t205330_0.271.1033073611 tag=TAG0222T205330 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/_02_22/nnndf0_tag0222t205334_0.272.1033073615 tag=TAG0222T205334 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/_02_22/nnndf0_tag0222t205334_0.273.1033073631 tag=TAG0222

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/_02_22/nnndf0_tag0222t205334_0.274.1033073637 tag=TAG0222

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/_02_22/nnndf0_tag0222t205334_0.275.1033073645 tag=TAG0222

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/_02_22/annnf0_tag0222t205414_0.278.1033073655 tag=TAG0222T205414 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/_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

本内容不代表本网观点和政治立场,如有侵犯你的权益请联系我们处理。
网友评论
网友评论仅供其表达个人看法,并不表明网站立场。