Home » Server Options » Data Guard » redo logs not getting applied
redo logs not getting applied [message #255152] Mon, 30 July 2007 19:20 Go to next message
Koolwant
Messages: 49
Registered: June 2007
Location: new jersey
Member
Hi Guru's

I have 10.2.0.1 on two servers RHEL Enterprise 4 .

My redo logs are not being shipped .

select sequence#,applied from v$archived_log ; GIVES
no rows selected

When I see alert.log I get following errors
PING[ARC0]: Heartbeat failed to connect to standby 'OHIO1_204'. Error is 1031.
*** 2007-07-30 20:10:07.329 58941 kcrr.c
kcrrfail: dest:2 err:1031 force:0 blast:1
kcrrwkx: nothing to do (end)
*** 2007-07-30 20:11:07.334
Redo shipping client performing standby login
OCISessionBegin failed -1
.. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privil
eges
'
*** 2007-07-30 20:11:07.366 60679 kcrr.c
Error 1031 received logging on to the standby
Error 1031 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'OHIO1_204
'
Error 1031 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'OHIO1_204'
ORA-01031: insufficient privileges
*** 2007-07-30 20:11:07.366 60679 kcrr.c
PING[ARC0]: Heartbeat failed to connect to standby 'OHIO1_204'. Error is 1031.
*** 2007-07-30 20:11:07.366 58941 kcrr.c
kcrrfail: dest:2 err:1031 force:
Re: redo logs not getting applied [message #255378 is a reply to message #255152] Tue, 31 July 2007 10:50 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
My redo logs are not being shipped .


post querry result

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


Quote:
select sequence#,applied from v$archived_log ; GIVES
no rows selected

If logs are not shipping then how could you except applied?


Post The parameteres you set for DG configuration.

Enable dead connection detection on the primary and standby sites
sqlnet.expire_time=2
Re: redo logs not getting applied [message #255419 is a reply to message #255378] Tue, 31 July 2007 15:45 Go to previous messageGo to next message
Koolwant
Messages: 49
Registered: June 2007
Location: new jersey
Member
Hi DremzZ
Thanks For your reply.
I figured out the problem .
That error is due to the password file.
What my mistake was I spelled it wrong.
So my dataguard started working fine .
And I have checked Failover and switchover also.
NOW I have a question.
203-Primary ,204-Standby
Pulled power cable of 203.
alter the database on 204 to PRIMARY .And It works fine too.
The question is what happens if I put the power cable back into 203
.And My database on 203 comes up with init.d scripts.

Is it like 203 will also try to come up as Primary.
And would there be like two Primary's.
Or what should I do.

Thanks in Advance.

Re: redo logs not getting applied [message #255422 is a reply to message #255419] Tue, 31 July 2007 16:37 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
Is it like 203 will also try to come up as Primary.
And would there be like two Primary's.
Or what should I do.


If Both come Primary then what about ARCHIVELOGS 203 will generate copy on 204 and 204 on 203??
You have to choose one 1 as PRIMARY.

Regarding Role transition check these

http://www.scribd.com/doc/138955/Oracle-Database-10g-Data-Guard-Role

http://www.scribd.com/doc/138958/DATAGUARD-CONFIGURATION
Re: redo logs not getting applied [message #255424 is a reply to message #255422] Tue, 31 July 2007 16:57 Go to previous messageGo to next message
Koolwant
Messages: 49
Registered: June 2007
Location: new jersey
Member
Thanks for sending me the document link.

CAn we do that when 203 comes up ,we can switchover it to physical standby and then when it synchronizes with 204 , we again swithover it to same old configuration
as 203-Primary and 204-Standby

Is it possible or we have take backup of datafiles on 204 and apply it to 203 and then create standby controlfile for 204 and shutdown both 203 and 204 and then startup again as 203-Primary and 204-Standby

Thanks

Re: redo logs not getting applied [message #255429 is a reply to message #255424] Tue, 31 July 2007 18:02 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Must Syncrohnize.Other wise you have to apply incremental backup or archivelogs.
Re: redo logs not getting applied [message #255737 is a reply to message #255429] Wed, 01 August 2007 11:07 Go to previous messageGo to next message
Koolwant
Messages: 49
Registered: June 2007
Location: new jersey
Member
Hey DreamzZ

One more thing what should we do if the Original primary comes up.Do we have to shut it down till it synchronizes or it would be okay if we dont even shut it down.

Thanks
Re: redo logs not getting applied [message #255754 is a reply to message #255737] Wed, 01 August 2007 12:03 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Actually In DG enviroment when your Primary goes down your Standby starts works ,in the mean while you recover the primary database syncronize it with standby after that you put it back as a PRIMARY and your primary(standby) again goes to STANDBY.

Quote:

One more thing what should we do if the Original primary comes up.Do we have to shut it down till it synchronizes or it would be okay if we dont even shut it down


you can DEFER ARCHIVING at PRIMARY for a while no need of SHUTDOWN.

log_archive_dest_state_2=DEFER.
Re: redo logs not getting applied [message #255769 is a reply to message #255754] Wed, 01 August 2007 13:08 Go to previous messageGo to next message
Koolwant
Messages: 49
Registered: June 2007
Location: new jersey
Member
Thanks for your replies

Regards


Re: redo logs not getting applied [message #255770 is a reply to message #255769] Wed, 01 August 2007 13:34 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
You welcome.Wink
Previous Topic: Archive LOGS SHIPPED TO WRONG DESTINATION - FLASH
Next Topic: Different platforms & data types
Goto Forum:
  


Current Time: Wed Dec 07 07:12:12 CST 2016

Total time taken to generate the page: 0.13389 seconds