分析数据库都做了哪些操作

这篇文章主要介绍"分析数据库都做了哪些操作"，在日常操作中，相信很多人在分析数据库都做了哪些操作问题上存在疑惑，小编查阅了各式资料，整理出简单好用的操作方法，希望对大家解答"分析数据库都做了哪些操作"的疑惑有所帮助！接下来，请跟着小编一起来学习吧！

由于不将数据库开启至nomount状态，数据库无法开启10046，所以只能通过后台日志了解，数据库都做了哪些操作

执行开启命令，分配内存（此系统内存分配没使用Large Page），内存页大小为4k

2020-01-24T09:24:21.783126-05:00Starting ORACLE instance (normal) (OS id: 12978)2020-01-24T09:24:21.897815-05:00****************************************************/dev/shm will be used for creating SGA Large pages will not be used. Only standard 4K pages will be used

将系统资源转储为SGA

****************************************************2020-01-24T09:24:21.921610-05:00**********************************************************************2020-01-24T09:24:21.922030-05:00Dump of system resources acquired for SHARED GLOBAL AREA (SGA)

然后根据系统 /etc/security/limits.conf 配置进行分配

2020-01-24T09:24:21.922828-05:00 Per process system memlock (soft) limit = 3072M2020-01-24T09:24:21.923100-05:00 Expected per process system memlock (soft) limit to lock instance MAX SHARED GLOBAL AREA (SGA) into memory: 792M2020-01-24T09:24:21.923559-05:00 Available system pagesizes:  4K, 2048K   2020-01-24T09:24:21.924205-05:00 Supported system pagesize(s):  PAGESIZE  AVAILABLE_PAGES  EXPECTED_PAGES  ALLOCATED_PAGES  ERROR(s)        4K       Configured          202757          202757        NONE2020-01-24T09:24:21.925105-05:00 Reason for not supporting certain system pagesizes:   2048K - Dynamic allocate and free memory regions

读取 CPU 信息

2020-01-24T09:24:21.925576-05:00**********************************************************************2020-01-24T09:24:30.963798-05:00LICENSE_MAX_SESSION = 0LICENSE_SESSIONS_WARNING = 02020-01-24T09:24:31.028811-05:00Initial number of CPU is 2Number of processor cores in the system is 2Number of processor sockets in the system is 1

环境校验

Capability Type : Network capabilities requested : 7 detected : 0 Simulated : 0Capability Type : Runtime Environment capabilities requested : 400000FF detected : 40000000 Simulated : 0Capability Type : Engineered Systems capabilities requested : 7 detected : 0 Simulated : 0Capability Type : Database Test capabilities requested : 3 detected : 0 Simulated : 0

读取参数文件

Using LOG_ARCHIVE_DEST_1 parameter default value as /u01/app/oracle/product/19.3.0/dbhome_1/dbs/archAutotune of undo retention is turned on. IMODE=BRILAT =51LICENSE_MAX_USERS = 0SYS auditing is enabledNOTE: remote asm mode is local (mode 0x1; from cluster type)NOTE: Using default ASM root directory ASMNOTE: 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 - ProductionVersion 19.3.0.0.0.ORACLE_HOME:    /u01/app/oracle/product/19.3.0/dbhome_1System name:    LinuxNode name:  node1Release:    3.10.0-957.el7.x86_64Version:    #1 SMP Thu Oct 4 20:48:51 UTC 2018Machine:    x86_64Using parameter settings in server-side spfile /u01/app/oracle/product/19.3.0/dbhome_1/dbs/spfileorcl.oraSystem parameters with non-default values:  processes                = 300  nls_language             = "AMERICAN"  nls_territory            = "AMERICA"  memory_target            = 792M  control_files            = "/oradata/ORCL/control01.ctl"  control_files            = "/oradata/ORCL/control02.ctl"  db_block_size            = 8192  compatible               = "19.0.0"  undo_tablespace          = "UNDOTBS1"  db_securefile            = "PREFERRED"  remote_login_passwordfile= "EXCLUSIVE"  dispatchers              = "(PROTOCOL=TCP) (SERVICE=orclXDB)"  local_listener           = "LISTENER_ORCL"  audit_trail              = "NONE"  db_name                  = "orcl"  open_cursors             = 300  diagnostic_dest          = "/u01/app/oracle"

