Last login: Fri Jan 25 00:37:47 2019 from oracle [root@oracle ~]# su - oracle [oracle@oracle ~]$ sqlplus / as sysdba; SQL*Plus: Release 12.1.0.2.0 Production on Fri Jan 25 00:47:07 2019 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options SQL> select value from v$diag_info; VALUE -------------------------------------------------------------------------------- TRUE /u01/app/oracle /u01/app/oracle/diag/rdbms/orcl/orcl /u01/app/oracle/diag/rdbms/orcl/orcl/trace /u01/app/oracle/diag/rdbms/orcl/orcl/alert /u01/app/oracle/diag/rdbms/orcl/orcl/incident /u01/app/oracle/diag/rdbms/orcl/orcl/cdump /u01/app/oracle/diag/rdbms/orcl/orcl/hm /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_17796.trc 2 2 11 rows selected. SQL> exit Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options [oracle@oracle ~]$ cd /u01/app/oracle/diag/rdbms/orcl/orcl/trace/ [oracle@oracle trace]$ tail -20f alert_orcl.log TABLE SYS.WRP$_REPORTS_TIME_BANDS: ADDED INTERVAL PARTITION SYS_P820 (3311) VALUES LESS THAN (TO_DATE(' 2019-01-25 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) Fri Jan 25 00:11:25 2019 alter database add logfile group 4 ('/u01/app/oracle/oradata/orcl/redo04_1.log','/u01/app/oracle/oradata/orcl/redo04_2.log') size 50m Completed: alter database add logfile group 4 ('/u01/app/oracle/oradata/orcl/redo04_1.log','/u01/app/oracle/oradata/orcl/redo04_2.log') size 50m Fri Jan 25 00:22:53 2019 Thread 1 advanced to log sequence 136 (LGWR switch) Current log# 4 seq# 136 mem# 0: /u01/app/oracle/oradata/orcl/redo04_1.log Current log# 4 seq# 136 mem# 1: /u01/app/oracle/oradata/orcl/redo04_2.log Fri Jan 25 00:23:19 2019 Thread 1 advanced to log sequence 137 (LGWR switch) Current log# 1 seq# 137 mem# 0: /u01/app/oracle/oradata/orcl/redo01.log alter database add logfile member '/u01/app/oracle/oradata/orcl/redo02_1.log' to group 2 Completed: alter database add logfile member '/u01/app/oracle/oradata/orcl/redo02_1.log' to group 2 Fri Jan 25 00:33:07 2019 alter database add logfile member '/u01/app/oracle/oradata/orcl/redo01_1.log' to group 1 Completed: alter database add logfile member '/u01/app/oracle/oradata/orcl/redo01_1.log' to group 1 Fri Jan 25 00:44:23 2019 Thread 1 advanced to log sequence 138 (LGWR switch) Current log# 2 seq# 138 mem# 0: /u01/app/oracle/oradata/orcl/redo02.log Current log# 2 seq# 138 mem# 1: /u01/app/oracle/oradata/orcl/redo02_1.log