nbu 恢复 oracle 控制文件 报错

johnson2002

回复 20# 赵大少爷


    试出结果来BG一下. 我也是做了部分测试和看了上面的doit的贴子后总结出来的 .

zhangmq

见鬼啦，今天测试恢复居然又可以。之前错误不知问题出在哪，跟set dbid=xxx不知有没关系。我之前也试没set dbid=xxx的，是失败后重新rman target / 登陆，设置的dbid还有效吗？如图，在备份服务器状态查看看，之前client老显示localhost，而这次成功的话是我的客户端aix。

RMAN> startup nomount

Oracle instance started

Total System Global Area     612368384 bytes

Fixed Size                     2022800 bytes
Variable Size                239075952 bytes
Database Buffers             364904448 bytes
Redo Buffers                   6365184 bytes

RMAN> run {
2>
3> allocate channel t1 type 'sbt_tape';
4> send 'NB_ORA_CLIENT=aix';
5> send 'NB_ORA_SERV=su182';
6> restore controlfile from 'cntrl_72_1_713122383';
7> release channel t1;
8> }

using target database control file instead of recovery catalog
allocated channel: t1
channel t1: sid=156 devtype=SBT_TAPE
channel t1: Veritas NetBackup for Oracle - Release 6.5 (2007072323)

sent command to channel: t1

sent command to channel: t1

Starting restore at 11-MAR-10

channel t1: restoring control file
channel t1: restore complete, elapsed time: 00:00:48
output filename=/oracle/database/oradata/orcl/control01.ctl
output filename=/oracle/database/oradata/orcl/control02.ctl
output filename=/oracle/database/oradata/orcl/control03.ctl
Finished restore at 11-MAR-10

released channel: t1

RMAN>

johnson2002

回复 21# johnson2002

对不起,.我说错了. relink nbu后, 备份type既可以是disk,也是SBT_TAPE.

type选择 'SBT_TAPE'

rman target sys/manager nocatalog msglog /var/tmp/rmanbkup_ts2.log append<<EOF
RUN {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';

SEND 'NB_ORA_POLICY=$NB_ORA_POLICY,NB_ORA_SERV=$NB_ORA_SERV, NB_ORA_CLIENT=$NB_ORA_CLIENT, NB_ORA_PC_SCHED=$NB_ORA_PC_SCHED';
BACKUP
        $BACKUP_TYPE
        FORMAT 'df_%s_%p_%t'
        (TABLESPACE 'TS2' CHANNEL ch00);
SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
RELEASE CHANNEL ch00;

}
EOF

Recovery Manager: Release 10.2.0.1.0 - Production on Mon Oct 25 15:38:25 2010

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: RACDB (DBID=729837050)
using target database control file instead of recovery catalog

RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12>
allocated channel: ch00
channel ch00: sid=139 devtype=SBT_TAPE
channel ch00: Veritas NetBackup for Oracle - Release 7.1 (2010101203)

sent command to channel: ch00

Starting backup at 25-OCT-10
channel ch00: starting incremental level 0 datafile backupset
channel ch00: specifying datafile(s) in backupset
input datafile fno=00005 name=/opt/oracle/oradata/racdb/ts2a.dbf
channel ch00: starting piece 1 at 25-OCT-10
channel ch00: finished piece 1 at 25-OCT-10
piece handle=df_16_1_733333108 tag=TAG20101025T153828 comment=API Version 2.0,MMS Version 5.0.0.0
channel ch00: backup set complete, elapsed time: 00:01:36
Finished backup at 25-OCT-10

sql statement: ALTER SYSTEM ARCHIVE LOG CURRENT

released channel: ch00

RMAN>

Recovery Manager complete.

type选择 disk

rman target sys/manager nocatalog msglog /var/tmp/rmanbkup_ts2.log append<<EOF
RUN {
ALLOCATE CHANNEL ch00 TYPE 'DISK';

SEND 'NB_ORA_POLICY=$NB_ORA_POLICY,NB_ORA_SERV=$NB_ORA_SERV, NB_ORA_CLIENT=$NB_ORA_CLIENT, NB_ORA_PC_SCHED=$NB_ORA_PC_SCHED';
BACKUP
        $BACKUP_TYPE
        FORMAT 'df_%s_%p_%t'
        (TABLESPACE 'TS2' CHANNEL ch00);
SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
RELEASE CHANNEL ch00;

}



