网站制作培训多少钱,怎么跟客户介绍网站建设,督查营商环境建设网站,机械公司简介模板Oracle数据库的启动#xff0c;其概念可参考Overview of Instance and Database Startup。
其过程可参见下图#xff1a; 当数据库从关闭状态进入打开数据库状态时#xff0c;它会经历以下阶段。
阶段Mount状态描述1实例在没有挂载数据库的情况下启动实例已启动#xff…Oracle数据库的启动其概念可参考Overview of Instance and Database Startup。
其过程可参见下图 当数据库从关闭状态进入打开数据库状态时它会经历以下阶段。
阶段Mount状态描述1实例在没有挂载数据库的情况下启动实例已启动但尚未与数据库关联。2数据库挂载实例启动并通过读取其控制文件与数据库相关联。 数据库对用户关闭。3数据库打开实例已启动并与打开的数据库相关联。 数据文件中包含的数据可供授权用户访问。
下面我们将通过示例来详细了解数据库的启动过程。
基本概念
启动的第一步是寻找spfileSPFILE 文件名为 spfileSID.ora位于ORACLE_HOME/database 目录中。
我们知道spfile是包含了control file的位置的因此启动的顺序也是先读spfile然后会读control file。
spfile和control file都是二进制文件。
获取文本形式的spfile可以
create pfilexxx from spfile;获取文本形式的control file可以
alter database backup controlfile to trace;数据库启动涉及的文件
SQL show parameter spfile
NAME TYPE VALUE
------ ------ ------------------------------------------------------
spfile string /opt/oracle/product/19c/dbhome_1/dbs/spfileORCLCDB.oraSQL show parameter control_files
NAME TYPE VALUE
------------- ------ ------------------------------------------------------------------------------------
control_files string /opt/oracle/oradata/ORCLCDB/control01.ctl, /opt/oracle/oradata/ORCLCDB/control02.ctlSQL select name from v$datafile;NAME
--------------------------------------------------------------------------------
/opt/oracle/oradata/ORCLCDB/system01.dbf
/opt/oracle/oradata/ORCLCDB/sysaux01.dbf
/opt/oracle/oradata/ORCLCDB/undotbs01.dbf
/opt/oracle/oradata/ORCLCDB/pdbseed/system01.dbf
/opt/oracle/oradata/ORCLCDB/pdbseed/sysaux01.dbf
/opt/oracle/oradata/ORCLCDB/users01.dbf
...SQL select member from v$logfile;MEMBER
--------------------------------------------------------------------------------
/opt/oracle/oradata/ORCLCDB/redo03.log
/opt/oracle/oradata/ORCLCDB/redo02.log
/opt/oracle/oradata/ORCLCDB/redo01.log为了简单我们只采用以下4个文件的状态
spfilecontrol file/opt/oracle/oradata/ORCLCDB/control01.ctldata file/opt/oracle/oradata/ORCLCDB/system01.dbfredo log file/opt/oracle/oradata/ORCLCDB/redo01.log
初始状态数据库处于关闭状态
记录一下几个文件的时间戳。包括atime, mtime和ctime。
$ stat /opt/oracle/product/19c/dbhome_1/dbs/spfileORCLCDB.oraFile: ‘/opt/oracle/product/19c/dbhome_1/dbs/spfileORCLCDB.ora’Size: 3584 Blocks: 8 IO Block: 4096 regular file
Device: fc00h/64512d Inode: 147838129 Links: 1
Access: (0640/-rw-r-----) Uid: (54321/ oracle) Gid: (54321/oinstall)
Context: unconfined_u:object_r:usr_t:s0
Access: 2024-01-08 22:39:40.758879960 0800
Modify: 2024-01-08 22:27:21.718465002 0800
Change: 2024-01-08 22:27:21.718465002 0800Birth: -$ stat /opt/oracle/oradata/ORCLCDB/control01.ctlFile: ‘/opt/oracle/oradata/ORCLCDB/control01.ctl’Size: 18726912 Blocks: 36576 IO Block: 4096 regular file
Device: fc00h/64512d Inode: 139684770 Links: 1
Access: (0640/-rw-r-----) Uid: (54321/ oracle) Gid: (54321/oinstall)
Context: unconfined_u:object_r:usr_t:s0
Access: 2024-01-08 22:41:25.153574355 0800
Modify: 2024-01-08 22:41:25.179574414 0800
Change: 2024-01-08 22:41:25.179574414 0800Birth: -$ stat /opt/oracle/oradata/ORCLCDB/system01.dbfFile: ‘/opt/oracle/oradata/ORCLCDB/system01.dbf’Size: 954212352 Blocks: 1863704 IO Block: 4096 regular file
Device: fc00h/64512d Inode: 139684766 Links: 1
Access: (0640/-rw-r-----) Uid: (54321/ oracle) Gid: (54321/oinstall)
Context: unconfined_u:object_r:usr_t:s0
Access: 2024-01-08 22:41:24.812573601 0800
Modify: 2024-01-08 22:41:24.816573610 0800
Change: 2024-01-08 22:41:24.816573610 0800Birth: -在以上时间中atime是文件最后被访问的时间如读取。mtime和ctime容易混淆前者指文件内容被修改后者指文件元数据被修改。 在ls命令中-t显示mtime-u显示atime-c显示ctime不过stat命令更清晰些。
然后目前并没有共享内存被分配。
$ ipcs -a------ Message Queues --------
key msqid owner perms used-bytes messages------ Shared Memory Segments --------
key shmid owner perms bytes nattch status------ Semaphore Arrays --------
key semid owner perms nsems$ ps -ef|grep smon|grep -v grep数据库实例已启动 阶段1
根据文档How an Instance Is Started启动实例的过程如下
搜索服务器参数文件SPFILE读取服务器参数文件以确定初始化参数的值根据初始化参数设置分配SGA启动 Oracle 后台进程打开警报日志和跟踪文件并以有效的参数语法将所有显式参数设置写入警报日志
相关命令为
-- 数据库从关闭状态进入实例启动状态
SQL STARTUP NOMOUNT
ORACLE instance started.Total System Global Area 1207955552 bytes
Fixed Size 9134176 bytes
Variable Size 603979776 bytes
Database Buffers 587202560 bytes
Redo Buffers 7639040 bytes来看一下相关变化。
首先spfile被读取了虽然其没有被改动。
$ stat /opt/oracle/product/19c/dbhome_1/dbs/spfileORCLCDB.oraFile: ‘/opt/oracle/product/19c/dbhome_1/dbs/spfileORCLCDB.ora’Size: 3584 Blocks: 8 IO Block: 4096 regular file
Device: fc00h/64512d Inode: 147838129 Links: 1
Access: (0640/-rw-r-----) Uid: (54321/ oracle) Gid: (54321/oinstall)
Context: unconfined_u:object_r:usr_t:s0
Access: 2024-01-08 22:39:40.758879960 0800
Modify: 2024-01-08 22:27:21.718465002 0800
Change: 2024-01-08 22:27:21.718465002 0800Birth: -控制文件和数据文件都没有被读取毕竟数据库还没有被mount。
$ stat /opt/oracle/oradata/ORCLCDB/control01.ctlFile: ‘/opt/oracle/oradata/ORCLCDB/control01.ctl’Size: 18726912 Blocks: 36576 IO Block: 4096 regular file
Device: fc00h/64512d Inode: 139684770 Links: 1
Access: (0640/-rw-r-----) Uid: (54321/ oracle) Gid: (54321/oinstall)
Context: unconfined_u:object_r:usr_t:s0
Access: 2024-01-08 22:41:25.153574355 0800
Modify: 2024-01-08 22:41:25.179574414 0800
Change: 2024-01-08 22:41:25.179574414 0800Birth: -$ stat /opt/oracle/oradata/ORCLCDB/system01.dbfFile: ‘/opt/oracle/oradata/ORCLCDB/system01.dbf’Size: 954212352 Blocks: 1863704 IO Block: 4096 regular file
Device: fc00h/64512d Inode: 139684766 Links: 1
Access: (0640/-rw-r-----) Uid: (54321/ oracle) Gid: (54321/oinstall)
Context: unconfined_u:object_r:usr_t:s0
Access: 2024-01-08 22:41:24.812573601 0800
Modify: 2024-01-08 22:41:24.816573610 0800
Change: 2024-01-08 22:41:24.816573610 0800Birth: -尽管数据库没有启动但内存确实分配了这也说明SGA等内存组件实际是实例的特性
$ ipcs -a------ Message Queues --------
key msqid owner perms used-bytes messages------ Shared Memory Segments --------
key shmid owner perms bytes nattch status
0x00000000 4 oracle 600 9138176 64
0x00000000 5 oracle 600 1191182336 32
0x00000000 6 oracle 600 7639040 32
0x43b375cc 7 oracle 600 12288 32------ Semaphore Arrays --------
key semid owner perms nsems
0x8d2a3534 10 oracle 600 250
0x8d2a3535 11 oracle 600 250对照以下SGA的信息
SQL select * from v$sga;NAME VALUE CON_ID
-------------------- ---------- ----------
Fixed Size 9134176 0
Variable Size 603979776 0
Database Buffers 587202560 0
Redo Buffers 7639040 0Fixed Size对应ipcs输出中的shmid 4Variable SizeDatabase Buffers等于1191182336对应ipcs输出中的shmid 5Redo Buffers对应ipcs输出中的shmid 6。
关于Fixed Size和Variable Size参见What are Fixed Size and Variable Size of SGA indicative of and how do we calculate them?
后台进程启动了
$ ps -ef|grep smon|grep -v grep
oracle 20677 1 0 22:51 ? 00:00:00 ora_smon_ORCLCDB这个阶段管理员还不能对数据库进行操作
SQL select open_mode from v$database;
select open_mode from v$database*
ERROR at line 1:
ORA-01507: database not mounted数据库已挂载阶段2
根据文档How a Database Is Mounted在这一阶段Oracle挂载一个数据库并与数据库实例关联。如果是RAC配置一个数据库可以与多个数据库实例关联。
实例通过CONTROL_FILES初始化参数获取控制文件的位置并将其打开。在控制文件中可以获取数据文件和在线重做日志文件的位置。
在这一阶段数据库仍然是关闭的管理员可以做一些特定的数据库维护操作。
相关命令为
-- 数据库从关闭状态直接进入数据库挂载状态
SQL STARTUP MOUNT
-- 数据库从NOMOUNT状态进入数据库挂载状态
SQL ALTER DATABASE MOUNT;
Database altered.来看一下和上一阶段想比发生了什么变化。
首先管理员已经可以访问数据库进行管理操作但访问用户数据还是不行的
SQL select open_mode from v$database;OPEN_MODE
--------------------
MOUNTEDSQL select * from hr.employees;
select * from hr.employees*
ERROR at line 1:
ORA-01219: database or pluggable database not open: queries allowed on fixed
tables or views onlyspfile被修改了而在上一阶段仅仅被读取。control file被修改了而在上一阶段没有被访问。
$ stat /opt/oracle/product/19c/dbhome_1/dbs/spfileORCLCDB.oraFile: ‘/opt/oracle/product/19c/dbhome_1/dbs/spfileORCLCDB.ora’Size: 3584 Blocks: 8 IO Block: 4096 regular file
Device: fc00h/64512d Inode: 147838129 Links: 1
Access: (0640/-rw-r-----) Uid: (54321/ oracle) Gid: (54321/oinstall)
Context: unconfined_u:object_r:usr_t:s0
Access: 2024-01-08 23:04:55.733604697 0800
Modify: 2024-01-08 23:04:55.744604708 0800
Change: 2024-01-08 23:04:55.744604708 0800Birth: -$ stat /opt/oracle/oradata/ORCLCDB/control01.ctlFile: ‘/opt/oracle/oradata/ORCLCDB/control01.ctl’Size: 18726912 Blocks: 36576 IO Block: 4096 regular file
Device: fc00h/64512d Inode: 139684770 Links: 1
Access: (0640/-rw-r-----) Uid: (54321/ oracle) Gid: (54321/oinstall)
Context: unconfined_u:object_r:usr_t:s0
Access: 2024-01-08 23:14:05.202142083 0800
Modify: 2024-01-08 23:14:05.189142070 0800
Change: 2024-01-08 23:14:05.189142070 0800Birth: -数据文件仍没有被读取
$ stat /opt/oracle/oradata/ORCLCDB/system01.dbfFile: ‘/opt/oracle/oradata/ORCLCDB/system01.dbf’Size: 954212352 Blocks: 1863704 IO Block: 4096 regular file
Device: fc00h/64512d Inode: 139684766 Links: 1
Access: (0640/-rw-r-----) Uid: (54321/ oracle) Gid: (54321/oinstall)
Context: unconfined_u:object_r:usr_t:s0
Access: 2024-01-08 22:41:24.812573601 0800
Modify: 2024-01-08 22:41:24.816573610 0800
Change: 2024-01-08 22:41:24.816573610 0800Birth: -数据库仍然是关闭的但可以做一些维护工作
SQL show con_nameCON_NAME
------------------------------
CDB$ROOT
SQL show pdbsCON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------2 PDB$SEED MOUNTED3 ORCLPDB1 MOUNTED4 ORCLPDB2 MOUNTED目前为止redo log也没有被读取
$ stat /opt/oracle/oradata/ORCLCDB/redo01.logFile: ‘/opt/oracle/oradata/ORCLCDB/redo01.log’Size: 209715712 Blocks: 409616 IO Block: 4096 regular file
Device: fc00h/64512d Inode: 139684773 Links: 1
Access: (0640/-rw-r-----) Uid: (54321/ oracle) Gid: (54321/oinstall)
Context: unconfined_u:object_r:usr_t:s0
Access: 2024-01-08 22:27:23.244467670 0800
Modify: 2024-01-08 22:27:23.252467684 0800
Change: 2024-01-08 22:27:23.252467684 0800Birth: -数据库已打开阶段3
根据文档How a Database Is Opened在这一阶段普通的用户就可以访问数据库进行增删改查了。
打开数据库时Oracle 数据库执行以下操作
打开除撤销表空间以外的表空间中的在线数据文件 如果之前关闭数据库时表空间处于脱机状态那么当数据库重新打开时该表空间及其相应的数据文件将处于脱机状态。获取一个撤销表空间打开在线重做日志文件
相关命令为
-- 数据库从关闭状态直接进入数据库打开状态
SQL STARTUP OPEN
-- 数据库从NOMOUNT状态进入数据库挂载状态
SQL ALTER DATABASE OPEN;Database altered.这一阶段数据文件和redo log都被读取和修改了
$ stat /opt/oracle/oradata/ORCLCDB/system01.dbfFile: ‘/opt/oracle/oradata/ORCLCDB/system01.dbf’Size: 954212352 Blocks: 1863704 IO Block: 4096 regular file
Device: fc00h/64512d Inode: 139684766 Links: 1
Access: (0640/-rw-r-----) Uid: (54321/ oracle) Gid: (54321/oinstall)
Context: unconfined_u:object_r:usr_t:s0
Access: 2024-01-08 23:24:32.182755204 0800
Modify: 2024-01-08 23:24:32.077755101 0800
Change: 2024-01-08 23:24:32.077755101 0800Birth: -$ stat /opt/oracle/oradata/ORCLCDB/redo01.logFile: ‘/opt/oracle/oradata/ORCLCDB/redo01.log’Size: 209715712 Blocks: 409616 IO Block: 4096 regular file
Device: fc00h/64512d Inode: 139684773 Links: 1
Access: (0640/-rw-r-----) Uid: (54321/ oracle) Gid: (54321/oinstall)
Context: unconfined_u:object_r:usr_t:s0
Access: 2024-01-08 23:24:32.020755046 0800
Modify: 2024-01-08 23:24:32.026755051 0800
Change: 2024-01-08 23:24:32.026755051 0800Birth: -此时数据库处于可读写状态业务用户可以访问数据库了
SQL select open_mode from v$database;OPEN_MODE
--------------------
READ WRITE查询实例启动时间
当前启动时间
SQL alter session set nls_date_formatyyyy-mm-dd hh24:mi:ss;Session altered.SQL select startup_time from v$instance;STARTUP_TIME
-------------------
2024-01-09 11:34:52历史启动时间1月8日晚上那几个是做本次实验的时间
SQL SELECT STARTUP_TIME FROM dba_hist_database_instance ORDER BY startup_time DESC;STARTUP_TIME
---------------------------------------------------------------------------
09-JAN-24 11.35.06.000 AM
08-JAN-24 11.24.32.000 PM
08-JAN-24 10.27.23.000 PM
15-DEC-23 09.50.18.000 AM
22-NOV-23 09.27.57.000 AM详细的启动日志可以从alert log中找到。
来看一下从close到nomount 数据库的这一段日志也就是启动实例的日志
2024-01-08T22:26:51.21675608:00
Starting ORACLE instance (normal) (OS id: 18596)
2024-01-08T22:26:51.41527408:00
****************************************************Sys-V shared memory will be used for creating SGA****************************************************
2024-01-08T22:26:51.42158108:00
**********************************************************************
2024-01-08T22:26:51.42177708:00
Dump of system resources acquired for SHARED GLOBAL AREA (SGA)2024-01-08T22:26:51.42209108:00Per process system memlock (soft) limit 128G
2024-01-08T22:26:51.42219708:00Expected per process system memlock (soft) limit to lockinstance MAX SHARED GLOBAL AREA (SGA) into memory: 1154M
...
2024-01-08T22:26:54.32178608:00
Initial number of CPU is 2
Number of processor cores in the system is 2
Number of processor sockets in the system is 1
...
2024-01-08T22:26:56.20123008:00
NOTE: remote asm mode is local (mode 0x1; from cluster type)
2024-01-08T22:26:57.06094208:00
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.3.0.0.0.
ORACLE_HOME: /opt/oracle/product/19c/dbhome_1
System name: Linux
Node name: oracle-19c-vagrant
Release: 5.4.17-2136.323.8.2.el7uek.x86_64
Version: #2 SMP Wed Sep 20 00:06:39 PDT 2023
Machine: x86_64
Using parameter settings in server-side spfile /opt/oracle/product/19c/dbhome_1/dbs/spfileORCLCDB.ora
System parameters with non-default values:processes 300nls_language AMERICANnls_territory AMERICAfilesystemio_options setallsga_target 1152Mcontrol_files /opt/oracle/oradata/ORCLCDB/control01.ctlcontrol_files /opt/oracle/oradata/ORCLCDB/control02.ctldb_block_size 8192compatible 19.0.0db_create_file_dest /u02/oradataundo_tablespace UNDOTBS1remote_login_passwordfile EXCLUSIVEaudit_sys_operations FALSEwallet_root /opt/oracle/wallettde_configuration keystore_configurationfiledispatchers (PROTOCOLTCP) (SERVICEORCLCDBXDB)local_listener (ADDRESS (PROTOCOL TCP)(HOST 0.0.0.0)(PORT 1521))audit_file_dest /opt/oracle/admin/ORCLCDB/adumpcommit_wait nowaitcommit_logging batchaudit_trail NONEdb_name ORCLCDBopen_cursors 300pga_aggregate_target 384Mmax_string_size EXTENDEDdiagnostic_dest /opt/oracleenable_pluggable_database TRUE
2024-01-08T22:26:57.27247108:00NOTE: PatchLevel of this instance 02024-01-08T22:27:00.84536608:00
Starting background process PMON
2024-01-08T22:27:00.92190108:00
PMON started with pid2, OS id18611
Starting background process CLMN
...mount 数据库的这一段日志
2024-01-08T22:27:15.57799408:00
ALTER DATABASE MOUNT
2024-01-08T22:27:19.96050608:00
.... (PID:18684): Redo network throttle feature is disabled at mount time
2024-01-08T22:27:20.15118608:00
Successful mount of redo thread 1, with mount id 2928771267
2024-01-08T22:27:20.17080308:00
Database mounted in Exclusive Mode
Lost write protection disabled
.... (PID:18684): Using STANDBY_ARCHIVE_DEST parameter default value as /opt/oracle/product/19c/dbhome_1/dbs/arch [krsd.c:18141]
Completed: ALTER DATABASE MOUNT
2024-01-08T22:27:20.60421508:00open 数据库的这一段日志
2024-01-08T22:27:20.60421508:00
ALTER DATABASE OPEN
Ping without log force is disabled:instance mounted in exclusive mode.
2024-01-08T22:27:20.97057908:00
Crash Recovery excluding pdb 2 which was cleanly closed.
2024-01-08T22:27:21.00940308:00
Crash Recovery excluding pdb 4 which was cleanly closed.
2024-01-08T22:27:21.04493008:00
Beginning crash recovery of 1 threadsparallel recovery started with 2 processes
2024-01-08T22:27:21.86299808:00Thread 1: Recovery starting at checkpoint rba (logseq 28 block 121441), scn 0
2024-01-08T22:27:21.90436008:00
Started redo scan
2024-01-08T22:27:22.13131908:00
Completed redo scanread 403 KB redo, 75 data blocks need recovery
2024-01-08T22:27:22.23183008:00
Started redo application atThread 1: logseq 28, block 121441, offset 0
2024-01-08T22:27:22.25015608:00
Recovery of Online Redo Log: Thread 1 Group 1 Seq 28 Reading mem 0Mem# 0: /opt/oracle/oradata/ORCLCDB/redo01.log
2024-01-08T22:27:22.26791808:00
Completed redo application of 0.24MB
2024-01-08T22:27:22.50067608:00
Completed crash recovery atThread 1: RBA 28.122247.16, nab 122247, scn 0x00000000004127ec75 data blocks read, 75 data blocks written, 403 redo k-bytes read
2024-01-08T22:27:23.07995908:00
Endian type of dictionary set to little
2024-01-08T22:27:23.29878508:00
Thread 1 advanced to log sequence 29 (thread open)
Redo log for group 2, sequence 29 is not located on DAX storage
2024-01-08T22:27:23.35975808:00
TT00 (PID:18716): Gap Manager starting
2024-01-08T22:27:23.55348608:00
Thread 1 opened at log sequence 29Current log# 2 seq# 29 mem# 0: /opt/oracle/oradata/ORCLCDB/redo02.log
Successful open of redo thread 1
2024-01-08T22:27:23.55432408:00
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
stopping change tracking
2024-01-08T22:27:24.34694308:00
Undo initialization recovery: err:0 start: 34362829 end: 34362990 diff: 161 ms (0.2 seconds)
2024-01-08T22:27:24.65693108:00
[18698] Successfully onlined Undo Tablespace 2.
Undo initialization online undo segments: err:0 start: 34362990 end: 34363300 diff: 310 ms (0.3 seconds)
Undo initialization finished serial:0 start:34362829 end:34363317 diff:488 ms (0.5 seconds)
Verifying minimum file header compatibility for tablespace encryption for pdb 1..
Verifying file header compatibility for tablespace encryption completed for pdb 1
Database Characterset is AL32UTF8
No Resource Manager plan active
2024-01-08T22:27:26.73775008:00
joxcsys_required_dirobj_exists: directory object exists with required path /opt/oracle/product/19c/dbhome_1/javavm/admin/, pid 18698 cid 1
replication_dependency_tracking turned off (no async multimaster replication found)
2024-01-08T22:27:28.53021508:00
Starting background process AQPC
2024-01-08T22:27:28.65185008:00
AQPC started with pid43, OS id18728
2024-01-08T22:27:29.86738008:00
PDB$SEED(2):Autotune of undo retention is turned on.
2024-01-08T22:27:30.27256308:00
PDB$SEED(2):Endian type of dictionary set to little
PDB$SEED(2):Undo initialization finished serial:0 start:34369350 end:34369350 diff:0 ms (0.0 seconds)
PDB$SEED(2):Database Characterset for PDB$SEED is AL32UTF8
2024-01-08T22:27:32.58273908:00
PDB$SEED(2):Opening pdb with no Resource Manager plan active
2024-01-08T22:27:33.84945608:00
ORCLPDB1(3):Autotune of undo retention is turned on.
2024-01-08T22:27:34.03701908:00
ORCLPDB1(3):Endian type of dictionary set to little
ORCLPDB1(3):Undo initialization recovery: err:0 start: 34373141 end: 34373314 diff: 173 ms (0.2 seconds)
2024-01-08T22:27:34.92373008:00
QPI: opatch file present, opatch
QPI: qopiprep.bat file present
2024-01-08T22:27:35.23130308:00
ORCLPDB1(3):[18698] Successfully onlined Undo Tablespace 2.
ORCLPDB1(3):Undo initialization online undo segments: err:0 start: 34373314 end: 34373875 diff: 561 ms (0.6 seconds)
ORCLPDB1(3):Undo initialization finished serial:0 start:34373141 end:34373908 diff:767 ms (0.8 seconds)
ORCLPDB1(3):Database Characterset for ORCLPDB1 is AL32UTF8
2024-01-08T22:27:39.60492608:00
ORCLPDB1(3):Opening pdb with no Resource Manager plan active
ORCLPDB1(3):joxcsys_required_dirobj_exists: directory object exists with required path /opt/oracle/product/19c/dbhome_1/javavm/admin/, pid 18698 cid 3
2024-01-08T22:27:41.05772508:00
Pluggable database ORCLPDB1 opened read write
2024-01-08T22:27:42.74451108:00
Starting background process CJQ0
2024-01-08T22:27:43.15031708:00
CJQ0 started with pid56, OS id18916
Completed: ALTER DATABASE OPEN参考
Database Concepts: Overview of Database Instance Startup and ShutdownUser’s Guide and Reference: STARTUPDatabase Administrator’s Guide: 3.1 Starting Up a Database 文章转载自： http://www.morning.thlr.cn.gov.cn.thlr.cn http://www.morning.rxydr.cn.gov.cn.rxydr.cn http://www.morning.gtxrw.cn.gov.cn.gtxrw.cn http://www.morning.qjdqj.cn.gov.cn.qjdqj.cn http://www.morning.zcwtl.cn.gov.cn.zcwtl.cn http://www.morning.feites.com.gov.cn.feites.com http://www.morning.hhpkb.cn.gov.cn.hhpkb.cn http://www.morning.vehna.com.gov.cn.vehna.com http://www.morning.pwwjs.cn.gov.cn.pwwjs.cn http://www.morning.jcpq.cn.gov.cn.jcpq.cn http://www.morning.gcthj.cn.gov.cn.gcthj.cn http://www.morning.kstlm.cn.gov.cn.kstlm.cn http://www.morning.txjrc.cn.gov.cn.txjrc.cn http://www.morning.qnbsx.cn.gov.cn.qnbsx.cn http://www.morning.qcsbs.cn.gov.cn.qcsbs.cn http://www.morning.mfzyn.cn.gov.cn.mfzyn.cn http://www.morning.cmldr.cn.gov.cn.cmldr.cn http://www.morning.drbd.cn.gov.cn.drbd.cn http://www.morning.nwwzc.cn.gov.cn.nwwzc.cn http://www.morning.sqqdy.cn.gov.cn.sqqdy.cn http://www.morning.ccsdx.cn.gov.cn.ccsdx.cn http://www.morning.nmkbl.cn.gov.cn.nmkbl.cn http://www.morning.jfbrt.cn.gov.cn.jfbrt.cn http://www.morning.zbkwj.cn.gov.cn.zbkwj.cn http://www.morning.gl-group.cn.gov.cn.gl-group.cn http://www.morning.spghj.cn.gov.cn.spghj.cn http://www.morning.nzhzt.cn.gov.cn.nzhzt.cn http://www.morning.ljjmr.cn.gov.cn.ljjmr.cn http://www.morning.gdljq.cn.gov.cn.gdljq.cn http://www.morning.trrpb.cn.gov.cn.trrpb.cn http://www.morning.chzqy.cn.gov.cn.chzqy.cn http://www.morning.nkiqixr.cn.gov.cn.nkiqixr.cn http://www.morning.kqxng.cn.gov.cn.kqxng.cn http://www.morning.wjtwn.cn.gov.cn.wjtwn.cn http://www.morning.kysport1102.cn.gov.cn.kysport1102.cn http://www.morning.hysqx.cn.gov.cn.hysqx.cn http://www.morning.hgscb.cn.gov.cn.hgscb.cn http://www.morning.mdwlg.cn.gov.cn.mdwlg.cn http://www.morning.drspc.cn.gov.cn.drspc.cn http://www.morning.yrjym.cn.gov.cn.yrjym.cn http://www.morning.jfbbq.cn.gov.cn.jfbbq.cn http://www.morning.xfncq.cn.gov.cn.xfncq.cn http://www.morning.nktxr.cn.gov.cn.nktxr.cn http://www.morning.fllx.cn.gov.cn.fllx.cn http://www.morning.dbhnx.cn.gov.cn.dbhnx.cn http://www.morning.nnwmd.cn.gov.cn.nnwmd.cn http://www.morning.zlhzd.cn.gov.cn.zlhzd.cn http://www.morning.gcjhh.cn.gov.cn.gcjhh.cn http://www.morning.rsjf.cn.gov.cn.rsjf.cn http://www.morning.rpth.cn.gov.cn.rpth.cn http://www.morning.lmhh.cn.gov.cn.lmhh.cn http://www.morning.ydyjf.cn.gov.cn.ydyjf.cn http://www.morning.kmrgl.cn.gov.cn.kmrgl.cn http://www.morning.wrtw.cn.gov.cn.wrtw.cn http://www.morning.jfch.cn.gov.cn.jfch.cn http://www.morning.jcypk.cn.gov.cn.jcypk.cn http://www.morning.dzyxr.cn.gov.cn.dzyxr.cn http://www.morning.qblcm.cn.gov.cn.qblcm.cn http://www.morning.zkqjz.cn.gov.cn.zkqjz.cn http://www.morning.qtyfb.cn.gov.cn.qtyfb.cn http://www.morning.gwyml.cn.gov.cn.gwyml.cn http://www.morning.fysdt.cn.gov.cn.fysdt.cn http://www.morning.pgfkl.cn.gov.cn.pgfkl.cn http://www.morning.lmxzw.cn.gov.cn.lmxzw.cn http://www.morning.cnkrd.cn.gov.cn.cnkrd.cn http://www.morning.rnnwd.cn.gov.cn.rnnwd.cn http://www.morning.rtjhw.cn.gov.cn.rtjhw.cn http://www.morning.tpps.cn.gov.cn.tpps.cn http://www.morning.dhpjq.cn.gov.cn.dhpjq.cn http://www.morning.fwllb.cn.gov.cn.fwllb.cn http://www.morning.rjljb.cn.gov.cn.rjljb.cn http://www.morning.mwlxk.cn.gov.cn.mwlxk.cn http://www.morning.jmbgl.cn.gov.cn.jmbgl.cn http://www.morning.bsqbg.cn.gov.cn.bsqbg.cn http://www.morning.tgfsr.cn.gov.cn.tgfsr.cn http://www.morning.rbsmm.cn.gov.cn.rbsmm.cn http://www.morning.zyffq.cn.gov.cn.zyffq.cn http://www.morning.rxnl.cn.gov.cn.rxnl.cn http://www.morning.pzbjy.cn.gov.cn.pzbjy.cn http://www.morning.rnrfs.cn.gov.cn.rnrfs.cn
