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

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

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

2020-01-24T09:24:21.783126-05:00StartingORACLEinstance(normal)(OSid:12978)2020-01-24T09:24:21.897815-05:00****************************************************/dev/shmwillbeusedforcreatingSGALargepageswillnotbeused.Onlystandard4Kpageswillbeused

将系统资源转储为SGA

****************************************************2020-01-24T09:24:21.921610-05:00**********************************************************************2020-01-24T09:24:21.922030-05:00DumpofsystemresourcesacquiredforSHAREDGLOBALAREA(SGA)

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

2020-01-24T09:24:21.922828-05:00Perprocesssystemmemlock(soft)limit=3072M2020-01-24T09:24:21.923100-05:00Expectedperprocesssystemmemlock(soft)limittolockinstanceMAXSHAREDGLOBALAREA(SGA)intomemory:792M2020-01-24T09:24:21.923559-05:00Availablesystempagesizes:4K,2048K2020-01-24T09:24:21.924205-05:00Supportedsystempagesize(s):PAGESIZEAVAILABLE_PAGESEXPECTED_PAGESALLOCATED_PAGESERROR(s)4KConfigured202757202757NONE2020-01-24T09:24:21.925105-05:00Reasonfornotsupportingcertainsystempagesizes:2048K-Dynamicallocateandfreememoryregions

读取 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:00InitialnumberofCPUis2Numberofprocessorcoresinthesystemis2Numberofprocessorsocketsinthesystemis1

环境校验

CapabilityType:Networkcapabilitiesrequested:7detected:0Simulated:0CapabilityType:RuntimeEnvironmentcapabilitiesrequested:400000FFdetected:40000000Simulated:0CapabilityType:EngineeredSystemscapabilitiesrequested:7detected:0Simulated:0CapabilityType:DatabaseTestcapabilitiesrequested:3detected:0Simulated:0

读取参数文件

UsingLOG_ARCHIVE_DEST_1parameterdefaultvalueas/u01/app/oracle/product/19.3.0/dbhome_1/dbs/archAutotuneofundoretentionisturnedon.IMODE=BRILAT=51LICENSE_MAX_USERS=0SYSauditingisenabledNOTE:remoteasmmodeislocal(mode0x1;fromclustertype)NOTE:UsingdefaultASMrootdirectoryASMNOTE:remoteasmmodeislocal(mode0x1;fromclustertype)NOTE:Clusterconfigurationtype=NONE[2]OracleDatabase19cEnterpriseEditionRelease19.0.0.0.0-ProductionVersion19.3.0.0.0.ORACLE_HOME:/u01/app/oracle/product/19.3.0/dbhome_1Systemname:LinuxNodename:node1Release:3.10.0-957.el7.x86_64Version:#1SMPThuOct420:48:51UTC2018Machine:x86_64Usingparametersettingsinserver-sidespfile/u01/app/oracle/product/19.3.0/dbhome_1/dbs/spfileorcl.oraSystemparameterswithnon-defaultvalues:processes=300nls_language="AMERICAN"nls_territory="AMERICA"memory_target=792Mcontrol_files="/oradata/ORCL/control01.ctl"control_files="/oradata/ORCL/control02.ctl"db_block_size=8192compatible="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=300diagnostic_dest="/u01/app/oracle"

开始启动各部分进程

