Friday, 31 March 2017

ORA 12514 Data guard is not in sync with primary

We had issue with the data guard is not in sync with Primary.
When I check the error from v$archive_dest I can see ORA-12514
cid:image001.png@01D2A7DC.C1CF55C0
But when doing tnsping to DR tns ,I works
cid:image002.png@01D2A7DC.C1CF55C0
Then while checking alert log the DG is picking the PROD host name after the TNS entry
cid:image003.png@01D2A7DC.C1CF55C0

Solution:
DR hostname was wrong,Updating the hostname then restarting the DR listener ,DR database and recovery.

No comments: