Thursday, March 1, 2012

PING[ARC1]: Heartbeat failed to connect to standby 'hcmsstby'

 This problem arises when standby server not getting archive logs from standby server. Here is the solution to fix this problem.

step1:- connect(go) to standby server log in as a system account.
step2:- then type the below command
SQL>recover standby database;
after executing this command it gives three options to recover file from main server. the options listed in below statement.
Specify log: {=suggested | filename | AUTO | CANCEL}
then specify which option is familiar to you. If you specified AUTO then automatically that statement only gives which log is needed for recovery then copy that log from main server then paste it in standby server. Then after that run the above commmand
SQL>recover standby database;
if their is no log is missing then standby server updates logs then logs will come automatically from main server to standby server. Then put standby server in managed mode. In this mode standby server automatically updates and logs will comes from main server. the command is listed below.
setp3:-SQL>recover managed standby database;
if you want to check the logs are updated in standby server then cancel this command using the below command.
step4:-SQL>recover managed standby database cancel;
then run that step2 command. then you will get log missing error message then cross check that archive log number in main server if that archive log is not exists in main server then you are standby server updated up to that  archive log. Then put your standby database is in managed mode using step3 command.



















No comments:

Post a Comment