• oracle 恢复归档日志 从指定的磁带中恢复归档日志及查看命令


    说明:

    数据库:ORACLE 10G

    备份软件:NBU 7.0

    (一)、查看指定时间范围内的已经备份的归档日志:

    $ rman target /  

    list backup of archivelog time between "to_date('2016-03-01 20:00:00','yyyy-mm-dd hh24:mi:ss')" and "to_date('2016-03-02 00:00:00','yyyy-mm-dd hh24:mi:ss')";


    (二)、从指定的磁带中恢复归档日志的方法:(异机恢复时,从指定的月度备份的磁带中恢复归档日志)

    方法一:

    指定参数(time between, from tag='xxxx')

    $ rman target /  

    run {
    allocate channel ch00 type 'SBT_TAPE'
    parms 'ENV=(NB_ORA_SERV=bkserver,NB_ORA_CLIENT=oradb1)';
    allocate channel ch01 type 'SBT_TAPE'
    parms 'ENV=(NB_ORA_SERV=bkserver,NB_ORA_CLIENT=oradb2)';
    restore archivelog time between "to_date('2016-03-01 20:00:00','yyyy-mm-dd hh24:mi:ss')" and "to_date('2016-03-02 00:00:00','yyyy-mm-dd hh24:mi:ss')" from tag='TAG20160301T235035';
    release channel ch00;
    release channel ch01;
    }



    方法二:

    指定参数(NSR_DATA_VOLUME_POOL=first_pool,NB_ORA_POLICY=ora_full)

    $ rman target /  

    run {
    allocate channel ch00 type 'SBT_TAPE'
    parms 'ENV=(NB_ORA_SERV=bkserver,NSR_DATA_VOLUME_POOL=per_pool,NB_ORA_POLICY=ora_full,NB_ORA_CLIENT=oradb1)';
    allocate channel ch01 type 'SBT_TAPE'
    parms 'ENV=(NB_ORA_SERV=bkserver,NSR_DATA_VOLUME_POOL=per_pool,NB_ORA_POLICY=ora_full,NB_ORA_CLIENT=oradb2)';
    set archivelog destination to "/oradata/arch";
    restore archivelog from logseq=30851 until logseq=30855 thread=2;
    restore archivelog from logseq=36232 until logseq=36236 thread=1;
    RELEASE CHANNEL ch00;
    RELEASE CHANNEL ch01;
    }

  • 相关阅读:
    【Tools__技巧】软件技巧整理归纳
    【JS__框架】主页面F5刷新iframe框架页面
    为类型增加选择属性
    单元测试mock当前时间
    silverlight属性改变事件通知
    修改博客园推荐人数增加W效果
    Enum扩展特性,代替中文属性
    Python爬虫-萌妹子图片
    吐槽下魅族
    使用openXML 不用插件导出excel
  • 原文地址:https://www.cnblogs.com/yaoyangding/p/15813954.html
Copyright © 2020-2023  润新知