OraFAQ Forum: Data Guard » Last Archived log's information.

Home » Server Options » Data Guard » Last Archived log's information. (oracle version 10g Windows XP)

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

Last Archived log's information. [message #518662]

Fri, 05 August 2011 06:33

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hello All,

Is there any way to find out the last archived file's:
A) sequence no
B) Date and time
C) As well as the log group name.

I have 4 Log group.

Regards:
Muktha

Report message to a moderator

Re: Last Archived log's information. [message #518665 is a reply to message #518662]

Fri, 05 August 2011 06:39

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

Senior Member
Account Moderator

A and B in the same view than the one I told you in your previous, don't you NEVER look at what we post?

C is irrelevant for Oracle so why should it record it? Why do you want to know this? What do you want to do with this information?

Regards
Michel

Report message to a moderator

Re: Last Archived log's information. [message #518674 is a reply to message #518665]

Fri, 05 August 2011 07:23

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi Michel,

The previous post shows the below code. In where i am not able to see the Date and Time of ONLY THE LAST ARCHIVED FILE.

select thread#, sequence#, applied
from v$archived_log

Kindly help me out?

Regards:
Muktha

Report message to a moderator

Re: Last Archived log's information. [message #518678 is a reply to message #518674]

Fri, 05 August 2011 07:42

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

Senior Member
Account Moderator

And you are unable to modify it to get ONLY THE LAST ARCHIVED FILE?
If so resign immediatly you are dangerous.

Regards
Michel

Report message to a moderator

Re: Last Archived log's information. [message #518909 is a reply to message #518678]

Mon, 08 August 2011 07:18

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi Michel,

Sorry for the previous query (I had lost myself, where i was writing).

Here is the answer for the my last query.

select a.thread#,a.group#,b.name,b.sequence#
from
v$log a,v$archived_log b
where a.sequence#=b.sequence#
and b.applied='NO'
order by b.sequence#

Thanks and Regards
Muktha

Report message to a moderator

Re: Last Archived log's information. [message #518910 is a reply to message #518909]

Mon, 08 August 2011 07:24

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

Senior Member
Account Moderator

Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.

Regards
Michel

Report message to a moderator

Previous Topic:	Confirm the Archive log applying
Next Topic:	switchover fails becoz of ORA-12514: TNS:listener does not currently

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 21:41:37 CST 2025