开始启动各部分进程

2020-01-24T09:24:31.719373-05:00============================================================NOTE: PatchLevel of this instance 0============================================================WARNING: Invalid value for listener related parameter MIXED LISTENER2020-01-24T09:24:31.962206-05:00ORA-00141: all addresses specified for parameter LOCAL_LISTENER are invalidORA-00132: syntax error or unresolved network name 'LISTENER_ORCL'Starting background process PMON2020-01-24T09:24:32.059335-05:00PMON started with pid=2, OS id=13012 Starting background process CLMN2020-01-24T09:24:32.130665-05:00CLMN started with pid=3, OS id=13014 Starting background process PSP02020-01-24T09:24:32.226568-05:00PSP0 started with pid=4, OS id=13016 Starting background process VKTM2020-01-24T09:24:33.424618-05:00VKTM started with pid=5, OS id=13019 at elevated (RT) priority2020-01-24T09:24:33.443572-05:00Starting background process GEN02020-01-24T09:24:33.457207-05:00VKTM running at (1)millisec precision with DBRM quantum (100)msStarting background process MMAN2020-01-24T09:24:33.526550-05:00GEN0 started with pid=6, OS id=13024 2020-01-24T09:24:33.594270-05:00MMAN started with pid=7, OS id=13026 Starting background process GEN12020-01-24T09:24:33.846502-05:00GEN1 started with pid=9, OS id=13030_13031 Starting background process DIAG2020-01-24T09:24:33.914542-05:00DIAG started with pid=11, OS id=13033 Starting background process OFSD2020-01-24T09:24:34.021251-05:00OFSD started with pid=12, OS id=13035_13036 Starting background process DBRM2020-01-24T09:24:34.029524-05:00Oracle running with ofslib:'Oracle File Server Library' version=22020-01-24T09:24:34.072386-05:00DBRM started with pid=8, OS id=13038 Starting background process VKRM2020-01-24T09:24:34.148547-05:00VKRM started with pid=14, OS id=13040 Starting background process SVCB2020-01-24T09:24:34.206158-05:00SVCB started with pid=15, OS id=13042 Starting background process PMAN2020-01-24T09:24:34.274700-05:00PMAN started with pid=16, OS id=13044 Starting background process DIA02020-01-24T09:24:34.357435-05:00DIA0 started with pid=17, OS id=13046 Starting background process DBW02020-01-24T09:24:34.483648-05:00Starting background process LGWR2020-01-24T09:24:34.483685-05:00DBW0 started with pid=18, OS id=13048 Starting background process CKPT2020-01-24T09:24:34.547257-05:00LGWR started with pid=19, OS id=13051 2020-01-24T09:24:34.625889-05:00CKPT started with pid=20, OS id=13053 2020-01-24T09:24:34.708849-05:00LGWR slave LG00 created with pid=21, OS pid=13055Starting background process SMON2020-01-24T09:24:34.771650-05:00SMON started with pid=22, OS id=13057 LGWR slave LG01 created with pid=23, OS pid=13059Starting background process SMCOStarting background process RECO2020-01-24T09:24:34.910826-05:00SMCO started with pid=24, OS id=13061 2020-01-24T09:24:34.981554-05:00RECO started with pid=25, OS id=13063 Starting background process LREG2020-01-24T09:24:35.115737-05:00LREG started with pid=27, OS id=13067 Starting background process PXMN2020-01-24T09:24:35.253859-05:00PXMN started with pid=29, OS id=13071 Starting background process FENC2020-01-24T09:24:35.321431-05:00FENC started with pid=30, OS id=13073 Starting background process MMON2020-01-24T09:24:35.379970-05:00MMON started with pid=31, OS id=13075 Starting background process MMNL2020-01-24T09:24:35.417133-05:00starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...2020-01-24T09:24:35.417175-05:00MMNL started with pid=30, OS id=13077 starting up 1 shared server(s) ...2020-01-24T09:24:35.565561-05:00Starting background process TMON2020-01-24T09:24:35.637575-05:00TMON started with pid=34, OS id=13083

到此，关于"分析数据库都做了哪些操作"的学习就结束了，希望能够解决大家的疑惑。理论与实践的搭配能更好的帮助大家学习，快去试试吧！若想继续学习更多相关知识，请继续关注网站，小编会继续努力为大家带来更多实用的文章！