• NBU 恢复日志


    在做NBU ORACLE备份的恢复测试,执行恢复时报错ORA-27211: Failed to load Media Management Library,具体处理过程如下:
    一、错误信息

    执行命令:

    复制代码
    run {
    ALLOCATE CHANNEL ch00 TYPE SBT_TAPE;
    send 'NB_ORA_CLIENT=192.168.x.x';
    send 'NB_ORA_SERV=nbu5230';
    restore controlfile from '/ctrl_dTESTDB_u0at7lkpa_s10_p1_t981127978';
    release channel ch00;
    }
    复制代码

    报错信息:

    复制代码
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03009: failure of allocate command on ch00 channel at 07/10/2018 16:16:09
    ORA-19554: error allocating device, device type: SBT_TAPE, device name:
    ORA-27211: Failed to load Media Management Library
    Additional information: 2
    复制代码

    二、错误原因

    由于数据库的Lib库不包含NBU的库文件,所以执行rman恢复时报错

    三、解决方案

    将NBU的库文件放入Oracle库文件目录下即可

    [oracle@node1 oracle]$ ln -s /usr/openv/netbackup/bin/libobk.so64  /U01/app/oracle/product/11.2.0.4/lib/libobk.so
    [oracle@node1 oracle]$ sbttest /etc/hosts

    复制代码
    [oracle@node1 oracle]$ sbttest /etc/hosts
    The sbt function pointers are loaded from libobk.so library.
    -- sbtinit succeeded
    -- sbtinit (2nd time) succeeded
    sbtinit: Media manager supports SBT API version 2.0
    sbtinit: Media manager is version 5.0.0.0
    sbtinit: vendor description string=Veritas NetBackup for Oracle - Release 7.7.2 (2016011116)
    sbtinit: allocated sbt context area of 8 bytes
    sbtinit: proxy copy is supported
    -- sbtinit2 succeeded
    -- regular_backup_restore starts ................................
    复制代码

    四、知识扩展

    1.NBU数据库恢复脚本

    复制代码
    run {
    
    allocate channel t1 type 'sbt_tape';
    
    allocate channel t2 type 'sbt_tape';
    
    allocate channel t3 type 'sbt_tape';
    
    send 'NB_ORA_CLIENT=192.168.x.x';
    
    send 'NB_ORA_SERV=nbu5230';
    
    set until sequence 12 thread 1;
    
    restore database;
    
    #switch datafile all;
    
    recover database;
    
    release channel t1;
    
    release channel t2;
    
    release channel t3;
    
    }
    复制代码

    2.归档日志恢复

    复制代码
    run {
    
    allocate channel t1 type 'sbt_tape';
    
    allocate channel t2 type 'sbt_tape';
    
    send 'NB_ORA_CLIENT=192.168.x.x';
    
    send 'NB_ORA_SERV=nbu5230';
    
    restore archivelog from sequence 8 until sequence 12 INCARNATION ALL;
    
    release channel t1;
    
    release channel t2;
    
    }
    复制代码

    3.其他恢复

    复制代码
    更改还原路径:
    
    RMAN> set archivelog destination to '/u01/backup';
    
    还原全部备份归档:
    
    RMAN> restore archivelog all;
    
    归档日志范围恢复:
    
    RMAN> restore archivelog from sequence 8 until sequence 12;
    
    RMAN> restore archivelog sequence between 8 and 12;
    
    从低sequence开始恢复:
    
    RMAN> restore archivelog from sequence 5;
    
    RMAN> restore archivelog low sequence 5;
    
    从高sequnece截止恢复:
    
    RMAN> restore archivelog until sequence 110;
    
    RMAN> restore archivelog high sequence 108;
    
    按时间恢复:
    
    RMAN> restore archivelog from time 'sysdate-7';
  • 相关阅读:
    BZOJ 1565 植物大战僵尸
    BZOJ 1497 最大获利(最大权闭合子图)
    BZOJ 1070 修车(最小费用流)
    BZOJ 2879 NOI2012美食节
    PHPCMS模板里面使用自定义函数
    邓_phpcms_数据库
    邓_ phpcms_
    dedecms====phpcms 区别==[工作]
    邓_html_图片轮播
    dedecms_插件
  • 原文地址:https://www.cnblogs.com/yaoyangding/p/15819349.html
Copyright © 2020-2023  润新知