ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-1031 for Remote Archive Destination on Primary [ID 733793.1]

ORA-1031 for Remote Archive Destination on Primary [ID 733793.1]

原创 Linux操作系统 作者:尛样儿 时间:2012-06-13 04:07:46 0 删除 编辑
ORA-1031 for Remote Archive Destination on Primary [ID 733793.1]

 修改时间 15-FEB-2012     类型 PROBLEM     状态 PUBLISHED 

In this Document
  Symptoms
  Cause
  Solution


Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.2.0.3 - Release: 10.1 to 11.2
Information in this document applies to any platform.
***Checked for relevance on 22-Aug-2011***

Symptoms

ORA-1031 for remote archive destination on primary

alert.log
===== 
ORA-01031: insufficient privileges 
PING[ARC1]: Heartbeat failed to connect to standby 'mmsp_stby'. Error is 1031. 

Cause

Password file is missing in standby database

OR

Password file mismatch between primary and standby site. 

OR

Format of name of password file on standby is different than primary. 

Solution

1. Make sure parameter REMOTE_LOGIN_PASSWORDFILE is set to EXCLUSIVE or SHARED in both databases. 

2. Copy the password file again from primary : 

a. Defer the log_archive_dest_2 on primary: 

SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2 = DEFER; 

b. Copy/ftp the password file from primary to standby and rename it accordingly on the standby database. Creating the password file on standby with orapwd-utility is not supported for 11g anymore.
Make sure that name of password file on both primary and standby is : orapw. Name of the password file is case sensitive. If SID of database on standby is prod then name of the password file should be orapwprod, orapwPROD will not work. 

c. Enable the log_archive_dest_2 on primary: 

SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2 = ENABLE;

d. Switch 2-3 log files on primary : 

SQL> ALTER SYSTEM SWITCH LOGFILE;

e. Check the status of log_archive_dest_2 on primary. 

SQL> SELECT STATUS,ERROR FROM V$ARCHIVE_DEST WHERE DEST_ID =2; 

STATUS    ERROR 
--------- ----------------------------------------------------------------- 
VALID

Note: In this note log_archive_dest_2 is used for remote archive destination. 


来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/23135684/viewspace-732623/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
Oracle数据库管理员,Oracle数据库系统构架员;2012年7月出版《构建最高可用Oracle数据库系统:Oracle 11gR2 RAC管理、维护与性能优化》一书;Oracle 10g OCM。

注册时间:2010-01-05

  • 博文量
    483
  • 访问量
    5240705