Home » Server Options » Data Guard » Finding Unapplied Archived log file in DR (oracle version 10g Windows XP)
Finding Unapplied Archived log file in DR [message #523920] Wed, 21 September 2011 02:23 Go to next message
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
Re: Finding Unapplied Archived log file in DR [message #523926 is a reply to message #523920] Wed, 21 September 2011 02:49 Go to previous messageGo to next message
John Watson
Messages: 8922
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>


Sad
Re: Finding Unapplied Archived log file in DR [message #523928 is a reply to message #523926] Wed, 21 September 2011 03:02 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
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;


Smile

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 Go to previous messageGo to next message
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
Re: Finding Unapplied Archived log file in DR [message #524010 is a reply to message #523994] Wed, 21 September 2011 06:41 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Muktha, there is no column APPLIED in v$log_history. Try again.
Re: Finding Unapplied Archived log file in DR [message #524029 is a reply to message #524010] Wed, 21 September 2011 07:36 Go to previous messageGo to next message
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
Re: Finding Unapplied Archived log file in DR [message #524038 is a reply to message #524029] Wed, 21 September 2011 08:19 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
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
Re: Finding Unapplied Archived log file in DR [message #524112 is a reply to message #524038] Wed, 21 September 2011 21:31 Go to previous message
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
Previous Topic: Data Guard Configuration for new server
Next Topic: Copying Archived log file From Primary to DR
Goto Forum:
  


Current Time: Thu Mar 28 06:44:10 CDT 2024