Recovery Manager: Release 10.2.0.1.0 - Production on Mon Oct 25 16:19:03 2010

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: RACDB (DBID=729837050)
using target database control file instead of recovery catalog

RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12>
allocated channel: ch00
channel ch00: sid=138 devtype=DISK

sent command to channel: ch00

Starting backup at 25-OCT-10
channel ch00: starting incremental level 0 datafile backupset
channel ch00: specifying datafile(s) in backupset
input datafile fno=00005 name=/opt/oracle/oradata/racdb/ts2a.dbf
channel ch00: starting piece 1 at 25-OCT-10
channel ch00: finished piece 1 at 25-OCT-10
piece handle=/opt/oracle/dbs/df_17_1_733335546 tag=TAG20101025T161906 comment=NONE
channel ch00: backup set complete, elapsed time: 00:00:25
Finished backup at 25-OCT-10

sql statement: ALTER SYSTEM ARCHIVE LOG CURRENT

released channel: ch00

RMAN>

Recovery Manager complete.

查看备份,


RMAN>  list backup of database ;


List of Backup Sets
===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
10      Incr 0  624.25M    SBT_TAPE    00:01:30     25-OCT-10      
        BP Key: 10   Status: EXPIRED  Compressed: NO  Tag: TAG20101025T153828
        Handle: df_16_1_733333108   Media:
  List of Datafiles in backup set 10
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  5    0  Incr 1316688    25-OCT-10 /opt/oracle/oradata/racdb/ts2a.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
11      Incr 0  628.11M    DISK        00:00:21     25-OCT-10      
        BP Key: 11   Status: AVAILABLE  Compressed: NO  Tag: TAG20101025T161906
        Piece Name: /opt/oracle/dbs/df_17_1_733335546
  List of Datafiles in backup set 11
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  5    0  Incr 1321409    25-OCT-10 /opt/oracle/oradata/racdb/ts2a.dbf

NBU只能认出TYPE为SBT_TAPE的备份

rac97:/stu1 #  date ;ls -rlt ; bplist -C  sun215vip -t 4 -R /
Mon Oct 25 16:46:21 CST 2010
total 639908
-rw------- 1 root root      4096 Oct 25 15:38 sun215vip_1287992312_C1_HDR.1287992312.info
-rw------- 1 root root      4096 Oct 25 15:38 sun215vip_1287992312_C1_HDR.1287992312.img
-rw------- 1 root root      4096 Oct 25 15:39 sun215vip_1287992312_C1_F1.1287992312.info
-rw------- 1 root root 654606336 Oct 25 15:39 sun215vip_1287992312_C1_F1.1287992312.img
/df_16_1_733333108

实践出真知...

ry715

真好，就是需要这样的技术贴

zakung

第一页的恢复文件写错了
SQL> declare
  2  devtype varchar2(256);
  3  done boolean;
  4  begin
  5  devtype:=dbms_backup_restore.deviceallocate('sbt_tape',params=>'');
  6  dbms_backup_restore.restoresetdatafile;
  7  dbms_backup_restore.restorecontrolfileto('/home/oracle/abc.cf');
  8  dbms_backup_restore.restorebackuppiece('c-1240301407-20100304-06',done=>done
  9  );
10  end;
11  /
declare

换成cntrl开头的文件试一试，我做过测试是可以提取出来的

zhangmq

回复 25# zakung


    这个我当时试过，报同样的错。怀疑跟我改成过aix客户端/etc/hosts文件有关，恢复成功是在127.0.0.1 localhost****一行注释掉后，回头再测试确认问题，这两天没时间。

wangyl1977

回复 27# kerlion


    对, relink nbu后,还把channel type选为disk, 那实际就是没用nbu, client端备份的 backupset只能保存在本地(NBU会存在media server的设备(disk or tape) ), nbu的catalog也没有这个备份集信息,恢复的话也就不能用nbu恢复

redwaves

RMAN> run {
allocate channel t1 type 'sbt_tape';
send 'NB_ORA_CLIENT=client_name';
send 'NB_ORA_SERV=veritas_server';
restore controlfile from  autobackup;
release channel t1;
}

100心

脚本用send 有什么好处呢？