ORA-19511: non RMAN but media manager or vendor specific failure error text | ORA-27029 | ORA-19507

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

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

Leave a Reply

Your email address will not be published. Required fields are marked *