Oracle alert文件分析(二)
KTM trace file for more details. -- VKTM (virtual keeper of time) is responsible for providing a wall-clock time
-- (updated every second) and reference-time counter (updated every 20 ms and
-- available only when running at elevated priority).
2013-05-20 09:36:21.723000 +08:00
db_recovery_file_dest_size of 5727 MB is 62.98% 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.
2013-05-20 09:21:51.131000 +08:00
Redo thread 2 internally disabled at seq 541 (CKPT)
[6620006] Successfully onlined Undo Tablespace 2.
Undo initialization finished serial:0 start:570407839 end:570410008 diff:2169 (21 seconds)
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
No Resource Manager plan active
2013-05-20 09:21:52.634000 +08:00
minact-scn: Inst 1 is now the master inc#:2 mmon proc-id:6226738 status:0x7
minact-scn status: grec-scn:0x0000.00000000 gmin-scn:0x0000.00000000 gcalc-scn:0x0000.00000000 -- "min active scn" introduced in 11g which is supposed to enhance delayed block cleanout operations. Note : - Disabling min active scn optimization feature will not have any impact on database.
Archived Log entry 1052 added for thread 2 sequence 540 ID 0xffffffff88d0f3f7 dest 1:
2013-05-20 09:21:53.759000 +08:00
ARC0: Archiving disabled thread 2 sequence 541
Archived Log entry 1053 added for thread 2 sequence 541 ID 0xffffffff88d0f3f7 dest 1:
Starting background process GTX0 -- 全局事务进程0，在 RAC 集群中，Oracle
数据库现在提供改进的 XA 事务处理。此进程协调 XA 事务。如果 XA 上的数据库负载增长，将自动创建更多进程，分别命名为 GTX1、GTX2，直至 GTXJ。
GTX0 started with pid=89, OS id=9764872
2013-05-20 09:21:54.814000 +08:00
Starting background process RCBG -- 高速缓存后台进程，支持新的结果高速缓存特性。
RCBG started with pid=90, OS id=8258348
replication_dependency_tracking turned off (no async multimaster replication found) -- REPLICATION_DEPENDENCY_TRACKING enables or disables dependency tracking for read/write operations to the database. Dependency tracking is essential for propagating changes in a replicated environment in parallel.
-- Note:Do not specify this value unless you are sure that your application will not perform any read/write operations to the replicated tables.
2013-05-20 09:21:56.014000 +08:00
Starting background process QMNC -- 队列监视器进程
QMNC started with pid=92, OS id=10289208
2013-05-20 09:21:59.295000 +08:00
Completed: ALTER DATABASE OPEN /* db agent *//* {2:26630:2} */
2013-05-20 09:22:03.686000 +08:00
db_recovery_file_dest_size of 5727 MB is 62.98% 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.
Starting background process CJQ0 -- 作业队列进程
CJQ0 started with pid=100, OS id=11534496
2013-05-20 09:22:19.267000 +08:00
Reconfiguration started (old inc 2, new inc 4)
List of instances:
1 2 (myinst: 1)