OraFAQ Forum: Data Guard » Finding Unapplied Archived log file in DR

Home » Server Options » Data Guard » Finding Unapplied Archived log file in DR (oracle version 10g Windows XP)

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

Finding Unapplied Archived log file in DR [message #523920]

Wed, 21 September 2011 02:23

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hello All,

Need a help.

I wanted to make a script for applying the Archived log File in to DR by certain interval.

1) I will use the below view for finding the SEQUENCE so far applied.

select sequence# from v$log_archive.

2) But how i can compare with the archive log files available in physical location with the above mentioned view.

eg:- the above view shows, the till the sequence 46789 is applied.
And in the DR physical Location available sequences are 46795. which means 6 more archived log files are more, which are not applied into the DR so far.

Regards:
Muktha

Report message to a moderator

Re: Finding Unapplied Archived log file in DR [message #523926 is a reply to message #523920]

Wed, 21 September 2011 02:49

John Watson
Messages: 8805
Registered: January 2010
Location: Global Village

Senior Member

orcl> select sequence# from v$log_archive;
select sequence# from v$log_archive
                      *
ERROR at line 1:
ORA-00942: table or view does not exist


orcl>

Report message to a moderator

Re: Finding Unapplied Archived log file in DR [message #523928 is a reply to message #523926]

Wed, 21 September 2011 03:02

Michel Cadot
Messages: 68421
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

select view_name from dba_views where view_name like 'V%ARCHIVE%' order by 1;

Regards
Michel

[Updated on: Wed, 21 September 2011 03:06]

Report message to a moderator

Re: Finding Unapplied Archived log file in DR [message #523994 is a reply to message #523928]

Wed, 21 September 2011 06:16

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi All,

Sorry for the mistake,

The view is v$log_history not v$log_archive;

Regards:
Muktha

Report message to a moderator

Re: Finding Unapplied Archived log file in DR [message #524010 is a reply to message #523994]

Wed, 21 September 2011 06:41

John Watson
Messages: 8805
Registered: January 2010
Location: Global Village

Senior Member

Muktha, there is no column APPLIED in v$log_history. Try again.

Report message to a moderator

Re: Finding Unapplied Archived log file in DR [message #524029 is a reply to message #524010]

Wed, 21 September 2011 07:36

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi John,

The column SEQUENCE# in the view V$LOG_HISTORY, list out the sequences which was applied. This view will not show the sequences which is presenting in the DR physical location unapplied.

Regards:
Muktha

Report message to a moderator

Re: Finding Unapplied Archived log file in DR [message #524038 is a reply to message #524029]

Wed, 21 September 2011 08:19

Michel Cadot
Messages: 68421
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

The answer is in one of the views returned by the query I posted.

Regards
Michel

Report message to a moderator

Re: Finding Unapplied Archived log file in DR [message #524112 is a reply to message #524038]

Wed, 21 September 2011 21:31

luc_tran
Messages: 31
Registered: October 2010
Location: Viet Nam

Member

Hi muktha,

I usually check this view v$archived_log, there are some useful fields like: sequence#, applied, name, first_time

Hope this help
Luc

Report message to a moderator

Previous Topic:	Data Guard Configuration for new server
Next Topic:	Copying Archived log file From Primary to DR

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Mar 31 16:29:06 CDT 2023