RMAN run命令塊中的logseq與sequence的區別

 

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