OraFAQ Forum: Data Guard » not updating APPLIED column in v$archived

Home » Server Options » Data Guard » not updating APPLIED column in v$archived_log.

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

not updating APPLIED column in v$archived_log. [message #198510]

Tue, 17 October 2006 07:45

tridentadm
Messages: 142
Registered: March 2006

Senior Member

I observed that the APPLIED column showed NO (on primary for standby dest) even when the log file has been applied to the standby site. any idea, what the process might be ??

eg.

seq 35 APPLIED YES
seq 36 APPLIED NO
seq 37 APPLIED NO
seq 38 APPLIED YES

how can this be ?

Report message to a moderator

Re: not updating APPLIED column in v$archived_log. [message #198522 is a reply to message #198510]

Tue, 17 October 2006 08:50

email.sandeepnaik
Messages: 121
Registered: August 2006

Senior Member

I think if you transport log by yourself on standby and then restart recovery process on standby and after that, if logs which are transported gets applied on standby then for those files, column will remain APPLIED=NO. However, if log files are transported automatically and hence applied thereafter APPLIED=YES gets populated.

Sandeep

Report message to a moderator

Re: not updating APPLIED column in v$archived_log. [message #199032 is a reply to message #198510]

Thu, 19 October 2006 15:11

ja62
Messages: 4
Registered: August 2006

Junior Member

If you transport and apply log by yourself on standby the APPLIED column showed NO.
When you transport log on standby, you must do :

alter database register physical logfile 'path of log';

Then, when you restart the recover, the logs are applyed and the APPLIED column showed YES.

J�r�me

Report message to a moderator

Re: not updating APPLIED column in v$archived_log. [message #199153 is a reply to message #198510]

Fri, 20 October 2006 11:09

email.sandeepnaik
Messages: 121
Registered: August 2006

Senior Member

J�r�me,

As per my experience,
even after doing alter database register logfile 'log file path/name';
and then restarting automatic recovery on standby database, it will still not register APPLIED=YES.

Sandeep

Report message to a moderator

Re: not updating APPLIED column in v$archived_log. [message #678063 is a reply to message #199153]

Tue, 05 November 2019 10:07

JoaoEvang
Messages: 1
Registered: November 2019

Junior Member

Restart primary and standby databases fix the problem in my environment.

Report message to a moderator

Re: not updating APPLIED column in v$archived_log. [message #678064 is a reply to message #678063]

Tue, 05 November 2019 12:30

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

JoaoEvang wrote on Tue, 05 November 2019 08:07

Restart primary and standby databases fix the problem in my environment.

After 13 years I doubt OP cares about this "solution"

Report message to a moderator

Re: not updating APPLIED column in v$archived_log. [message #678068 is a reply to message #678063]

Wed, 06 November 2019 01:45

John Watson
Messages: 8976
Registered: January 2010
Location: Global Village

Senior Member

Welcome to the forum. Please read the OraFAQ Forum Guide and How to use code tags and make your code easier to read

Always nice to see a new person posting an answer, not a question (even if it is probably a bit too late in this case Smile

)

Report message to a moderator

Previous Topic:	RAC to RAC physical standby, why only one node to be applied?
Next Topic:	Oracle dataguard limitations what is best

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 01 12:57:41 CDT 2025