查询ORACLE数据文件最近备份时间及SCN的SQL语句

最新推荐文章于 2021-12-29 08:58:20 发布

allway2

最新推荐文章于 2021-12-29 08:58:20 发布

阅读量1.8k

点赞数

本文链接：https://blog.csdn.net/allway2/article/details/95654624

版权

SELECT
   df.file# ,
   df.name ,
   MAX(bd.COMPLETION_TIME) COMPLETION_TIME ,
   MAX(bd.CHECKPOINT_CHANGE#) MAX_SCN
FROM
   v$backup_datafile bd
RIGHT JOIN v$datafile_header dh ON
   dh.file# = bd.file#
RIGHT JOIN v$datafile df ON
   dh.file# = df.file#
WHERE
   dh.status = 'ONLINE'
GROUP BY
   df.file#,
   df.name
ORDER BY
   COMPLETION_TIME ;

FILE#	NAME	COMPLETION_TIME	MAX_SCN
6	/data/oracle/oradata/orcl/test02.dbf	2019-07-12 19:42:21	1,178,845
3	/data/oracle/oradata/orcl/undotbs01.dbf	2019-07-12 19:42:21	1,178,845
5	/data/oracle/oradata/orcl/test01.dbf	2019-07-12 19:42:21	1,178,845
4	/data/oracle/oradata/orcl/users01.dbf	2019-07-12 19:42:21	1,178,845
1	/data/oracle/oradata/orcl/system01.dbf	2019-07-12 19:42:21	1,178,845
2	/data/oracle/oradata/orcl/sysaux01.dbf	2019-07-12 19:42:21	1,178,845
7	/data/oracle/oradata/orcl/test03.dbf