Skip to main content
commvault.com commvault.com
Solved

out of place oracle restore failed ORA-27199

  • February 1, 2023
  • 4 replies
  • 695 views
M
Byte
Forum|alt.badge.img+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

 

 

 

Best answer by Muhammad Abdullah

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

 

 

 

View original
1 Attachments
Did this answer your question?

4 replies

G
Vaulter
Forum|alt.badge.img+13

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,

 

M
Byte
Forum|alt.badge.img+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
 

2 Attachments
M
Byte
Forum|alt.badge.img+9

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

 

 

 

G
1 person likes this
  • G
    Gowri Shankar
L
Byte
Forum|alt.badge.img+1
  • LBN
  • Byte
  • 1 reply
  • February 28, 2024

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


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings