Solved

out of place oracle restore failed ORA-27199

  • 1 February 2023
  • 4 replies
  • 334 views

Userlevel 1
Badge +9

Hello dears, 

 

im facing an issue while performing out of place restore for oracle database, 

the restore start to transfer 3 or more files then go in pending status with the below error

       Error Code: [18:182]
Description: Failed with     SBT library error [ORA-27199: skgfpst: sbtpcstatus returned     errorORA-19511: non RMAN, but media manager or vendor specific failure,     error text: ]
Source: R12_DB, Process: ClOraAgent

 

Mediaagent job manager log

26501 59f7 02/01 10:28:38 #### SdtTailServerPool::StopPipe: Going to stop client with SDT pipe [SDTPipe_R12_DBCRP_COLD_jd-mediaagent_5255_1675236023_20203_1_11b7691e0]. Type [0]
26501 59f7 02/01 10:28:38 #### SdtTailServerPool::StopPipe: Cannot find SDT pipe [SDTPipe_R12_DBCRP_COLD_jd-mediaagent_5255_1675236023_20203_1_11b7691e0]. JobId [5255]. Calling JM unregister here on its behalf
26501 59f7 02/01 10:28:38 #### deinitializeSDTpipeline CALLED for pipelineID [SDTPipe_R12_DBCRP_COLD_jd-mediaagent_5255_1675236023_20203_1_11b7691e0] 5255

 

 

 

icon

Best answer by Muhammad Abdullah 24 May 2023, 13:35

View original

4 replies

Userlevel 4
Badge +12

Hi @Muhammad Abdullah 

 

It looks like a failure due to network error 

 

Could you check ClOraAgent.log and ORASBT.log on the destination machine 

 

Are they any native backups executed on the source database

connect to RMAN and provide the following output

 

list backuppiece ‘bk_dPRODCDB_ugg1bdpvp_s7696_p67_t1119283193’

list backuppiece ‘4882_PRODCDB_ic1j0g15_13900_1_1’

 

Regards,

 

Userlevel 1
Badge +9

Hello @Gowri Shankar 

  • no native backups are running on the source db
  • im not an oracle admin can you enlighten me how to check the mentioned pieces?

list backuppiece ‘bk_dPRODCDB_ugg1bdpvp_s7696_p67_t1119283193’

list backuppiece ‘4882_PRODCDB_ic1j0g15_13900_1_1’

 

i have checked the CIOra and ORASBT and i found the below [logs are attached as well]

 

28761 a   02/01 14:17:52 5266 CCvNetworkServer::ReadThread() - Could not peek for data format. Error:'0xFFFFFFFF:{CCvNetwork::PeekDataFormat(6530)} + {CCvNetwork::ReceiveXDRMessageInternal(5514)} + {CCvNetwork::CheckIfDataAvailable(5824)/R12_DBCRP_COLD/dbcrp.acc.com/SockIP(Unknown)/10.10.1.27:0/0 (28810:1)} + {CCvNetwork::CheckDataWaiting(6498)} + {CSessionConnectionSocket::CheckDataWaiting(733)/ErrNo.-1.(Unknown error)-Failed to peek data on socket. Connection has been lost}', timedOut:No, handle:1
 

Userlevel 1
Badge +9

issue resolved after raising a ticket to the support and it was escalated to dev team.

 

 

 

Badge +1

Hi all,

I have the same issue, possible to share the solution, thanks

 

Error Code: [18:182] Description: Failed with SBT library error [channel ch2: ORA-19870: error while restoring backup piece 796088_PHR_9h2hii58_1_1ORA-19511: Error received from media manager layer, error text: sbtread2: Job[870893] thread[12779658]: CvArchive returned wrong buf_type=135. ORA-19511: Error received from media manager layer, error text: channel ch2: ORA-19870: error while restoring backup piece 796793_PHR_9l2hj60b_1_1 ORA-19511: Error received from media manager layer, error text: channel ch2: ORA-19870: error while restoring backup piece 797154_PHR_9n2hjk3u_1_1 ORA-19511: Error received from media manager layer, error text: channel ch2: ORA-19870: error while restoring backup piece 797591_PHR_9p2hk27h_1_1 ORA-19511: Error received from media manager layer, error text: channel ch1: ORA-19870: error while restoring backup piece 796020_PHR_932hi9pd_1_1 ORA-19511: Error received from media manager layer, error text: sbtread2: Job[870893] thread[21692510]: CvArchive returned wrong buf_type=135. ORA-19511: Error received 

 

Best regards

Reply