Log output during Oracle instance startup under Windows platform

Source: Internet
Author: User

Log output records during the startup of an Oracle instance under Windows platform.

Path:
D:\app\Administrator\diag\rdbms\orcl\orcl\trace\alert_orcl.log

Output content:

Sat .  -: the: -  .starting ORACLE instance (normal) License_max_session=0license_sessions_warning=0Picked Latch- FreeSCN scheme3Using log_archive_dest_1 parameter default value as Use_db_recovery_file_destautotune of undo retention is turned on. IMODE=Brilat= -license_max_users=0SYS Auditing is disabledstarting up:oracle Database 11g Enterprise Edition Release11.2.0.1.0-64bit Productionwith The partitioning, OLAP, Data Mining and Real application testing options. Using parameter SettingsinchServer-side SPFile D:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEORCL. Orasystem Parameters with non-default Values:processes= MaxMemory_target=13120M control_files="D:\APP\ADMINISTRATOR\ORADATA\ORCL\CONTROL01. CTL"Control_files="D:\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\ORCL\CONTROL02. CTL"db_block_size=8192compatible="11.2.0.0.0"db_recovery_file_dest="D:\app\Administrator\flash_recovery_area"db_recovery_file_dest_size=3912M Undo_tablespace="UNDOTBS1"Remote_login_passwordfile="EXCLUSIVE"Db_domain=""Dispatchers="(PROTOCOL=TCP) (SERVICE=ORCLXDB)"audit_file_dest="D:\APP\ADMINISTRATOR\ADMIN\ORCL\ADUMP"Audit_trail="DB"db_name="ORCL"open_cursors= -diagnostic_dest="D:\APP\ADMINISTRATOR"Sat .  -: +:Geneva  .Pmon started with PID=2, OSID=584Sat .  -: +:Geneva  .Vktm started with PID=3, OSID=564At elevated Priorityvktm running at (Ten) Millisec precision with DBRM Quantum ( -) Mssat .  -: +:Geneva  .GEN0 started with PID=4, OSID=1676Sat .  -: +:Geneva  .DBRM started with PID=6, OSID=3328Sat .  -: +:Geneva  .PSP0 started with PID=7, OSID=1920x1080Sat .  -: +:Geneva  .DIAG started with PID=5, OSID=3868Sat .  -: +:Geneva  .Mman started with PID=9, OSID=4028Sat .  -: +:Ten  .DBW0 started with PID=Ten, OSID=1972Sat .  -: +:Geneva  .DIA0 started with PID=8, OSID=1128Sat .  -: +:Ten  .LGWR started with PID= One, OSID=3280Sat .  -: +:Ten  .CKPT started with PID= A, OSID=3700Sat .  -: +:Ten  .RECO started with PID= -, OSID=3776Sat .  -: +:Ten  .Smon started with PID= -, OSID=1296Sat .  -: +:Ten  .MMNL started with PID= -, OSID=3356Sat .  -: +:Ten  .starting up1Dispatcher (s) forNetwork address'(address= (Partial=yes) (protocol=tcp))'... starting up1Shared Server (s) ... Oracle_base from Environment=D:\app\AdministratorSat .  -: +: -  .ALTER DATABASEMountExclusivesat .  -: +:Ten  .Mmon started with PID= the, OSID=2060Sat .  -: +: +  .successfulMountof Redo Thread1, withMount ID 1446963249Database MountedinchExclusive modelostWriteProtection Disabledcompleted:alter DatabaseMountExclusivealter Database Openthread1Opened at log sequence4055Current log#2 seq#4055mem#0: D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO02. Logsuccessful Open of Redo thread1MTTR advisory is disabled because Fast_start_mttr_target are not Setsat .  -: +: -  .smon:enabling Cache recoverysuccessfully onlined Undo tablespace2. VerifyingfileHeader compatibility for11g tablespace encryption. Verifying 11gfileHeader compatibility fortablespace Encryption completedsmon:enabling TX recoverydatabase Characterset is Al32utf8sat .  -: +: -  .no Resource Manager plan activereplication_dependency_tracking turned off (no async multimaster replication found) Sta Rting Background Process Qmncsat .  -: +: -  .QMNC started with PID= -, OSID=2668Completed:alter Database Opensat .  -: +: to  .Starting background Process Cjq0sat .  -: +: +  .CJQ0 started with PID= -, OSID=1740Sat .  -: +: +  .Db_recovery_file_dest_size of3912MB is0.00%used. this is Auser-specified limit on the amount of space that would be used by thisdatabase forrecovery-related files, and does not reflect the amount Ofspace availableinchThe underlying filesystem or ASM DiskGroup. Setting Resource Manager Plan scheduler[0x3008]:D Efault_maintenance_plan via scheduler windowsetting Resource Manager PLAN Default_maintenance_plan via Parametersat .  -: +: $  .Starting background Process Vkrmsat .  -: +: $  .VKRM started with PID= +, OSID=3712Sat .  -: $: -  .Starting background Process Smcosat .  -: $: -  .SMCO started with PID= +, OSID=3876

Log output during Oracle instance startup under Windows platform

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.