?
Solved

View Containing log seq # and log number

Posted on 2011-04-25
7
Medium Priority
?
286 Views
Last Modified: 2012-05-11
I have a log sequence number of 101461.  How do I determine the log file that contains that sequence# ?
0
Comment
Question by:xoxomos
  • 4
  • 3
7 Comments
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35461953
What is the value of LOG_ARCHIVE_FORMAT?

Sequence number is typically in there.

Anyway, check v$archived_log
0
 

Author Comment

by:xoxomos
ID: 35461994
------------------------------
log_archive_format                   string
%t_%s_%r.arc
SQL>
0
 

Author Comment

by:xoxomos
ID: 35462010
I've got the sequence#, what i need is basically the filename of the log.
0
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
LVL 78

Accepted Solution

by:
slightwv (䄆 Netminder) earned 2000 total points
ID: 35462032
my bad.  I guess v$archived_log doesn't have the name.

The '%s' in the log_archive_format is the sequence number.  Just go look in the folder for a file with that number in it?
0
 

Author Comment

by:xoxomos
ID: 35462095
Yeah, i think you're right although when I did a select trim(name) from v$archived_log where sequence#=
i did not get a filename.
0
 

Author Comment

by:xoxomos
ID: 35462110
Yeah, I must not have done what i thought I did.
Thanks,
0
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35462116
I've never used that view for anything.

From the docs:
V$ARCHIVED_LOG displays archived log information from the control file.

If should hold the correct values.  I'm not sure if you are using an RMAN catalog.


0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question