OraFAQ Forum: Data Guard

Home » Server Options » Data Guard » Config issue

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Config issue [message #271896]

Wed, 03 October 2007 05:31

hexmanju
Messages: 78
Registered: September 2005
Location: MUMBAI

Member

Hi
I am trying to configure Physical Standby Database.When i see the Alert Log of Primary Database i get an error as follows:-

PING[ARC1]: Heartbeat failed to connect to standby 'standby'. Error is 12528.
Wed Oct 03 15:44:59 2007
Thread 1 cannot allocate new log, sequence 6
Private strand flush not complete
Current log# 1 seq# 5 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\PRIMARY\REDO01.LOG
Thread 1 advanced to log sequence 6
Current log# 2 seq# 6 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\PRIMARY\REDO02.LOG
Wed Oct 03 15:46:40 2007
Shutting down archive processes
Wed Oct 03 15:46:45 2007
ARCH shutting down
ARC2: Archival stopped
Wed Oct 03 15:46:46 2007
Error 1031 received logging on to the standby
Wed Oct 03 15:46:46 2007
Errors in file e:\oracle\product\10.2.0\admin\primary\bdump\primary_arc1_5236.trc:
ORA-01031: insufficient privileges

PING[ARC1]: Heartbeat failed to connect to standby 'standby'. Error is 1031.
Wed Oct 03 15:49:08 2007
Thread 1 cannot allocate new log, sequence 7
Private strand flush not complete
Current log# 2 seq# 6 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\PRIMARY\REDO02.LOG
Thread 1 advanced to log sequence 7
Current log# 3 seq# 7 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\PRIMARY\REDO03.LOG
Wed Oct 03 15:50:39 2007
Thread 1 cannot allocate new log, sequence 8
Private strand flush not complete
Current log# 3 seq# 7 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\PRIMARY\REDO03.LOG
Thread 1 advanced to log sequence 8
Current log# 1 seq# 8 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\PRIMARY\REDO01.LOG
Wed Oct 03 15:51:47 2007
Error 1031 received logging on to the standby
Wed Oct 03 15:51:47 2007
Errors in file e:\oracle\product\10.2.0\admin\primary\bdump\primary_arc1_5236.trc:
ORA-01031: insufficient privileges

Kindly help me asap

Thanks
MM

Report message to a moderator

Re: Config issue [message #272003 is a reply to message #271896]

Wed, 03 October 2007 11:09

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Post oracle version and result of this query from PRIMARY

SQL>  Select Status, Error
  2  from v$Archive_dest
  3  where dest_id=2;

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


SQL> select sequence#,applied from v$archived_log;

 SEQUENCE# APP
---------- ---
       318 YES
       319 YES
       320 YES
       321 YES

Report message to a moderator

Re: Config issue [message #272132 is a reply to message #272003]

Thu, 04 October 2007 01:57

NandKumar
Messages: 92
Registered: June 2007
Location: v$hyderabad

Member

Seems like a password file issue. Recreate the password file at the standby...giving the same password as the primary database.

Report message to a moderator

Re: Config issue [message #272283 is a reply to message #272132]

Thu, 04 October 2007 07:43

hexmanju
Messages: 78
Registered: September 2005
Location: MUMBAI

Member

Thanks Nand Kumar.You were right.It was a password file issue.I amde the password same in both primary and standby.

But just tell me copying the same password file as primary would also resolve the issue,right?

Thanks anyways

MM

Report message to a moderator

Re: Config issue [message #272299 is a reply to message #272283]

Thu, 04 October 2007 08:29

NandKumar
Messages: 92
Registered: June 2007
Location: v$hyderabad

Member

Yes it might have worked.

Report message to a moderator

Previous Topic:	dataguard broker issue
Next Topic:	can't applied archive log????

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 16:50:40 CST 2025