今天检查了监听,发现能起来,在日志文件中有以下内容,请高手帮忙分析一下是什么错误。
sun Mar 1 09:11:13 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.4.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 83886080
large_pool_size = 16777216
java_pool_size = 83886080
control_files = /u01/app/oracle/oradata/oradb/control01.ctl, /u01/app/oracle/oradata/oradb/control02.ctl, /u01/app/oracle/oradata/oradb/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 = oradb
dispatchers = (PROTOCOL=TCP) (SERVICE=oradbXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = /u01/app/oracle/admin/oradb/bdump
user_dump_dest = /u01/app/oracle/admin/oradb/udump
core_dump_dest = /u01/app/oracle/admin/oradb/cdump
sort_area_size = 524288
db_name = oradb
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
Sun Mar 1 09:11:13 2009
starting up 1 shared server(s) ...
QMN0 started with pid=9
Sun Mar 1 09:11:13 2009
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Sun Mar 1 09:11:13 2009
ALTER DATABASE MOUNT
Sun Mar 1 09:11:18 2009
Successful mount of redo thread 1, with mount id 2433644977.
Sun Mar 1 09:11:18 2009
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Sun Mar 1 09:11:18 2009
ALTER DATABASE OPEN
Sun Mar 1 09:11:18 2009
Beginning crash recovery of 1 threads
Sun Mar 1 09:11:18 2009
Started first pass scan
Sun Mar 1 09:11:18 2009
Completed first pass scan
1 redo blocks read, 0 data blocks need recovery
Sun Mar 1 09:11:18 2009
Started recovery at
Thread 1: logseq 129, block 2, scn 0.3056044
Recovery of Online Redo Log: Thread 1 Group 2 Seq 129 Reading mem 0
Mem# 0 errs 0: /u01/app/oracle/oradata/oradb/redo02.log
Sun Mar 1 09:11:19 2009
Completed redo application
Sun Mar 1 09:11:19 2009
Ended recovery at
Thread 1: logseq 129, block 3, scn 0.3076045
0 data blocks read, 0 data blocks written, 1 redo blocks read
Crash recovery completed successfully
Sun Mar 1 09:11:20 2009
Thread 1 advanced to log sequence 130
Thread 1 opened at log sequence 130
Current log# 3 seq# 130 mem# 0: /u01/app/oracle/oradata/oradb/redo03.log
Successful open of redo thread 1.
Sun Mar 1 09:11:21 2009
SMON: enabling cache recovery
***
Corrupt block relative dba: 0x004012cd (file 1, block 4813)
Fractured block found during buffer read
Data in bad block -
type: 6 format: 2 rdba: 0x004012cd
last change scn: 0x0000.00027d58 seq: 0x1 flg: 0x06
consistency value in tail: 0xffffffff
check value in block header: 0xb43c, computed block checksum: 0xde47
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
Reread of rdba: 0x004012cd (file 1, block 4813) found same corrupted data
Sun Mar 1 09:11:21 2009
Errors in file /u01/app/oracle/admin/oradb/udump/oradb_ora_4946.trc:
ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 1
ORA-01578: ORACLE data block corrupted (file # 1, block # 4813)
ORA-01110: data file 1: '/u01/app/oracle/oradata/oradb/system01.dbf'
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Instance terminated by USER, pid = 4946
ORA-1092 signalled during: ALTER DATABASE OPEN...
557

被折叠的 条评论
为什么被折叠?



