博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
windows oracle的日志,Windows平台下Oracle实例启动过程中日志输出
阅读量:6657 次
发布时间:2019-06-25

本文共 4199 字,大约阅读时间需要 13 分钟。

Sat Aug 06 20:39:55 2016Starting ORACLE instance (normal)

LICENSE_MAX_SESSION= 0LICENSE_SESSIONS_WARNING= 0Picked latch-free SCN scheme 3Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST

Autotune of undo retention is turned on.

IMODE=BR

ILAT=27LICENSE_MAX_USERS= 0SYS auditing is disabled

Starting up:

Oracle Database 11g Enterprise Edition Release11.2.0.1.0 -64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options.

Using parameter settingsin server-side spfile D:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEORCL.ORA

System parameters with non-default values:

processes= 150memory_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= 300diagnostic_dest= "D:\APP\ADMINISTRATOR"Sat Aug06 20:40:04 2016PMON started with pid=2, OS id=584Sat Aug06 20:40:04 2016VKTM started with pid=3, OS id=564at elevated priority

VKTM running at (10)millisec precision with DBRM quantum (100)ms

Sat Aug06 20:40:04 2016GEN0 started with pid=4, OS id=1676Sat Aug06 20:40:04 2016DBRM started with pid=6, OS id=3328Sat Aug06 20:40:04 2016PSP0 started with pid=7, OS id=1920Sat Aug06 20:40:04 2016DIAG started with pid=5, OS id=3868Sat Aug06 20:40:04 2016MMAN started with pid=9, OS id=4028Sat Aug06 20:40:10 2016DBW0 started with pid=10, OS id=1972Sat Aug06 20:40:04 2016DIA0 started with pid=8, OS id=1128Sat Aug06 20:40:10 2016LGWR started with pid=11, OS id=3280Sat Aug06 20:40:10 2016CKPT started with pid=12, OS id=3700Sat Aug06 20:40:10 2016RECO started with pid=14, OS id=3776Sat Aug06 20:40:10 2016SMON started with pid=13, OS id=1296Sat Aug06 20:40:10 2016MMNL started with pid=16, OS id=3356Sat Aug06 20:40:10 2016starting up1 dispatcher(s) for network address ‘(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))‘...

starting up1shared server(s) ...

ORACLE_BASE from environment=D:\app\Administrator

Sat Aug06 20:40:17 2016alter databasemountexclusive

Sat Aug06 20:40:10 2016MMON started with pid=15, OS id=2060Sat Aug06 20:40:21 2016Successfulmount of redo thread 1, with mount id 1446963249Database mountedinExclusive Mode

Lostwriteprotection disabled

Completed: alter databasemountexclusive

alter database open

Thread1 opened at log sequence 4055Current log#2 seq# 4055 mem# 0: D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO02.LOG

Successful open of redo thread1MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set

Sat Aug06 20:40:25 2016SMON: enabling cache recovery

Successfully onlined Undo Tablespace2.

Verifyingfile header compatibility for11g tablespace encryption..

Verifying 11gfile header compatibility fortablespace encryption completed

SMON: enabling tx recovery

Database Characterset is AL32UTF8

Sat Aug06 20:40:28 2016No Resource Manager plan active

replication_dependency_tracking turned off (no async multimaster replication found)

Starting background process QMNC

Sat Aug06 20:40:30 2016QMNC started with pid=20, OS id=2668Completed: alter database open

Sat Aug06 20:40:31 2016Starting background process CJQ0

Sat Aug06 20:40:32 2016CJQ0 started with pid=24, OS id=1740Sat Aug06 20:40:32 2016db_recovery_file_dest_size of3912 MB is 0.00%used. This is a

user-specified limit on the amount of space that will be used by this

databasefor recovery-related files, and does not reflect the amount of

space availableinthe underlying filesystem or ASM diskgroup.

Setting Resource Manager plan SCHEDULER[0x3008]:DEFAULT_MAINTENANCE_PLAN via scheduler window

Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter

Sat Aug06 20:40:36 2016Starting background process VKRM

Sat Aug06 20:40:36 2016VKRM started with pid=19, OS id=3712Sat Aug06 20:45:30 2016Starting background process SMCO

Sat Aug06 20:45:30 2016SMCO started with pid=21, OS id=3876

转载地址:http://tutto.baihongyu.com/

你可能感兴趣的文章
动态样式语言Scss&Less介绍与区别
查看>>
aptana--python开发工具使用技巧
查看>>
纯CSS画的基本图形(矩形、圆形、三角形、多边形、爱心、八卦等)
查看>>
使用PM2来部署nodejs项目
查看>>
Postgres 小技巧
查看>>
保证分布式系统数据一致性的6种方案
查看>>
wordpress wp_list_authors作者函数和扩展
查看>>
[leetcode] Insert Interval
查看>>
gethostname.c
查看>>
zookeeper的客户端操作命令
查看>>
也来折腾折腾css sprites(转自www.jqueryba.com)
查看>>
Solr的一些查询参数
查看>>
用户态事件
查看>>
Java集合之Collection接口
查看>>
Git - 如何修改开源项目并推送给作者 / 克隆远程仓库到本地
查看>>
分布式服务协调员zookeeper - 应用场景和监控
查看>>
源码 安装步骤
查看>>
PMBOK中输入输出工具的规律
查看>>
Core Animation之CAKeyframeAnimation学习篇
查看>>
代码中weak, alias
查看>>