NBU6.5 oracle 恢复归档日志是报错，麻烦帮忙分析一下

月黑高飞

list backup可以看到有做归档日志的备份，但在 resotre时却报找不到文件。现在如恢复nbu备份过的所有archivelog日志？

RMAN> run {
2> allocate channel t1 type SBT_TAPE;
3> RESTORE ARCHIVELOG ALL;
4> }

allocated channel: t1
channel t1: sid=159 devtype=SBT_TAPE
channel t1: Veritas NetBackup for Oracle - Release 6.5 (2007072323)

Starting restore at 19-4月 -11

released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 04/19/2011 18:18:16
RMAN-06026: some targets not found - aborting restore
RMAN-06025: no backup of log thread 1 seq 12 lowscn 12446583 found to restore
RMAN-06025: no backup of log thread 1 seq 11 lowscn 12446580 found to restore
RMAN-06025: no backup of log thread 1 seq 10 lowscn 12446520 found to restore
RMAN-06025: no backup of log thread 1 seq 9 lowscn 12446489 found to restore
RMAN-06025: no backup of log thread 1 seq 8 lowscn 12446480 found to restore




SQL> recover tablespace RMAN_TS;
ORA-00279: change 12560017 generated at 04/19/2011 15:44:40 needed for thread 1
ORA-00289: suggestion :
/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2011_04_19/o1_mf_1_18_%u_.ar
c
ORA-00280: change 12560017 for thread 1 is in sequence #18


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00308: cannot open archived log
'/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2011_04_19/o1_mf_1_18_%u_.a
rc'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3


ORA-00308: cannot open archived log
'/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2011_04_19/o1_mf_1_18_%u_.a
rc'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3


SQL>

RMAN>list backu;
BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
105     Full    2.07G      SBT_TAPE    00:01:05     19-4月 -11     
        BP Key: 109   Status: AVAILABLE  Compressed: NO  Tag: TAG20110419T154440
        Handle: bk_121_1_748885480   Media:
  List of Datafiles in backup set 105
  File LV Type Ckp SCN    Ckp Time   Name
  ---- -- ---- ---------- ---------- ----
  1       Full 12560017   19-4月 -11 /u01/app/oracle/oradata/orcl/system01.dbf
  2       Full 12560017   19-4月 -11 /u01/app/oracle/oradata/orcl/undotbs01.dbf
  3       Full 12560017   19-4月 -11 /u01/app/oracle/oradata/orcl/sysaux01.dbf
  4       Full 12560017   19-4月 -11 /u01/app/oracle/oradata/orcl/users01.dbf
  5       Full 12560017   19-4月 -11 /u01/app/oracle/oradata/orcl/example01.dbf
  6       Full 12560017   19-4月 -11 /u01/app/oracle/oradata/orcl/rman_ts.dbf
  7       Full 12560017   19-4月 -11 /u01/app/oracle/oradata/orcl/rmantable.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
106     Full    7.25M      SBT_TAPE    00:00:41     19-4月 -11     
        BP Key: 110   Status: AVAILABLE  Compressed: NO  Tag: TAG20110419T154440
        Handle: bk_122_1_748885555   Media:
  Control File Included: Ckp SCN: 12560042     Ckp time: 19-4月 -11

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
107     Full    7.25M      SBT_TAPE    00:00:53     19-4月 -11     
        BP Key: 111   Status: AVAILABLE  Compressed: NO  Tag: TAG20110419T154640
        Handle: c-1261790618-20110419-01   Media:
  Control File Included: Ckp SCN: 12560061     Ckp time: 19-4月 -11
  SPFILE Included: Modification time: 16-4月 -11

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
108     256.00K    SBT_TAPE    00:00:42     19-4月 -11     
        BP Key: 112   Status: AVAILABLE  Compressed: NO  Tag: TAG20110419T154739
        Handle: arch-124-1-748885659   Media:

  List of Archived Logs in backup set 108
  Thrd Seq     Low SCN    Low Time   Next SCN   Next Time
  ---- ------- ---------- ---------- ---------- ---------
  1    18      12559749   19-4月 -11 12560091   19-4月 -11
  1    19      12560091   19-4月 -11 12560105   19-4月 -11

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
109     Full    7.25M      SBT_TAPE    00:00:45     19-4月 -11     
        BP Key: 113   Status: AVAILABLE  Compressed: NO  Tag: TAG20110419T154825
        Handle: c-1261790618-20110419-02   Media:
  Control File Included: Ckp SCN: 12560125     Ckp time: 19-4月 -11
  SPFILE Included: Modification time: 16-4月 -11

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
110     1.25M      SBT_TAPE    00:00:42     19-4月 -11     
        BP Key: 114   Status: AVAILABLE  Compressed: NO  Tag: TAG20110419T164332
        Handle: 3uma68tk_1_1   Media:

  List of Archived Logs in backup set 110
  Thrd Seq     Low SCN    Low Time   Next SCN   Next Time
  ---- ------- ---------- ---------- ---------- ---------
  1    18      12559749   19-4月 -11 12560091   19-4月 -11
  1    19      12560091   19-4月 -11 12560105   19-4月 -11
  1    20      12560105   19-4月 -11 12561495   19-4月 -11

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
111     Full    7.25M      SBT_TAPE    00:00:43     19-4月 -11     
        BP Key: 115   Status: AVAILABLE  Compressed: NO  Tag: TAG20110419T164419
        Handle: c-1261790618-20110419-03   Media:
  Control File Included: Ckp SCN: 12561517     Ckp time: 19-4月 -11
  SPFILE Included: Modification time: 16-4月 -11

月黑高飞

run {
allocate channel t1 type SBT_TAPE;        
restore archivelog sequence 21 thread 1;
release channel t1;
}

这样就可以恢复。

中国龙老张

自问自答？

赵大少爷

回复 2# 月黑高飞


    这样才是正确的

月黑高飞

回复 3# 中国龙老张


    摸索前进啊老大，请多指导。

heroesray

从list backup结果看你的备份集备份的归档只有18,19,20。所以恢复sequence 8-12当然报错了。
如果在sql提示符下恢复，先确保'/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2011_04_19/下面有18-21的归档。
如果归档在别的位置，如/archivelog，应该执行recover from ‘/archivelog' tablespace RMAN_TS.
如果在rman下恢复，直接recover tablespace RMAN_TS就可以。所需归档自动会从备份集恢复到/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2011_04_19/下。

月黑高飞

回复 6# heroesray


    backup list 我拷贝出来的知识一部分，又明白了不少，谢谢