使用init.ora参数文件启动数据库:
[oracle@jumper dbs]$ sqlplus "/ as sysdba"SQL*Plus: Release 9.2.0.4.0 - Production on Sat Jan 21 13:56:47 2006Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.Connected to an idle instance.SQL> startup pfile=initconner.ora
ORACLE instance started.Total System Global Area 97588504 bytes
Fixed Size 451864 bytes
Variable Size 33554432 bytes
Database Buffers 62914560 bytes
Redo Buffers 667648 bytes
Database mounted.
Database opened.
此时数据库正常Open。
观察alert文件可以获得如下信息:
Sat Jan 21 13:57:03 2006
SMON: enabling tx recovery
SMON: about to recover undo segment 11
SMON: mark undo segment 11 as needs recovery
SMON: about to recover undo segment 12
SMON: mark undo segment 12 as needs recovery
SMON: about to recover undo segment 13
SMON: mark undo segment 13 as needs recovery
Sat Jan 21 13:57:03 2006
Database Characterset is ZHS16GBK
Sat Jan 21 13:57:03 2006
SMON: about to recover undo segment 11
SMON: mark undo segment 11 as needs recovery
SMON: about to recover undo segment 12
SMON: mark undo segment 12 as needs recovery
SMON: about to recover undo segment 13
SMON: mark undo segment 13 as needs recovery
Sat Jan 21 13:57:04 2006
Created Undo Segment _SYSSMU1$
Undo Segment 1 Onlined
Completed: ALTER DATABASE OPEN
aSat Jan 21 14:02:11 2006
SMON: about to recover undo segment 11
SMON: mark undo segment 11 as needs recovery
SMON: about to recover undo segment 12
SMON: mark undo segment 12 as needs recovery
SMON: about to recover undo segment 13
SMON: mark undo segment 13 as needs recovery
此时可以重新创建新的UNDO表空间，删除出现问题的表空间，修改参数文件，由参数文件生成新的spfile，重新启动数据库：
SQL> create undo tablespace undotbs1
2 datafile '/opt/oracle/oradata/conner/undotbs1.dbf' size 10M;Tablespace created.SQL> alter system set undo_tablespace=undotbs1;System altered.
SQL> drop tablespace undotbs2;Tablespace dropped.
此时的alert文件记录的:
Sat Jan 21 14:03:29 2006
create undo tablespace undotbs1
datafile '/opt/oracle/oradata/conner/undotbs1.dbf' size 10M
Sat Jan 21 14:03:29 2006
Created Undo Segment _SYSSMU2$
Created Undo Segment _SYSSMU3$
Created Undo Segment _SYSSMU4$
Created Undo Segment _SYSSMU5$
Created Undo Segment _SYSSMU6$
Created Undo Segment _SYSSMU7$
Created Undo Segment _SYSSMU8$
Created Undo Segment _SYSSMU9$
Created Undo Segment _SYSSMU10$
Created Undo Segment _SYSSMU14$
Starting control autobackup
Control autobackup written to DISK device
handle '/opt/oracle/product/9.2.0/dbs/c-3152029224-20060121-00'
Completed: create undo tablespace undotbs1
datafile '/opt/ora
Sat Jan 21 14:03:43 2006
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Undo Segment 14 Onlined
Successfully onlined Undo Tablespace 1.
Undo Segment 1 Offlined
Undo Tablespace 16 successfully switched out.
Sat Jan 21 14:03:43 2006
ALTER SYSTEM SET undo_tablespace='UNDOTBS1' SCOPE=MEMORY;
Sat Jan 21 14:07:18 2006
SMON: about to recover undo segment 11
SMON: mark undo segment 11 as needs recovery
SMON: about to recover undo segment 12
SMON: mark undo segment 12 as needs recovery
SMON: about to recover undo segment 13
SMON: mark undo segment 13 as needs recovery
Sat Jan 21 14:08:06 2006
drop tablespace undotbs2
Sat Jan 21 14:08:07 2006
Starting control autobackup
Control autobackup written to DISK device
handle '/opt/oracle/product/9.2.0/dbs/c-3152029224-20060121-01'
Completed: drop tablespace undotbs2
修改参数文件，变更undo表空间，并取消_corrupted_rollback_segments设置:
*.undo_tablespace='UNDOTBS1'
由参数文件创建spfile文件。
SQL> create spfile from pfile;File created.SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.Total System Global Area 97588504 bytes
Fixed Size 451864 bytes
Variable Size 33554432 bytes
Database Buffers 62914560 bytes
Redo Buffers 667648 bytes
Database mounted.
Database opened.
重起数据库，观察alert文件:
Sat Jan 21 14:08:36 2006
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Undo Segment 14 Onlined
Successfully onlined Undo Tablespace 1.
此时数据库恢复正常，通常建议立即全库exp，然后重新建库，再imp恢复数据库。
最后附上几次启动数据库的日志供参考:
Starting ORACLE instance (normal)
Sat Jan 21 13:55:15 2006
WARNING: EINVAL creating segment of size 0x0000000007400000
fix shm parameters in /etc/system or equivalent
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.4.0.
System parameters with non-default values:
_latch_class_1 = 10000
_latch_classes = 98:1
processes = 150
timed_statistics = FALSE
event =
shared_pool_size = 20971520
large_pool_size = 16777216
java_pool_size = 0
_kghdsidx_count = 1
control_files = /opt/oracle/oradata/conner/control01.ctl,
/opt/oracle/oradata/conner/control02.ctl,
/opt/oracle/oradata/conner/control03.ctl
db_block_size = 8192
db_2k_cache_size = 20971520
db_cache_size = 41943040
compatible = 9.2.0.0.0
log_archive_start = TRUE
log_archive_dest = /opt/oracle/oradata/conner/archive
_disable_logging = TRUE
db_files = 8
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
_allow_resetlogs_corruption= TRUE
_corrupted_rollback_segments=
undo_management = AUTO
undo_tablespace = UNDOTBS2
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
global_names = TRUE
instance_name = conner
utl_file_dir = /tmp
job_queue_processes = 0
_system_trig_enabled = FALSE
hash_join_enabled = TRUE
background_dump_dest = /opt/oracle/admin/conner/bdump
user_dump_dest = /opt/oracle/admin/conner/udump
core_dump_dest = /opt/oracle/admin/conner/cdump
audit_trail = DB
sort_area_size = 524288
db_name = conner
open_cursors = 300
sql_trace = FALSE
optimizer_mode = CHOOSE
star_transformation_enabled= FALSE
optimizer_index_cost_adj = 10000
query_rewrite_enabled = FALSE
_left_nested_loops_random= FALSE
_use_nosegment_indexes = FALSE
pga_aggregate_target = 20480000
aq_tm_processes = 0
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
Sat Jan 21 13:55:16 2006
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=8
ARC0: Archival started
Sat Jan 21 13:55:16 2006
ARCH: STARTING ARCH PROCESSES COMPLETE
Sat Jan 21 13:55:16 2006
ARC0: Thread not mounted
ARC1 started with pid=9
ARC1: Archival started
ARC1: Thread not mounted
Sat Jan 21 13:55:16 2006
ALTER DATABASE MOUNT
Sat Jan 21 13:55:20 2006
Successful mount of redo thread 1, with mount id 3192212932.
Sat Jan 21 13:55:20 2006
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Sat Jan 21 13:55:20 2006
ALTER DATABASE OPEN
Sat Jan 21 13:55:20 2006
Beginning crash recovery of 1 threads
Sat Jan 21 13:55:20 2006
Started first pass scan
Sat Jan 21 13:55:21 2006
Completed first pass scan
0 redo blocks read, 0 data blocks need recovery
Sat Jan 21 13:55:21 2006
Started recovery at
Thread 1: logseq 42, block 3, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 1 Seq 42 Reading mem 0
Mem# 0 errs 0: /opt/oracle/oradata/conner/redo01.log
Sat Jan 21 13:55:21 2006
Completed redo application
Sat Jan 21 13:55:21 2006
Ended recovery at
Thread 1: logseq 42, block 3, scn 2073.1734548
0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
Sat Jan 21 13:55:21 2006
Thread 1 advanced to log sequence 43
Thread 1 opened at log sequence 43
Current log# 3 seq# 43 mem# 0: /opt/oracle/oradata/conner/redo03.log
Successful open of redo thread 1.
Sat Jan 21 13:55:21 2006
ARC0: Media recovery disabled
Sat Jan 21 13:55:21 2006
SMON: enabling cache recovery
Sat Jan 21 13:55:21 2006
Undo Segment 11 Onlined
Undo Segment 12 Onlined
Undo Segment 13 Onlined
Successfully onlined Undo Tablespace 16.
Sat Jan 21 13:55:21 2006
SMON: enabling tx recovery
Sat Jan 21 13:55:21 2006
Database Characterset is ZHS16GBK
Sat Jan 21 13:55:21 2006
Errors in file /opt/oracle/admin/conner/bdump/conner_smon_17113.trc:
ORA-00600: internal error code, arguments: [4194], [43], [46], [], [], [], [], []
Sat Jan 21 13:55:21 2006
Errors in file /opt/oracle/admin/conner/udump/conner_ora_17121.trc:
ORA-00600: internal error code, arguments: [4194], [45], [44], [], [], [], [], []
Sat Jan 21 13:55:26 2006
Recovery of Online Redo Log: Thread 1 Group 3 Seq 43 Reading mem 0
Mem# 0 errs 0: /opt/oracle/oradata/conner/redo03.log
Sat Jan 21 13:55:26 2006
Recovery of Online Redo Log: Thread 1 Group 3 Seq 43 Reading mem 0
Mem# 0 errs 0: /opt/oracle/oradata/conner/redo03.log
Sat Jan 21 13:55:26 2006
Recovery of Online Redo Log: Thread 1 Group 3 Seq 43 Reading mem 0
Mem# 0 errs 0: /opt/oracle/oradata/conner/redo03.log
Sat Jan 21 13:55:26 2006
Recovery of Online Redo Log: Thread 1 Group 3 Seq 43 Reading mem 0
Mem# 0 errs 0: /opt/oracle/oradata/conner/redo03.log
Sat Jan 21 13:55:26 2006
Errors in file /opt/oracle/admin/conner/bdump/conner_smon_17113.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [43], [46], [], [], [], [], []
Sat Jan 21 13:55:26 2006
Errors in file /opt/oracle/admin/conner/udump/conner_ora_17121.trc:
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [45], [44], [], [], [], [], []
Error 607 happened during db open, shutting down database
USER: terminating instance due to error 607
Instance terminated by USER, pid = 17121
ORA-1092 signalled during: ALTER DATABASE OPEN...Sat Jan 21 13:56:58 2006
Starting ORACLE instance (normal)
Sat Jan 21 13:56:58 2006
WARNING: EINVAL creating segment of size 0x0000000006400000
fix shm parameters in /etc/system or equivalent
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.4.0.
System parameters with non-default values:
_latch_class_1 = 10000
_latch_classes = 98:1
processes = 150
timed_statistics = FALSE
shared_pool_size = 20971520
large_pool_size = 0
java_pool_size = 0
_kghdsidx_count = 1
control_files = /opt/oracle/oradata/conner/control01.ctl,
/opt/oracle/oradata/conner/control02.ctl,
/opt/oracle/oradata/conner/control03.ctl
db_block_size = 8192
db_2k_cache_size = 20971520
db_cache_size = 41943040
compatible = 9.2.0.0.0
log_archive_start = TRUE
log_archive_dest = /opt/oracle/oradata/conner/archive
_disable_logging = TRUE
db_files = 8
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
_allow_resetlogs_corruption= TRUE
_corrupted_rollback_segments= _SYSSMU11$, _SYSSMU12$, _SYSSMU13$
undo_management = AUTO
undo_tablespace = UNDOTBS2
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
global_names = TRUE
instance_name = conner
utl_file_dir = /tmp
job_queue_processes = 0
_system_trig_enabled = FALSE
hash_join_enabled = TRUE
background_dump_dest = /opt/oracle/admin/conner/bdump
user_dump_dest = /opt/oracle/admin/conner/udump
core_dump_dest = /opt/oracle/admin/conner/cdump
audit_trail = DB
sort_area_size = 524288
db_name = conner
open_cursors = 300
sql_trace = FALSE
optimizer_mode = CHOOSE
star_transformation_enabled= FALSE
optimizer_index_cost_adj = 10000
query_rewrite_enabled = FALSE
_left_nested_loops_random= FALSE
_use_nosegment_indexes = FALSE
pga_aggregate_target = 20480000
aq_tm_processes = 0
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
Sat Jan 21 13:56:58 2006
ARCH: STARTING ARCH PROCESSES
RECO started with pid=7
ARC0 started with pid=8
ARC0: Archival started
ARC1 started with pid=9
Sat Jan 21 13:56:58 2006
ARCH: STARTING ARCH PROCESSES COMPLETE
Sat Jan 21 13:56:58 2006
ARC1: Archival started
ARC1: Thread not mounted
Sat Jan 21 13:56:58 2006
ARC0: Thread not mounted
Sat Jan 21 13:56:58 2006
ALTER DATABASE MOUNT
Sat Jan 21 13:57:03 2006
Successful mount of redo thread 1, with mount id 3192214826.
Sat Jan 21 13:57:03 2006
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Sat Jan 21 13:57:03 2006
ALTER DATABASE OPEN
Sat Jan 21 13:57:03 2006
Beginning crash recovery of 1 threads
Sat Jan 21 13:57:03 2006
Started first pass scan
Sat Jan 21 13:57:03 2006
Completed first pass scan
0 redo blocks read, 0 data blocks need recovery
Sat Jan 21 13:57:03 2006
Started recovery at
Thread 1: logseq 44, block 2, scn 2073.1754552
Recovery of Online Redo Log: Thread 1 Group 4 Seq 44 Reading mem 0
Mem# 0 errs 0: /opt/oracle/oradata/conner/redo04.log
Sat Jan 21 13:57:03 2006
Completed redo application
Sat Jan 21 13:57:03 2006
Ended recovery at
Thread 1: logseq 44, block 2, scn 2073.1774553
0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
Sat Jan 21 13:57:03 2006
Thread 1 advanced to log sequence 45
Thread 1 opened at log sequence 45
Current log# 2 seq# 45 mem# 0: /opt/oracle/oradata/conner/redo02.log
Successful open of redo thread 1.
Sat Jan 21 13:57:03 2006
ARC0: Media recovery disabled
Sat Jan 21 13:57:03 2006
SMON: enabling cache recovery
Sat Jan 21 13:57:03 2006
Successfully onlined Undo Tablespace 16.
Sat Jan 21 13:57:03 2006
SMON: enabling tx recovery
SMON: about to recover undo segment 11
SMON: mark undo segment 11 as needs recovery
SMON: about to recover undo segment 12
SMON: mark undo segment 12 as needs recovery
SMON: about to recover undo segment 13
SMON: mark undo segment 13 as needs recovery
Sat Jan 21 13:57:03 2006
Database Characterset is ZHS16GBK
Sat Jan 21 13:57:03 2006
SMON: about to recover undo segment 11
SMON: mark undo segment 11 as needs recovery
SMON: about to recover undo segment 12
SMON: mark undo segment 12 as needs recovery
SMON: about to recover undo segment 13
SMON: mark undo segment 13 as needs recovery
Sat Jan 21 13:57:04 2006
Created Undo Segment _SYSSMU1$
Undo Segment 1 Onlined
Completed: ALTER DATABASE OPEN
aSat Jan 21 14:02:11 2006
SMON: about to recover undo segment 11
SMON: mark undo segment 11 as needs recovery
SMON: about to recover undo segment 12
SMON: mark undo segment 12 as needs recovery
SMON: about to recover undo segment 13
SMON: mark undo segment 13 as needs recovery
Sat Jan 21 14:03:29 2006
create undo tablespace undotbs1
datafile '/opt/oracle/oradata/conner/undotbs1.dbf' size 10M
Sat Jan 21 14:03:29 2006
Created Undo Segment _SYSSMU2$
Created Undo Segment _SYSSMU3$
Created Undo Segment _SYSSMU4$
Created Undo Segment _SYSSMU5$
Created Undo Segment _SYSSMU6$
Created Undo Segment _SYSSMU7$
Created Undo Segment _SYSSMU8$
Created Undo Segment _SYSSMU9$
Created Undo Segment _SYSSMU10$
Created Undo Segment _SYSSMU14$
Starting control autobackup
Control autobackup written to DISK device
handle '/opt/oracle/product/9.2.0/dbs/c-3152029224-20060121-00'
Completed: create undo tablespace undotbs1
datafile '/opt/ora
Sat Jan 21 14:03:43 2006
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Undo Segment 14 Onlined
Successfully onlined Undo Tablespace 1.
Undo Segment 1 Offlined
Undo Tablespace 16 successfully switched out.
Sat Jan 21 14:03:43 2006
ALTER SYSTEM SET undo_tablespace='UNDOTBS1' SCOPE=MEMORY;
Sat Jan 21 14:07:18 2006
SMON: about to recover undo segment 11
SMON: mark undo segment 11 as needs recovery
SMON: about to recover undo segment 12
SMON: mark undo segment 12 as needs recovery
SMON: about to recover undo segment 13
SMON: mark undo segment 13 as needs recovery
Sat Jan 21 14:08:06 2006
drop tablespace undotbs2
Sat Jan 21 14:08:07 2006
Starting control autobackup
Control autobackup written to DISK device
handle '/opt/oracle/product/9.2.0/dbs/c-3152029224-20060121-01'
Completed: drop tablespace undotbs2
Sat Jan 21 14:08:23 2006
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 1
Sat Jan 21 14:08:23 2006
ALTER DATABASE CLOSE NORMAL
Sat Jan 21 14:08:23 2006
SMON: disabling tx recovery
SMON: disabling cache recovery
Sat Jan 21 14:08:23 2006
Shutting down archive processes
Archiving is disabled
Sat Jan 21 14:08:23 2006
ARCH shutting down
ARC0: Archival stopped
Sat Jan 21 14:08:23 2006
ARCH shutting down
ARC1: Archival stopped
Sat Jan 21 14:08:23 2006
Thread 1 closed at log sequence 45
Successful close of redo thread 1.
Sat Jan 21 14:08:23 2006
Completed: ALTER DATABASE CLOSE NORMAL
Sat Jan 21 14:08:23 2006
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Sat Jan 21 14:08:30 2006
Starting ORACLE instance (normal)
Sat Jan 21 14:08:31 2006
WARNING: EINVAL creating segment of size 0x0000000006400000
fix shm parameters in /etc/system or equivalent
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.4.0.
System parameters with non-default values:
_latch_class_1 = 10000
_latch_classes = 98:1
processes = 150
timed_statistics = FALSE
shared_pool_size = 20971520
large_pool_size = 0
java_pool_size = 0
_kghdsidx_count = 1
control_files = /opt/oracle/oradata/conner/control01.ctl,
/opt/oracle/oradata/conner/control02.ctl,
/opt/oracle/oradata/conner/control03.ctl
db_block_size = 8192
db_2k_cache_size = 20971520
db_cache_size = 41943040
compatible = 9.2.0.0.0
log_archive_start = TRUE
log_archive_dest = /opt/oracle/oradata/conner/archive
_disable_logging = TRUE
db_files = 8
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
_allow_resetlogs_corruption= TRUE
_corrupted_rollback_segments=
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
global_names = TRUE
instance_name = conner
utl_file_dir = /tmp
job_queue_processes = 0
_system_trig_enabled = FALSE
hash_join_enabled = TRUE
background_dump_dest = /opt/oracle/admin/conner/bdump
user_dump_dest = /opt/oracle/admin/conner/udump
core_dump_dest = /opt/oracle/admin/conner/cdump
audit_trail = DB
sort_area_size = 524288
db_name = conner
open_cursors = 300
sql_trace = FALSE
optimizer_mode = CHOOSE
star_transformation_enabled= FALSE
optimizer_index_cost_adj = 10000
query_rewrite_enabled = FALSE
_left_nested_loops_random= FALSE
_use_nosegment_indexes = FALSE
pga_aggregate_target = 20480000
aq_tm_processes = 0
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
Sat Jan 21 14:08:31 2006
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=8
ARC0: Archival started
Sat Jan 21 14:08:31 2006
ARCH: STARTING ARCH PROCESSES COMPLETE
Sat Jan 21 14:08:31 2006
ARC0: Thread not mounted
ARC1 started with pid=9
ARC1: Archival started
ARC1: Thread not mounted
Sat Jan 21 14:08:31 2006
ALTER DATABASE MOUNT
Sat Jan 21 14:08:36 2006
Successful mount of redo thread 1, with mount id 3192249311.
Sat Jan 21 14:08:36 2006
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Sat Jan 21 14:08:36 2006
ALTER DATABASE OPEN
Sat Jan 21 14:08:36 2006
Thread 1 opened at log sequence 45
Current log# 2 seq# 45 mem# 0: /opt/oracle/oradata/conner/redo02.log
Successful open of redo thread 1.
Sat Jan 21 14:08:36 2006
ARC1: Media recovery disabled
Sat Jan 21 14:08:36 2006
SMON: enabling cache recovery
Sat Jan 21 14:08:36 2006
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Undo Segment 14 Onlined
Successfully onlined Undo Tablespace 1.
Sat Jan 21 14:08:36 2006
SMON: enabling tx recovery
Sat Jan 21 14:08:36 2006
Database Characterset is ZHS16GBK
Completed: ALTER DATABASE OPEN 文章出处：
