OraFAQ Forum: Data Guard » Redo logs not getting applied

Home » Server Options » Data Guard » Redo logs not getting applied - production issue,please advise

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

Redo logs not getting applied - production issue,please advise [message #267921]

Sun, 16 September 2007 08:21

riteshshah
Messages: 1
Registered: September 2007
Location: Texas

Junior Member

Hi,
The redo logs are not getting applied on the stand by database.

I tried this command:

alter database recover managed standby database disconnect;

It gave me

database altered

But still I am not seeing any difference in the log sequence number. Please help as the difference is around 1000 logfiles.

Regards,
Ritesh

Report message to a moderator

Re: Redo logs not getting applied - production issue,please advise [message #267940 is a reply to message #267921]

Sun, 16 September 2007 16:03

Frank Naude
Messages: 4590
Registered: April 1998

Senior Member

Have you checked the database's alter log file to see what's going on?

Report message to a moderator

Re: Redo logs not getting applied - production issue,please advise [message #268095 is a reply to message #267940]

Mon, 17 September 2007 09:02

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Did you copy the password file to standby?
post the result of query.

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

Report message to a moderator

Re: Redo logs not getting applied - production issue,please advise [message #274534 is a reply to message #267921]

Tue, 16 October 2007 06:14

ibrpearl
Messages: 2
Registered: October 2007
Location: MUMBAI

Junior Member

Check the tnsnames.ora file . tnsentry shoould be clear. check service_name
and alert.log file that actually what error it is giving.

Report message to a moderator

Re: Redo logs not getting applied - production issue,please advise [message #274551 is a reply to message #274534]

Tue, 16 October 2007 07:06

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Check post date and OP last connexion date.
It appears it only connected the day he posted the question, so your answer is useless.
Let the topic die.

Regards
Michel

Report message to a moderator

Previous Topic:	can't applied archive log????
Next Topic:	archives not applied at standby

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 00:35:51 CST 2025