ORA-19870: error while restoring CDB backup piece.
ORA-19870: error while restoring backup piece.ORA-19507, ORA-27029
We received above mentioned errors while restoring a tape backup from prod environment to non-prod env.
As soon as the restoration starts , first error message is like given above .
Errors:
| channel t1: ORA-19870: error while restoring backup piece bk_ORCLP_24317_1_1101614995 ORA-19507: failed to retrieve sequential file, handle=”bk_ORCLP_24317_1_ ORA-27029: skgfrtrv: sbtrestore returned error ORA-19511: non RMAN, but media manager or vendor specific failure, error text: ANS1302E (RC2) No objects on server match query |
Reason:
i)In the source backup script, below entries were there.==>skip readonly
==>skip inaccesible
==>skip offlineii)And below parameter value is showing in the show all commands coutput.
==>skip inaccesible
==>skip offlineii)And below parameter value is showing in the show all commands coutput.
==>optimization is on
Overview of the environment:
- Source Database had been upgraded and converted from normal DB to CDB.
- Before conversion to CDB ,there were no read-only datafiles.
- As CDB contains read-only PDB$SEED database and the datafiles in that were in read-only status.
- After conversion to CDB, When the 1st time full backup taken , all the datafiles backup was completed.
- In the subsequent backups those file’s backup was skipped as per “skip readonly” command.
- As per the retention, those first time full backup sets of read-only datafiles were deleted.
- we have checked “restore preview”, it did not show any errors.
Actions taken:
Took the backup of missing readonly datafiles from the source database, and re ran the restore activity.
Restore activity completed and recovered the database and corrected the original backup script in the source server.
See Also: