Compare getting error " ORA-01187: cannot read from file XXX" and "ORA-01110: data file " (4324875)

Tchater maintenant avec le support

Compare getting error " ORA-01187: cannot read from file XXX" and "ORA-01110: data file " (4324875)

Retour

Commentaire envoyé

Cet article vous a-t-il à résoudre un problème ?

Sélectionner une évaluation

Titre

Compare getting error " ORA-01187: cannot read from file XXX" and "ORA-01110: data file "
Description

Compare failed with error " ORA-01187: cannot read from file XXX" and "ORA-01110: data file "
Server log has following error :
006: Oracle Error 1187: ORA-01187: cannot read from file xxx because it failed verification tests
ORA-01110: data file xxx: '/dev/rM_TEMP_01'
006: Error 1187 calling OCIStmtExecute (de_select_prepare_to_fetch,L1490)
006: Error 1 calling de_select_prepare_to_fetch in de_batch_setup
Event_log on source shows the following error :

Error 2011-03-28 14:24:31.124303 823382 515 Compare server: Oracle Error 1187: ORA-01187: cannot read from file xxx because it failed verification tests.ORA-01110: data file xxx: '/dev/rM_TEMP_01'. [sp_desvr] [module deq]
Error 2011-03-28 14:24:31.180206 823382 515 Compare server: Error 1 in de_batch_setup, see sdpa_desvr-823382-01*.log [sp_desvr] [module deq]
Info 2011-03-28 14:24:55.271355 1372300 1 Compare server exited normally, pid = 823382 [sp_desvr]
Cause

In this scenario the problem is with the temp tablespace. It was corrupted hence the compare couldn't read from it.
Résolution

Workaround:
Check the Temp tablespace and if there is corruption and datafiles cannot be read then the corruption needs to be fixed.

Commentaire envoyé

Cet article vous a-t-il à résoudre un problème ?

Sélectionner une évaluation

Contenu recommandé

Historique de l’article :: Créé le : 5/24/2011
Dernière mise à jour le : 5/7/2023

Titre