Oracle-归档日志

Command not found

于 2024-06-25 08:52:24 发布

阅读量109

点赞数 1

分类专栏： Oracle-文件相关文章标签： oracle 数据库

本文链接：https://blog.csdn.net/weixin_44904114/article/details/139945948

版权

Oracle-文件相关专栏收录该内容

15 篇文章 0 订阅

订阅专栏

Oracle-归档日志

1、基本概念

归档日志文件情况

set line 400 pagesize 500
col NAME for a100
select inst_id,
       recid,
       name,
       thread#,
       sequence#,
       to_char(first_time, 'yyyy/mm/dd hh24:mi:ss') first_time
  from gv$archived_log
 where name is not null
   and first_time between sysdate - 7 and sysdate
 order by inst_id, recid desc;

  INST_ID	RECID NAME												      		THREAD#  SEQUENCE# FIRST_TIME
---------- ---------- ---------------------------------------------------- 		---------- ---------- -------------------
	 1	    5 +ARCH/orcl/archivelog/2020_07_17/thread_3_seq_2.260.1045994639		3	       2 		2020/07/16 12:56:18
	 1	    4 +ARCH/orcl/archivelog/2020_07_16/thread_3_seq_1.259.1045918567		3	       1 		2020/07/16 12:56:01
	 2	    5 +ARCH/orcl/archivelog/2020_07_17/thread_3_seq_2.260.1045994639		3	       2 		2020/07/16 12:56:18
	 2	    4 +ARCH/orcl/archivelog/2020_07_16/thread_3_seq_1.259.1045918567		3	       1 		2020/07/16 12:56:01