05-04-2017 06:59 AM
05-04-2017 07:11 AM
05-04-2017 07:20 AM
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.
05-05-2017 05:30 AM
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