Skip to main content
Solved

Oracle restore; AFileIdList is empty, restore files not found in cache

  • 6 October 2023
  • 2 replies
  • 45 views

Hi Team,

 

Could anyone help me understand why i could be seeing this errors on an oracle restore job. Considering the backup i am restoring from is from 1st which is recent, and the data verification for the job in the storage policy shows successful. The mediaagent is ready and the storage mountpaths associated to the job are also ready...other files are getting restored on the same job which tells me its not a communication issue but these ones it seems are not found? so i’m not sure if the job will complete successfully. I’m looking for any ideas on what i can check on?

29410 72e2 10/06 11:29:26 474484 OraBackupRestoreBase::NewArchive() - Getting new CvDeMuxArchive for archFileName=e]...
29410 72e2 10/06 11:29:26 474484 CVArchive::Construct() - Constructing CVArchive Object. This=0x12478360
29410 72e2 10/06 11:29:26 474484 CVArchive::Construct() - Enable CVArchive Big Buffer utrue] tperf-update interval 600 seconds]
29410 72e2 10/06 11:29:26 474484 JM Client  CVJobClient::initialize(): Got remote host eKEDRCOMMSVR.kcbad.com].
29410 72e2 10/06 11:29:26 474484 CreateOraObject: Added CvArchive to IdaPerfMgr
29410 72e2 10/06 11:29:26 474484 CreateOraObject20: after initialize new OraBackupRestore20
29410 72e2 10/06 11:29:26 474484 get_file_info: enter.
29410 72e2 10/06 11:29:26 474484 get_file_info: begin GetBackupInfo - file <KCBSLDB_j027jkss_41568_1_1>
29410 72e2 10/06 11:29:26 474484 OraBackupRestoreBase::GetBackupInfo() - clientId=i94] instanceId=a305] name=]KCBSLDB_j027jkss_41568_1_1] copy=]0], matchClient =l1]...
29410 72e2 10/06 11:29:26 474484 OraBackupRestoreBase::FetchArchFileFromArchMgrResp(1577) - backupFileName <KCBSLDB_j027jkss_41568_1_1> not found in cache
29410 72e2 10/06 11:29:26 474484 OraBackupRestoreBase::GetBackupInfo() - calling archMgr
29410 72e2 10/06 11:29:26 474484 OraBackupRestoreBase::GetBackupInfo() - AFileIdList is empty, retCode=1
29410 72e2 10/06 11:29:26 474484 OraBackupRestoreBase::GetBackupInfo() - For restore: retCode=e1] appId= 0] afileNumber=N0] agroupNumber=N0] streamNum=e0] appType=p0].
29410 72e2 10/06 11:29:26 474484 OscLogBackupUtility::CheckIndexAndDataServerAPI(38) - Request XML= t<?xml version="1.0" encoding="UTF-8" standalone="no" ?><Ida_DumpSweepPITCheckReq><sourceEntity _type_="0" instanceId="305"/></Ida_DumpSweepPITCheckReq>]
Response XML = <?xml version='1.0' encoding='utf-8' ?><Ida_DumpSweepPITCheckResp status="0" errorString="Sweep option not set, therefore not doing index/dump search"/>]
29410 72e2 10/06 11:29:26 474484 OscLogBackupUtility::CheckIndexAndDataServerAPI(60) - Dump attribute not set
29410 72e2 10/06 11:29:26 474484 OscLogBackupUtility::CheckIndexAndDataServerAPI(95) - LogSweepEnabled attribute = b0]
29410 72e2 10/06 11:29:26 474484 get_file_info: file <KCBSLDB_j027jkss_41568_1_1> is not found
29410 72e2 10/06 11:29:26 474484 get_file_info: begin GetBackupInfo - file <KCBSLDB_iv27jkrj_41567_1_1>
29410 72e2 10/06 11:29:26 474484 OraBackupRestoreBase::GetBackupInfo() - clientId=i94] instanceId=a305] name=]KCBSLDB_iv27jkrj_41567_1_1] copy=]0], matchClient =l1]...
29410 72e2 10/06 11:29:26 474484 OraBackupRestoreBase::FetchArchFileFromArchMgrResp(1577) - backupFileName <KCBSLDB_iv27jkrj_41567_1_1> not found in cache
29410 72e2 10/06 11:29:26 474484 OraBackupRestoreBase::GetBackupInfo() - calling archMgr
29410 72e2 10/06 11:29:26 474484 OraBackupRestoreBase::GetBackupInfo() - AFileIdList is empty, retCode=1
29410 72e2 10/06 11:29:26 474484 OraBackupRestoreBase::GetBackupInfo() - For restore: retCode=e1] appId= 0] afileNumber=N0] agroupNumber=N0] streamNum=e0] appType=p0].
29410 72e2 10/06 11:29:26 474484 get_file_info: file <KCBSLDB_iv27jkrj_41567_1_1> is not found
29410 72e2 10/06 11:29:26 474484 get_file_info: begin GetBackupInfo - file <KCBSLDB_ic27j55i_41548_1_1>
29410 72e2 10/06 11:29:26 474484 OraBackupRestoreBase::GetBackupInfo() - clientId=i94] instanceId=a305] name=]KCBSLDB_ic27j55i_41548_1_1] copy=]0], matchClient =l1]...
29410 72e2 10/06 11:29:26 474484 OraBackupRestoreBase::FetchArchFileFromArchMgrResp(1577) - backupFileName <KCBSLDB_ic27j55i_41548_1_1> not found in cache
29410 72e2 10/06 11:29:26 474484 OraBackupRestoreBase::GetBackupInfo() - calling archMgr
29410 72e2 10/06 11:29:26 474484 OraBackupRestoreBase::GetBackupInfo() - AFileIdList is empty, retCode=1
29410 72e2 10/06 11:29:26 474484 OraBackupRestoreBase::GetBackupInfo() - For restore: retCode=e1] appId= 0] afileNumber=N0] agroupNumber=N0] streamNum=e0] appType=p0].
29410 72e2 10/06 11:29:26 474484 get_file_info: file <KCBSLDB_ic27j55i_41548_1_1> is not found
29410 72e2 10/06 11:29:26 474484 get_file_info: begin GetBackupInfo - file <KCBSLDB_fj27g3ig_41459_1_1>
29410 72e2 10/06 11:29:26 474484 OraBackupRestoreBase::GetBackupInfo() - clientId=i94] instanceId=a305] name=]KCBSLDB_fj27g3ig_41459_1_1] copy=]0], matchClient =l1]...
29410 72e2 10/06 11:29:26 474484 OraBackupRestoreBase::FetchArchFileFromArchMgrResp(1577) - backupFileName <KCBSLDB_fj27g3ig_41459_1_1> not found in cache
29410 72e2 10/06 11:29:26 474484 OraBackupRestoreBase::GetBackupInfo() - calling archMgr
29410 72e2 10/06 11:29:26 474484 OraBackupRestoreBase::GetBackupInfo() - AFileIdList is empty, retCode=1
29410 72e2 10/06 11:29:26 474484 OraBackupRestoreBase::GetBackupInfo() - For restore: retCode=e1] appId= 0] afileNumber=N0] agroupNumber=N0] streamNum=e0] appType=p0].
29410 72e2 10/06 11:29:26 474484 get_file_info: file <KCBSLDB_fj27g3ig_41459_1_1> is not found
29410 72e2 10/06 11:29:26 474484 get_file_info: begin GetBackupInfo - file <KCBSLDB_fn27gc5a_41463_1_1>
29410 72e2 10/06 11:29:26 474484 OraBackupRestoreBase::GetBackupInfo() - clientId=i94] instanceId=a305] name=]KCBSLDB_fn27gc5a_41463_1_1] copy=]0], matchClient =l1]...
29410 72e2 10/06 11:29:26 474484 OraBackupRestoreBase::FetchArchFileFromArchMgrResp(1577) - backupFileName <KCBSLDB_fn27gc5a_41463_1_1> not found in cache
29410 72e2 10/06 11:29:26 474484 OraBackupRestoreBase::GetBackupInfo() - calling archMgr
29410 72e2 10/06 11:29:26 474484 OraBackupRestoreBase::GetBackupInfo() - AFileIdList is empty, retCode=1
29410 72e2 10/06 11:29:26 474484 OraBackupRestoreBase::GetBackupInfo() - For restore: retCode=e1] appId= 0] afileNumber=N0] agroupNumber=N0] streamNum=e0] appType=p0].
29410 72e2 10/06 11:29:26 474484 get_file_info: file <KCBSLDB_fn27gc5a_41463_1_1> is not found
29410 72e2 10/06 11:29:26 474484 get_file_info: begin GetBackupInfo - file <KCBSLDB_j127jmtp_41569_1_1>
29410 72e2 10/06 11:29:26 474484 OraBackupRestoreBase::GetBackupInfo() - clientId=i94] instanceId=a305] name=]KCBSLDB_j127jmtp_41569_1_1] copy=]0], matchClient =l1]...
29410 72e2 10/06 11:29:26 474484 OraBackupRestoreBase::FetchArchFileFromArchMgrResp(1577) - backupFileName <KCBSLDB_j127jmtp_41569_1_1> not found in cache
29410 72e2 10/06 11:29:26 474484 OraBackupRestoreBase::GetBackupInfo() - calling archMgr
29410 72e2 10/06 11:29:26 474484 OraBackupRestoreBase::GetBackupInfo() - AFileIdList is empty, retCode=1
29410 72e2 10/06 11:29:26 474484 OraBackupRestoreBase::GetBackupInfo() - For restore: retCode=e1] appId= 0] afileNumber=N0] agroupNumber=N0] streamNum=e0] appType=p0].
29410 72e2 10/06 11:29:26 474484 get_file_info: file <KCBSLDB_j127jmtp_41569_1_1> is not found
29410 72e2 10/06 11:29:26 474484 get_file_info: begin GetBackupInfo - file <KCBSLDB_i727j55i_41543_1_1>
29410 72e2 10/06 11:29:26 474484 OraBackupRestoreBase::GetBackupInfo() - clientId=i94] instanceId=a305] name=]KCBSLDB_i727j55i_41543_1_1] copy=]0], matchClient =l1]...
29410 72e2 10/06 11:29:26 474484 OraBackupRestoreBase::FetchArchFileFromArchMgrResp(1577) - backupFileName <KCBSLDB_i727j55i_41543_1_1> not found in cache
29410 72e2 10/06 11:29:26 474484 OraBackupRestoreBase::GetBackupInfo() - calling archMgr
29410 72e2 10/06 11:29:27 474484 OraBackupRestoreBase::GetBackupInfo() - AFileIdList is empty, retCode=1
29410 72e2 10/06 11:29:27 474484 OraBackupRestoreBase::GetBackupInfo() - For restore: retCode=e1] appId= 0] afileNumber=N0] agroupNumber=N0] streamNum=e0] appType=p0].
29410 72e2 10/06 11:29:27 474484 get_file_info: file <KCBSLDB_i727j55i_41543_1_1> is not found
29410 72e2 10/06 11:29:27 474484 get_file_info: begin GetBackupInfo - file <KCBSLDB_d427dg1u_41380_1_1>
29410 72e2 10/06 11:29:27 474484 OraBackupRestoreBase::GetBackupInfo() - clientId=i94] instanceId=a305] name=]KCBSLDB_d427dg1u_41380_1_1] copy=]0], matchClient =l1]...
29410 72e2 10/06 11:29:27 474484 OraBackupRestoreBase::FetchArchFileFromArchMgrResp(1577) - backupFileName <KCBSLDB_d427dg1u_41380_1_1> not found in cache


 

2 replies

C
Rank
Userlevel 5
Badge +14

Hello @MOGFREY 

Based on the logs you are restoring from Copy0 which should be the primary copy. How are you performing the browse? From the Storage Policy Copy or from the Client’s Backup History?

Could you try running the Browse from the specific Storage Policy Copy you want to restore from? It is possible the job has aged off of the Primary copy, resulting in this error.

 

Thank you,
Collin

 

M
Rank
Badge +5

Hi Collin,

 

Thanks for your response. Tried from the storage policy but still gave the same error. Had to raise a support case. Turns out the customer had been running concurrent backups from a different solution. So commvault was looking for datafiles backed up from the other solution. and not finding them, so we cant restore from any of those backups.

Reply


Terms & ConditionsCookie settings