Sometimes we need to know date and redo log sequence from SCN
When we debug, we know SCN, then we need to know what archive logs and log sequence number
ie we have SCN 0x0b09.1c7947c0 . its hex
We converts it to decimal it is 12133760321472
use below sql to do it
SELECT thread#, name, sequence#, first_time, next_time
FROM gv$archived_log
WHERE 12133760321472
BETWEEN first_change# AND next_change#;