[oracle@localhost ~]$ tail -f /app/oracle/diag/rdbms/testdb/testdb/trace/alert_testdb.log
Sun Oct 26 23:36:13 2014
CJQ0 started with pid=25, OS id=2427
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
Sun Oct 26 23:41:12 2014
Starting background process SMCO
Sun Oct 26 23:41:13 2014
SMCO started with pid=26, OS id=2487
Mon Oct 27 00:24:49 2014
Time drift detected. Please check VKTM trace file for more details.
Fri Oct 31 23:27:29 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Partitioning option.
Using parameter settings in server-side pfile /app/oracle/product/11g/dbs/inittestdb.ora
System parameters with non-default values:
processes = 150
memory_target = 404M
control_files = "/home/oracle/disk4/control01.ctl"
control_files = "/home/oracle/disk5/control02.ctl"
control_files = "/home/oracle/disk6/control03.ctl"
db_block_size = 8192
compatible = "11.2.0.0.0"
log_archive_format = "%t_%s_%r.dbf"
db_recovery_file_dest = "/home/oracle/fast_recovery_area"
db_recovery_file_dest_size= 4002M
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=testdbXDB)"
audit_file_dest = "/app/oracle/admin/testdb/adump"
audit_trail = "DB"
db_name = "testdb"
open_cursors = 300
diagnostic_dest = "/app/oracle"
Fri Oct 31 23:27:30 2014
PMON started with pid=2, OS id=4312
Fri Oct 31 23:27:30 2014
PSP0 started with pid=3, OS id=4316
Fri Oct 31 23:27:30 2014
VKTM started with pid=4, OS id=4320 at elevated priority
VKTM running at (1)millisec precision with DBRM quantum (100)ms
Fri Oct 31 23:27:30 2014
GEN0 started with pid=5, OS id=4326
Fri Oct 31 23:27:30 2014
DIAG started with pid=6, OS id=4330
Fri Oct 31 23:27:30 2014
DBRM started with pid=7, OS id=4334
Fri Oct 31 23:27:30 2014
DIA0 started with pid=8, OS id=4338
Fri Oct 31 23:27:30 2014
MMAN started with pid=9, OS id=4342
Fri Oct 31 23:27:30 2014
DBW0 started with pid=10, OS id=4346
Fri Oct 31 23:27:31 2014
LGWR started with pid=11, OS id=4350
Fri Oct 31 23:27:31 2014
CKPT started with pid=12, OS id=4354
Fri Oct 31 23:27:31 2014
SMON started with pid=13, OS id=4358
Fri Oct 31 23:27:31 2014
RECO started with pid=14, OS id=4362
Fri Oct 31 23:27:31 2014
MMON started with pid=15, OS id=4366
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Fri Oct 31 23:27:31 2014
MMNL started with pid=16, OS id=4370
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /app/oracle
Fri Oct 31 23:27:31 2014
ALTER DATABASE MOUNT
Successful mount of redo thread 1, with mount id 2645753059
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE MOUNT
Fri Oct 31 23:27:35 2014
ALTER DATABASE OPEN
Beginning crash recovery of 1 threads
Started redo scan
Completed redo scan
read 42 KB redo, 12 data blocks need recovery
Started redo application at
Thread 1: logseq 23, block 67668
Recovery of Online Redo Log: Thread 1 Group 2 Seq 23 Reading mem 0
Mem# 0: /app/oracle/oradata/testdb/redo02.log
Completed redo application of 0.02MB
Completed crash recovery at
Thread 1: logseq 23, block 67752, scn 1316379
12 data blocks read, 12 data blocks written, 42 redo k-bytes read
LGWR: STARTING ARCH PROCESSES
Fri Oct 31 23:27:35 2014
ARC0 started with pid=20, OS id=4416
ARC0: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
Thread 1 advanced to log sequence 24 (thread open)
Thread 1 opened at log sequence 24
Current log# 3 seq# 24 mem# 0: /app/oracle/oradata/testdb/redo03.log
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
SMON: enabling cache recovery
Fri Oct 31 23:27:36 2014
ARC2 started with pid=22, OS id=4424
Fri Oct 31 23:27:36 2014
ARC3 started with pid=23, OS id=4428
Fri Oct 31 23:27:36 2014
ARC1 started with pid=21, OS id=4420
[4412] Successfully onlined Undo Tablespace 2.
Undo initialization finished serial:0 start:680744 end:680824 diff:80 (0 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 KO16MSWIN949
No Resource Manager plan active
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Fri Oct 31 23:27:37 2014
QMNC started with pid=24, OS id=4432
Completed: ALTER DATABASE OPEN
ARC1: Archival started
ARC2: Archival started
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
ARC1: Becoming the heartbeat ARCH
Archived Log entry 19 added for thread 1 sequence 23 ID 0x9d84fd92 dest 1:
Starting background process CJQ0
Fri Oct 31 23:27:38 2014
CJQ0 started with pid=30, OS id=4460
Fri Oct 31 23:27:38 2014
db_recovery_file_dest_size of 4002 MB is 13.11% 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.
Setting Resource Manager plan SCHEDULER[0x310B]:DEFAULT_MAINTENANCE_PLAN via scheduler window
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Fri Oct 31 23:27:42 2014
Starting background process VKRM
Fri Oct 31 23:27:42 2014
VKRM started with pid=25, OS id=4464
Fri Oct 31 23:27:44 2014
Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
Fri Oct 31 23:27:49 2014
Starting background process SMCO
Fri Oct 31 23:27:50 2014
SMCO started with pid=37, OS id=4516
