| 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 ?
|
|
|
|
| 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
|
|
|
|
| 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
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
)