通过如下的测试，发现 X$KCCAL 存储的就是 archive log 的信息。
SQL> SELECT alnam FROM x$kccal WHERE alnam IS NOT NULL; no rows selected SQL> SQL> alter system switch logfile; System altered. SQL> SELECT alnam FROM x$kccal WHERE alnam IS NOT NULL; ALNAM -------------------------------------------------------------------------------- /refresh/home/app/12.2.0.1/oracle/product/12.2.0.1/dbhome3/dbs/arch1_6_952836426 .dbf SQL>
原文：https://www.cnblogs.com/gaojian/p/14632566.html