RMAN 恢复时候出现不存在的备份片

发布时间 2023-11-07 13:45:29作者: 蚌壳里夜有多长
ORA-19870: error reading backup piece al_43199_1_760245675
ORA-19507: failed to retrieve sequential file, handle="al_43199_1_760245675", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text

报错信息如上边这样

rman target /

list backup of database;


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
97843   Full    78.62G     DISK        02:42:22     29-OCT-23      
        BP Key: 97856   Status: AVAILABLE  Compressed: YES  Tag: TAG20231029T020100
        Piece Name: /dbbackup/nfs2/backupset/20231029/hrdb/full_r20_HRDB_qm2a3omt_1_1_20231029_1.bak
  List of Datafiles in backup set 97843
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 49451766724 29-OCT-23 /lbc/hr/data/PHRDB/datafile/system01.dbf
  4       Full 49451766724 29-OCT-23 /lbc/hr/data/PHRDB/datafile/users01.dbf
  8       Full 49451766724 29-OCT-23 /lbc/hr/data/PHRDB/datafile/EAS_D_LBCHR_STANDARD02.dbf
  12      Full 49451766724 29-OCT-23 /lbc/hr/data/PHRDB/datafile/EAS_D_LBCHR_STANDARD20200928.dbf
  16      Full 49451766724 29-OCT-23 /lbc/hr/data/PHRDB/datafile/EAS_D_LBCHR_STANDARD5.dbf
  24      Full 49451766724 29-OCT-23 /lbc/hr/data/PHRDB/datafile/EAS_D_LBCHR_STANDARD11.dbf

列出发现有一个备份片是不存在但是

 Status: AVAILABLE 
CHANGE BACKUP TAG 'TAG20231029T020100' UNAVAILABLE

在进行restore 就可以了