Adjusting the default value of parameter parallel_max_servers from 320 to 226 due to the value of parameter processes (300) Starting ORACLE instance (restrict) (OS id: 16700) CLI notifier numLatches:13 maxDescs:519 ********************************************************************** Dump of system resources acquired for SHARED GLOBAL AREA (SGA) Per process system memlock (soft) limit = 4696M Expected per process system memlock (soft) limit to lock SHARED GLOBAL AREA (SGA) into memory: 4690M Available system pagesizes: 4K, 2048K Supported system pagesize(s): PAGESIZE AVAILABLE_PAGES EXPECTED_PAGES ALLOCATED_PAGES ERROR(s) 4K Configured 6 1200134 NONE 2048K 0 2345 0 NONE RECOMMENDATION: 1. For optimal performance, configure system with expected number of pages for every supported system pagesize prior to the next instance restart operation. ********************************************************************** LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Initial number of CPU is 8 Number of processor cores in the system is 8 Number of processor sockets in the system is 1 Shared memory segment for instance monitoring created Picked latch-free SCN scheme 3 Autotune of undo retention is turned on. IMODE=BR ILAT =51 LICENSE_MAX_USERS = 0 SYS auditing is disabled NOTE: remote asm mode is local (mode 0x1; from cluster type) NOTE: Using default ASM root directory ASM 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_HOME = /data/u01/app/product/12.1.0/dbhome_1 System name:Linux Node name:ip-10-0-1-7.eu-west-1.compute.internal Release:4.1.12-124.32.3.2.el7uek.x86_64 Version:#2 SMP Fri Nov 1 15:12:08 PDT 2019 Machine:x86_64 Using parameter settings in client-side pfile /mnt/provision/VVMurex3_FNK/datafile/init.ora.rename on machine ip-10-0-1-7.eu-west-1.compute.internal System parameters with non-default values: processes = 300 event = "10052 trace name context forever" filesystemio_options = "setall" _omf = "DISABLED" sga_target = 4688M control_files = "/mnt/provision/VVMurex3_FNK/datafile/data/u01/app/oradata/orcl/control01.ctl" _controlfile_enqueue_timeout= 4500 control_file_record_keep_time= 1 db_block_size = 8192 compatible = "12.1.0.2.0" log_archive_dest_1 = "location=/mnt/provision/VVMurex3_FNK/source-archive/ MANDATORY" db_create_file_dest = "/mnt/provision/VVMurex3_FNK/datafile" db_block_checking = "false" remote_login_passwordfile= "EXCLUSIVE" audit_sys_operations = FALSE job_queue_processes = 0 _system_trig_enabled = FALSE parallel_execution_message_size= 65536 audit_trail = "NONE" db_name = "VMurex3" db_unique_name = "VVMurex3_FNK" open_cursors = 300 pga_aggregate_target = 1560M _diag_hm_rc_enabled = FALSE NOTE: remote asm mode is local (mode 0x1; from cluster type) Starting background process PMON PMON started with pid=2, OS id=17503 Starting background process PSP0 PSP0 started with pid=3, OS id=17505 Starting background process VKTM VKTM started with pid=4, OS id=17508 at elevated (RT) priority Starting background process GEN0 VKTM running at (1)millisec precision with DBRM quantum (100)ms GEN0 started with pid=5, OS id=17512 Starting background process MMAN MMAN started with pid=6, OS id=17514 Starting background process DIAG DIAG started with pid=8, OS id=17518 Starting background process DBRM DBRM started with pid=9, OS id=17520 Starting background process VKRM VKRM started with pid=10, OS id=17522 Starting background process DIA0 DIA0 started with pid=11, OS id=17524 Starting background process DBW0 DBW0 started with pid=12, OS id=17526 Starting background process LGWR LGWR started with pid=13, OS id=17528 Starting background process CKPT CKPT started with pid=14, OS id=17530 Starting background process SMON SMON started with pid=16, OS id=17534 Starting background process RECO RECO started with pid=18, OS id=17538 Starting background process LREG LREG started with pid=19, OS id=17540 Starting background process PXMN PXMN started with pid=20, OS id=17542 Starting background process MMON MMON started with pid=21, OS id=17544 Starting background process MMNL MMNL started with pid=22, OS id=17546 ORACLE_BASE from environment = /data/u01/app ALTER DATABASE MOUNT Using default pga_aggregate_limit of 3120 MB Changing di2dbun from VMurex3 to VVMurex3_FNK Successful mount of redo thread 1, with mount id 2169124474 Database mounted in Exclusive Mode Lost write protection disabled Create Relation IPS_PACKAGE_UNPACK_HISTORY Completed: ALTER DATABASE MOUNT alter database flashback off Flashback Database Disabled Completed: alter database flashback off Switch of datafile 9 complete to datafile copy checkpoint is 553973418 Switch of datafile 1 complete to datafile copy checkpoint is 553973418 Switch of datafile 5 complete to datafile copy checkpoint is 553973418 Switch of datafile 6 complete to datafile copy checkpoint is 553973418 Switch of datafile 4 complete to datafile copy checkpoint is 553973418 Switch of datafile 3 complete to datafile copy checkpoint is 553973418 Switch of datafile 2 complete to datafile copy checkpoint is 553973418 Switch of datafile 8 complete to datafile copy checkpoint is 553973418 Switch of datafile 7 complete to datafile copy checkpoint is 553973418 alter database rename file '/delphix/VMurex3/datafile/VMUREX3/onlinelog/o1_mf_7_h1k867rf_.log' to '/mnt/provision/VVMurex3_FNK/datafile/VMUREX3/onlinelog/o1_mf_7_h1k867rf_.log' Completed: alter database rename file '/delphix/VMurex3/datafile/VMUREX3/onlinelog/o1_mf_7_h1k867rf_.log' to '/mnt/provision/VVMurex3_FNK/datafile/VMUREX3/onlinelog/o1_mf_7_h1k867rf_.log' alter database rename file '/delphix/VMurex3/datafile/VMUREX3/onlinelog/o1_mf_6_h1k8679c_.log' to '/mnt/provision/VVMurex3_FNK/datafile/VMUREX3/onlinelog/o1_mf_6_h1k8679c_.log' Completed: alter database rename file '/delphix/VMurex3/datafile/VMUREX3/onlinelog/o1_mf_6_h1k8679c_.log' to '/mnt/provision/VVMurex3_FNK/datafile/VMUREX3/onlinelog/o1_mf_6_h1k8679c_.log' alter database rename file '/delphix/VMurex3/datafile/VMUREX3/onlinelog/o1_mf_8_h1k868sf_.log' to '/mnt/provision/VVMurex3_FNK/datafile/VMUREX3/onlinelog/o1_mf_8_h1k868sf_.log' Completed: alter database rename file '/delphix/VMurex3/datafile/VMUREX3/onlinelog/o1_mf_8_h1k868sf_.log' to '/mnt/provision/VVMurex3_FNK/datafile/VMUREX3/onlinelog/o1_mf_8_h1k868sf_.log' Shutting down instance (abort) License high water mark = 3 USER (ospid: 17726): terminating the instance Instance terminated by USER, pid = 17726 Instance shutdown complete Adjusting the default value of parameter parallel_max_servers from 320 to 226 due to the value of parameter processes (300) Starting ORACLE instance (restrict) (OS id: 17729) CLI notifier numLatches:13 maxDescs:519 ********************************************************************** Dump of system resources acquired for SHARED GLOBAL AREA (SGA) Per process system memlock (soft) limit = 4696M Expected per process system memlock (soft) limit to lock SHARED GLOBAL AREA (SGA) into memory: 4690M Available system pagesizes: 4K, 2048K Supported system pagesize(s): PAGESIZE AVAILABLE_PAGES EXPECTED_PAGES ALLOCATED_PAGES ERROR(s) 4K Configured 6 1200134 NONE 2048K 0 2345 0 NONE RECOMMENDATION: 1. For optimal performance, configure system with expected number of pages for every supported system pagesize prior to the next instance restart operation. ********************************************************************** LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Initial number of CPU is 8 Number of processor cores in the system is 8 Number of processor sockets in the system is 1 Picked latch-free SCN scheme 3 Autotune of undo retention is turned on. IMODE=BR ILAT =51 LICENSE_MAX_USERS = 0 SYS auditing is disabled NOTE: remote asm mode is local (mode 0x1; from cluster type) NOTE: Using default ASM root directory ASM 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_HOME = /data/u01/app/product/12.1.0/dbhome_1 System name:Linux Node name:ip-10-0-1-7.eu-west-1.compute.internal Release:4.1.12-124.32.3.2.el7uek.x86_64 Version:#2 SMP Fri Nov 1 15:12:08 PDT 2019 Machine:x86_64 Using parameter settings in client-side pfile /mnt/provision/VVMurex3_FNK/datafile/init.ora.recovery on machine ip-10-0-1-7.eu-west-1.compute.internal System parameters with non-default values: processes = 300 event = "10052 trace name context forever" filesystemio_options = "setall" _omf = "ENABLED" sga_target = 4688M control_files = "/mnt/provision/VVMurex3_FNK/datafile/data/u01/app/oradata/orcl/control01.ctl" _controlfile_enqueue_timeout= 4500 control_file_record_keep_time= 1 db_block_size = 8192 compatible = "12.1.0.2.0" log_archive_dest_1 = "location=/mnt/provision/VVMurex3_FNK/source-archive/ MANDATORY" db_create_file_dest = "/mnt/provision/VVMurex3_FNK/datafile" db_block_checking = "false" remote_login_passwordfile= "EXCLUSIVE" audit_sys_operations = FALSE job_queue_processes = 0 _system_trig_enabled = FALSE parallel_execution_message_size= 65536 audit_trail = "NONE" db_name = "VMurex3" db_unique_name = "VVMurex3_FNK" open_cursors = 300 pga_aggregate_target = 1560M _diag_hm_rc_enabled = FALSE NOTE: remote asm mode is local (mode 0x1; from cluster type) Starting background process PMON PMON started with pid=2, OS id=17734 Starting background process PSP0 PSP0 started with pid=3, OS id=17736 Starting background process VKTM VKTM started with pid=4, OS id=17739 at elevated (RT) priority Starting background process GEN0 VKTM running at (1)millisec precision with DBRM quantum (100)ms GEN0 started with pid=5, OS id=17743 Starting background process MMAN MMAN started with pid=6, OS id=17745 Starting background process DIAG DIAG started with pid=8, OS id=17749 Starting background process DBRM DBRM started with pid=9, OS id=17751 Starting background process VKRM VKRM started with pid=10, OS id=17753 Starting background process DIA0 DIA0 started with pid=11, OS id=17755 Starting background process DBW0 DBW0 started with pid=12, OS id=17757 Starting background process LGWR LGWR started with pid=13, OS id=17759 Starting background process CKPT CKPT started with pid=14, OS id=17761 Starting background process SMON SMON started with pid=16, OS id=17765 Starting background process RECO RECO started with pid=18, OS id=17769 Starting background process LREG LREG started with pid=19, OS id=17771 Starting background process PXMN PXMN started with pid=20, OS id=17773 Starting background process MMON MMON started with pid=21, OS id=17775 Starting background process MMNL MMNL started with pid=22, OS id=17777 ORACLE_BASE from environment = /data/u01/app ALTER DATABASE MOUNT Using default pga_aggregate_limit of 3120 MB Successful mount of redo thread 1, with mount id 2169132938 Database mounted in Exclusive Mode Lost write protection disabled Completed: ALTER DATABASE MOUNT alter database recover datafile list clear Completed: alter database recover datafile list clear alter database recover datafile list 1 , 2 , 3 , 4 , 5 , 6 , 7 , 8 , 9 Completed: alter database recover datafile list 1 , 2 , 3 , 4 , 5 , 6 , 7 , 8 , 9 alter database recover if needed start until change 553973451 Media Recovery Start Started logmerger process Parallel Media Recovery started with 8 slaves Recovery of Online Redo Log: Thread 1 Group 6 Seq 135 Reading mem 0 Mem# 0: /mnt/provision/VVMurex3_FNK/datafile/VMUREX3/onlinelog/o1_mf_6_h1k8679c_.log Incomplete recovery applied all redo ever generated. Recovery completed through change 553973440 time 01/13/2020 16:09:49 Media Recovery Complete (VVMurex3FNK) Completed: alter database recover if needed start until change 553973451 Shutting down instance (abort) License high water mark = 12 USER (ospid: 17884): terminating the instance Instance terminated by USER, pid = 17884 Instance shutdown complete Adjusting the default value of parameter parallel_max_servers from 320 to 226 due to the value of parameter processes (300) Starting ORACLE instance (normal) (OS id: 17888) CLI notifier numLatches:13 maxDescs:519 ********************************************************************** Dump of system resources acquired for SHARED GLOBAL AREA (SGA) Per process system memlock (soft) limit = 4696M Expected per process system memlock (soft) limit to lock SHARED GLOBAL AREA (SGA) into memory: 4690M Available system pagesizes: 4K, 2048K Supported system pagesize(s): PAGESIZE AVAILABLE_PAGES EXPECTED_PAGES ALLOCATED_PAGES ERROR(s) 4K Configured 6 1200134 NONE 2048K 0 2345 0 NONE RECOMMENDATION: 1. For optimal performance, configure system with expected number of pages for every supported system pagesize prior to the next instance restart operation. ********************************************************************** LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Initial number of CPU is 8 Number of processor cores in the system is 8 Number of processor sockets in the system is 1 Picked latch-free SCN scheme 3 Autotune of undo retention is turned on. IMODE=BR ILAT =51 LICENSE_MAX_USERS = 0 SYS auditing is disabled NOTE: remote asm mode is local (mode 0x1; from cluster type) NOTE: Using default ASM root directory ASM 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_HOME = /data/u01/app/product/12.1.0/dbhome_1 System name:Linux Node name:ip-10-0-1-7.eu-west-1.compute.internal Release:4.1.12-124.32.3.2.el7uek.x86_64 Version:#2 SMP Fri Nov 1 15:12:08 PDT 2019 Machine:x86_64 Using parameter settings in client-side pfile /mnt/provision/VVMurex3_FNK/datafile/init.ora.recovery on machine ip-10-0-1-7.eu-west-1.compute.internal System parameters with non-default values: processes = 300 event = "10052 trace name context forever" filesystemio_options = "setall" _omf = "ENABLED" sga_target = 4688M control_files = "/mnt/provision/VVMurex3_FNK/datafile/data/u01/app/oradata/orcl/control01.ctl" _controlfile_enqueue_timeout= 4500 control_file_record_keep_time= 1 db_block_size = 8192 compatible = "12.1.0.2.0" log_archive_dest_1 = "location=/mnt/provision/VVMurex3_FNK/source-archive/ MANDATORY" db_create_file_dest = "/mnt/provision/VVMurex3_FNK/datafile" db_block_checking = "false" remote_login_passwordfile= "EXCLUSIVE" audit_sys_operations = FALSE job_queue_processes = 0 _system_trig_enabled = FALSE parallel_execution_message_size= 65536 audit_trail = "NONE" db_name = "VMurex3" db_unique_name = "VVMurex3_FNK" open_cursors = 300 pga_aggregate_target = 1560M _diag_hm_rc_enabled = FALSE NOTE: remote asm mode is local (mode 0x1; from cluster type) Starting background process PMON PMON started with pid=2, OS id=17892 Starting background process PSP0 PSP0 started with pid=3, OS id=17894 Starting background process VKTM VKTM started with pid=4, OS id=17897 at elevated (RT) priority Starting background process GEN0 VKTM running at (1)millisec precision with DBRM quantum (100)ms GEN0 started with pid=5, OS id=17901 Starting background process MMAN MMAN started with pid=6, OS id=17903 Starting background process DIAG DIAG started with pid=8, OS id=17907 Starting background process DBRM DBRM started with pid=9, OS id=17909 Starting background process VKRM VKRM started with pid=10, OS id=17911 Starting background process DIA0 DIA0 started with pid=11, OS id=17913 Starting background process DBW0 DBW0 started with pid=12, OS id=17915 Starting background process LGWR LGWR started with pid=13, OS id=17917 Starting background process CKPT CKPT started with pid=14, OS id=17919 Starting background process SMON SMON started with pid=16, OS id=17923 Starting background process RECO RECO started with pid=18, OS id=17927 Starting background process LREG LREG started with pid=19, OS id=17929 Starting background process PXMN PXMN started with pid=20, OS id=17931 Starting background process MMON MMON started with pid=21, OS id=17933 Starting background process MMNL MMNL started with pid=22, OS id=17935 ORACLE_BASE from environment = /data/u01/app ALTER DATABASE MOUNT Using default pga_aggregate_limit of 3120 MB Successful mount of redo thread 1, with mount id 2169087910 Database mounted in Exclusive Mode Lost write protection disabled Completed: ALTER DATABASE MOUNT Shutting down instance (abort) License high water mark = 1 USER (ospid: 18011): terminating the instance Instance terminated by USER, pid = 18011 Instance shutdown complete Adjusting the default value of parameter parallel_max_servers from 320 to 226 due to the value of parameter processes (300) Starting ORACLE instance (restrict) (OS id: 18014) CLI notifier numLatches:13 maxDescs:519 ********************************************************************** Dump of system resources acquired for SHARED GLOBAL AREA (SGA) Per process system memlock (soft) limit = 4696M Expected per process system memlock (soft) limit to lock SHARED GLOBAL AREA (SGA) into memory: 4690M Available system pagesizes: 4K, 2048K Supported system pagesize(s): PAGESIZE AVAILABLE_PAGES EXPECTED_PAGES ALLOCATED_PAGES ERROR(s) 4K Configured 6 1200134 NONE 2048K 0 2345 0 NONE RECOMMENDATION: 1. For optimal performance, configure system with expected number of pages for every supported system pagesize prior to the next instance restart operation. ********************************************************************** LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Initial number of CPU is 8 Number of processor cores in the system is 8 Number of processor sockets in the system is 1 Picked latch-free SCN scheme 3 Autotune of undo retention is turned on. IMODE=BR ILAT =51 LICENSE_MAX_USERS = 0 SYS auditing is disabled NOTE: remote asm mode is local (mode 0x1; from cluster type) NOTE: Using default ASM root directory ASM 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_HOME = /data/u01/app/product/12.1.0/dbhome_1 System name:Linux Node name:ip-10-0-1-7.eu-west-1.compute.internal Release:4.1.12-124.32.3.2.el7uek.x86_64 Version:#2 SMP Fri Nov 1 15:12:08 PDT 2019 Machine:x86_64 Using parameter settings in client-side pfile /mnt/provision/VVMurex3_FNK/datafile/init.ora.createControlfile on machine ip-10-0-1-7.eu-west-1.compute.internal System parameters with non-default values: processes = 300 event = "10052 trace name context forever" filesystemio_options = "setall" _omf = "ENABLED" sga_target = 4688M control_files = "/mnt/provision/VVMurex3_FNK/datafile/data/u01/app/oradata/orcl/control01.ctl" db_block_size = 8192 compatible = "12.1.0.2.0" log_archive_dest_1 = "location=/mnt/provision/VVMurex3_FNK/source-archive/ MANDATORY" db_create_file_dest = "/mnt/provision/VVMurex3_FNK/datafile" db_block_checking = "false" remote_login_passwordfile= "EXCLUSIVE" audit_sys_operations = FALSE job_queue_processes = 0 _system_trig_enabled = FALSE parallel_execution_message_size= 65536 audit_trail = "NONE" db_name = "VVMu_FNK" db_unique_name = "VVMurex3_FNK" open_cursors = 300 pga_aggregate_target = 1560M NOTE: remote asm mode is local (mode 0x1; from cluster type) Starting background process PMON PMON started with pid=2, OS id=18019 Starting background process PSP0 PSP0 started with pid=3, OS id=18021 Starting background process VKTM VKTM started with pid=4, OS id=18024 at elevated (RT) priority Starting background process GEN0 VKTM running at (1)millisec precision with DBRM quantum (100)ms GEN0 started with pid=5, OS id=18028 Starting background process MMAN MMAN started with pid=6, OS id=18030 Starting background process DIAG DIAG started with pid=8, OS id=18034 Starting background process DBRM DBRM started with pid=9, OS id=18036 Starting background process VKRM VKRM started with pid=10, OS id=18038 Starting background process DIA0 DIA0 started with pid=11, OS id=18040 Starting background process DBW0 DBW0 started with pid=12, OS id=18042 Starting background process LGWR LGWR started with pid=13, OS id=18044 Starting background process CKPT CKPT started with pid=14, OS id=18046 Starting background process SMON SMON started with pid=16, OS id=18050 Starting background process RECO RECO started with pid=18, OS id=18054 Starting background process LREG LREG started with pid=19, OS id=18056 Starting background process PXMN PXMN started with pid=20, OS id=18058 Starting background process MMON MMON started with pid=21, OS id=18060 Starting background process MMNL MMNL started with pid=22, OS id=18062 ORACLE_BASE from environment = /data/u01/app CREATE CONTROLFILE REUSE SET DATABASE 'VVMu_FNK' RESETLOGS ARCHIVELOG MAXLOGFILES 64 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 32 MAXLOGHISTORY 11680 LOGFILE GROUP 7 '/mnt/provision/VVMurex3_FNK/datafile/VMUREX3/onlinelog/o1_mf_7_h1k867rf_.log' SIZE 52428800, GROUP 6 '/mnt/provision/VVMurex3_FNK/datafile/VMUREX3/onlinelog/o1_mf_6_h1k8679c_.log' SIZE 52428800, GROUP 8 '/mnt/provision/VVMurex3_FNK/datafile/VMUREX3/onlinelog/o1_mf_8_h1k868sf_.log' SIZE 52428800 DATAFILE '/mnt/provision/VVMurex3_FNK/datafile/data/u01/app/oradata/orcl/system01.dbf' ,'/mnt/provision/VVMurex3_FNK/datafile/data/u01/app/oradata/orcl/murex_02.dbf' ,'/mnt/provision/VVMurex3_FNK/datafile/data/u01/app/oradata/orcl/sysaux01.dbf' ,'/mnt/provision/VVMurex3_FNK/datafile/data/u01/app/oradata/orcl/undotbs01.dbf' ,'/mnt/provision/VVMurex3_FNK/datafile/data/u01/app/oradata/orcl/murex_01.dbf' ,'/mnt/provision/VVMurex3_FNK/datafile/data/u01/app/oradata/orcl/users01.dbf' ,'/mnt/provision/VVMurex3_FNK/datafile/data/u01/app/oradata/mgmt_depot.dbf' ,'/mnt/provision/VVMurex3_FNK/datafile/data/u01/app/oradata/mgmt.dbf' ,'/mnt/provision/VVMurex3_FNK/datafile/data/u01/app/oradata/mgmt_ad4j.dbf' CHARACTER SET AL32UTF8 WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command Default Temporary Tablespace will be necessary for a locally managed database in future release Successful mount of redo thread 1, with mount id 707328944 Completed: CREATE CONTROLFILE REUSE SET DATABASE 'VVMu_FNK' RESETLOGS ARCHIVELOG MAXLOGFILES 64 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 32 MAXLOGHISTORY 11680 LOGFILE GROUP 7 '/mnt/provision/VVMurex3_FNK/datafile/VMUREX3/onlinelog/o1_mf_7_h1k867rf_.log' SIZE 52428800, GROUP 6 '/mnt/provision/VVMurex3_FNK/datafile/VMUREX3/onlinelog/o1_mf_6_h1k8679c_.log' SIZE 52428800, GROUP 8 '/mnt/provision/VVMurex3_FNK/datafile/VMUREX3/onlinelog/o1_mf_8_h1k868sf_.log' SIZE 52428800 DATAFILE '/mnt/provision/VVMurex3_FNK/datafile/data/u01/app/oradata/orcl/system01.dbf' ,'/mnt/provision/VVMurex3_FNK/datafile/data/u01/app/oradata/orcl/murex_02.dbf' ,'/mnt/provision/VVMurex3_FNK/datafile/data/u01/app/oradata/orcl/sysaux01.dbf' ,'/mnt/provision/VVMurex3_FNK/datafile/data/u01/app/oradata/orcl/undotbs01.dbf' ,'/mnt/provision/VVMurex3_FNK/datafile/data/u01/app/oradata/orcl/murex_01.dbf' ,'/mnt/provision/VVMurex3_FNK/datafile/data/u01/app/oradata/orcl/users01.dbf' ,'/mnt/provision/VVMurex3_FNK/datafile/data/u01/app/oradata/mgmt_depot.dbf' ,'/mnt/provision/VVMurex3_FNK/datafile/data/u01/app/oradata/mgmt.dbf' ,'/mnt/provision/VVMurex3_FNK/datafile/data/u01/app/oradata/mgmt_ad4j.dbf' CHARACTER SET AL32UTF8 alter database recover database noparallel until cancel using backup controlfile Media Recovery Start Serial Media Recovery started ORA-279 signalled during: alter database recover database noparallel until cancel using backup controlfile... alter database recover cancel Media Recovery Canceled Completed: alter database recover cancel alter database add logfile thread 1 SIZE 4M Completed: alter database add logfile thread 1 SIZE 4M alter database add logfile thread 1 SIZE 4M Completed: alter database add logfile thread 1 SIZE 4M Shutting down instance (abort) License high water mark = 2 USER (ospid: 18114): terminating the instance Instance terminated by USER, pid = 18114 Instance shutdown complete Adjusting the default value of parameter parallel_max_servers from 320 to 226 due to the value of parameter processes (300) Starting ORACLE instance (restrict) (OS id: 18117) CLI notifier numLatches:13 maxDescs:519 ********************************************************************** Dump of system resources acquired for SHARED GLOBAL AREA (SGA) Per process system memlock (soft) limit = 4696M Expected per process system memlock (soft) limit to lock SHARED GLOBAL AREA (SGA) into memory: 4690M Available system pagesizes: 4K, 2048K Supported system pagesize(s): PAGESIZE AVAILABLE_PAGES EXPECTED_PAGES ALLOCATED_PAGES ERROR(s) 4K Configured 6 1200134 NONE 2048K 0 2345 0 NONE RECOMMENDATION: 1. For optimal performance, configure system with expected number of pages for every supported system pagesize prior to the next instance restart operation. ********************************************************************** LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Initial number of CPU is 8 Number of processor cores in the system is 8 Number of processor sockets in the system is 1 Picked latch-free SCN scheme 3 Autotune of undo retention is turned on. IMODE=BR ILAT =51 LICENSE_MAX_USERS = 0 SYS auditing is disabled NOTE: remote asm mode is local (mode 0x1; from cluster type) NOTE: Using default ASM root directory ASM 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_HOME = /data/u01/app/product/12.1.0/dbhome_1 System name:Linux Node name:ip-10-0-1-7.eu-west-1.compute.internal Release:4.1.12-124.32.3.2.el7uek.x86_64 Version:#2 SMP Fri Nov 1 15:12:08 PDT 2019 Machine:x86_64 Using parameter settings in server-side pfile /data/u01/app/product/12.1.0/dbhome_1/dbs/initVVMurex3FNK.ora System parameters with non-default values: processes = 300 spfile = "/mnt/provision/VVMurex3_FNK/datafile/spfile.ora" filesystemio_options = "setall" _omf = "ENABLED" sga_target = 4688M control_files = "/mnt/provision/VVMurex3_FNK/datafile/data/u01/app/oradata/orcl/control01.ctl" db_block_size = 8192 compatible = "12.1.0.2.0" log_archive_dest_1 = "location=/mnt/provision/VVMurex3_FNK/archive/ MANDATORY" db_create_file_dest = "/mnt/provision/VVMurex3_FNK/datafile" instance_number = 1 remote_login_passwordfile= "EXCLUSIVE" audit_sys_operations = FALSE audit_trail = "NONE" db_name = "VVMu_FNK" db_unique_name = "VVMurex3_FNK" open_cursors = 300 pga_aggregate_target = 1560M NOTE: remote asm mode is local (mode 0x1; from cluster type) Starting background process PMON PMON started with pid=2, OS id=18122 Starting background process PSP0 PSP0 started with pid=3, OS id=18124 Starting background process VKTM VKTM started with pid=4, OS id=18126 at elevated (RT) priority Starting background process GEN0 VKTM running at (1)millisec precision with DBRM quantum (100)ms GEN0 started with pid=5, OS id=18131 Starting background process MMAN MMAN started with pid=6, OS id=18133 Starting background process DIAG DIAG started with pid=8, OS id=18137 Starting background process DBRM DBRM started with pid=9, OS id=18139 Starting background process VKRM VKRM started with pid=10, OS id=18141 Starting background process DIA0 DIA0 started with pid=11, OS id=18143 Starting background process DBW0 DBW0 started with pid=12, OS id=18145 Starting background process LGWR LGWR started with pid=13, OS id=18147 Starting background process CKPT CKPT started with pid=14, OS id=18149 Starting background process SMON SMON started with pid=16, OS id=18153 Starting background process RECO RECO started with pid=18, OS id=18157 Starting background process LREG LREG started with pid=19, OS id=18159 Starting background process PXMN PXMN started with pid=20, OS id=18161 Starting background process MMON MMON started with pid=21, OS id=18163 Starting background process MMNL MMNL started with pid=22, OS id=18165 ORACLE_BASE from environment = /data/u01/app ALTER DATABASE MOUNT Using default pga_aggregate_limit of 3120 MB Successful mount of redo thread 1, with mount id 707340472 Database mounted in Exclusive Mode Lost write protection disabled Completed: ALTER DATABASE MOUNT alter database open resetlogs RESETLOGS after incomplete recovery UNTIL CHANGE 553973440 time 01/13/2020 16:09:49 Archived Log entry 1 added for thread 1 sequence 135 ID 0x811f5fc0 dest 1: Archived Log entry 2 added for thread 1 sequence 133 ID 0x811f5fc0 dest 1: Archived Log entry 3 added for thread 1 sequence 134 ID 0x811f5fc0 dest 1: Clearing online redo logfile 6 /mnt/provision/VVMurex3_FNK/datafile/VMUREX3/onlinelog/o1_mf_6_h1k8679c_.log Clearing online log 6 of thread 1 sequence number 135 Clearing online redo logfile 6 complete Clearing online redo logfile 7 /mnt/provision/VVMurex3_FNK/datafile/VMUREX3/onlinelog/o1_mf_7_h1k867rf_.log Clearing online log 7 of thread 1 sequence number 133 Clearing online redo logfile 7 complete Clearing online redo logfile 8 /mnt/provision/VVMurex3_FNK/datafile/VMUREX3/onlinelog/o1_mf_8_h1k868sf_.log Clearing online log 8 of thread 1 sequence number 134 Clearing online redo logfile 8 complete Online log /mnt/provision/VVMurex3_FNK/datafile/VVMUREX3_FNK/onlinelog/o1_mf_1_h47d3koy_.log: Thread 1 Group 1 was previously cleared Online log /mnt/provision/VVMurex3_FNK/datafile/VVMUREX3_FNK/onlinelog/o1_mf_2_h47d3kqd_.log: Thread 1 Group 2 was previously cleared Online log /mnt/provision/VVMurex3_FNK/datafile/VMUREX3/onlinelog/o1_mf_6_h1k8679c_.log: Thread 1 Group 6 was previously cleared Online log /mnt/provision/VVMurex3_FNK/datafile/VMUREX3/onlinelog/o1_mf_7_h1k867rf_.log: Thread 1 Group 7 was previously cleared Online log /mnt/provision/VVMurex3_FNK/datafile/VMUREX3/onlinelog/o1_mf_8_h1k868sf_.log: Thread 1 Group 8 was previously cleared Setting recovery target incarnation to 2 Ping without log force is disabled . Initializing SCN for created control file Database SCN compatibility initialized to 3 Warning - High Database SCN: Current SCN value is 553973443, threshold SCN value is 0 If you have not previously reported this warning on this database, please notify Oracle Support so that additional diagnosis can be performed. Starting background process TMON TMON started with pid=7, OS id=18218 Assigning activation ID 707340472 (0x2a2928b8) LGWR: STARTING ARCH PROCESSES Starting background process ARC0 ARC0 started with pid=24, OS id=18220 ARC0: Archival started LGWR: STARTING ARCH PROCESSES COMPLETE ARC0: STARTING ARCH PROCESSES Starting background process ARC1 ARC1 started with pid=25, OS id=18222 Starting background process ARC2 ARC2 started with pid=26, OS id=18224 Starting background process ARC3 ARC3 started with pid=27, OS id=18226 ARC1: Archival started ARC2: Archival started ARC1: Becoming the 'no FAL' ARCH ARC1: Becoming the 'no SRL' ARCH ARC2: Becoming the heartbeat ARCH Thread 1 opened at log sequence 1 Current log# 1 seq# 1 mem# 0: /mnt/provision/VVMurex3_FNK/datafile/VVMUREX3_FNK/onlinelog/o1_mf_1_h47d3koy_.log Successful open of redo thread 1 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set ARC3: Archival started ARC0: STARTING ARCH PROCESSES COMPLETE SMON: enabling cache recovery [18212] Successfully onlined Undo Tablespace 2. Undo initialization finished serial:0 start:142954 end:143134 diff:180 ms (0.2 seconds) Dictionary check beginning Tablespace 'TEMP' #3 found in data dictionary, but not in the controlfile. Adding to controlfile. Dictionary check complete Verifying minimum file header compatibility (11g) for tablespace encryption.. Verifying 11g file header compatibility for tablespace encryption completed SMON: enabling tx recovery Starting background process SMCO ********************************************************************* WARNING: The following temporary tablespaces contain no files. This condition can occur when a backup controlfile has been restored. It may be necessary to add files to these tablespaces. That can be done using the SQL statement: ALTER TABLESPACE <tablespace_name> ADD TEMPFILE Alternatively, if these temporary tablespaces are no longer needed, then they can be dropped. Empty temporary tablespace: TEMP ********************************************************************* Database Characterset is AL32UTF8 SMCO started with pid=29, OS id=18230 No Resource Manager plan active replication_dependency_tracking turned off (no async multimaster replication found) AQ Processes can not start in restrict mode LOGSTDBY: Validating controlfile with logical metadata LOGSTDBY: Validation complete Global Name changed to VVMU_FNK Starting background process CJQ0 CJQ0 started with pid=32, OS id=18239 Completed: alter database open resetlogs ALTER TABLESPACE "TEMP" ADD TEMPFILE '/mnt/provision/VVMurex3_FNK/temp/temp1.dbf' SIZE 434M AUTOEXTEND ON NEXT 50M MAXSIZE 32767M Completed: ALTER TABLESPACE "TEMP" ADD TEMPFILE '/mnt/provision/VVMurex3_FNK/temp/temp1.dbf' SIZE 434M AUTOEXTEND ON NEXT 50M MAXSIZE 32767M ALTER SYSTEM ARCHIVE LOG Thread 1 advanced to log sequence 2 (LGWR switch) Current log# 2 seq# 2 mem# 0: /mnt/provision/VVMurex3_FNK/datafile/VVMUREX3_FNK/onlinelog/o1_mf_2_h47d3kqd_.log Archived Log entry 4 added for thread 1 sequence 1 ID 0x2a2928b8 dest 1: ALTER SYSTEM SET local_listener='' SCOPE=BOTH SID='VVMurex3FNK'; Shutting down instance (abort) License high water mark = 1 USER (ospid: 18297): terminating the instance Instance terminated by USER, pid = 18297 Instance shutdown complete Adjusting the default value of parameter parallel_max_servers from 320 to 226 due to the value of parameter processes (300) Starting ORACLE instance (normal) (OS id: 18308) CLI notifier numLatches:13 maxDescs:519 ********************************************************************** Dump of system resources acquired for SHARED GLOBAL AREA (SGA) Per process system memlock (soft) limit = 4696M Expected per process system memlock (soft) limit to lock SHARED GLOBAL AREA (SGA) into memory: 4690M Available system pagesizes: 4K, 2048K Supported system pagesize(s): PAGESIZE AVAILABLE_PAGES EXPECTED_PAGES ALLOCATED_PAGES ERROR(s) 4K Configured 6 1200134 NONE 2048K 0 2345 0 NONE RECOMMENDATION: 1. For optimal performance, configure system with expected number of pages for every supported system pagesize prior to the next instance restart operation. ********************************************************************** LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Initial number of CPU is 8 Number of processor cores in the system is 8 Number of processor sockets in the system is 1 Picked latch-free SCN scheme 3 Autotune of undo retention is turned on. IMODE=BR ILAT =51 LICENSE_MAX_USERS = 0 SYS auditing is disabled NOTE: remote asm mode is local (mode 0x1; from cluster type) NOTE: Using default ASM root directory ASM 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_HOME = /data/u01/app/product/12.1.0/dbhome_1 System name:Linux Node name:ip-10-0-1-7.eu-west-1.compute.internal Release:4.1.12-124.32.3.2.el7uek.x86_64 Version:#2 SMP Fri Nov 1 15:12:08 PDT 2019 Machine:x86_64 Using parameter settings in server-side pfile /data/u01/app/product/12.1.0/dbhome_1/dbs/initVVMurex3FNK.ora System parameters with non-default values: processes = 300 spfile = "/mnt/provision/VVMurex3_FNK/datafile/spfile.ora" filesystemio_options = "setall" _omf = "ENABLED" sga_target = 4688M control_files = "/mnt/provision/VVMurex3_FNK/datafile/data/u01/app/oradata/orcl/control01.ctl" db_block_size = 8192 compatible = "12.1.0.2.0" log_archive_dest_1 = "location=/mnt/provision/VVMurex3_FNK/archive/ MANDATORY" db_create_file_dest = "/mnt/provision/VVMurex3_FNK/datafile" instance_number = 1 remote_login_passwordfile= "EXCLUSIVE" audit_sys_operations = FALSE local_listener = "" audit_trail = "NONE" db_name = "VVMu_FNK" db_unique_name = "VVMurex3_FNK" open_cursors = 300 pga_aggregate_target = 1560M NOTE: remote asm mode is local (mode 0x1; from cluster type) Starting background process PMON PMON started with pid=2, OS id=18312 Starting background process PSP0 PSP0 started with pid=3, OS id=18314 Starting background process VKTM VKTM started with pid=4, OS id=18317 at elevated (RT) priority Starting background process GEN0 VKTM running at (1)millisec precision with DBRM quantum (100)ms GEN0 started with pid=5, OS id=18321 Starting background process MMAN MMAN started with pid=6, OS id=18323 Starting background process DIAG DIAG started with pid=8, OS id=18327 Starting background process DBRM DBRM started with pid=9, OS id=18329 Starting background process VKRM VKRM started with pid=10, OS id=18331 Starting background process DIA0 DIA0 started with pid=11, OS id=18333 Starting background process DBW0 DBW0 started with pid=12, OS id=18335 Starting background process LGWR LGWR started with pid=13, OS id=18337 Starting background process CKPT CKPT started with pid=14, OS id=18339 Starting background process SMON SMON started with pid=16, OS id=18343 Starting background process RECO RECO started with pid=18, OS id=18347 Starting background process LREG LREG started with pid=19, OS id=18349 Starting background process PXMN PXMN started with pid=20, OS id=18351 Starting background process MMON MMON started with pid=21, OS id=18353 Starting background process MMNL MMNL started with pid=22, OS id=18355 ORACLE_BASE from environment = /data/u01/app ALTER DATABASE MOUNT Using default pga_aggregate_limit of 3120 MB Successful mount of redo thread 1, with mount id 707327943 Database mounted in Exclusive Mode Lost write protection disabled Completed: ALTER DATABASE MOUNT ALTER DATABASE OPEN Ping without log force is disabled . Beginning crash recovery of 1 threads parallel recovery started with 7 processes Started redo scan Completed redo scan read 56 KB redo, 34 data blocks need recovery Started redo application at Thread 1: logseq 1, block 2, scn 553973444 Recovery of Online Redo Log: Thread 1 Group 1 Seq 1 Reading mem 0 Mem# 0: /mnt/provision/VVMurex3_FNK/datafile/VVMUREX3_FNK/onlinelog/o1_mf_1_h47d3koy_.log Recovery of Online Redo Log: Thread 1 Group 2 Seq 2 Reading mem 0 Mem# 0: /mnt/provision/VVMurex3_FNK/datafile/VVMUREX3_FNK/onlinelog/o1_mf_2_h47d3kqd_.log Completed redo application of 0.03MB Completed crash recovery at Thread 1: logseq 2, block 2, scn 553973580 34 data blocks read, 34 data blocks written, 56 redo k-bytes read Starting background process TMON TMON started with pid=30, OS id=18385 LGWR: STARTING ARCH PROCESSES Starting background process ARC0 ARC0 started with pid=31, OS id=18387 ARC0: Archival started LGWR: STARTING ARCH PROCESSES COMPLETE ARC0: STARTING ARCH PROCESSES Starting background process ARC1 ARC1 started with pid=32, OS id=18389 Starting background process ARC2 ARC2 started with pid=33, OS id=18391 Starting background process ARC3 ARC3 started with pid=34, OS id=18393 ARC1: Archival started ARC2: Archival started ARC2: Becoming the 'no FAL' ARCH ARC2: Becoming the 'no SRL' ARCH ARC1: Becoming the heartbeat ARCH Thread 1 advanced to log sequence 3 (thread open) ARC3: Archival started ARC0: STARTING ARCH PROCESSES COMPLETE Thread 1 opened at log sequence 3 Current log# 6 seq# 3 mem# 0: /mnt/provision/VVMurex3_FNK/datafile/VMUREX3/onlinelog/o1_mf_6_h1k8679c_.log Successful open of redo thread 1 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set SMON: enabling cache recovery Archived Log entry 5 added for thread 1 sequence 2 ID 0x2a2928b8 dest 1: [18368] Successfully onlined Undo Tablespace 2. Undo initialization finished serial:0 start:156014 end:156124 diff:110 ms (0.1 seconds) Verifying minimum file header compatibility (11g) for tablespace encryption.. Verifying 11g file header compatibility for tablespace encryption completed SMON: enabling tx recovery Starting background process SMCO SMCO started with pid=36, OS id=18397 Database Characterset is AL32UTF8 No Resource Manager plan active replication_dependency_tracking turned off (no async multimaster replication found) Starting background process AQPC AQPC started with pid=39, OS id=18405 Starting background process CJQ0 CJQ0 started with pid=40, OS id=18408 Completed: ALTER DATABASE OPEN =========================================================== Dumping current patch information =========================================================== No patches have been applied =========================================================== Errors in file /data/u01/app/diag/rdbms/vvmurex3_fnk/VVMurex3FNK/trace/VVMurex3FNK_j037_18798.trc: ORA-12012: error on auto execute of job "SYSMAN"."METRIC_DATA_LOAD_CONTROLLER" ORA-02149: Specified partition does not exist ORA-06512: at "SYSMAN.EM_METRIC_DATA_LOAD_CONTROLLER", line 1088 ORA-06512: at line 1 Thread 1 advanced to log sequence 4 (LGWR switch) Current log# 7 seq# 4 mem# 0: /mnt/provision/VVMurex3_FNK/datafile/VMUREX3/onlinelog/o1_mf_7_h1k867rf_.log Archived Log entry 6 added for thread 1 sequence 3 ID 0x2a2928b8 dest 1: Thread 1 advanced to log sequence 5 (LGWR switch) Current log# 8 seq# 5 mem# 0: /mnt/provision/VVMurex3_FNK/datafile/VMUREX3/onlinelog/o1_mf_8_h1k868sf_.log Archived Log entry 7 added for thread 1 sequence 4 ID 0x2a2928b8 dest 1: Thread 1 advanced to log sequence 6 (LGWR switch) Current log# 1 seq# 6 mem# 0: /mnt/provision/VVMurex3_FNK/datafile/VVMUREX3_FNK/onlinelog/o1_mf_1_h47d3koy_.log Thread 1 advanced to log sequence 7 (LGWR switch) Current log# 2 seq# 7 mem# 0: /mnt/provision/VVMurex3_FNK/datafile/VVMUREX3_FNK/onlinelog/o1_mf_2_h47d3kqd_.log Archived Log entry 8 added for thread 1 sequence 5 ID 0x2a2928b8 dest 1: Thread 1 cannot allocate new log, sequence 8 Checkpoint not complete Current log# 2 seq# 7 mem# 0: /mnt/provision/VVMurex3_FNK/datafile/VVMUREX3_FNK/onlinelog/o1_mf_2_h47d3kqd_.log Archived Log entry 9 added for thread 1 sequence 6 ID 0x2a2928b8 dest 1: Thread 1 advanced to log sequence 8 (LGWR switch) Current log# 6 seq# 8 mem# 0: /mnt/provision/VVMurex3_FNK/datafile/VMUREX3/onlinelog/o1_mf_6_h1k8679c_.log Archived Log entry 10 added for thread 1 sequence 7 ID 0x2a2928b8 dest 1: TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P22394 (43872) VALUES LESS THAN (TO_DATE(' 2020-02-13 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) Thread 1 cannot allocate new log, sequence 9 Checkpoint not complete Current log# 6 seq# 8 mem# 0: /mnt/provision/VVMurex3_FNK/datafile/VMUREX3/onlinelog/o1_mf_6_h1k8679c_.log Thread 1 advanced to log sequence 9 (LGWR switch) Current log# 7 seq# 9 mem# 0: /mnt/provision/VVMurex3_FNK/datafile/VMUREX3/onlinelog/o1_mf_7_h1k867rf_.log Archived Log entry 11 added for thread 1 sequence 8 ID 0x2a2928b8 dest 1: Thread 1 cannot allocate new log, sequence 10 Checkpoint not complete Current log# 7 seq# 9 mem# 0: /mnt/provision/VVMurex3_FNK/datafile/VMUREX3/onlinelog/o1_mf_7_h1k867rf_.log Thread 1 advanced to log sequence 10 (LGWR switch) Current log# 8 seq# 10 mem# 0: /mnt/provision/VVMurex3_FNK/datafile/VMUREX3/onlinelog/o1_mf_8_h1k868sf_.log Archived Log entry 12 added for thread 1 sequence 9 ID 0x2a2928b8 dest 1: Thread 1 advanced to log sequence 11 (LGWR switch) Current log# 1 seq# 11 mem# 0: /mnt/provision/VVMurex3_FNK/datafile/VVMUREX3_FNK/onlinelog/o1_mf_1_h47d3koy_.log Thread 1 advanced to log sequence 12 (LGWR switch) Current log# 2 seq# 12 mem# 0: /mnt/provision/VVMurex3_FNK/datafile/VVMUREX3_FNK/onlinelog/o1_mf_2_h47d3kqd_.log Archived Log entry 13 added for thread 1 sequence 10 ID 0x2a2928b8 dest 1: Archived Log entry 14 added for thread 1 sequence 11 ID 0x2a2928b8 dest 1: Thread 1 advanced to log sequence 13 (LGWR switch) Current log# 6 seq# 13 mem# 0: /mnt/provision/VVMurex3_FNK/datafile/VMUREX3/onlinelog/o1_mf_6_h1k8679c_.log Archived Log entry 15 added for thread 1 sequence 12 ID 0x2a2928b8 dest 1: Thread 1 cannot allocate new log, sequence 14 Checkpoint not complete Current log# 6 seq# 13 mem# 0: /mnt/provision/VVMurex3_FNK/datafile/VMUREX3/onlinelog/o1_mf_6_h1k8679c_.log Thread 1 advanced to log sequence 14 (LGWR switch) Current log# 7 seq# 14 mem# 0: /mnt/provision/VVMurex3_FNK/datafile/VMUREX3/onlinelog/o1_mf_7_h1k867rf_.log Archived Log entry 16 added for thread 1 sequence 13 ID 0x2a2928b8 dest 1: TABLE SYS.WRP$_REPORTS: ADDED INTERVAL PARTITION SYS_P22649 (3695) VALUES LESS THAN (TO_DATE(' 2020-02-13 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLE SYS.WRP$_REPORTS_DETAILS: ADDED INTERVAL PARTITION SYS_P22650 (3695) VALUES LESS THAN (TO_DATE(' 2020-02-13 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) Shared IO Pool defaulting to 240MB. Trying to get it from Buffer Cache for process 19117. TABLE SYS.WRP$_REPORTS_TIME_BANDS: ADDED INTERVAL PARTITION SYS_P22653 (3694) VALUES LESS THAN (TO_DATE(' 2020-02-12 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))