How to find log sequences used during the recovery

RMAN> restore database preview;

Starting restore at 2009-MAY-22 11:24:50

using channel ORA_DISK_1

List of Backup Sets

===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time     

------- ---- -- ---------- ----------- ------------ --------------------

1       Full    209.16M    DISK        00:01:50     2009-MAY-22 11:21:04

        BP Key: 1   Status: AVAILABLE  Compressed: YES  Tag: TAG20090522T111914

        Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/backupset/2009_05_22/o1_mf_nnndf_TAG20090522T111914_51d6fm3b_.bkp

  List of Datafiles in backup set 1

  File LV Type Ckp SCN    Ckp Time             Name

  ---- -- ---- ---------- -------------------- ----

  1       Full 1621673    2009-MAY-22 11:19:15 /u01/app/oracle/oradata/ORCL/system01.dbf

  2       Full 1621673    2009-MAY-22 11:19:15 /u01/app/oracle/oradata/ORCL/sysaux01.dbf

  3       Full 1621673    2009-MAY-22 11:19:15 /u01/app/oracle/oradata/ORCL/undotbs01.dbf

  4       Full 1621673    2009-MAY-22 11:19:15 /u01/app/oracle/oradata/ORCL/users01.dbf



List of Archived Log Copies for database with db_unique_name ORCL

=====================================================================



Key     Thrd Seq     S Low Time            

------- ---- ------- - --------------------

30      1    97      A 2009-MAY-22 11:11:24

        Name: /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2009_05_22/o1_mf_1_97_51d6kvcr_.arc

Media recovery start SCN is 1621093

Recovery must be done beyond SCN 1621673 to clear datafile fuzziness

Finished restore at 2009-MAY-22 11:24:51

RMAN> exit





Recovery Manager complete.

How to find log sequences used during the recovery

From above restore preview, we confirm that all redo logs generated from SCN 1621093 and 1621673 will be used.

SQL> select thread#,sequence# from v$archived_log

  2  where --cross begin backup only (sample SEQ# 90)

  3  (first_change#<=1621093 and next_change#>=1621093 and next_change#<=1621673)

  4  or    --within begin backup and end backup (sample SEQ# 91,92)

  5  (first_change#>=1621093 and next_change#<=1621673)

  6  or   --cross end backup only (sample SEQ# 93)

  7  (first_change#>=1621093 and first_change#<=1621673 and next_change#>=1621673)

  8  or   --cross begin backup and end backup (sample SEQ# 150)

  9  (first_change#<=1621093 and next_change#>=1621673)

 10  ;



   THREAD#  SEQUENCE#

---------- ----------

         1         97