2020-01-24T09:24:31.719373-05:00============================================================NOTE:PatchLevelofthisinstance0============================================================WARNING:InvalidvalueforlistenerrelatedparameterMIXEDLISTENER2020-01-24T09:24:31.962206-05:00ORA-00141:alladdressesspecifiedforparameterLOCAL_LISTENERareinvalidORA-00132:syntaxerrororunresolvednetworkname'LISTENER_ORCL'StartingbackgroundprocessPMON2020-01-24T09:24:32.059335-05:00PMONstartedwithpid=2,OSid=13012StartingbackgroundprocessCLMN2020-01-24T09:24:32.130665-05:00CLMNstartedwithpid=3,OSid=13014StartingbackgroundprocessPSP02020-01-24T09:24:32.226568-05:00PSP0startedwithpid=4,OSid=13016StartingbackgroundprocessVKTM2020-01-24T09:24:33.424618-05:00VKTMstartedwithpid=5,OSid=13019atelevated(RT)priority2020-01-24T09:24:33.443572-05:00StartingbackgroundprocessGEN02020-01-24T09:24:33.457207-05:00VKTMrunningat(1)millisecprecisionwithDBRMquantum(100)msStartingbackgroundprocessMMAN2020-01-24T09:24:33.526550-05:00GEN0startedwithpid=6,OSid=130242020-01-24T09:24:33.594270-05:00MMANstartedwithpid=7,OSid=13026StartingbackgroundprocessGEN12020-01-24T09:24:33.846502-05:00GEN1startedwithpid=9,OSid=13030_13031StartingbackgroundprocessDIAG2020-01-24T09:24:33.914542-05:00DIAGstartedwithpid=11,OSid=13033StartingbackgroundprocessOFSD2020-01-24T09:24:34.021251-05:00OFSDstartedwithpid=12,OSid=13035_13036StartingbackgroundprocessDBRM2020-01-24T09:24:34.029524-05:00Oraclerunningwithofslib:'OracleFileServerLibrary'version=22020-01-24T09:24:34.072386-05:00DBRMstartedwithpid=8,OSid=13038StartingbackgroundprocessVKRM2020-01-24T09:24:34.148547-05:00VKRMstartedwithpid=14,OSid=13040StartingbackgroundprocessSVCB2020-01-24T09:24:34.206158-05:00SVCBstartedwithpid=15,OSid=13042StartingbackgroundprocessPMAN2020-01-24T09:24:34.274700-05:00PMANstartedwithpid=16,OSid=13044StartingbackgroundprocessDIA02020-01-24T09:24:34.357435-05:00DIA0startedwithpid=17,OSid=13046StartingbackgroundprocessDBW02020-01-24T09:24:34.483648-05:00StartingbackgroundprocessLGWR2020-01-24T09:24:34.483685-05:00DBW0startedwithpid=18,OSid=13048StartingbackgroundprocessCKPT2020-01-24T09:24:34.547257-05:00LGWRstartedwithpid=19,OSid=130512020-01-24T09:24:34.625889-05:00CKPTstartedwithpid=20,OSid=130532020-01-24T09:24:34.708849-05:00LGWRslaveLG00createdwithpid=21,OSpid=13055StartingbackgroundprocessSMON2020-01-24T09:24:34.771650-05:00SMONstartedwithpid=22,OSid=13057LGWRslaveLG01createdwithpid=23,OSpid=13059StartingbackgroundprocessSMCOStartingbackgroundprocessRECO2020-01-24T09:24:34.910826-05:00SMCOstartedwithpid=24,OSid=130612020-01-24T09:24:34.981554-05:00RECOstartedwithpid=25,OSid=13063StartingbackgroundprocessLREG2020-01-24T09:24:35.115737-05:00LREGstartedwithpid=27,OSid=13067StartingbackgroundprocessPXMN2020-01-24T09:24:35.253859-05:00PXMNstartedwithpid=29,OSid=13071StartingbackgroundprocessFENC2020-01-24T09:24:35.321431-05:00FENCstartedwithpid=30,OSid=13073StartingbackgroundprocessMMON2020-01-24T09:24:35.379970-05:00MMONstartedwithpid=31,OSid=13075StartingbackgroundprocessMMNL2020-01-24T09:24:35.417133-05:00startingup1dispatcher(s)fornetworkaddress'(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...2020-01-24T09:24:35.417175-05:00MMNLstartedwithpid=30,OSid=13077startingup1sharedserver(s)...2020-01-24T09:24:35.565561-05:00StartingbackgroundprocessTMON2020-01-24T09:24:35.637575-05:00TMONstartedwithpid=34,OSid=13083

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