Oracle数据库诊断文件(日志)查看(四)
mem 0
Mem# 0: D:\APP\TOPWQP\ORADATA\ORCL\REDO02.LOG
Completed redo application
Completed crash recovery at
Thread 1: logseq 434, block 71731, scn 5101264
510 data blocks read, 510 data blocks written, 4095 redo blocks read
Thu Jun 13 22:14:00 2013
Thread 1 advanced to log sequence 435
Thread 1 opened at log sequence 435
Current log# 3 seq# 435 mem# 0: D:\APP\TOPWQP\ORADATA\ORCL\REDO03.LOG
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Thu Jun 13 22:14:01 2013
SMON: enabling cache recovery
Successfully onlined Undo Tablespace 2.
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Database Characterset is ZHS16GBK
Opening with internal Resource Manager plan
Starting background process FBDA
Starting background process SMCO
Thu Jun 13 22:14:06 2013
FBDA started with pid=22, OS id=4524
Thu Jun 13 22:14:06 2013
SMCO started with pid=23, OS id=6344
Thu Jun 13 22:14:07 2013
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Thu Jun 13 22:14:09 2013
QMNC started with pid=25, OS id=7168
Thu Jun 13 22:14:20 2013
db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Thu Jun 13 22:14:30 2013
Completed: alter database open
Thu Jun 13 22:18:50 2013
Starting background process CJQ0
Thu Jun 13 22:18:50 2013
CJQ0 started with pid=28, OS id=5912
Setting Resource Manager plan SCHEDULER[0x2C0C]:DEFAULT_MAINTENANCE_PLAN via scheduler window
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Thu Jun 13 22:19:07 2013
Thu Jun 13 22:19:07 2013
Logminer Bld: Lockdown Complete. DB_TXN_SCN is UnwindToSCN (LockdownSCN) is 5102149
Thu Jun 13 22:19:11 2013
Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
Thu Jun 13 22:20:29 2013
End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
oracle的启动参数信息如下：
System parameters with non-default values:
processes = 150
memory_target = 412M
control_files = "D:\APP\TOPWQP\ORADATA\ORCL\CONTROL01.CTL"
control_files = "D:\APP\TOPWQP\ORADATA\ORCL\CONTROL02.CTL"
control_files = "D:\APP\TOPWQP\ORADATA\ORCL\CONTROL03.CTL"
db_block_size = 8192
compatible = "11.1.0.0.0"
db_recovery_file_dest = "D:\app\topwqp\flash_recovery_area"
db_recovery_file_dest_size= 2G
fast_start_mttr_target = 0
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=orclXDB)"
audit_file_dest = "D:\APP\TOPWQP\ADMIN\ORCL\ADUMP"
audit_trail = "DB"
db_name = "orcl"
open_cursors = 300
diagnostic_dest = "D:\APP\TOPWQP"
这些信息可以用于pfile或者spfile内容。