OraFAQ Forum: Data Guard » Confirm the Archive log applying

Home » Server Options » Data Guard » Confirm the Archive log applying (oracle version 10g Windows XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Confirm the Archive log applying [message #518632]

Fri, 05 August 2011 03:00

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

Michel Cadot
Messages: 68758
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Code: [Select all] [Show/ hide]

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 29 01:00:56 CDT 2025