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 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
Previous Topic: ORA-01156: recovery in progress may need access to files
Next Topic: Heartbeat failed to connect to standby 'DG2'. Error is 1031
Goto Forum:
  


Current Time: Thu Dec 08 02:03:39 CST 2016

Total time taken to generate the page: 0.16062 seconds