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