RUN {SET UNTIL SEQUENCE 124 THREAD 1;}
RUN {SET UNTIL LOGSEQ 124 THREAD 1;}
SEQUENCE指的就是日志切换后的SEQUENCE,和LOGSEQ是一样的。
测试如下:
RMAN> list copy of archivelog from sequence 14681 until sequence 14682 thread 2 ;
List of Archived Log Copies
Key Thrd Seq S Low Time Name
------- ---- ------- - ------------------- ----
70712 2 14681 A 2010-06-24 11:19:27 /data/log/ORCL/archivelog/0002_0000014681_628034536.dbf
70718 2 14682 A 2010-06-24 11:45:38 /data/log/ORCL/archivelog/0002_0000014682_628034536.dbf
RMAN> list copy of archivelog from logseq 14681 until logseq 14682 thread 2 ;
List of Archived Log Copies
Key Thrd Seq S Low Time Name
------- ---- ------- - ------------------- ----
70712 2 14681 A 2010-06-24 11:19:27 /data/log/ORCL/archivelog/0002_0000014681_628034536.dbf
70718 2 14682 A 2010-06-24 11:45:38 /data/log/ORCL/archivelog/0002_0000014682_628034536.dbf
RMAN> list copy of archivelog from logseq 14681 until sequence 14682 thread 2 ;
List of Archived Log Copies
Key Thrd Seq S Low Time Name
------- ---- ------- - ------------------- ----
70712 2 14681 A 2010-06-24 11:19:27 /data/log/ORCL/archivelog/0002_0000014681_628034536.dbf
70718 2 14682 A 2010-06-24 11:45:38 /data/log/ORCL/archivelog/0002_0000014682_628034536.dbf
RMAN> list copy of archivelog from sequence 14681 until logseq 14682 thread 2 ;
List of Archived Log Copies
Key Thrd Seq S Low Time Name
------- ---- ------- - ------------------- ----
70712 2 14681 A 2010-06-24 11:19:27 /data/log/ORCL/archivelog/0002_0000014681_628034536.dbf
70718 2 14682 A 2010-06-24 11:45:38 /data/log/ORCL/archivelog/0002_0000014682_628034536.dbf