I got ” ORA-19511: non RMAN but media manager or vendor specific failure error text | ORA-27029 | ORA-19507 ” error in Oracle database during Database Restore.
ORA-19511: non RMAN but media manager or vendor specific failure error text | ORA-27029 | ORA-19507
Details of error are as follows.
channel ch16: starting datafile backup set restore channel ch16: specifying datafile(s) to restore from backup set channel ch16: restoring datafile 00108 to +DATA/MSDBA/DATAFILE/tbs_msdba.1483.1057166321 channel ch16: restoring section 248 of 256 channel ch16: reading from backup piece bk_MSDBA_2054866743_2243570_248_1056972823 channel ch18: ORA-19870: error while restoring backup piece bk_MSDBA_2054866743_2243570_149_1056972823 ORA-19507: failed to retrieve sequential file, handle="bk_MSDBA_2054866743_2243570_149_1056972823", parms="" ORA-27029: skgfrtrv: sbtrestore returned error ORA-19511: non RMAN, but media manager or vendor specific failure, error text: Backup file <bk_MSDBA_2054866743_2243570_149_1056972823> not found in NetBackup catalog channel ch18: starting datafile backup set restore channel ch18: specifying datafile(s) to restore from backup set channel ch18: restoring datafile 00108 to +DATA/MSDBA/DATAFILE/tbs_msdba.1483.1057166321 channel ch18: restoring section 249 of 256 channel ch18: reading from backup piece bk_MSDBA_2054866743_2243570_249_1056972823 channel ch19: ORA-19870: error while restoring backup piece bk_MSDBA_2054866743_2243570_169_1056972823 ORA-19507: failed to retrieve sequential file, handle="bk_MSDBA_2054866743_2243570_169_1056972823", parms="" ORA-27029: skgfrtrv: sbtrestore returned error ORA-19511: non RMAN, but media manager or vendor specific failure, error text: Backup file <bk_MSDBA_2054866743_2243570_169_1056972823> not found in NetBackup catalog channel ch19: starting datafile backup set restore
The ORA-19511 ORA-27029 ORA-19507 error is related with the NSR_CLIENT and NSR_SERVER parameters if you are restoring from the Tape Backup ( Data domain )
ORA-19511 ORA-27029 ORA-19507
To solve this error, you should fix the NSR_CLIENT and NSR_SERVER parameters with the correct values. You can review the Backup job to find the correct NSR_CLIENT and NSR_SERVER values or you can request it from Backup Admin.
NSR_CLIENT —> Name of the NetWorker client resource used to perform the backup
NSR_SERVER —>Hostname of the NetWorker backup server used to perform the Oracle backup
Here source is the original production database and target is the auxiliary instance.
According to Network support, the client (NSR_Client of Source where backup was taken) information which was set in the allocate channel command was being lost for the auxiliary instance when the auxiliary database was stopped/started during duplicate process, and the information of auxiliary server NSR_Client was being used afterwards. As the target database was never backed up to Networker using the NSR_Client of auxiliary server, there were no backups to be found.
The information in the SEND command does not persist through a restart of the database. The PARMS keyword appears to cause the client information to persist through the entire duplicate operation.
The issue was resolved by Change SEND command to PARMS ALLOCATE AUXILIARY CHANNEL CH1 TYPE 'SBT_TAPE'; SEND 'NSR_ENV=(NSR_SERVER=NetworkerServer.domain.com, NSR_CLIENT=sourceServer.domain.com)';
to: ALLOCATE AUXILIARY CHANNEL CH1 TYPE 'SBT_TAPE' PARMS 'ENV=(NSR_SERVER=NetworkerServer.domain.com,NSR_CLIENT=sourceServer.domain.com)';
Other Case:
If you got this error on Pluggable database ( PDB), Restoring PDB was done on the tape which is unsupported.
Provisioning worked when RMAN was configured to use disk instead of tape.
Do you want to learn RMAN Restore database from Tape Backup, then Click This Link and read the articles.
How to Restore Oracle Database ( Controlfile, Datafile, Archivelog ) via RMAN from Tape Backup