4 Replies Latest reply: Jul 24, 2013 8:51 AM by mseberg RSS

    RMAN-06054 and right seq number

    User511360-OC

      Hello.

      I do a test disaster recovery restore using RMAN with full+incremental backups from another server.

      After a long (db is big) restoring process I got an error:

      RMAN-06054: media recovery requesting unknown log: thread 1 seq 3121 lowscn 125553200

      if I then add 'SET UNTIL sequence 125553200;' to restore script, all is OK.

      I would like to know, how to get the right sequence number before restore process ?

      When I do:

      LIST BACKUP OF ARCHIVELOG ALL;

      I got the following last line in the list:

        Thrd Seq     Low SCN    Low Time  Next SCN   Next Time

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

          1    3118    125499484  24-JUL-13 125504458  24-JUL-13

       

      So you see, there are 3 seqs missing (3121 minus 3118).