Oracle常用脚本——通过RMAN配置RAC环境的分布式磁带机

最新推荐文章于 2025-09-11 20:53:34 发布

weixin_30656145

最新推荐文章于 2025-09-11 20:53:34 发布

阅读量56

点赞数

CC 4.0 BY-SA版权

文章标签：数据库

原文链接：http://www.cnblogs.com/pangblog/p/3348069.html

本文介绍了一个针对RAC集群的备份配置脚本，该脚本通过设置8个并行通道实现高效的数据备份。每个通道配置了特定的设备类型，并且根据不同的节点进行了连接设置。

RAC的两个节点：node1，node2
RAC的两个实例：dbrac1，dbrac2
用户，密码的东西大家看看就懂了。设置成8能通道的。

#!/bin/bash

rman target / <<EOF

show all;

CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
CONFIGURE CONTROLFILE AUTOBACKUP ON;

CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 8 BACKUP TYPE TO BACKUPSET;

CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=node1)' CONNECT  'sys/passwd@DBRAC1';
CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=node2)' CONNECT  'sys/passwd@DBRAC2';
CONFIGURE CHANNEL 3 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=node1)' CONNECT  'sys/passwd@DBRAC1';
CONFIGURE CHANNEL 4 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=node2)' CONNECT  'sys/passwd@DBRAC2';
CONFIGURE CHANNEL 5 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=node1)' CONNECT  'sys/passwd@DBRAC1';
CONFIGURE CHANNEL 6 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=node2)' CONNECT  'sys/passwd@DBRAC2';
CONFIGURE CHANNEL 7 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=node1)' CONNECT  'sys/passwd@DBRAC1';
CONFIGURE CHANNEL 8 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=node2)' CONNECT  'sys/passwd@DBRAC2';

show all;

EOF

转载于:https://www.cnblogs.com/pangblog/p/3348069.html