SQL> show parameter dumpNAME TYPE VALUE ------------------------------------ ----------- ------------------------------ background_core_dump string partial background_dump_dest string D:\oracle\admin\ora92xf\bdump core_dump_dest string D:\oracle\admin\ora92xf\cdump max_dump_file_size string UNLIMITED shadow_core_dump string partial user_dump_dest string D:\oracle\admin\ora92xf\udump在这里:background_dump_dest string D:\oracle\admin\ora92xf\bdump
建议用rman恢复一下,应该可以回到最近某个状态
%oracle_home%/[sid]/bdump几W条记录啊
找alert<sid>.log日志文件看看启动时的报错是什么
System parameters with non-default values: processes = 150 timed_statistics = TRUE shared_pool_size = 117440512 large_pool_size = 16777216 java_pool_size = 117440512 control_files = /u01/app/oracle/oradata/ORCL/control01.ctl, /u01/app/oracle/oradata/ORCL/control02.ctl, /u01/app/oracle/oradata/ORCL/control03.ctl db_block_size = 8192 db_cache_size = 33554432 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 = ORCL dispatchers = (PROTOCOL=TCP) (SERVICE=ORCLXDB) job_queue_processes = 10 _system_trig_enabled = FALSE hash_join_enabled = TRUE background_dump_dest = /u01/app/oracle/admin/ORCL/bdump user_dump_dest = /u01/app/oracle/admin/ORCL/udump core_dump_dest = /u01/app/oracle/admin/ORCL/cdump sort_area_size = 524288 db_name = ORCL open_cursors = 300 star_transformation_enabled= FALSE optimizer_index_cost_adj = 90 optimizer_index_caching = 80 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 Fri Jul 10 13:14:21 2009 starting up 1 shared server(s) ... starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... Fri Jul 10 13:14:21 2009 ALTER DATABASE MOUNT Fri Jul 10 13:14:25 2009 Successful mount of redo thread 1, with mount id 1219580461. Fri Jul 10 13:14:25 2009 Database mounted in Exclusive Mode. Completed: ALTER DATABASE MOUNT Fri Jul 10 13:14:25 2009 ALTER DATABASE OPEN Fri Jul 10 13:14:26 2009 Thread 1 opened at log sequence 3845 Current log# 2 seq# 3845 mem# 0: /u01/app/oracle/oradata/ORCL/redo02.log Successful open of redo thread 1. Fri Jul 10 13:14:26 2009 SMON: enabling cache recovery Fri Jul 10 13:14:26 2009 Undo Segment 1 Onlined 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 Successfully onlined Undo Tablespace 1. Fri Jul 10 13:14:27 2009 SMON: enabling tx recovery Fri Jul 10 13:14:27 2009 Database Characterset is ZHS16GBK Fri Jul 10 13:14:27 2009 Errors in file /u01/app/oracle/admin/ORCL/bdump/orcl_smon_7063.trc: ORA-00604: error occurred at recursive SQL level 1 ORA-00942: table or view does not exist replication_dependency_tracking turned off (no async multimaster replication found) ORA-604 signalled during: ALTER DATABASE OPEN... Fri Jul 10 13:16:21 2009 Restarting dead background process QMN0 QMN0 started with pid=16 Fri Jul 10 13:21:21 2009 Restarting dead background process QMN0 QMN0 started with pid=12 Fri Jul 10 13:26:21 2009 Restarting dead background process QMN0 QMN0 started with pid=12 Fri Jul 10 13:31:22 2009 Restarting dead background process QMN0 QMN0 started with pid=19 Fri Jul 10 13:36:22 2009 Restarting dead background process QMN0 QMN0 started with pid=19 Fri Jul 10 13:41:22 2009 Restarting dead background process QMN0 QMN0 started with pid=19 Fri Jul 10 13:46:22 2009 Restarting dead background process QMN0 QMN0 started with pid=19 Fri Jul 10 13:51:22 2009 Restarting dead background process QMN0 QMN0 started with pid=19 Fri Jul 10 13:56:22 2009 Restarting dead background process QMN0 QMN0 started with pid=17 Fri Jul 10 14:01:23 2009 Restarting dead background process QMN0 QMN0 started with pid=20 Fri Jul 10 14:06:23 2009 Restarting dead background process QMN0 QMN0 started with pid=19 Fri Jul 10 14:11:23 2009 Restarting dead background process QMN0 QMN0 started with pid=19 Fri Jul 10 14:16:23 2009 Restarting dead background process QMN0 QMN0 started with pid=19 Fri Jul 10 14:21:23 2009 Restarting dead background process QMN0 QMN0 started with pid=19 Fri Jul 10 14:26:23 2009 Restarting dead background process QMN0 QMN0 started with pid=19 Fri Jul 10 14:31:23 2009 Restarting dead background process QMN0 QMN0 started with pid=21 Fri Jul 10 14:36:24 2009 Restarting dead background process QMN0 QMN0 started with pid=21 Fri Jul 10 14:41:24 2009 Restarting dead background process QMN0 QMN0 started with pid=20 Fri Jul 10 14:46:24 2009 Restarting dead background process QMN0 QMN0 started with pid=25 Fri Jul 10 14:51:24 2009 Restarting dead background process QMN0 QMN0 started with pid=20 Fri Jul 10 14:56:24 2009 Restarting dead background process QMN0 QMN0 started with pid=13 Fri Jul 10 15:01:24 2009 Restarting dead background process QMN0 QMN0 started with pid=19 Fri Jul 10 15:06:27 2009 Restarting dead background process QMN0 QMN0 started with pid=24 Fri Jul 10 15:11:27 2009 Restarting dead background process QMN0 QMN0 started with pid=24 Fri Jul 10 15:16:27 2009 Restarting dead background process QMN0 QMN0 started with pid=20 Fri Jul 10 15:21:28 2009 Restarting dead background process QMN0 QMN0 started with pid=13 Fri Jul 10 15:26:28 2009 Restarting dead background process QMN0 QMN0 started with pid=20 Fri Jul 10 15:31:28 2009 Restarting dead background process QMN0 QMN0 started with pid=9 Fri Jul 10 15:36:28 2009 Restarting dead background process QMN0 QMN0 started with pid=17 Fri Jul 10 15:41:29 2009 Restarting dead background process QMN0 QMN0 started with pid=25 Fri Jul 10 15:46:29 2009 Restarting dead background process QMN0 QMN0 started with pid=25 Fri Jul 10 15:51:29 2009 Restarting dead background process QMN0 QMN0 started with pid=22
Fri Jul 10 12:50:20 2009 Errors in file /u01/app/oracle/admin/ORCL/udump/orcl_ora_18728.trc: ORA-07445: 出现异常: 核心转储 [kottins()+165] [SIGSEGV] [Address not mapped to object] [0x000000007] [] [] Fri Jul 10 12:54:45 2009 Restarting dead background process QMN0 QMN0 started with pid=12 Fri Jul 10 12:59:45 2009 Restarting dead background process QMN0 QMN0 started with pid=12 Fri Jul 10 13:04:45 2009 Restarting dead background process QMN0 QMN0 started with pid=21 Fri Jul 10 13:08:00 2009 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 SCN scheme 1 Using log_archive_dest parameter default value LICENSE_MAX_USERS = 0 SYS auditing is disabled Starting up ORACLE RDBMS Version: 9.2.0.4.0. System parameters with non-default values: processes = 150 timed_statistics = TRUE shared_pool_size = 117440512 large_pool_size = 16777216 java_pool_size = 117440512 control_files = /u01/app/oracle/oradata/ORCL/control01.ctl, /u01/app/oracle/oradata/ORCL/control02.ctl, /u01/app/oracle/oradata/ORCL/control03.ctl db_block_size = 8192 db_cache_size = 33554432 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 = ORCL dispatchers = (PROTOCOL=TCP) (SERVICE=ORCLXDB) job_queue_processes = 10 _system_trig_enabled = FALSE hash_join_enabled = TRUE background_dump_dest = /u01/app/oracle/admin/ORCL/bdump user_dump_dest = /u01/app/oracle/admin/ORCL/udump core_dump_dest = /u01/app/oracle/admin/ORCL/cdump sort_area_size = 524288 db_name = ORCL open_cursors = 300 star_transformation_enabled= FALSE optimizer_index_cost_adj = 90 optimizer_index_caching = 80 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 Fri Jul 10 13:08:01 2009 starting up 1 shared server(s) ... starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... Fri Jul 10 13:08:02 2009 ALTER DATABASE MOUNT Fri Jul 10 13:08:06 2009 Successful mount of redo thread 1, with mount id 1219595186. Fri Jul 10 13:08:06 2009 Database mounted in Exclusive Mode. Completed: ALTER DATABASE MOUNT Fri Jul 10 13:08:06 2009 ALTER DATABASE OPEN Fri Jul 10 13:08:08 2009 Beginning crash recovery of 1 threads Fri Jul 10 13:08:08 2009 Started first pass scan Fri Jul 10 13:08:10 2009 Completed first pass scan 154345 redo blocks read, 1159 data blocks need recovery Fri Jul 10 13:08:14 2009 Started recovery at Thread 1: logseq 3844, block 2679, scn 0.0 Recovery of Online Redo Log: Thread 1 Group 1 Seq 3844 Reading mem 0 Mem# 0 errs 0: /u01/app/oracle/oradata/ORCL/redo01.log Fri Jul 10 13:08:21 2009 Completed redo application Fri Jul 10 13:08:21 2009 Ended recovery at Thread 1: logseq 3844, block 157024, scn 0.107771442 1159 data blocks read, 1159 data blocks written, 154345 redo blocks read Crash recovery completed successfully Fri Jul 10 13:08:21 2009 Thread 1 advanced to log sequence 3845 Thread 1 opened at log sequence 3845 Current log# 2 seq# 3845 mem# 0: /u01/app/oracle/oradata/ORCL/redo02.log Successful open of redo thread 1. Fri Jul 10 13:08:22 2009 SMON: enabling cache recovery Fri Jul 10 13:08:22 2009 Undo Segment 1 Onlined 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 Successfully onlined Undo Tablespace 1. Fri Jul 10 13:08:22 2009 SMON: enabling tx recovery Fri Jul 10 13:08:22 2009 Database Characterset is ZHS16GBK Fri Jul 10 13:08:27 2009 Errors in file /u01/app/oracle/admin/ORCL/bdump/orcl_smon_3720.trc: ORA-00604: error occurred at recursive SQL level 1 ORA-00942: table or view does not exist replication_dependency_tracking turned off (no async multimaster replication found) ORA-604 signalled during: ALTER DATABASE OPEN... Fri Jul 10 13:10:02 2009 Restarting dead background process QMN0 QMN0 started with pid=9 Shutting down instance: further logons disabled Shutting down instance (immediate) License high water = 8 Waiting for shared server 'S000' to die All dispatchers and shared servers shutdown Fri Jul 10 13:14:08 2009 ALTER DATABASE CLOSE NORMAL Fri Jul 10 13:14:09 2009 SMON: disabling tx recovery SMON: disabling cache recovery Fri Jul 10 13:14:09 2009 Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active Thread 1 closed at log sequence 3845 Successful close of redo thread 1. Fri Jul 10 13:14:09 2009 Completed: ALTER DATABASE CLOSE NORMAL Fri Jul 10 13:14:09 2009 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 Fri Jul 10 13:14:21 2009 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 SCN scheme 1 Using log_archive_dest parameter default value LICENSE_MAX_USERS = 0 SYS auditing is disabled Starting up ORACLE RDBMS Version: 9.2.0.4.0.
应该是莫个系统创建的对象失效了或者丢失了。看看你的alert_<SID>.ora里有没有什么提示信息的。顺便你这个数据库有没有做过什么特别的操作,出错前。
------------------------------------ ----------- ------------------------------
background_core_dump string partial
background_dump_dest string D:\oracle\admin\ora92xf\bdump
core_dump_dest string D:\oracle\admin\ora92xf\cdump
max_dump_file_size string UNLIMITED
shadow_core_dump string partial
user_dump_dest string D:\oracle\admin\ora92xf\udump在这里:background_dump_dest string D:\oracle\admin\ora92xf\bdump
processes = 150
timed_statistics = TRUE
shared_pool_size = 117440512
large_pool_size = 16777216
java_pool_size = 117440512
control_files = /u01/app/oracle/oradata/ORCL/control01.ctl, /u01/app/oracle/oradata/ORCL/control02.ctl, /u01/app/oracle/oradata/ORCL/control03.ctl
db_block_size = 8192
db_cache_size = 33554432
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 = ORCL
dispatchers = (PROTOCOL=TCP) (SERVICE=ORCLXDB)
job_queue_processes = 10
_system_trig_enabled = FALSE
hash_join_enabled = TRUE
background_dump_dest = /u01/app/oracle/admin/ORCL/bdump
user_dump_dest = /u01/app/oracle/admin/ORCL/udump
core_dump_dest = /u01/app/oracle/admin/ORCL/cdump
sort_area_size = 524288
db_name = ORCL
open_cursors = 300
star_transformation_enabled= FALSE
optimizer_index_cost_adj = 90
optimizer_index_caching = 80
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
Fri Jul 10 13:14:21 2009
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Fri Jul 10 13:14:21 2009
ALTER DATABASE MOUNT
Fri Jul 10 13:14:25 2009
Successful mount of redo thread 1, with mount id 1219580461.
Fri Jul 10 13:14:25 2009
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Fri Jul 10 13:14:25 2009
ALTER DATABASE OPEN
Fri Jul 10 13:14:26 2009
Thread 1 opened at log sequence 3845
Current log# 2 seq# 3845 mem# 0: /u01/app/oracle/oradata/ORCL/redo02.log
Successful open of redo thread 1.
Fri Jul 10 13:14:26 2009
SMON: enabling cache recovery
Fri Jul 10 13:14:26 2009
Undo Segment 1 Onlined
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
Successfully onlined Undo Tablespace 1.
Fri Jul 10 13:14:27 2009
SMON: enabling tx recovery
Fri Jul 10 13:14:27 2009
Database Characterset is ZHS16GBK
Fri Jul 10 13:14:27 2009
Errors in file /u01/app/oracle/admin/ORCL/bdump/orcl_smon_7063.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist
replication_dependency_tracking turned off (no async multimaster replication found)
ORA-604 signalled during: ALTER DATABASE OPEN...
Fri Jul 10 13:16:21 2009
Restarting dead background process QMN0
QMN0 started with pid=16
Fri Jul 10 13:21:21 2009
Restarting dead background process QMN0
QMN0 started with pid=12
Fri Jul 10 13:26:21 2009
Restarting dead background process QMN0
QMN0 started with pid=12
Fri Jul 10 13:31:22 2009
Restarting dead background process QMN0
QMN0 started with pid=19
Fri Jul 10 13:36:22 2009
Restarting dead background process QMN0
QMN0 started with pid=19
Fri Jul 10 13:41:22 2009
Restarting dead background process QMN0
QMN0 started with pid=19
Fri Jul 10 13:46:22 2009
Restarting dead background process QMN0
QMN0 started with pid=19
Fri Jul 10 13:51:22 2009
Restarting dead background process QMN0
QMN0 started with pid=19
Fri Jul 10 13:56:22 2009
Restarting dead background process QMN0
QMN0 started with pid=17
Fri Jul 10 14:01:23 2009
Restarting dead background process QMN0
QMN0 started with pid=20
Fri Jul 10 14:06:23 2009
Restarting dead background process QMN0
QMN0 started with pid=19
Fri Jul 10 14:11:23 2009
Restarting dead background process QMN0
QMN0 started with pid=19
Fri Jul 10 14:16:23 2009
Restarting dead background process QMN0
QMN0 started with pid=19
Fri Jul 10 14:21:23 2009
Restarting dead background process QMN0
QMN0 started with pid=19
Fri Jul 10 14:26:23 2009
Restarting dead background process QMN0
QMN0 started with pid=19
Fri Jul 10 14:31:23 2009
Restarting dead background process QMN0
QMN0 started with pid=21
Fri Jul 10 14:36:24 2009
Restarting dead background process QMN0
QMN0 started with pid=21
Fri Jul 10 14:41:24 2009
Restarting dead background process QMN0
QMN0 started with pid=20
Fri Jul 10 14:46:24 2009
Restarting dead background process QMN0
QMN0 started with pid=25
Fri Jul 10 14:51:24 2009
Restarting dead background process QMN0
QMN0 started with pid=20
Fri Jul 10 14:56:24 2009
Restarting dead background process QMN0
QMN0 started with pid=13
Fri Jul 10 15:01:24 2009
Restarting dead background process QMN0
QMN0 started with pid=19
Fri Jul 10 15:06:27 2009
Restarting dead background process QMN0
QMN0 started with pid=24
Fri Jul 10 15:11:27 2009
Restarting dead background process QMN0
QMN0 started with pid=24
Fri Jul 10 15:16:27 2009
Restarting dead background process QMN0
QMN0 started with pid=20
Fri Jul 10 15:21:28 2009
Restarting dead background process QMN0
QMN0 started with pid=13
Fri Jul 10 15:26:28 2009
Restarting dead background process QMN0
QMN0 started with pid=20
Fri Jul 10 15:31:28 2009
Restarting dead background process QMN0
QMN0 started with pid=9
Fri Jul 10 15:36:28 2009
Restarting dead background process QMN0
QMN0 started with pid=17
Fri Jul 10 15:41:29 2009
Restarting dead background process QMN0
QMN0 started with pid=25
Fri Jul 10 15:46:29 2009
Restarting dead background process QMN0
QMN0 started with pid=25
Fri Jul 10 15:51:29 2009
Restarting dead background process QMN0
QMN0 started with pid=22
Errors in file /u01/app/oracle/admin/ORCL/udump/orcl_ora_18728.trc:
ORA-07445: 出现异常: 核心转储 [kottins()+165] [SIGSEGV] [Address not mapped to object] [0x000000007] [] []
Fri Jul 10 12:54:45 2009
Restarting dead background process QMN0
QMN0 started with pid=12
Fri Jul 10 12:59:45 2009
Restarting dead background process QMN0
QMN0 started with pid=12
Fri Jul 10 13:04:45 2009
Restarting dead background process QMN0
QMN0 started with pid=21
Fri Jul 10 13:08:00 2009
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 1
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.4.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 117440512
large_pool_size = 16777216
java_pool_size = 117440512
control_files = /u01/app/oracle/oradata/ORCL/control01.ctl, /u01/app/oracle/oradata/ORCL/control02.ctl, /u01/app/oracle/oradata/ORCL/control03.ctl
db_block_size = 8192
db_cache_size = 33554432
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 = ORCL
dispatchers = (PROTOCOL=TCP) (SERVICE=ORCLXDB)
job_queue_processes = 10
_system_trig_enabled = FALSE
hash_join_enabled = TRUE
background_dump_dest = /u01/app/oracle/admin/ORCL/bdump
user_dump_dest = /u01/app/oracle/admin/ORCL/udump
core_dump_dest = /u01/app/oracle/admin/ORCL/cdump
sort_area_size = 524288
db_name = ORCL
open_cursors = 300
star_transformation_enabled= FALSE
optimizer_index_cost_adj = 90
optimizer_index_caching = 80
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
Fri Jul 10 13:08:01 2009
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Fri Jul 10 13:08:02 2009
ALTER DATABASE MOUNT
Fri Jul 10 13:08:06 2009
Successful mount of redo thread 1, with mount id 1219595186.
Fri Jul 10 13:08:06 2009
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Fri Jul 10 13:08:06 2009
ALTER DATABASE OPEN
Fri Jul 10 13:08:08 2009
Beginning crash recovery of 1 threads
Fri Jul 10 13:08:08 2009
Started first pass scan
Fri Jul 10 13:08:10 2009
Completed first pass scan
154345 redo blocks read, 1159 data blocks need recovery
Fri Jul 10 13:08:14 2009
Started recovery at
Thread 1: logseq 3844, block 2679, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 1 Seq 3844 Reading mem 0
Mem# 0 errs 0: /u01/app/oracle/oradata/ORCL/redo01.log
Fri Jul 10 13:08:21 2009
Completed redo application
Fri Jul 10 13:08:21 2009
Ended recovery at
Thread 1: logseq 3844, block 157024, scn 0.107771442
1159 data blocks read, 1159 data blocks written, 154345 redo blocks read
Crash recovery completed successfully
Fri Jul 10 13:08:21 2009
Thread 1 advanced to log sequence 3845
Thread 1 opened at log sequence 3845
Current log# 2 seq# 3845 mem# 0: /u01/app/oracle/oradata/ORCL/redo02.log
Successful open of redo thread 1.
Fri Jul 10 13:08:22 2009
SMON: enabling cache recovery
Fri Jul 10 13:08:22 2009
Undo Segment 1 Onlined
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
Successfully onlined Undo Tablespace 1.
Fri Jul 10 13:08:22 2009
SMON: enabling tx recovery
Fri Jul 10 13:08:22 2009
Database Characterset is ZHS16GBK
Fri Jul 10 13:08:27 2009
Errors in file /u01/app/oracle/admin/ORCL/bdump/orcl_smon_3720.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist
replication_dependency_tracking turned off (no async multimaster replication found)
ORA-604 signalled during: ALTER DATABASE OPEN...
Fri Jul 10 13:10:02 2009
Restarting dead background process QMN0
QMN0 started with pid=9
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water = 8
Waiting for shared server 'S000' to die
All dispatchers and shared servers shutdown
Fri Jul 10 13:14:08 2009
ALTER DATABASE CLOSE NORMAL
Fri Jul 10 13:14:09 2009
SMON: disabling tx recovery
SMON: disabling cache recovery
Fri Jul 10 13:14:09 2009
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 3845
Successful close of redo thread 1.
Fri Jul 10 13:14:09 2009
Completed: ALTER DATABASE CLOSE NORMAL
Fri Jul 10 13:14:09 2009
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
Fri Jul 10 13:14:21 2009
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 1
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.4.0.