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'))