- 最后登录
- 2017-5-4
- 在线时间
- 81 小时
- 威望
- 999
- 金钱
- 2391
- 注册时间
- 2013-9-11
- 阅读权限
- 150
- 帖子
- 1124
- 精华
- 5
- 积分
- 999
- UID
- 1220
|
1#
发表于 2017-4-15 10:18:01
|
查看: 1291 |
回复: 1
数据库 oracle10.2.0.3
如图 12:16 开机 自动启动数据库后 其他文件都更新了 redo时间未更新 估计是这里出问题了?
alter_log里面的日志如下
Mon Apr 01 12:16:00 2013
ORACLE V10.2.0.3.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows Server 2003 Version V5.2 Service Pack 2
CPU : 16 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:31357M/32756M, Ph+PgF:33463M/33847M, VA:3976M/4095M
Mon Apr 01 12:16:00 2013
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 1000
LICENSE_SESSIONS_WARNING = 1000
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 =121
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 = 1000
sessions = 1105
license_max_sessions = 1000
license_sessions_warning = 1000
__shared_pool_size = 427819008
__large_pool_size = 8388608
__java_pool_size = 8388608
__streams_pool_size = 8388608
sga_target = 1258291200
control_files = Z:\ORACLE\PRODUCT\10.2.0\ORADATA\SWFACE\CONTROL01.CTL, Z:\ORACLE\PRODUCT\10.2.0\ORADATA\SWFACE\CONTROL02.CTL, Z:\ORACLE\PRODUCT\10.2.0\ORADATA\SWFACE\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 796917760
compatible = 10.2.0.3.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = Z:\oracle\product\10.2.0\flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=SWFaceXDB)
session_cached_cursors = 1000
job_queue_processes = 10
audit_file_dest = Z:\ORACLE\PRODUCT\10.2.0\ADMIN\SWFACE\ADUMP
background_dump_dest = Z:\ORACLE\PRODUCT\10.2.0\ADMIN\SWFACE\BDUMP
user_dump_dest = Z:\ORACLE\PRODUCT\10.2.0\ADMIN\SWFACE\UDUMP
core_dump_dest = Z:\ORACLE\PRODUCT\10.2.0\ADMIN\SWFACE\CDUMP
session_max_open_files = 1000
db_name = SWFace
open_cursors = 300
pga_aggregate_target = 418381824
PSP0 started with pid=4, OS id=2776
MMAN started with pid=6, OS id=2780
DBW0 started with pid=8, OS id=2808
DBW1 started with pid=10, OS id=2812
LGWR started with pid=12, OS id=2816
CKPT started with pid=14, OS id=2820
SMON started with pid=16, OS id=2824
RECO started with pid=18, OS id=2828
CJQ0 started with pid=20, OS id=2832
MMON started with pid=22, OS id=2836
Mon Apr 01 12:16:03 2013
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=24, OS id=2840
Mon Apr 01 12:16:03 2013
starting up 1 shared server(s) ...
Mon Apr 01 12:16:04 2013
alter database mount exclusive
PMON started with pid=2, OS id=2772
Setting recovery target incarnation to 2
Mon Apr 01 12:16:08 2013
Successful mount of redo thread 1, with mount id 2957411652
Mon Apr 01 12:16:08 2013
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Mon Apr 01 12:16:08 2013
alter database open
ORA-1113 signalled during: alter database open...
Mon Apr 01 12:29:52 2013
db_recovery_file_dest_size of 2048 MB is 0.00% 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.
Mon Apr 01 13:51:59 2013
WARNING: inbound connection timed out (ORA-3136)
Mon Apr 01 14:04:40 2013
WARNING: inbound connection timed out (ORA-3136)
数据库里面有大量图片 我初来乍到 不敢乱动了,求大神支援 |
|