Home » Server Options » Data Guard » Last Archived log's information. (oracle version 10g Windows XP)
Last Archived log's information. [message #518662] Fri, 05 August 2011 06:33 Go to next message
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
Re: Last Archived log's information. [message #518665 is a reply to message #518662] Fri, 05 August 2011 06:39 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Last Archived log's information. [message #518674 is a reply to message #518665] Fri, 05 August 2011 07:23 Go to previous messageGo to next message
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
Re: Last Archived log's information. [message #518678 is a reply to message #518674] Fri, 05 August 2011 07:42 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Last Archived log's information. [message #518909 is a reply to message #518678] Mon, 08 August 2011 07:18 Go to previous messageGo to next message
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
Re: Last Archived log's information. [message #518910 is a reply to message #518909] Mon, 08 August 2011 07:24 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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

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


Current Time: Fri Mar 29 01:18:07 CDT 2024