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