<<Back to Oracle Backup & Recovery Main Page
Finding Archivelog Names and Sequence Number using the SCN
There are many situations when we have the time or scn and you want to know the archivelog sequence number or archivelog name to proceed further. For example I had a situation today when there was some data deleted from an important table. We know the timestamp when this happened and we decided to mine the archivelogs generated at this timestamp using log miner. I tried to find the database SCN for the timestamp How to Find SCN from Timestamp and Vice Versa in Oracle and used query below to find the archivelogs generated at this timestamp and are good candidate to mine.SQL>set pages 100 lines 100
SQL> col name for a70
SQL>col first_change# for 9999999999
SQL>col next_change# for 9999999999
SQL>alter session set nls_date_format='DD-MON-RRRR HH24:MI:SS';
SQL>select name, thread#, sequence#, status, first_time, next_time, first_change#, next_change# from v$archived_log
where 456922382062 between first_change# and next_change#;
NOTE: The status column show you whether the archive is present of deleted from the disk.D= Deleted and A=Available
Do you have a spam issue on this site; I also am a blogger, and I was curious about your situation; we have created some nice procedures and we are looking to swap solutions with other folks, why not shoot me an email if interested.
ReplyDeletestorage container for sale
Thanks for sharing the article with us!
ReplyDeleteBest stock broker in India
Thanks for sharing such a useful blog.
ReplyDeleteCarbonite
SD-WAN LANCOM
Logiciel de sauvegarde pas cher
When I originally commented I clicked the -Notify me when new comments are added- checkbox and now each time a comment is added I get 4 emails with the identical comment. Is there any means you can take away me from that service? Thanks! shipping container dimensions
ReplyDeletethanks for sharing
ReplyDeletehave nice day
Epson Perfection V850 Pro Driver