我的10G数据库开启LOG

Wed Dec 19 21:10:50 2007
!XnUKO3_Z2rf0Starting ORACLE instance (normal)ITPUB个人空间7E%fb \j0Ltn^
LICENSE_MAX_SESSION = 0ITPUB个人空间;P*C's"R1d}6G^1m}j
LICENSE_SESSIONS_WARNING = 0
ENRg.q.q"W:|0Picked latch-free SCN scheme 2ITPUB个人空间;D'O!j3xaV#LV
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DESTITPUB个人空间'b8o/vz{VU
Autotune of undo retention is turned on.
4kWfBZ*A/jAy0IMODE=BR
Y$|g:l:dS0ILAT =18
T1]']W*n,Rd E6|0LICENSE_MAX_USERS = 0
jQ JFxF4?;d0SYS auditing is disabled
o{9I;RH_+i C0ksdpec: called for event 13740 prior to event group initialization
fBG Y;lc+AN;hk0Starting up ORACLE RDBMS Version: 10.2.0.3.0.
~$[Q:}q a,d:B0h"G0System parameters with non-default values:
a
hWq0EM0}C W0  processes                = 150ITPUB个人空间s~ Y6CcP
  timed_statistics         = TRUE
j m1en{+mI0  resource_limit           = FALSE
%Nu7`%nc)iA2` T&p0  __shared_pool_size       = 314572800
'HF3w/@n
DvY0  __large_pool_size        = 12582912
5Ef{ d&}#Uq1L0  __java_pool_size         = 4194304ITPUB个人空间Y Otm.|Y
  __streams_pool_size      = 0
iE-N0Z7e@dt0  nls_language             = SIMPLIFIED CHINESEITPUB个人空间M5dpp'[j~q:sM
  nls_territory            = CHINA
2x
KyM&n'v`#b8l0  sga_target               = 612368384
h3|g,][
e0  control_files            = D:\ORACLE\PRODUCT\10.2.0\ORADATA\fox\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\fox\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\fox\CONTROL03.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\fox\CONTROL04.CTLITPUB个人空间2X2O$MP_M NP B J0M
  db_block_size            = 8192
a)h]!DH
i0  __db_cache_size          = 272629760
0wK"nY;e8aFAjV0  compatible               = 10.2.0.3.0
(`;WC|`h0|Y"w,_0  log_archive_start        = TRUEITPUB个人空间-AX K6yC.T#s
  db_file_multiblock_read_count= 16
t{|,o,b7^b0  db_create_file_dest      = d:\oracle\product\10.2.0\oradata
;I3Dnuk l+}h0  db_recovery_file_dest    = d:\oracle\product\10.2.0\flash_recovery_area
pU2dA!o$IXE0  db_recovery_file_dest_size= 2147483648ITPUB个人空间4y&dm:UY
  undo_management          = AUTO
fC*M1v7] FT4`_0  undo_tablespace          = UNDOTBS1
+whL!Ql0  O7_DICTIONARY_ACCESSIBILITY= TRUEITPUB个人空间n8d#U+I;` {
  remote_login_passwordfile= EXCLUSIVEITPUB个人空间@R;V` },o"n7G*An_}$oR
  db_domain                =
E9KB6M$i3N S0  dispatchers              = (protocol=tcp)(dispatchers=10)
.a*M$Zm-Y.Yf0  utl_file_dir             = DEFAULT
a0WsRX&v0  job_queue_processes      = 10
1f b7m bR K0  audit_file_dest          = D:\ORACLE\PRODUCT\10.2.0\ADMIN\fox\ADUMPITPUB个人空间(FK%~&Q9W
  background_dump_dest     = D:\ORACLE\PRODUCT\10.2.0\ADMIN\fox\BDUMP
7DYmaq_0  user_dump_dest           = D:\ORACLE\PRODUCT\10.2.0\ADMIN\fox\UDUMP
X#p{;|:p+e] |v0  core_dump_dest           = D:\ORACLE\PRODUCT\10.2.0\ADMIN\fox\CDUMP
rn8s:gDx9n8V0  db_name                  = fox
(`v7e/GCE(P0  open_cursors             = 300ITPUB个人空间qW'N]7d`u3s]]
  pga_aggregate_target     = 203423744ITPUB个人空间5q}Q
I(p;byZ,q|
Deprecated system parameters with specified values:
*r;I3n-J2S\vP%p0  log_archive_start       ITPUB个人空间"Ot C9S:Ie]
End of deprecated system parameter listingITPUB个人空间3]!qLj5Kg
PMON started with pid=2, OS id=113692ITPUB个人空间.F!~V.V|U?i
PSP0 started with pid=3, OS id=113696ITPUB个人空间"V@4KL
V`7`0`,R.z n
MMAN started with pid=4, OS id=113700
+@}9Va*uoWB W0DBW0 started with pid=5, OS id=113704
+@+PS_5Did!k0LGWR started with pid=6, OS id=113708
YCS!nq0CKPT started with pid=7, OS id=113712ITPUB个人空间aKk YrK pA
SMON started with pid=8, OS id=113716ITPUB个人空间 ?'Z%\,]h&@z8^xbe
RECO started with pid=9, OS id=113720
@X;It,~ dcU0CJQ0 started with pid=10, OS id=113724ITPUB个人空间6ks"x ?i
MMON started with pid=11, OS id=113728ITPUB个人空间v]
viH+@c0k
Wed Dec 19 21:10:51 2007
tZ1b5I2_t0starting up 10 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=tcp))'...
4n\4`8Y,S"r0Wed Dec 19 21:10:51 2007ITPUB个人空间X&~RN%X[$oC
starting up 1 shared server(s) ...
E5DwL+za6n0MMNL started with pid=12, OS id=113732
9\Qz'co/D?)[\0Wed Dec 19 21:10:52 2007
tO f;c f{0ALTER DATABASE   MOUNT
,|KFm9e}Bc?B0Wed Dec 19 21:10:59 2007
p `9B!P-eT*H0Setting recovery target incarnation to 3
}8^B(N%I7s2I$N0Wed Dec 19 21:10:59 2007
h,b rGM0Successful mount of redo thread 1, with mount id 571660766ITPUB个人空间~9j;u%Wy~&c4v$}!W
Wed Dec 19 21:10:59 2007
f#CfKJJ0Database mounted in Exclusive ModeITPUB个人空间;}1b"Wf0K\y@ FUY
Completed: ALTER DATABASE   MOUNT
a2j)T*zX yy1d o0Wed Dec 19 21:11:00 2007ITPUB个人空间!x
zF8{@E7D?-s#B
ALTER DATABASE OPENITPUB个人空间0o*l6E%} U.~
Wed Dec 19 21:11:00 2007ITPUB个人空间9n3O0l rt4W
LGWR: STARTING ARCH PROCESSESITPUB个人空间qx*r4q`,q[eT1[
ARC0 started with pid=25, OS id=113880
3q0BQ;P7I0}v0Wed Dec 19 21:11:00 2007
l#M4QE$^-j?0ARC0: Archival started
i1o*p(?9XW-um0Wed Dec 19 21:11:00 2007
1Nm*Z
}%_!\"s6W0ARC1: Archival started
q#C,ejP0LGWR: STARTING ARCH PROCESSES COMPLETE
/TfU2aC3d6So!o0Thread 1 opened at log sequence 65ITPUB个人空间Zs'Ff/x*CoV
  Current log# 1 seq# 65 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\fox\REDO01.LOG
W@)J?$hc g0Wed Dec 19 21:11:01 2007ITPUB个人空间:^y
_-{,o,qR8w
Successful open of redo thread 1ITPUB个人空间tZcc~-UG7I
Wed Dec 19 21:11:01 2007ITPUB个人空间6H,B`@
P
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not setITPUB个人空间/KxJ3cu
ARC1 started with pid=26, OS id=113884
?,{'N5T,J*E0Wed Dec 19 21:11:02 2007ITPUB个人空间F!Z1b,Lixo
ARC0: Becoming the 'no FAL' ARCH
y;Uh!J?F0Wed Dec 19 21:11:02 2007ITPUB个人空间U1eys
]p
ARC0: Becoming the 'no SRL' ARCHITPUB个人空间u.H??}C
Wed Dec 19 21:11:02 2007
MA jpT^&W0ARC1: Becoming the heartbeat ARCHITPUB个人空间 Wx;H q-M_#e
Wed Dec 19 21:11:02 2007
~Bwx$h*U4h+o`.\4d0SMON: enabling cache recovery

dc5`4rnB R5_0Wed Dec 19 21:11:03 2007ITPUB个人空间$I e,GQH
Successfully onlined Undo Tablespace 1.
u&THPu5L+LaP0Wed Dec 19 21:11:03 2007ITPUB个人空间:y MhU%?QR T
SMON: enabling tx recovery
V/ZC.G]`A9VW0Wed Dec 19 21:11:03 2007
+i,F;g*Z;_
}0Database Characterset is ZHS16GBKITPUB个人空间]7H`o|1H+VQ
replication_dependency_tracking turned off (no async multimaster replication found)
8bx/m!`$PT0Starting background process QMNCITPUB个人空间GJg/@EF
QMNC started with pid=27, OS id=113908ITPUB个人空间fZ
mks
Wed Dec 19 21:11:09 2007
X!jczpJ.z0db_recovery_file_dest_size of 2048 MB is 68.47% used. This is aITPUB个人空间pt.VHt)J8LP h
user-specified limit on the amount of space that will be used by this
WD"` `W3b'uH [j0database for recovery-related files, and does not reflect the amount ofITPUB个人空间b,hV r&Wt8h)P?-i
space available in the underlying filesystem or ASM diskgroup.
4^ov%t[5Q"{!s;|0Wed Dec 19 21:11:09 2007ITPUB个人空间y9`|
E ?z
Completed: ALTER DATABASE OPEN
1y9w3\9o:}{[0