suse-1:~ # su - oracle
oracle@suse-1:~> sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Tue Dec 18 18:36:19 2018
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> set linesize 400
SQL> col member for a65
SQL> select * from v$log order by group#;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME CON_ID
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------- ------------ --------- ----------
1 1 97 209715200 512 1 YES INACTIVE 7379778 18-DEC-18 7383387 18-DEC-18 0
2 1 98 209715200 512 1 NO CURRENT 7383387 18-DEC-18 1.8447E+19 0
3 1 96 209715200 512 1 YES INACTIVE 7379737 18-DEC-18 7379778 18-DEC-18 0
SQL>
SQL> select * from v$logfile order by group#;
GROUP# STATUS TYPE MEMBER IS_ CON_ID
---------- ------- ------- ----------------------------------------------------------------- --- ----------
1 ONLINE /oradata/orcl/redo01.log NO 0
2 ONLINE /oradata/orcl/redo02.log NO 0
3 ONLINE /oradata/orcl/redo03.log NO 0
4 STANDBY /oradata/orcl/stdby_logfile_1.log NO 0
5 STANDBY /oradata/orcl/stdby_logfile_2.log NO 0
6 STANDBY /oradata/orcl/stdby_logfile_3.log NO 0
6 rows selected.
SQL>
SQL> set linesize 400
SQL> col name for a65
SQL> select name,thread#,sequence#,to_char(first_time,'yyyy-mm-dd hh24:mi:ss') "First",to_char(next_time,'yyyy-mm-dd hh24:mi:ss') "Next",applied from v$archived_log order by sequence#;
NAME THREAD# SEQUENCE# First Next APPLIED
----------------------------------------------------------------- ---------- ---------- ------------------- ------------------- ---------
/oradata/log_archive_dest_1/1_2_992771642.dbf 1 2 2018-11-21 10:05:10 2018-11-21 14:32:22 NO
/oradata/log_archive_dest_1/1_3_992771642.dbf 1 3 2018-11-21 14:32:22 2018-11-21 14:47:31 NO
/oradata/log_archive_dest_1/1_4_992771642.dbf 1 4 2018-11-21 14:47:31 2018-11-21 16:35:31 NO
/oradata/log_archive_dest_1/1_5_992771642.dbf 1 5 2018-11-21 16:35:31 2018-11-21 16:35:36 NO
/oradata/log_archive_dest_1/1_6_992771642.dbf 1 6 2018-11-21 16:35:36 2018-11-21 17:10:06 NO
orclstdby 1 6 2018-11-21 16:35:36 2018-11-21 17:10:06 YES
/oradata/log_archive_dest_1/1_7_992771642.dbf 1 7 2018-11-21 17:10:06 2018-11-21 17:11:44 NO
orclstdby 1 7 2018-11-21 17:10:06 2018-11-21 17:11:44 YES
/oradata/log_archive_dest_1/1_8_992771642.dbf 1 8 2018-11-21 17:11:44 2018-11-21 17:41:53 NO
orclstdby 1 8 2018-11-21 17:11:44 2018-11-21 17:41:53 YES
/oradata/log_archive_dest_1/1_9_992771642.dbf 1 9 2018-11-21 17:41:53 2018-11-21 17:41:59 NO
NAME THREAD# SEQUENCE# First Next APPLIED
----------------------------------------------------------------- ---------- ---------- ------------------- ------------------- ---------
orclstdby 1 9 2018-11-21 17:41:53 2018-11-21 17:41:59 YES
/oradata/log_archive_dest_1/1_10_992771642.dbf 1 10 2018-11-21 17:41:59 2018-11-21 17:42:03 NO
orclstdby 1 10 2018-11-21 17:41:59 2018-11-21 17:42:03 YES
/oradata/log_archive_dest_1/1_11_992771642.dbf 1 11 2018-11-21 17:42:03 2018-11-21 17:50:20 NO
orclstdby 1 11 2018-11-21 17:42:03 2018-11-21 17:50:20 YES
/oradata/log_archive_dest_1/1_12_992771642.dbf 1 12 2018-11-21 17:50:20 2018-11-21 17:56:24 NO
orclstdby 1 12 2018-11-21 17:50:20 2018-11-21 17:56:24 YES
/oradata/log_archive_dest_1/1_13_992771642.dbf 1 13 2018-11-21 17:56:24 2018-11-21 17:56:26 NO
orclstdby 1 13 2018-11-21 17:56:24 2018-11-21 17:56:26 YES
orclstdby 1 14 2018-11-21 17:56:26 2018-11-21 17:56:32 YES
/oradata/log_archive_dest_1/1_14_992771642.dbf 1 14 2018-11-21 17:56:26 2018-11-21 17:56:32 NO
NAME THREAD# SEQUENCE# First Next APPLIED
----------------------------------------------------------------- ---------- ---------- ------------------- ------------------- ---------
/oradata/log_archive_dest_1/1_15_992771642.dbf 1 15 2018-11-21 17:56:32 2018-11-21 17:56:34 NO
orclstdby 1 15 2018-11-21 17:56:32 2018-11-21 17:56:34 YES
/oradata/log_archive_dest_1/1_16_992771642.dbf 1 16 2018-11-21 17:56:34 2018-11-21 17:56:50 NO
orclstdby 1 16 2018-11-21 17:56:34 2018-11-21 17:56:50 YES
/oradata/log_archive_dest_1/1_17_992771642.dbf 1 17 2018-11-21 17:56:50 2018-11-21 17:56:51 NO
orclstdby 1 17 2018-11-21 17:56:50 2018-11-21 17:56:51 YES
/oradata/log_archive_dest_1/1_18_992771642.dbf 1 18 2018-11-21 17:56:51 2018-11-21 17:56:58 NO
orclstdby 1 18 2018-11-21 17:56:51 2018-11-21 17:56:58 YES
/oradata/log_archive_dest_1/1_19_992771642.dbf 1 19 2018-11-21 17:56:58 2018-11-21 17:56:59 NO
orclstdby 1 19 2018-11-21 17:56:58 2018-11-21 17:56:59 YES
orclstdby 1 20 2018-11-21 17:56:59 2018-11-21 17:57:06 YES
NAME THREAD# SEQUENCE# First Next APPLIED
----------------------------------------------------------------- ---------- ---------- ------------------- ------------------- ---------
/oradata/log_archive_dest_1/1_20_992771642.dbf 1 20 2018-11-21 17:56:59 2018-11-21 17:57:06 NO
orclstdby 1 21 2018-11-21 17:57:06 2018-11-21 17:57:09 YES
/oradata/log_archive_dest_1/1_21_992771642.dbf 1 21 2018-11-21 17:57:06 2018-11-21 17:57:09 NO
orclstdby 1 22 2018-11-21 17:57:09 2018-11-21 23:38:50 YES
/oradata/log_archive_dest_1/1_22_992771642.dbf 1 22 2018-11-21 17:57:09 2018-11-21 23:38:50 NO
orclstdby 1 23 2018-11-21 23:38:50 2018-11-22 22:00:37 YES
/oradata/log_archive_dest_1/1_23_992771642.dbf 1 23 2018-11-21 23:38:50 2018-11-22 22:00:37 NO
orclstdby 1 24 2018-11-22 22:00:37 2018-11-23 07:32:26 YES
/oradata/log_archive_dest_1/1_24_992771642.dbf 1 24 2018-11-22 22:00:37 2018-11-23 07:32:26 NO
orclstdby 1 25 2018-11-23 07:32:26 2018-11-24 00:48:01 YES
/oradata/log_archive_dest_1/1_25_992771642.dbf 1 25 2018-11-23 07:32:26 2018-11-24 00:48:01 NO
NAME THREAD# SEQUENCE# First Next APPLIED
----------------------------------------------------------------- ---------- ---------- ------------------- ------------------- ---------
orclstdby 1 26 2018-11-24 00:48:01 2018-11-24 10:00:37 YES
/oradata/log_archive_dest_1/1_26_992771642.dbf 1 26 2018-11-24 00:48:01 2018-11-24 10:00:37 NO
orclstdby 1 27 2018-11-24 10:00:37 2018-11-24 15:20:30 YES
/oradata/log_archive_dest_1/1_27_992771642.dbf 1 27 2018-11-24 10:00:37 2018-11-24 15:20:30 NO
orclstdby 1 28 2018-11-24 15:20:30 2018-11-24 22:00:58 YES
/oradata/log_archive_dest_1/1_28_992771642.dbf 1 28 2018-11-24 15:20:30 2018-11-24 22:00:58 NO
orclstdby 1 29 2018-11-24 22:00:58 2018-11-25 07:23:33 YES
/oradata/log_archive_dest_1/1_29_992771642.dbf 1 29 2018-11-24 22:00:58 2018-11-25 07:23:33 NO
orclstdby 1 30 2018-11-25 07:23:33 2018-11-25 13:04:44 YES
/oradata/log_archive_dest_1/1_30_992771642.dbf 1 30 2018-11-25 07:23:33 2018-11-25 13:04:44 NO
orclstdby 1 31 2018-11-25 13:04:44 2018-11-25 19:25:37 YES
NAME THREAD# SEQUENCE# First Next APPLIED
----------------------------------------------------------------- ---------- ---------- ------------------- ------------------- ---------
/oradata/log_archive_dest_1/1_31_992771642.dbf 1 31 2018-11-25 13:04:44 2018-11-25 19:25:37 NO
/oradata/log_archive_dest_1/1_32_992771642.dbf 1 32 2018-11-25 19:25:37 2018-11-26 01:06:30 NO
orclstdby 1 32 2018-11-25 19:25:37 2018-11-26 01:06:30 YES
/oradata/log_archive_dest_1/1_33_992771642.dbf 1 33 2018-11-26 01:06:30 2018-11-26 23:10:21 NO
orclstdby 1 33 2018-11-26 01:06:30 2018-11-26 23:10:21 YES
/oradata/log_archive_dest_1/1_34_992771642.dbf 1 34 2018-11-26 23:10:21 2018-11-27 18:05:50 NO
orclstdby 1 34 2018-11-26 23:10:21 2018-11-27 18:05:50 YES
/oradata/log_archive_dest_1/1_35_992771642.dbf 1 35 2018-11-27 18:05:50 2018-11-28 03:00:48 NO
orclstdby 1 35 2018-11-27 18:05:50 2018-11-28 03:00:48 YES
/oradata/log_archive_dest_1/1_36_992771642.dbf 1 36 2018-11-28 03:00:48 2018-11-28 23:15:46 NO
orclstdby 1 36 2018-11-28 03:00:48 2018-11-28 23:15:46 YES
NAME THREAD# SEQUENCE# First Next APPLIED
----------------------------------------------------------------- ---------- ---------- ------------------- ------------------- ---------
/oradata/log_archive_dest_1/1_37_992771642.dbf 1 37 2018-11-28 23:15:46 2018-11-29 12:04:22 NO
orclstdby 1 37 2018-11-28 23:15:46 2018-11-29 12:04:22 YES
/oradata/log_archive_dest_1/1_38_992771642.dbf 1 38 2018-11-29 12:04:22 2018-11-30 02:00:39 NO
orclstdby 1 38 2018-11-29 12:04:22 2018-11-30 02:00:39 YES
/oradata/log_archive_dest_1/1_39_992771642.dbf 1 39 2018-11-30 02:00:39 2018-11-30 22:02:00 NO
orclstdby 1 39 2018-11-30 02:00:39 2018-11-30 22:02:00 YES
/oradata/log_archive_dest_1/1_40_992771642.dbf 1 40 2018-11-30 22:02:00 2018-12-01 07:04:05 NO
orclstdby 1 40 2018-11-30 22:02:00 2018-12-01 07:04:05 YES
/oradata/log_archive_dest_1/1_41_992771642.dbf 1 41 2018-12-01 07:04:05 2018-12-01 10:04:25 NO
orclstdby 1 41 2018-12-01 07:04:05 2018-12-01 10:04:25 YES
/oradata/log_archive_dest_1/1_42_992771642.dbf 1 42 2018-12-01 10:04:25 2018-12-01 17:01:01 NO
NAME THREAD# SEQUENCE# First Next APPLIED
----------------------------------------------------------------- ---------- ---------- ------------------- ------------------- ---------
orclstdby 1 42 2018-12-01 10:04:25 2018-12-01 17:01:01 YES
/oradata/log_archive_dest_1/1_43_992771642.dbf 1 43 2018-12-01 17:01:01 2018-12-02 00:00:03 NO
orclstdby 1 43 2018-12-01 17:01:01 2018-12-02 00:00:03 YES
/oradata/log_archive_dest_1/1_44_992771642.dbf 1 44 2018-12-02 00:00:03 2018-12-02 08:10:24 NO
orclstdby 1 44 2018-12-02 00:00:03 2018-12-02 08:10:24 YES
/oradata/log_archive_dest_1/1_45_992771642.dbf 1 45 2018-12-02 08:10:24 2018-12-02 12:07:49 NO
/oradata/log_archive_dest_1/1_46_992771642.dbf 1 46 2018-12-02 12:07:49 2018-12-02 18:08:45 NO
/oradata/log_archive_dest_1/1_47_992771642.dbf 1 47 2018-12-02 18:08:45 2018-12-03 01:43:45 NO
/oradata/log_archive_dest_1/1_48_992771642.dbf 1 48 2018-12-03 01:43:45 2018-12-03 22:01:17 NO
/oradata/log_archive_dest_1/1_49_992771642.dbf 1 49 2018-12-03 22:01:17 2018-12-04 08:12:01 NO
/oradata/log_archive_dest_1/1_50_992771642.dbf 1 50 2018-12-04 08:12:01 2018-12-04 23:22:23 NO
NAME THREAD# SEQUENCE# First Next APPLIED
----------------------------------------------------------------- ---------- ---------- ------------------- ------------------- ---------
/oradata/log_archive_dest_1/1_51_992771642.dbf 1 51 2018-12-04 23:22:23 2018-12-05 16:54:27 NO
/oradata/log_archive_dest_1/1_52_992771642.dbf 1 52 2018-12-05 16:54:27 2018-12-06 04:00:15 NO
/oradata/log_archive_dest_1/1_53_992771642.dbf 1 53 2018-12-06 04:00:15 2018-12-06 22:01:19 NO
/oradata/log_archive_dest_1/1_54_992771642.dbf 1 54 2018-12-06 22:01:19 2018-12-07 09:00:34 NO
/oradata/log_archive_dest_1/1_55_992771642.dbf 1 55 2018-12-07 09:00:34 2018-12-08 00:01:02 NO
/oradata/log_archive_dest_1/1_56_992771642.dbf 1 56 2018-12-08 00:01:02 2018-12-08 08:24:10 NO
/oradata/log_archive_dest_1/1_57_992771642.dbf 1 57 2018-12-08 08:24:10 2018-12-08 13:13:10 NO
/oradata/log_archive_dest_1/1_58_992771642.dbf 1 58 2018-12-08 13:13:10 2018-12-08 20:00:40 NO
/oradata/log_archive_dest_1/1_59_992771642.dbf 1 59 2018-12-08 20:00:40 2018-12-09 05:47:19 NO
/oradata/log_archive_dest_1/1_60_992771642.dbf 1 60 2018-12-09 05:47:19 2018-12-09 08:34:31 NO
/oradata/log_archive_dest_1/1_61_992771642.dbf 1 61 2018-12-09 08:34:31 2018-12-09 15:06:33 NO
NAME THREAD# SEQUENCE# First Next APPLIED
----------------------------------------------------------------- ---------- ---------- ------------------- ------------------- ---------
/oradata/log_archive_dest_1/1_62_992771642.dbf 1 62 2018-12-09 15:06:33 2018-12-09 22:07:29 NO
/oradata/log_archive_dest_1/1_63_992771642.dbf 1 63 2018-12-09 22:07:29 2018-12-10 11:00:35 NO
/oradata/log_archive_dest_1/1_64_992771642.dbf 1 64 2018-12-10 11:00:35 2018-12-10 22:38:20 NO
/oradata/log_archive_dest_1/1_65_992771642.dbf 1 65 2018-12-10 22:38:20 2018-12-11 13:21:00 NO
/oradata/log_archive_dest_1/1_66_992771642.dbf 1 66 2018-12-11 13:21:00 2018-12-12 01:20:41 NO
/oradata/log_archive_dest_1/1_67_992771642.dbf 1 67 2018-12-12 01:20:41 2018-12-12 22:01:35 NO
/oradata/log_archive_dest_1/1_68_992771642.dbf 1 68 2018-12-12 22:01:35 2018-12-13 11:00:43 NO
/oradata/log_archive_dest_1/1_69_992771642.dbf 1 69 2018-12-13 11:00:43 2018-12-13 17:22:00 NO
orclstdby 1 69 2018-12-13 11:00:43 2018-12-13 17:22:00 NO
/oradata/log_archive_dest_1/1_70_992771642.dbf 1 70 2018-12-13 17:22:00 2018-12-13 17:32:57 NO
orclstdby 1 70 2018-12-13 17:22:00 2018-12-13 17:32:57 NO
NAME THREAD# SEQUENCE# First Next APPLIED
----------------------------------------------------------------- ---------- ---------- ------------------- ------------------- ---------
/oradata/log_archive_dest_1/1_71_992771642.dbf 1 71 2018-12-13 17:32:57 2018-12-13 17:33:04 NO
/oradata/log_archive_dest_1/1_72_992771642.dbf 1 72 2018-12-13 17:33:04 2018-12-13 17:33:06 NO
/oradata/log_archive_dest_1/1_73_992771642.dbf 1 73 2018-12-13 17:33:06 2018-12-13 17:33:08 NO
/oradata/log_archive_dest_1/1_74_992771642.dbf 1 74 2018-12-13 17:33:08 2018-12-13 17:33:36 NO
/oradata/log_archive_dest_1/1_75_992771642.dbf 1 75 2018-12-13 17:33:36 2018-12-13 17:33:38 NO
/oradata/log_archive_dest_1/1_76_992771642.dbf 1 76 2018-12-13 17:33:38 2018-12-13 17:33:39 NO
/oradata/log_archive_dest_1/1_77_992771642.dbf 1 77 2018-12-13 17:33:39 2018-12-13 17:33:40 NO
/oradata/log_archive_dest_1/1_78_992771642.dbf 1 78 2018-12-13 17:33:40 2018-12-13 17:33:41 NO
/oradata/log_archive_dest_1/1_79_992771642.dbf 1 79 2018-12-13 17:33:41 2018-12-13 17:33:41 NO
/oradata/log_archive_dest_1/1_80_992771642.dbf 1 80 2018-12-13 17:33:41 2018-12-13 17:33:42 NO
/oradata/log_archive_dest_1/1_81_992771642.dbf 1 81 2018-12-13 17:33:42 2018-12-13 23:02:59 NO
NAME THREAD# SEQUENCE# First Next APPLIED
----------------------------------------------------------------- ---------- ---------- ------------------- ------------------- ---------
/oradata/log_archive_dest_1/1_82_992771642.dbf 1 82 2018-12-13 23:02:59 2018-12-14 13:00:12 NO
/oradata/log_archive_dest_1/1_83_992771642.dbf 1 83 2018-12-14 13:00:12 2018-12-14 23:05:45 NO
/oradata/log_archive_dest_1/1_84_992771642.dbf 1 84 2018-12-14 23:05:45 2018-12-15 08:00:31 NO
/oradata/log_archive_dest_1/1_85_992771642.dbf 1 85 2018-12-15 08:00:31 2018-12-15 13:57:25 NO
/oradata/log_archive_dest_1/1_86_992771642.dbf 1 86 2018-12-15 13:57:25 2018-12-15 19:58:05 NO
/oradata/log_archive_dest_1/1_87_992771642.dbf 1 87 2018-12-15 19:58:05 2018-12-15 22:28:50 NO
/oradata/log_archive_dest_1/1_88_992771642.dbf 1 88 2018-12-15 22:28:50 2018-12-16 07:49:36 NO
/oradata/log_archive_dest_1/1_89_992771642.dbf 1 89 2018-12-16 07:49:36 2018-12-16 14:10:36 NO
/oradata/log_archive_dest_1/1_90_992771642.dbf 1 90 2018-12-16 14:10:36 2018-12-16 20:01:19 NO
/oradata/log_archive_dest_1/1_91_992771642.dbf 1 91 2018-12-16 20:01:19 2018-12-16 23:01:44 NO
/oradata/log_archive_dest_1/1_92_992771642.dbf 1 92 2018-12-16 23:01:44 2018-12-17 20:46:05 NO
NAME THREAD# SEQUENCE# First Next APPLIED
----------------------------------------------------------------- ---------- ---------- ------------------- ------------------- ---------
/oradata/log_archive_dest_1/1_93_992771642.dbf 1 93 2018-12-17 20:46:05 2018-12-17 23:34:35 NO
/oradata/log_archive_dest_1/1_94_992771642.dbf 1 94 2018-12-17 23:34:35 2018-12-18 17:10:47 NO
/oradata/log_archive_dest_1/1_95_992771642.dbf 1 95 2018-12-18 17:10:47 2018-12-18 17:11:10 NO
/oradata/log_archive_dest_1/1_96_992771642.dbf 1 96 2018-12-18 17:11:10 2018-12-18 17:11:30 NO
/oradata/log_archive_dest_1/1_97_992771642.dbf 1 97 2018-12-18 17:11:30 2018-12-18 17:38:20 NO
137 rows selected.
SQL>