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 就可以了
标签：datafile,Full,23,恢复,备份,29,dbf,RMAN,OCT From： https://www.cnblogs.com/dbahrz/p/17814812.html