[root@oraclelab1 ~]# ps -ef|grep smon
oracle 19657 1 0 00:43 ? 00:00:00 ora_smon_DEVDB
root 21556 21354 0 01:03 pts/0 00:00:00 grep --color=auto smon
[root@oraclelab1 ~]#
[root@oraclelab1 ~]# su - oracle
Last login: Thu Feb 1 00:34:23 IST 2024
[oracle@oraclelab1 ~]$ . oraenv
ORACLE_SID = [oracle] ? DEVDB
The Oracle base has been set to /u01/app/oracle
[oracle@oraclelab1 ~]$
[oracle@oraclelab1 ~]$ env |grep ORA
ORACLE_SID=DEVDB
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/dbhome_1
[oracle@oraclelab1 ~]$
[oracle@oraclelab1 ~]$
[oracle@oraclelab1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Feb 1 01:04:05 2024
Version 19.17.0.0.0
Copyright (c) 1982, 2022, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.17.0.0.0
SQL>
SQL> set pages 1000 lines 1000
SQL> col NAME for a30
SQL> col VALUE for a65
SQL> select * from v$diag_info;
INST_ID NAME VALUE CON_ID
---------- ------------------------------ ----------------------------------------------------------------- ----------
1 Diag Enabled TRUE 0
1 ADR Base /u01/app/oracle 0
1 ADR Home /u01/app/oracle/diag/rdbms/devdb/DEVDB 0
1 Diag Trace /u01/app/oracle/diag/rdbms/devdb/DEVDB/trace 0
1 Diag Alert /u01/app/oracle/diag/rdbms/devdb/DEVDB/alert 0
1 Diag Incident /u01/app/oracle/diag/rdbms/devdb/DEVDB/incident 0
1 Diag Cdump /u01/app/oracle/diag/rdbms/devdb/DEVDB/cdump 0
1 Health Monitor /u01/app/oracle/diag/rdbms/devdb/DEVDB/hm 0
1 Default Trace File /u01/app/oracle/diag/rdbms/devdb/DEVDB/trace/DEVDB_ora_21642.trc 0
1 Active Problem Count 2 0
1 Active Incident Count 3 0
1 ORACLE_HOME /u01/app/oracle/product/19.0.0.0/dbhome_1 0
12 rows selected.
SQL>
[oracle@oraclelab1 ~]$ env |grep ORA
ORACLE_SID=DEVDB
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/dbhome_1
[oracle@oraclelab1 ~]$ cd /u01/app/oracle
[oracle@oraclelab1 oracle]$ ll
total 12
drwxr-x---. 9 oracle oinstall 97 Dec 20 18:57 admin
drwxr-x---. 9 oracle oinstall 97 Dec 20 19:14 audit
drwxr-x---. 7 oracle oinstall 70 Aug 21 08:56 cfgtoollogs
drwxr-xr-x. 2 oracle oinstall 6 Mar 13 2023 checkpoints
drwxrwxr-x. 23 oracle oinstall 4096 Jul 11 2022 diag
drwxr-x---. 6 oracle oinstall 63 Dec 20 18:59 fast_recovery_area
drwxr-x---. 7 oracle oinstall 75 Dec 20 18:59 oradata
-rw-r--r--. 1 oracle oinstall 6732 Nov 7 09:47 PDB1.xml
drwxr-xr-x. 4 oracle oinstall 38 Aug 8 2022 product
[oracle@oraclelab1 oracle]$ cd diag
[oracle@oraclelab1 diag]$ ll
total 0
drwxrwxr-x. 2 oracle oinstall 6 Jul 11 2022 afdboot
drwxrwxr-x. 2 oracle oinstall 6 Jul 11 2022 apx
drwxrwxr-x. 2 oracle oinstall 6 Jul 11 2022 asm
drwxrwxr-x. 2 oracle oinstall 6 Jul 11 2022 asmcmd
drwxrwxr-x. 2 oracle oinstall 6 Jul 11 2022 asmtool
drwxrwxr-x. 2 oracle oinstall 6 Jul 11 2022 bdsql
drwxrwxr-x. 3 oracle oinstall 25 Sep 23 2022 clients
drwxrwxr-x. 2 oracle oinstall 6 Jul 11 2022 crs
drwxrwxr-x. 2 oracle oinstall 6 Jul 11 2022 diagtool
drwxrwxr-x. 2 oracle oinstall 6 Jul 11 2022 dps
drwxrwxr-x. 2 oracle oinstall 6 Jul 11 2022 em
drwxrwxr-x. 2 oracle oinstall 6 Jul 11 2022 gsm
drwxrwxr-x. 2 oracle oinstall 6 Jul 11 2022 ios
drwxrwxr-x. 2 oracle oinstall 6 Jul 11 2022 kfod
drwxrwxr-x. 2 oracle oinstall 6 Jul 11 2022 lsnrctl
drwxrwxr-x. 2 oracle oinstall 6 Jul 11 2022 netcman
drwxrwxr-x. 2 oracle oinstall 6 Jul 11 2022 ofm
drwxrwxr-x. 2 oracle oinstall 6 Jul 11 2022 plsql
drwxrwxr-x. 2 oracle oinstall 6 Jul 11 2022 plsqlapp
drwxrwxr-x. 9 oracle oinstall 97 Dec 20 18:57 rdbms
drwxrwxr-x. 3 oracle oinstall 24 Jul 19 2022 tnslsnr
[oracle@oraclelab1 diag]$ cd rdbms
[oracle@oraclelab1 rdbms]$ ll
total 0
drwxr-x---. 3 oracle oinstall 32 Aug 20 15:47 dev
drwxr-x---. 3 oracle oinstall 35 Nov 7 07:04 devcdb
drwxr-x---. 3 oracle oinstall 34 Jul 24 2023 devdb
drwxr-xr-x. 3 oracle oinstall 36 Dec 20 18:57 orclsba
drwxr-x---. 3 oracle oinstall 33 Aug 20 16:42 test
drwxr-x---. 3 oracle oinstall 36 Nov 7 07:23 testcdb
drwxr-x---. 3 oracle oinstall 32 Aug 20 16:47 uat
[oracle@oraclelab1 rdbms]$ cd devdb
[oracle@oraclelab1 devdb]$ ll
total 4
drwxr-x---. 16 oracle oinstall 4096 Jul 24 2023 DEVDB
-rw-r-----. 1 oracle oinstall 0 Jul 24 2023 i_1.mif
[oracle@oraclelab1 devdb]$ cd DEVDB
[oracle@oraclelab1 DEVDB]$ ll
total 76
drwxr-x---. 2 oracle oinstall 55 Jan 25 09:30 alert
drwxr-x---. 2 oracle oinstall 6 Jul 24 2023 cdump
drwxr-x---. 2 oracle oinstall 6 Jul 24 2023 hm
drwxr-x---. 5 oracle oinstall 66 Oct 26 08:37 incident
drwxr-x---. 2 oracle oinstall 6 Jul 24 2023 incpkg
drwxr-x---. 2 oracle oinstall 34 Sep 30 08:38 ir
drwxr-x---. 2 oracle oinstall 4096 Oct 26 08:37 lck
drwxr-x---. 8 oracle oinstall 4096 Oct 26 07:49 log
drwxr-x---. 2 oracle oinstall 4096 Jul 24 2023 metadata
drwxr-x---. 2 oracle oinstall 6 Jul 24 2023 metadata_dgif
drwxr-x---. 2 oracle oinstall 6 Jul 24 2023 metadata_pv
drwxr-x---. 2 oracle oinstall 4096 Oct 26 08:37 stage
drwxr-x---. 2 oracle oinstall 6 Oct 26 08:37 sweep
drwxr-x---. 17 oracle oinstall 630784 Feb 1 00:44 trace
[oracle@oraclelab1 DEVDB]$ cd trace
[oracle@oraclelab1 trace]$ ls -ltr alert_DEVDB.log
-rw-r-----. 1 oracle oinstall 1665888 Feb 1 00:44 alert_DEVDB.log
[oracle@oraclelab1 trace]$
[oracle@oraclelab1 trace]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Feb 1 01:09:33 2024
Version 19.17.0.0.0
Copyright (c) 1982, 2022, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.17.0.0.0
SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.
Total System Global Area 3690985856 bytes
Fixed Size 8903040 bytes
Variable Size 889192448 bytes
Database Buffers 2785017856 bytes
Redo Buffers 7872512 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.17.0.0.0
[oracle@oraclelab1 trace]$
[root@oraclelab1 ~]# cd /u01/app/oracle/diag/rdbms/devdb/DEVDB/trace
[root@oraclelab1 trace]# ls -ltr alert_DEVDB.log
-rw-r-----. 1 oracle oinstall 1665888 Feb 1 00:44 alert_DEVDB.log
[root@oraclelab1 trace]#
[root@oraclelab1 trace]# locate alert_DEVDB.log
/u01/app/oracle/diag/rdbms/devdb/DEVDB/trace/alert_DEVDB.log
/u01/app/oracle/product/19.0.0.0/dbhome_1/rdbms/log/alert_DEVDB.log
[root@oraclelab1 trace]#
[root@oraclelab1 trace]# tail -f /u01/app/oracle/diag/rdbms/devdb/DEVDB/trace/alert_DEVDB.log
34177775,34184266,34201893,34202416,34202636,34208046,34208548,34211888,
34246296,34270679,34273582,34291960,34293849,34295122,34311758,34314261,
34315159,34339952,34461889,34467154,34467707,34507132,34510212,34534868,
34613266,34621704
===========================================================
2024-02-01T00:44:12.135606+05:30
db_recovery_file_dest_size of 20480 MB is 47.17% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
2024-02-01T01:09:37.284396+05:30
Shutting down ORACLE instance (immediate) (OS id: 21970)
2024-02-01T01:09:37.284514+05:30
Shutdown is initiated by sqlplus@oraclelab1.localdomain.com (TNS V1-V3).
2024-02-01T01:09:38.681622+05:30
Stopping background process SMCO
2024-02-01T01:09:39.695626+05:30
Shutting down instance: further logons disabled
2024-02-01T01:09:39.708193+05:30
Stopping background process CJQ0
Stopping background process MMNL
2024-02-01T01:09:40.789994+05:30
Stopping background process MMON
2024-02-01T01:09:42.831977+05:30
License high water mark = 4
2024-02-01T01:09:42.905188+05:30
Dispatchers and shared servers shutdown
Data Pump shutdown on PDB: 0 in progress
ALTER DATABASE CLOSE NORMAL
Stopping Emon pool
2024-02-01T01:09:43.955227+05:30
IM on ADG: Start of Empty Journal
IM on ADG: End of Empty Journal
Stopping Emon pool
Closing sequence subsystem (5323004488970).
Stopping change tracking
2024-02-01T01:09:44.017410+05:30
Shutting down archive processes
2024-02-01T01:09:44.017883+05:30
TT00 (PID:19705): Gap Manager exiting
2024-02-01T01:09:45.017817+05:30
Archiving is disabled
2024-02-01T01:09:45.018333+05:30
ARC2 (PID:19713): ARCH shutting down
ARC2 (PID:19713): Archival stopped
2024-02-01T01:09:45.019240+05:30
ARC1 (PID:19711): ARCH shutting down
ARC1 (PID:19711): Archival stopped
2024-02-01T01:09:45.020187+05:30
ARC0 (PID:19703): ARCH shutting down
ARC0 (PID:19703): Archival stopped
2024-02-01T01:09:45.021963+05:30
ARC3 (PID:19715): ARCH shutting down
2024-02-01T01:09:45.022041+05:30
ARC3 (PID:19715): Archival stopped
2024-02-01T01:09:46.018662+05:30
Thread 1 closed at log sequence 282
Successful close of redo thread 1
2024-02-01T01:09:46.066911+05:30
Completed: ALTER DATABASE CLOSE NORMAL
ALTER DATABASE DISMOUNT
Shutting down archive processes
Archiving is disabled
Completed: ALTER DATABASE DISMOUNT
2024-02-01T01:09:46.081379+05:30
.... (PID:21970): Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
2024-02-01T01:09:47.082565+05:30
JIT: pid 21970 requesting stop
2024-02-01T01:09:47.083149+05:30
Stopping background process VKTM
2024-02-01T01:09:47.120850+05:30
.... (PID:21970): Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
JIT: pid 21970 requesting stop
2024-02-01T01:09:54.916992+05:30
Instance shutdown complete (OS id: 21970)
2024-02-01T01:10:03.244965+05:30
Starting ORACLE instance (normal) (OS id: 22003)
2024-02-01T01:10:03.250206+05:30
****************************************************
Sys-V shared memory will be used for creating SGA
****************************************************
2024-02-01T01:10:03.251190+05:30
**********************************************************************
2024-02-01T01:10:03.251244+05:30
Dump of system resources acquired for SHARED GLOBAL AREA (SGA)
2024-02-01T01:10:03.251335+05:30
Per process system memlock (soft) limit = 128G
2024-02-01T01:10:03.251385+05:30
Expected per process system memlock (soft) limit to lock
instance MAX SHARED GLOBAL AREA (SGA) into memory: 3522M
2024-02-01T01:10:03.251468+05:30
Available system pagesizes:
4K, 2048K
2024-02-01T01:10:03.251560+05:30
Supported system pagesize(s):
2024-02-01T01:10:03.251603+05:30
PAGESIZE AVAILABLE_PAGES EXPECTED_PAGES ALLOCATED_PAGES ERROR(s)
2024-02-01T01:10:03.251647+05:30
4K Configured 9 901129 NONE
2024-02-01T01:10:03.251749+05:30
2048K 0 1761 0 NONE
2024-02-01T01:10:03.251792+05:30
RECOMMENDATION:
2024-02-01T01:10:03.251835+05:30
1. For optimal performance, configure system with expected number
of pages for every supported system pagesize prior to the next
instance restart operation.
2024-02-01T01:10:03.258101+05:30
**********************************************************************
2024-02-01T01:10:06.302980+05:30
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
2024-02-01T01:10:06.346222+05:30
Initial number of CPU is 2
Number of processor cores in the system is 2
Number of processor sockets in the system is 2
Capability Type : Network
capabilities requested : 7 detected : 0 Simulated : 0
Capability Type : Runtime Environment
capabilities requested : 400000FF detected : 40000000 Simulated : 0
Capability Type : Engineered Systems
capabilities requested : F detected : 0 Simulated : 0
Capability Type : Database Test
capabilities requested : 3 detected : 0 Simulated : 0
Capability Type : Database Editions
capabilities requested : 1CC detected : 8 Simulated : 0
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
.... (PID:): Enable RFS client [kcrlc.c:601]
Autotune of undo retention is turned on.
IMODE=BR
ILAT =55
LICENSE_MAX_USERS = 0
SYS auditing is enabled
NOTE: remote asm mode is local (mode 0x1; from cluster type)
NOTE: Using default ASM root directory ASM
NOTE: remote asm mode is local (mode 0x1; from cluster type)
NOTE: Cluster configuration type = NONE [2]
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.17.0.0.0.
ORACLE_HOME: /u01/app/oracle/product/19.0.0.0/dbhome_1
System name: Linux
Node name: oraclelab1.localdomain.com
Release: 5.4.17-2102.201.3.el7uek.x86_64
Version: #2 SMP Fri Apr 23 09:05:55 PDT 2021
Machine: x86_64
Using parameter settings in server-side spfile /u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/spfileDEVDB.ora
System parameters with non-default values:
processes = 320
nls_language = "AMERICAN"
nls_territory = "AMERICA"
service_names = "MALLIK"
sga_target = 3520M
control_files = "/u01/app/oracle/oradata/DEVDB/controlfile/o1_mf_lcx8xtjt_.ctl"
control_files = "/u01/app/oracle/fast_recovery_area/DEVDB/controlfile/o1_mf_lcx8xtm8_.ctl"
db_block_size = 8192
db_16k_cache_size = 112M
compatible = "19.0.0"
log_archive_format = "%t_%s_%r.dbf"
db_create_file_dest = "/u01/app/oracle/oradata"
db_recovery_file_dest = "/u01/app/oracle/fast_recovery_area"
db_recovery_file_dest_size= 20G
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
dispatchers = "(PROTOCOL=TCP) (SERVICE=DEVDBXDB)"
local_listener = ""
audit_file_dest = "/u01/app/oracle/admin/DEVDB/adump"
audit_trail = "DB"
db_name = "DEVDB"
open_cursors = 380
pga_aggregate_target = 1169M
diagnostic_dest = "/u01/app/oracle"
2024-02-01T01:10:06.678641+05:30
============================================================
NOTE: PatchLevel of this instance 0
============================================================
Starting background process PMON
2024-02-01T01:10:06.702555+05:30
PMON started with pid=2, OS id=22027
Starting background process CLMN
2024-02-01T01:10:06.716987+05:30
CLMN started with pid=3, OS id=22031
Starting background process PSP0
2024-02-01T01:10:06.731368+05:30
PSP0 started with pid=4, OS id=22035
Starting background process VKTM
2024-02-01T01:10:07.815221+05:30
VKTM started with pid=5, OS id=22040 at elevated (RT) priority
2024-02-01T01:10:07.815295+05:30
Starting background process GEN0
2024-02-01T01:10:07.816623+05:30
VKTM running at (1)millisec precision with DBRM quantum (100)ms
2024-02-01T01:10:07.831323+05:30
GEN0 started with pid=6, OS id=22046
Starting background process MMAN
2024-02-01T01:10:07.846745+05:30
MMAN started with pid=7, OS id=22050
Starting background process GEN1
2024-02-01T01:10:07.887455+05:30
GEN1 started with pid=9, OS id=22056_22057
Starting background process DIAG
2024-02-01T01:10:07.901587+05:30
DIAG started with pid=11, OS id=22059
Starting background process OFSD
2024-02-01T01:10:07.920450+05:30
OFSD started with pid=12, OS id=22061_22062
2024-02-01T01:10:07.921390+05:30
Oracle running with ofslib:'Oracle File Server Library' version=2 inc=1
Starting background process DBRM
2024-02-01T01:10:07.937151+05:30
DBRM started with pid=14, OS id=22064
Starting background process VKRM
2024-02-01T01:10:07.950982+05:30
VKRM started with pid=15, OS id=22068
Starting background process SVCB
2024-02-01T01:10:07.965506+05:30
SVCB started with pid=16, OS id=22070
Starting background process PMAN
2024-02-01T01:10:07.984201+05:30
PMAN started with pid=17, OS id=22072
Starting background process DIA0
2024-02-01T01:10:07.996694+05:30
DIA0 started with pid=18, OS id=22076
Starting background process DBW0
2024-02-01T01:10:08.020559+05:30
DBW0 started with pid=19, OS id=22078
Starting background process LGWR
2024-02-01T01:10:08.034749+05:30
LGWR started with pid=20, OS id=22082
2024-02-01T01:10:08.047463+05:30
LGWR slave LG00 created with pid=21, OS pid=22086
Starting background process CKPT
2024-02-01T01:10:08.060806+05:30
CKPT started with pid=22, OS id=22088
LGWR slave LG01 created with pid=23, OS pid=22092
Starting background process SMON
2024-02-01T01:10:08.086787+05:30
SMON started with pid=24, OS id=22094
Starting background process SMCO
2024-02-01T01:10:08.098737+05:30
SMCO started with pid=25, OS id=22098
Starting background process RECO
2024-02-01T01:10:08.122677+05:30
RECO started with pid=27, OS id=22102
Starting background process LREG
2024-02-01T01:10:08.149749+05:30
LREG started with pid=29, OS id=22106
Starting background process PXMN
2024-02-01T01:10:08.163473+05:30
PXMN started with pid=30, OS id=22110
Starting background process FENC
2024-02-01T01:10:08.177741+05:30
FENC started with pid=31, OS id=22112
Starting background process MMON
2024-02-01T01:10:08.198829+05:30
MMON started with pid=31, OS id=22116
Starting background process MMNL
2024-02-01T01:10:08.211057+05:30
MMNL started with pid=32, OS id=22118
2024-02-01T01:10:08.212244+05:30
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Starting background process TMON
2024-02-01T01:10:08.253128+05:30
TMON started with pid=35, OS id=22124
ORACLE_BASE from environment = /u01/app/oracle
2024-02-01T01:10:08.373970+05:30
ALTER DATABASE MOUNT
2024-02-01T01:10:10.993502+05:30
Using default pga_aggregate_limit of 2338 MB
2024-02-01T01:10:12.414035+05:30
.... (PID:22125): Redo network throttle feature is disabled at mount time
2024-02-01T01:10:12.429236+05:30
Successful mount of redo thread 1, with mount id 1064474992
2024-02-01T01:10:12.429946+05:30
Database mounted in Exclusive Mode
Lost write protection disabled
.... (PID:22125): Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST [krsd.c:18237]
Completed: ALTER DATABASE MOUNT
2024-02-01T01:10:12.496834+05:30
ALTER DATABASE OPEN
Smart fusion block transfer is disabled:
instance mounted in exclusive mode.
Endian type of dictionary set to little
2024-02-01T01:10:12.514121+05:30
LGWR (PID:22082): STARTING ARCH PROCESSES
2024-02-01T01:10:12.529351+05:30
TT00 (PID:22138): Gap Manager starting
Starting background process ARC0
2024-02-01T01:10:12.541811+05:30
ARC0 started with pid=39, OS id=22140
2024-02-01T01:10:12.552390+05:30
LGWR (PID:22082): ARC0: Archival started
LGWR (PID:22082): STARTING ARCH PROCESSES COMPLETE
2024-02-01T01:10:12.553430+05:30
ARC0 (PID:22140): Becoming a 'no FAL' ARCH
ARC0 (PID:22140): Becoming the 'no SRL' ARCH
2024-02-01T01:10:12.554979+05:30
TMON (PID:22124): STARTING ARCH PROCESSES
Starting background process ARC1
2024-02-01T01:10:12.558073+05:30
Redo log for group 3, sequence 282 is not located on DAX storage
2024-02-01T01:10:12.566733+05:30
ARC1 started with pid=41, OS id=22144
Starting background process ARC2
Thread 1 opened at log sequence 282
Current log# 3 seq# 282 mem# 0: /u01/app/oracle/oradata/DEVDB/onlinelog/o1_mf_3_lcx8xwwk_.log
Current log# 3 seq# 282 mem# 1: /u01/app/oracle/fast_recovery_area/DEVDB/onlinelog/o1_mf_3_lcx8xxnx_.log
Successful open of redo thread 1
2024-02-01T01:10:12.579051+05:30
ARC2 started with pid=42, OS id=22146
Starting background process ARC3
2024-02-01T01:10:12.580861+05:30
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Stopping change tracking
2024-02-01T01:10:12.593098+05:30
ARC3 started with pid=43, OS id=22148
2024-02-01T01:10:12.594055+05:30
TMON (PID:22124): ARC1: Archival started
TMON (PID:22124): ARC2: Archival started
TMON (PID:22124): ARC3: Archival started
TMON (PID:22124): STARTING ARCH PROCESSES COMPLETE
2024-02-01T01:10:12.679038+05:30
Undo initialization recovery: Parallel FPTR complete: start:1028065909 end:1028065910 diff:1 ms (0.0 seconds)
Undo initialization recovery: err:0 start: 1028065909 end: 1028065910 diff: 1 ms (0.0 seconds)
[22136] Successfully onlined Undo Tablespace 2.
Undo initialization online undo segments: err:0 start: 1028065911 end: 1028065938 diff: 27 ms (0.0 seconds)
Undo initialization finished serial:0 start:1028065909 end:1028065942 diff:33 ms (0.0 seconds)
Database Characterset is AL32UTF8
No Resource Manager plan active
joxcsys_required_dirobj_exists: directory object exists with required path /u01/app/oracle/product/19.0.0.0/dbhome_1/javavm/admin/, pid 22136 cid 0
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process AQPC
2024-02-01T01:10:13.199828+05:30
AQPC started with pid=45, OS id=22154
Starting background process CJQ0
Completed: ALTER DATABASE OPEN
2024-02-01T01:10:13.440968+05:30
CJQ0 started with pid=48, OS id=22160
2024-02-01T01:10:14.079880+05:30
QPI: opatch file present, opatch
QPI: qopiprep.bat file present
2024-02-01T01:10:16.845870+05:30
Setting Resource Manager plan SCHEDULER[0x4D54]:DEFAULT_MAINTENANCE_PLAN via scheduler window
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
2024-02-01T01:10:20.368699+05:30
===========================================================
Dumping current patch information
===========================================================
Patch Id: 34419443
Patch Description: Database Release Update : 19.17.0.0.221018 (34419443)
Patch Apply Time: 2023-11-15T08:34:15+05:30
Bugs Fixed: 1297945,7391838,8460502,8476681,9002767,10123661,14570574,14735102,
15931756,15959416,16662822,16664572,16750494,17275499,17395507,17428816,
<<<<<<<<<<<<<<<<truncated>>>>>>>>>>>>>>>>>>>>>
<<<<<<<<<<<<<<<<truncated>>>>>>>>>>>>>>>>>>>>>
34613266,34621704
===========================================================
2024-02-01T01:10:20.793648+05:30
db_recovery_file_dest_size of 20480 MB is 47.17% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Regards,
Mallik
No comments:
Post a Comment