有会的老大帮忙解决一下,分可以加。日志内容为:
Dump file h:\oracle\product\10.2.0/admin/myoracle/bdump\alert_myoracle.log
Fri Jun 15 17:33:44 2012
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows Server 2003 Version V5.2 Service Pack 2
CPU : 2 - type 586, 1 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:2872M/3317M, Ph+PgF:4937M/5206M, VA:1937M/2047M
Fri Jun 15 17:33:44 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =97
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
processes = 800
sessions = 885
__shared_pool_size = 109051904
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
sga_target = 448790528
control_files = H:\ORACLE\PRODUCT\10.2.0\ORADATA\MYORACLE\CONTROL01.CTL, H:\ORACLE\PRODUCT\10.2.0\ORADATA\MYORACLE\CONTROL02.CTL, H:\ORACLE\PRODUCT\10.2.0\ORADATA\MYORACLE\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 322961408
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = H:\oracle\product\10.2.0/flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
_row_cr = FALSE
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=myoracleXDB)
job_queue_processes = 10
cursor_sharing = SIMILAR
audit_file_dest = H:\ORACLE\PRODUCT\10.2.0\ADMIN\MYORACLE\ADUMP
background_dump_dest = H:\ORACLE\PRODUCT\10.2.0\ADMIN\MYORACLE\BDUMP
user_dump_dest = H:\ORACLE\PRODUCT\10.2.0\ADMIN\MYORACLE\UDUMP
core_dump_dest = H:\ORACLE\PRODUCT\10.2.0\ADMIN\MYORACLE\CDUMP
db_name = myoracle
open_cursors = 300
pga_aggregate_target = 148897792
PMON started with pid=2, OS id=2284
PSP0 started with pid=3, OS id=2264
MMAN started with pid=4, OS id=2280
DBW0 started with pid=5, OS id=1076
LGWR started with pid=6, OS id=2292
CKPT started with pid=7, OS id=3536
SMON started with pid=8, OS id=2304
RECO started with pid=9, OS id=2320
CJQ0 started with pid=10, OS id=2316
MMON started with pid=11, OS id=1932
Fri Jun 15 17:33:44 2012
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=2488
Fri Jun 15 17:33:44 2012
starting up 1 shared server(s) ...
Fri Jun 15 17:33:44 2012
alter database mount exclusive
Fri Jun 15 17:33:48 2012
Setting recovery target incarnation to 2
Fri Jun 15 17:33:48 2012
Successful mount of redo thread 1, with mount id 1884694584
Fri Jun 15 17:33:48 2012
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Fri Jun 15 17:33:48 2012
alter database open
Fri Jun 15 17:33:49 2012
Beginning crash recovery of 1 threads
parallel recovery started with 2 processes
Fri Jun 15 17:33:49 2012
Started redo scan
Fri Jun 15 17:33:50 2012
Completed redo scan
327 redo blocks read, 547 data blocks need recovery