ITPub博客

我的10G数据库开启LOG

原创 Linux操作系统 作者:浪漫双鱼 时间:2007-12-19 21:12:14 0 删除 编辑
Wed Dec 19 21:10:50 2007
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 =18
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.3.0.
System parameters with non-default values:
  processes                = 150
  timed_statistics         = TRUE
  resource_limit           = FALSE
  __shared_pool_size       = 314572800
  __large_pool_size        = 12582912
  __java_pool_size         = 4194304
  __streams_pool_size      = 0
  nls_language             = SIMPLIFIED CHINESE
  nls_territory            = CHINA
  sga_target               = 612368384
  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.CTL
  db_block_size            = 8192
  __db_cache_size          = 272629760
  compatible               = 10.2.0.3.0
  log_archive_start        = TRUE
  db_file_multiblock_read_count= 16
  db_create_file_dest      = d:\oracle\product\10.2.0\oradata
  db_recovery_file_dest    = d:\oracle\product\10.2.0\flash_recovery_area
  db_recovery_file_dest_size= 2147483648
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  O7_DICTIONARY_ACCESSIBILITY= TRUE
  remote_login_passwordfile= EXCLUSIVE
  db_domain                =
  dispatchers              = (protocol=tcp)(dispatchers=10)
  utl_file_dir             = DEFAULT
  job_queue_processes      = 10
  audit_file_dest          = D:\ORACLE\PRODUCT\10.2.0\ADMIN\fox\ADUMP
  background_dump_dest     = D:\ORACLE\PRODUCT\10.2.0\ADMIN\fox\BDUMP
  user_dump_dest           = D:\ORACLE\PRODUCT\10.2.0\ADMIN\fox\UDUMP
  core_dump_dest           = D:\ORACLE\PRODUCT\10.2.0\ADMIN\fox\CDUMP
  db_name                  = fox
  open_cursors             = 300
  pga_aggregate_target     = 203423744
Deprecated system parameters with specified values:
  log_archive_start       
End of deprecated system parameter listing
PMON started with pid=2, OS id=113692
PSP0 started with pid=3, OS id=113696
MMAN started with pid=4, OS id=113700
DBW0 started with pid=5, OS id=113704
LGWR started with pid=6, OS id=113708
CKPT started with pid=7, OS id=113712
SMON started with pid=8, OS id=113716
RECO started with pid=9, OS id=113720
CJQ0 started with pid=10, OS id=113724
MMON started with pid=11, OS id=113728
Wed Dec 19 21:10:51 2007
starting up 10 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=tcp))'...
Wed Dec 19 21:10:51 2007
starting up 1 shared server(s) ...
MMNL started with pid=12, OS id=113732
Wed Dec 19 21:10:52 2007
ALTER DATABASE   MOUNT
Wed Dec 19 21:10:59 2007
Setting recovery target incarnation to 3
Wed Dec 19 21:10:59 2007
Successful mount of redo thread 1, with mount id 571660766
Wed Dec 19 21:10:59 2007
Database mounted in Exclusive Mode
Completed: ALTER DATABASE   MOUNT
Wed Dec 19 21:11:00 2007
ALTER DATABASE OPEN
Wed Dec 19 21:11:00 2007
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=25, OS id=113880
Wed Dec 19 21:11:00 2007
ARC0: Archival started
Wed Dec 19 21:11:00 2007
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
Thread 1 opened at log sequence 65
  Current log# 1 seq# 65 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\fox\REDO01.LOG
Wed Dec 19 21:11:01 2007
Successful open of redo thread 1
Wed Dec 19 21:11:01 2007
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
ARC1 started with pid=26, OS id=113884
Wed Dec 19 21:11:02 2007
ARC0: Becoming the 'no FAL' ARCH
Wed Dec 19 21:11:02 2007
ARC0: Becoming the 'no SRL' ARCH
Wed Dec 19 21:11:02 2007
ARC1: Becoming the heartbeat ARCH
Wed Dec 19 21:11:02 2007
SMON: enabling cache recovery
Wed Dec 19 21:11:03 2007
Successfully onlined Undo Tablespace 1.
Wed Dec 19 21:11:03 2007
SMON: enabling tx recovery
Wed Dec 19 21:11:03 2007
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=27, OS id=113908
Wed Dec 19 21:11:09 2007
db_recovery_file_dest_size of 2048 MB is 68.47% 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.
Wed Dec 19 21:11:09 2007
Completed: ALTER DATABASE OPEN

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11088128/viewspace-911/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2007-12-10

  • 博文量
    91
  • 访问量
    219259