v$archived_log

最新推荐文章于 2025-03-20 17:06:00 发布

oracleerp

最新推荐文章于 2025-03-20 17:06:00 发布

阅读量564

点赞数

文章标签： sql

本文链接：https://blog.youkuaiyun.com/oracleerp/article/details/2743964

版权

SQL> col name format a42;

SQL> select name,first_change#,next_change# from v$archived_log where thread#=1;

NAME                                       FIRST_CHANGE# NEXT_CHANGE#
------------------------------------------ ------------- ------------
F:/ARC/ARCH1_13_654199347.ARC                    1675922      1740639
F:/ARC/ARCH1_14_654199347.ARC                    1740639      1766345
F:/ARC/ARCH1_15_654199347.ARC                    1766345      1786579
F:/ARC/ARCH1_16_654199347.ARC                    1786579      1810720
F:/ARC/ARCH1_17_654199347.ARC                    1810720      1842812
F:/ARC/ARCH1_18_654199347.ARC                    1842812      1863015
F:/ARC/ARCH1_19_654199347.ARC                    1863015      1893761
F:/ARC/ARCH1_20_654199347.ARC                    1893761      1931979
F:/ARC/ARCH1_21_654199347.ARC                    1931979      1974840
F:/ARC/ARCH1_22_654199347.ARC                    1974840      2019003

已选择10行。

（first_change#：对应于归档日志的起始SCN值，next_change#：对应于下一个归档日志的起始SCN值）