Oracle数据库诊断文件(日志)查看(三)
N = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as D:\app\topwqp\product\11.1.0\db_1\RDBMS
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 11.1.0.6.0.
Using parameter settings in server-side spfile D:\APP\TOPWQP\PRODUCT\11.1.0\DB_1\DATABASE\SPFILEORCL.ORA
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"
Thu Jun 13 22:13:46 2013
PMON started with pid=2, OS id=1888
Thu Jun 13 22:13:46 2013
VKTM started with pid=3, OS id=4296 at elevated priority
Thu Jun 13 22:13:46 2013
DIAG started with pid=4, OS id=6804
VKTM running at (20)ms precision
Thu Jun 13 22:13:46 2013
DBRM started with pid=5, OS id=7360
Thu Jun 13 22:13:46 2013
PSP0 started with pid=6, OS id=648
Thu Jun 13 22:13:46 2013
DSKM started with pid=7, OS id=7460
Thu Jun 13 22:13:46 2013
DIA0 started with pid=8, OS id=1592
Thu Jun 13 22:13:46 2013
MMAN started with pid=7, OS id=4512
Thu Jun 13 22:13:46 2013
DBW0 started with pid=9, OS id=6920
Thu Jun 13 22:13:46 2013
LGWR started with pid=10, OS id=3712
Thu Jun 13 22:13:46 2013
CKPT started with pid=11, OS id=6512
Thu Jun 13 22:13:46 2013
SMON started with pid=12, OS id=7992
Thu Jun 13 22:13:46 2013
RECO started with pid=13, OS id=7056
Thu Jun 13 22:13:46 2013
MMON started with pid=14, OS id=7844
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Thu Jun 13 22:13:46 2013
MMNL started with pid=15, OS id=6284
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\app\topwqp
Thu Jun 13 22:13:46 2013
alter database mount exclusive
Setting recovery target incarnation to 2
Successful mount of redo thread 1, with mount id 1345846942
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: alter database mount exclusive
alter database open
Beginning crash recovery of 1 threads
parallel recovery started with 3 processes
Started redo scan
Thu Jun 13 22:13:56 2013
Completed redo scan
4095 redo blocks read, 510 data blocks need recovery
Started redo application at
Thread 1: logseq 434, block 67636
Recovery of Online Redo Log: Thread 1 Group 2 Seq 434 Reading