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
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/22664653/viewspace-666241/ ,如需转载,请注明出处,否则将追究法律责任。