в алерте нет ничего. Приведу часть алерта, как раз когда служба остановилась, а затем я уже стартую экземпляр:
Код:
Wed Dec 24 11:59:12 2014
Thread 1 advanced to log sequence 5219
Current log# 1 seq# 5219 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Current log# 1 seq# 5219 mem# 1: F:\ORACLE\ORADATA\ORCL\REDO11.LOG
Wed Dec 24 11:59:12 2014
ARC0: Evaluating archive log 2 thread 1 sequence 5218
ARC0: Beginning to archive log 2 thread 1 sequence 5218
Creating archive destination LOG_ARCHIVE_DEST_1: 'G:\ORACLE\ARCHLOGS\ARC5218.001'
ARC0: Completed archiving log 2 thread 1 sequence 5218
Dump file c:\oracle\admin\orcl\bdump\alert_orcl.log
Wed Dec 24 13:12:51 2014
ORACLE V9.2.0.7.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 2, CPU type 586
Wed Dec 24 13:12:51 2014
Starting ORACLE instance (normal)
Wed Dec 24 13:12:51 2014
Running with 1 strand for Non-Enterprise Edition
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Running with 1 strand for Non-Enterprise Edition
LICENSE_MAX_USERS = 80
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.7.0.
System parameters with non-default values:
processes = 200
timed_statistics = TRUE
resource_limit = TRUE
shared_pool_size = 67108864
sga_max_size = 1311320348
large_pool_size = 16777216
java_pool_size = 16777216
control_files = C:\oracle\oradata\orcl\control01.ctl, D:\oracle\oradata\orcl\control02.ctl, E:\oracle\oradata\orcl\control03.ctl, F:\oracle\oradata\orcl\control04.ctl
db_block_size = 8192
db_keep_cache_size = 0
db_recycle_cache_size = 109051904
db_cache_size = 1073741824
db_cache_advice = ON
compatible = 9.2.0.0.0
log_archive_start = TRUE
log_archive_dest = G:\oracle\archlogs
log_archive_dest_state_1 = defer
log_archive_dest_state_2 = defer
log_archive_dest_state_3 = defer
log_archive_dest_state_4 = defer
log_archive_dest_state_5 = defer
log_archive_dest_state_6 = defer
log_archive_dest_state_7 = defer
log_archive_dest_state_8 = defer
log_archive_dest_state_9 = defer
log_archive_dest_state_10= defer
log_archive_max_processes= 1
log_archive_format = ARC%s.%T
log_buffer = 2097152
db_file_multiblock_read_count= 15
fast_start_mttr_target = 0
log_checkpoints_to_alert = FALSE
control_file_record_keep_time= 15
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 86400
remote_os_authent = FALSE
O7_DICTIONARY_ACCESSIBILITY= FALSE
remote_login_passwordfile= EXCLUSIVE
license_max_users = 80
audit_sys_operations = FALSE
db_domain =
instance_name = orcl
service_names = ORCL
session_cached_cursors = 50
utl_file_dir = C:\oracle\oradata\utl_file
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = C:\oracle\admin\orcl\bdump
user_dump_dest = C:\oracle\admin\orcl\udump
core_dump_dest = C:\oracle\admin\orcl\cdump
audit_trail = NONE
sort_area_size = 524288
db_name = orcl
open_cursors = 400
os_authent_prefix =
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 83886080
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
Wed Dec 24 13:12:54 2014
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=10
Wed Dec 24 13:12:54 2014
ARCH: STARTING ARCH PROCESSES COMPLETE
Wed Dec 24 13:12:54 2014
Oracle Data Guard is not available in this edition of Oracle.
Wed Dec 24 13:12:55 2014
ALTER DATABASE MOUNT
Wed Dec 24 13:12:55 2014
ARC0: Archival started
Wed Dec 24 13:12:55 2014
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no FAL' ARCHARC0: Becoming the heartbeat ARCH
ARC0: Becoming the heartbeat ARCHARC0: Thread not mounted
Wed Dec 24 13:12:59 2014
Successful mount of redo thread 1, with mount id 1394921559
Wed Dec 24 13:12:59 2014
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Wed Dec 24 13:13:00 2014
ALTER DATABASE OPEN
Wed Dec 24 13:13:00 2014
Beginning crash recovery of 1 threads
Wed Dec 24 13:13:00 2014
Started recovery at
Thread 1: logseq 5218, block 166153, scn 0.0
Wed Dec 24 13:13:01 2014
Recovery of Online Redo Log: Thread 1 Group 2 Seq 5218 Reading mem 0
Mem# 0 errs 0: E:\ORACLE\ORADATA\ORCL\REDO02.LOG
Mem# 1 errs 0: D:\ORACLE\ORADATA\ORCL\REDO12.LOG
Wed Dec 24 13:13:04 2014
Recovery of Online Redo Log: Thread 1 Group 1 Seq 5219 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Mem# 1 errs 0: F:\ORACLE\ORADATA\ORCL\REDO11.LOG
Wed Dec 24 13:13:07 2014
Completed redo application
Wed Dec 24 13:13:09 2014
Ended recovery at
Thread 1: logseq 5219, block 145689, scn 4.673415397
9415 data blocks read, 8038 data blocks written, 184333 redo blocks read
Crash recovery completed successfully
Wed Dec 24 13:13:10 2014
LGWR: Primary database is in CLUSTER CONSISTENT mode
Thread 1 advanced to log sequence 5220
Thread 1 opened at log sequence 5220
Current log# 3 seq# 5220 mem# 0: F:\ORACLE\ORADATA\ORCL\REDO03.LOG
Current log# 3 seq# 5220 mem# 1: E:\ORACLE\ORADATA\ORCL\REDO13.LOG
Successful open of redo thread 1
Wed Dec 24 13:13:10 2014
ARC0: Evaluating archive log 1 thread 1 sequence 5219
Wed Dec 24 13:13:10 2014
SMON: enabling cache recovery
Wed Dec 24 13:13:10 2014
ARC0: Beginning to archive log 1 thread 1 sequence 5219
Creating archive destination LOG_ARCHIVE_DEST_1: 'G:\ORACLE\ARCHLOGS\ARC5219.001'
Wed Dec 24 13:13:10 2014
Successfully onlined Undo Tablespace 1.
Wed Dec 24 13:13:10 2014
SMON: enabling tx recovery
Wed Dec 24 13:13:10 2014
Database Characterset is CL8MSWIN1251
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: ALTER DATABASE OPEN
заметила что служба остановилась только потому, что редо давно не переключались. У пользователей обед был, за час никто не среагировал