failed to perform rman restore ora27192

[kkhoo]

master server : SUSE 11 SP3; NBU 7.7.3 media server: SUSE 11 SP3; NBU 7.7.3 client: SUSE 11 SP4; NBU 7.7.3 (media server) Trying to do full db restore to alternate client. However, failed with ORA-27192. In NBU, see errors. 05/04/2017 09:44:36 - Error bptm (pid=21743) cannot write data to socket, Connection timed out 05/04/2017 09:44:36 - Error bptm (pid=21743) The following files/folders were not restored: 05/04/2017 09:44:36 - Error bptm (pid=21743) UTF - /ORA_ONL_BKUP_SP13_15643_1_941486413 05/04/2017 09:44:36 - Info bpbrm (pid=21671) media manager for backup id bknb-zsindb09vip_1492344016 exited with status 24: socket write failed 05/04/2017 09:44:36 - Info bpbrm (pid=21671) terminating bpbrm child 21744 jobid=2679018 05/04/2017 09:44:36 - restored from image bknb-zsindb09vip_1492344016; restore time: 1:21:49 05/04/2017 09:44:37 - end Restore; elapsed time 1:22:21 Restore error (2850) In rman restore log: channel aux1: reading from backup piece ORA_ONL_BKUP_SP13_15699_1_942091214 channel aux1: ORA-27192: skgfcls: sbtclose2 returned error - failed to close file ORA-19511: Error received from media manager layer, error text: VxBSAEndTxn: Failed with error: The sequence of calls is incorrect. ORA-19870: error while restoring backup piece ORA_ONL_BKUP_SP13_15699_1_942091214 ORA-19501: read error on file "ORA_ONL_BKUP_SP13_15699_1_942091214", block number 649741313 (block size=512) ORA-27190: skgfrd: sbtread2 returned erro channel aux1: starting datafile backup set restore channel aux1: specifying datafile(s) to restore from backup set channel aux1: restoring datafile 00020 to /OraBase/data/WX01/WX01SP13/data_D-SP13_TS-STREAMS_FNO-20 channel aux1: reading from backup piece ORA_ONL_BKUP_SP13_15753_1_942696016 channel aux1: ORA-27192: skgfcls: sbtclose2 returned error - failed to close file ORA-19511: Error received from media manager layer, error text: VxBSAEndTxn: Failed with error: The sequence of calls is incorrect. ORA-19870: error while restoring backup piece ORA_ONL_BKUP_SP13_15753_1_942696016 ORA-19501: read error on file "ORA_ONL_BKUP_SP13_15753_1_942696016", block number 531271169 (block size=512) ORA-27190: skgfrd: sbtread2 returned erro failover to previous backup Please advise, thanks.

[Will_Restore]

See this note for possible solution

https://www.veritas.com/support/en_US/article.000012940

[Marianne]

Difficult to read a post when everything seems to be one long line.

Herewith same post with a couple of <CR>s :

master server : SUSE 11 SP3; NBU 7.7.3
media server: SUSE 11 SP3; NBU 7.7.3
client: SUSE 11 SP4; NBU 7.7.3 (media server)

Trying to do full db restore to alternate client.
However, failed with ORA-27192. In NBU, see errors.

05/04/2017 09:44:36 - Error bptm (pid=21743) cannot write data to socket, Connection timed out
05/04/2017 09:44:36 - Error bptm (pid=21743) The following files/folders were not restored:
05/04/2017 09:44:36 - Error bptm (pid=21743) UTF - /ORA_ONL_BKUP_SP13_15643_1_941486413
05/04/2017 09:44:36 - Info bpbrm (pid=21671) media manager for backup id bknb-zsindb09vip_1492344016 exited with status 24: socket write failed
05/04/2017 09:44:36 - Info bpbrm (pid=21671) terminating bpbrm child 21744 jobid=2679018
05/04/2017 09:44:36 - restored from image bknb-zsindb09vip_1492344016; restore time: 1:21:49 05/04/2017 09:44:37 - end Restore; elapsed time 1:22:21 Restore error (2850)

In rman restore log:
channel aux1: reading from backup piece ORA_ONL_BKUP_SP13_15699_1_942091214
channel aux1: ORA-27192: skgfcls: sbtclose2 returned error - failed to close file
ORA-19511: Error received from media manager layer, error text: VxBSAEndTxn: Failed with error: The sequence of calls is incorrect.
ORA-19870: error while restoring backup piece ORA_ONL_BKUP_SP13_15699_1_942091214
ORA-19501: read error on file "ORA_ONL_BKUP_SP13_15699_1_942091214", block number 649741313 (block size=512)
ORA-27190: skgfrd: sbtread2 returned erro channel aux1: starting datafile backup set restore channel aux1: specifying datafile(s) to restore from backup set channel aux1: restoring datafile 00020 to /OraBase/data/WX01/WX01SP13/data_D-SP13_TS-STREAMS_FNO-20
channel aux1: reading from backup piece ORA_ONL_BKUP_SP13_15753_1_942696016
channel aux1: ORA-27192: skgfcls: sbtclose2 returned error - failed to close file
ORA-19511: Error received from media manager layer, error text: VxBSAEndTxn: Failed with error: The sequence of calls is incorrect.
ORA-19870: error while restoring backup piece ORA_ONL_BKUP_SP13_15753_1_942696016
ORA-19501: read error on file "ORA_ONL_BKUP_SP13_15753_1_942696016", block number 531271169 (block size=512)
ORA-27190: skgfrd: sbtread2 returned erro failover to previous backup

Please advise, thanks.

[Michael_G_Ander]

Errors on redirected Oracle restores is usually caused by a name problem somewhere.

Things to check

NB_ORA_CLIENT on all channels in the script

That the destination client is allowed to read the source clients backup on the interface it contacts the backup system with.

There was/is a rather good technote about doing Oracle alternate client restore.

The post below was made for database backup, but is probably useful for restores too

https://vox.veritas.com/t5/NetBackup/General-database-backup-error-troubleshooting/m-p/675381