Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> apply status in standby server is in-memory
alireza.mmm
post May 3 2017, 10:07 AM
Post #1


Member
**

Group: Members
Posts: 10
Joined: 16-April 17
Member No.: 51,910



hi every body
please help me to undrestand this issue.

i run this query in Standby server (oracle 11g and maximum availability)


SQL> select max(sequence#),applied from v$archived_log group by applied;

MAX(SEQUENCE#) APPLIED
-------------- ---------
20 YES
21 IN-MEMORY

this query always show applied column 'in-memory' for last archivelog that transfer to standby server . why ? and What should I do to change status of applied column from 'in-memory' to 'YES' for last archivelog transfer to standby.
this issue always exist for last archive log that transfered to standby server.

thanks
Go to the top of the page
 
+Quote Post
burleson
post May 3 2017, 02:17 PM
Post #2


Advanced Member
***

Group: Members
Posts: 13,476
Joined: 26-January 04
Member No.: 13



Hi Alireza,

>> What should I do to change status of applied column from 'in-memory' to 'YES' for last archivelog transfer to standby.

I'm not sure, but I have these notes:

http://www.dba-oracle.com/t_v$_archived_log_group.htm




--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 25th July 2017 - 07:45 AM