读书人

Oracle惯用脚本通过RMAN配置RAC环

发布时间: 2013-10-01 12:15:56 作者: rapoo

Oracle常用脚本——通过RMAN配置RAC环境的分布式磁带机
RAC的两个节点:node1,node2
RAC的两个实例:dbrac1,dbrac2
用户,密码的东西大家看看就懂了。设置成8能通道的。

#!/bin/bashrman target / <<EOFshow 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



读书人网 >编程

热点推荐