NBU Oracle恢复案例

最近在做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';