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


    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




  • 相关阅读:
    Nhibernate对象转JSON
    C# Windows服务
    C# 接收http请求
    C# XML 基础解系
    C# XML 序列化与反序列化
    C# Newtonsoft.Json 应用
    C# 读取自定义XML
    对图片添加水印
    iText: 对pdf文件添加水印
    java对Office文件处理技术(介绍)
  • 原文地址:https://www.cnblogs.com/pangblog/p/3348069.html
Copyright © 2020-2023  润新知