Home » Server Options » Data Guard » Confirm the Archive log applying (oracle version 10g Windows XP)
Confirm the Archive log applying [message #518632] Fri, 05 August 2011 03:00 Go to next message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
Hello All,

I need a clarification on the below query.

I am having a Dataguard setup as Logical.

I am copying all the archive log files generated in the live server into the local server in order to apply into the Data Guard.

I am running a script for this process.

Question:
---------
How i can verify whether particular archive log file was applied into the data guard or not.

Regards:
Muktha

Report message to a moderator

Re: Confirm the Archive log applying [message #518641 is a reply to message #518632] Fri, 05 August 2011 03:27 Go to previous message
Michel Cadot
Messages: 68501
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
 
select thread#, sequence#, applied
from v$archived_log 
/

Regards
Michel

Report message to a moderator

Previous Topic: Data Gaurd
Next Topic: Last Archived log's information.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Sep 25 04:06:00 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.