断电 oracle无法连接,求助, 断电后oracle 连不上

今天检查了监听,发现能起来,在日志文件中有以下内容,请高手帮忙分析一下是什么错误。

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...

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值