• aix上oracle使用rman备份到nfs


    环境:aix6、oracle10G

    1、配置nfs

    nfs服务器上配置nfs
    yum -y install nfs-utils 
    vim /etc/exports
    增加一行
    /data   *(rw,sync,no_root_squash,no_all_squash)
    systemctl start nfs
    systemctl status nfs
    检查对外共享的目录。使用下列命令:
    showmount -e localhost
    
    aix上挂载磁盘
    在AIX系统打开NFS保留端口,命令如下:
    nfso -o nfs_use_reserved_ports=1
    然后,将共享的/data目录挂载即可
    mount 192.168.1.65:/data /data
    

    2、rman配置备份路径(下面直接指定通道的时候就不用配置这项)

    RMAN> configure channel 1 device type disk format '/rman/bak/%d_db_%u';
    RMAN> configure channel 2 device type disk format '/rman/bak/%d_db_%u';
    

    3、rman进行备份

    RMAN> run {
       allocate channel c1 device type disk format '/rman/bak/disk1/%U';
       allocate channel c2 device type disk format '/rman/bak/disk2/%U';
       backup database;
       release channel c1;
       release channel c2;
       }

    4、错误处理

    报错

    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure of backup plus archivelog command at 10/30/2020 14:02:03
    ORA-19504: failed to create file "/rman/ibudb/arch_IBUDB_31_631980121.rman"
    ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
    Additional information: 3
    在metalink上找到一个Doc,Note:424785.1。这个问题在10.2的版本中比较普遍。

    直接执行

    alter system set event='10298 trace name context forever,level 32'

    再次备份即可

    做一个决定,并不难,难的是付诸行动,并且坚持到底。
  • 相关阅读:
    flask框架(一):初入
    .py文件打包成.exe文件
    gtk+-3.21.4 static build step in windows XP
    cairo-1.14.6 static compiler msys mingw32
    ffmpeg-20160811-bin.7z
    gtk+2.24.0-glib-2.28.1-staticLib-mingw32-x86-2016-08-10.7z
    ffmpeg-20160806-bin.7z
    glib-2.49.4-msys-x86-staticLib.7z
    Tesseract-OCR text2image.exe [ x86 支持 XP ]
    ffmpeg-20160803-bin.7z
  • 原文地址:https://www.cnblogs.com/wukc/p/13921679.html
Copyright © 2020-2023  润新知