Добрый день.
Упала база, ни стого ничего с утра просто не запустилась, ругнулась на UNDOTBS.
в алерте ничего критичного не увидел, база опустилась корректно.
Из-за чего такое могло случиться?
(Оракл 9, на winxp)
алерт:
Sat Nov 21 21:25:15 2009
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 6
All dispatchers and shared servers shutdown
Sat Nov 21 21:25:20 2009
alter database close normal
Sat Nov 21 21:25:20 2009
SMON: disabling tx recovery
Dump file c:\oracle92\admin\opk\bdump\alert_opk.log
Sun Nov 22 09:12:34 2009
ORACLE V9.2.0.7.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.1 Service Pack 2, CPU type 586
Sun Nov 22 09:12:34 2009
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.7.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size = 8388608
java_pool_size = 33554432
control_files = c:\oracle92\oradata\OPK\CONTROL01.CTL, c:\oracle92\oradata\OPK\CONTROL02.CTL, c:\oracle92\oradata\OPK\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = OPK
dispatchers = (PROTOCOL=TCP) (SERVICE=OPKXDB)
utl_file_dir = c:\out, D:\APPL\SQL_RUN\log, D:\APPL\SQL_RUN\in
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = c:\oracle92\admin\OPK\bdump
user_dump_dest = c:\oracle92\admin\OPK\udump
core_dump_dest = c:\oracle92\admin\OPK\cdump
sort_area_size = 524288
db_name = OPK
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Sun Nov 22 09:12:43 2009
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Sun Nov 22 09:12:46 2009
alter database mount exclusive
Sun Nov 22 09:12:54 2009
Successful mount of redo thread 1, with mount id 669204559
Sun Nov 22 09:12:54 2009
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Sun Nov 22 09:12:54 2009
alter database open
ORA-1113 signalled during: alter database open...
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 3