Sunday, April 1, 2012

Steps to resolve Error 1031 received logging on to the standby

Case Study.

    today, I would like to discuss about a typical issue faced on our environment.
One of our DataGuard environment was out of sync. Since the gap was too much time we decided to use the incremental recovery method and resolve the gap .

The issue faced

even though be resolved the gap, the subsequent redo transfer was not happening. When we checked in the
v$managed_process data dictionary view, we could see that RFS was not starting.

Analysis

The following observations were made.

  • The RFS process was not started in the standby which indicates that standby is not receiving any redo information from the primary.
  • In the primary alert log file we could see the errors indicating that the primary is not able to communicate with the standby instance. The error observed was "Error 1031 received logging on to the standby".
  • We tried to connect to the standby instance from primary by using the following command and it was successful.
sqlplus sys/oracle@tns.


  • the time stamp of the password file on the primary and the standby was different. This indicated the possibility of having the wrong password file in the standby.

solution


  • we copied the password file from the primary to the standby and renamed the password file in the following format  ie orapw<sid> . 
  • we restarted the media recovery process on the standby. 
Once the above steps are completed we could see that redo shipping and redo apply is taking place.

lessons learned.

For the redo transfer to take place efficiently, the password file on standby should be a copy from the primary and renamed standby.

For eg :  assume  our primary database password file is orapwdprim  and the standby instance is stand . In this case we should copy the password  file from primary and rename it to orapwdstand 

We can use v$pwd_file_users data dictionary view to check if the  password file is used

5 comments:

  1. Thanks. I don't know why they don't make this simple step more clear in the documentation. I had all kinds of different password files.

    ReplyDelete
  2. I also face this problem. after follow this blog I can solve it.
    Thanks
    Pitou

    ReplyDelete
  3. Recently face this issue and it hit the right solution. Thanks.

    ReplyDelete
  4. Actually I change the Primary site sys password almost 1 months ago , ADG sync has no issue, after that 2 months later when I restart synchronization process then face same issue, After follow your steps now everything all right,

    ReplyDelete
  5. Betway Casino Bonus Code is MAXBONUS | ᐈ 30 Free Spins
    Casino Review, Bonuses, FAQ & More! New worrione.com players welcome bonus $10 aprcasino no deposit bonus + 100% 1등 사이트 up to $1000 in Betway Casino 출장안마 Bonuses! https://vannienailor4166blog.blogspot.com/

    ReplyDelete