Home » Server Options » Data Guard » not updating APPLIED column in v$archived_log.
not updating APPLIED column in v$archived_log. [message #198510] Tue, 17 October 2006 07:45 Go to next message
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 ?
Re: not updating APPLIED column in v$archived_log. [message #198522 is a reply to message #198510] Tue, 17 October 2006 08:50 Go to previous messageGo to next message
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
Re: not updating APPLIED column in v$archived_log. [message #199032 is a reply to message #198510] Thu, 19 October 2006 15:11 Go to previous messageGo to next message
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
Re: not updating APPLIED column in v$archived_log. [message #199153 is a reply to message #198510] Fri, 20 October 2006 11:09 Go to previous messageGo to next message
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
Re: not updating APPLIED column in v$archived_log. [message #678063 is a reply to message #199153] Tue, 05 November 2019 10:07 Go to previous messageGo to next message
JoaoEvang
Messages: 1
Registered: November 2019
Junior Member
Restart primary and standby databases fix the problem in my environment.
Re: not updating APPLIED column in v$archived_log. [message #678064 is a reply to message #678063] Tue, 05 November 2019 12:30 Go to previous messageGo to next message
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"
Re: not updating APPLIED column in v$archived_log. [message #678068 is a reply to message #678063] Wed, 06 November 2019 01:45 Go to previous message
John Watson
Messages: 8922
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)
Previous Topic: RAC to RAC physical standby, why only one node to be applied?
Next Topic: Oracle dataguard limitations what is best
Goto Forum:
  


Current Time: Thu Mar 28 12:22:41 CDT 2024