Total System Global Area 437749616 bytes
Fixed Size 730992 bytes
Variable Size 218103808 bytes
Database Buffers 218103808 bytes
Redo Buffers 811008 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
操作系统:
Solaris
日志如下:
Thu May 20 11:19:04 2010
Starting ORACLE instance (normal)
Thu May 20 11:19:04 2010
Running with 1 strand for Non-Enterprise Edition
LICENSE_MAX_SESSION = 200
LICENSE_SESSIONS_WARNING = 200
SCN scheme 3
Using log_archive_dest parameter default value
Running with 1 strand for Non-Enterprise Edition
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 = 200
sessions = 300
timed_statistics = TRUE
license_max_sessions = 200
license_sessions_warning = 200
shared_pool_size = 184549376
large_pool_size = 0
java_pool_size = 0
control_files = /opt/oracle/oradata/ora92/control01.ctl, /opt/oracle/oradata/ora92/control02.ctl, /opt/oracle/oradata/ora92/control03.ctl
db_block_size = 8192
db_cache_size = 218103808
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 0
undo_management = AUTO
undo_tablespace = UNDOTBS
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = ora92
session_cached_cursors = 200
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = /opt/oracle/admin/ora92/bdump
user_dump_dest = /opt/oracle/admin/ora92/udump
core_dump_dest = /opt/oracle/admin/ora92/cdump
session_max_open_files = 200
sort_area_size = 524288
db_name = ora92
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 26214400
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
Thu May 20 11:19:05 2010
Oracle Data Guard is not available in this edition of Oracle.
Thu May 20 11:19:05 2010
ALTER DATABASE MOUNT
Thu May 20 11:19:09 2010
Successful mount of redo thread 1, with mount id 2031455913
Thu May 20 11:19:09 2010
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Thu May 20 11:19:09 2010
ALTER DATABASE OPEN
Thu May 20 11:19:10 2010
Beginning crash recovery of 1 threads
Thu May 20 11:19:10 2010
Started recovery at
Thread 1: logseq 9, block 2, scn 0.345293
Thu May 20 11:19:10 2010
Recovery of Online Redo Log: Thread 1 Group 2 Seq 9 Reading mem 0
Mem# 0 errs 0: /opt/oracle/oradata/ora92/redo02.log
Thu May 20 11:19:10 2010
Completed redo application
Thu May 20 11:19:10 2010
Ended recovery at
Thread 1: logseq 9, block 3, scn 0.365294
0 data blocks read, 0 data blocks written, 1 redo blocks read
Crash recovery completed successfully
Thu May 20 11:19:10 2010
Thread 1 advanced to log sequence 10
Thread 1 opened at log sequence 10
Current log# 3 seq# 10 mem# 0: /opt/oracle/oradata/ora92/redo03.log
Successful open of redo thread 1
Thu May 20 11:19:10 2010
SMON: enabling cache recovery
Thu May 20 11:19:10 2010
Errors in file /opt/oracle/admin/ora92/udump/ora92_ora_1182.trc:
ORA-30012: undo tablespace 'UNDOTBS' does not exist or of wrong type
Thu May 20 11:19:10 2010
Error 30012 happened during db open, shutting down database
USER: terminating instance due to error 30012
Instance terminated by USER, pid = 1182
ORA-1092 signalled during: ALTER DATABASE OPEN...