oracle恢复后无法打开,求助数据库恢复后无法open

各位大大:

一个10.2.0.1的生产数据库,非归档,无备份,昨天上午在双机切换了两次后报错system02.dbf出错,数据库就无法open了,只能在mount方式下。

后来按网上的方法将system02.dbf cp 到新的目录下rename,然后recover database,又开始报system01.dbf的错.经过几次recover后目前启动时报错如下:

SQL> startup

ORACLE instance started.

Total System Global Area 2147483648 bytes

Fixed Size                  1220460 bytes

Variable Size             486539412 bytes

Database Buffers         1644167168 bytes

Redo Buffers               15556608 bytes

Database mounted.

ORA-01092: ORACLE instance terminated. Disconnection forced

查看alter日志如下:

Fri Jul 29 14:25:02 2011

Starting ORACLE instance (normal)

Cannot determine all dependent dynamic libraries for /proc/self/exe

Unable to find dynamic library libocr10.so in search paths

RPATH = /ade/aime1_build2101/oracle/has/lib/:/ade/aime1_build2101/oracle/lib/:/ade/aime1_build2101/oracle/has/lib/:

LD_LIBRARY_PATH is not set!

The default library directories are /lib and /usr/lib

Unable to find dynamic library libocrb10.so in search paths

Unable to find dynamic library libocrutl10.so in search paths

Unable to find dynamic library libocrutl10.so in search paths

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Picked latch-free SCN scheme 2

Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST

Autotune of undo retention is turned on.

IMODE=BR

ILAT =18

LICENSE_MAX_USERS = 0

SYS auditing is disabled

ksdpec: called for event 13740 prior to event group initialization

Starting up ORACLE RDBMS Version: 10.2.0.1.0.

System parameters with non-default values:

processes                = 150

sga_max_size             = 2147483648

__shared_pool_size       = 452984832

__large_pool_size        = 16777216

__java_pool_size         = 16777216

__streams_pool_size      = 0

sga_target               = 2147483648

control_files            = /oradata/plxxxydb/control01.ctl, /oradata/plxxxydb/control02.ctl, /oradata/plxxxydb/control03.ctl

db_block_size            = 8192

__db_cache_size          = 1644167168

compatible               = 10.2.0.1.0

db_file_multiblock_read_count= 16

db_recovery_file_dest    = /oracle/flash_recovery_area

db_recovery_file_dest_size= 2147483648

undo_management          = AUTO

undo_tablespace          = UNDOTBS1

remote_login_passwordfile= EXCLUSIVE

db_domain                =

dispatchers              = (PROTOCOL=TCP) (SERVICE=plxxxydbXDB)

job_queue_processes      = 10

parallel_max_servers     = 8

background_dump_dest     = /oracle/admin/plxxxydb/bdump

user_dump_dest           = /oracle/admin/plxxxydb/udump

core_dump_dest           = /oracle/admin/plxxxydb/cdump

audit_file_dest          = /oracle/admin/plxxxydb/adump

db_name                  = plxxxydb

open_cursors             = 300

pga_aggregate_target     = 838860800

PMON started with pid=2, OS id=24069

PSP0 started with pid=3, OS id=24071

MMAN started with pid=4, OS id=24073

DBW0 started with pid=5, OS id=24075

LGWR started with pid=6, OS id=24077

CKPT started with pid=7, OS id=24079

SMON started with pid=8, OS id=24081

RECO started with pid=9, OS id=24083

CJQ0 started with pid=10, OS id=24085

MMON started with pid=11, OS id=24087

Fri Jul 29 14:25:02 2011

starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...

MMNL started with pid=12, OS id=24089

Fri Jul 29 14:25:02 2011

starting up 1 shared server(s) ...

Fri Jul 29 14:25:02 2011

ALTER DATABASE   MOUNT

Fri Jul 29 14:25:06 2011

Setting recovery target incarnation to 4

Fri Jul 29 14:25:06 2011

Successful mount of redo thread 1, with mount id 3412198462

Fri Jul 29 14:25:06 2011

Database mounted in Exclusive Mode

Completed: ALTER DATABASE   MOUNT

Fri Jul 29 14:25:06 2011

ALTER DATABASE OPEN

Fri Jul 29 14:25:06 2011

Beginning crash recovery of 1 threads

parallel recovery started with 7 processes

Fri Jul 29 14:25:06 2011

Started redo scan

Fri Jul 29 14:25:06 2011

Completed redo scan

2 redo blocks read, 0 data blocks need recovery

Fri Jul 29 14:25:06 2011

Started redo application at

Thread 1: logseq 4, block 3

Fri Jul 29 14:25:06 2011

Recovery of Online Redo Log: Thread 1 Group 3 Seq 4 Reading mem 0

Mem# 0 errs 0: /oradata/plxxxydb/redo03.log

Fri Jul 29 14:25:06 2011

Completed redo application

Fri Jul 29 14:25:06 2011

Completed crash recovery at

Thread 1: logseq 4, block 5, scn 21643418

0 data blocks read, 0 data blocks written, 2 redo blocks read

Fri Jul 29 14:25:07 2011

Thread 1 advanced to log sequence 5

Thread 1 opened at log sequence 5

Current log# 1 seq# 5 mem# 0: /oradata/plxxxydb/redo01.log

Successful open of redo thread 1

Fri Jul 29 14:25:07 2011

MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set

Fri Jul 29 14:25:07 2011

SMON: enabling cache recovery

Fri Jul 29 14:25:07 2011

Errors in file /oracle/admin/plxxxydb/udump/plxxxydb_ora_24115.trc:

ORA-00600: internal error code, arguments: [4194], [31], [9], [], [], [], [], []

Fri Jul 29 14:25:07 2011

Doing block recovery for file 1 block 394

Block recovery from logseq 5, block 3 to scn 21643426

Fri Jul 29 14:25:07 2011

Recovery of Online Redo Log: Thread 1 Group 1 Seq 5 Reading mem 0

Mem# 0 errs 0: /oradata/plxxxydb/redo01.log

Block recovery stopped at EOT rba 5.5.16

Block recovery completed at rba 5.5.16, scn 0.21643424

Doing block recovery for file 1 block 9

Block recovery from logseq 5, block 3 to scn 21643423

Fri Jul 29 14:25:07 2011

Recovery of Online Redo Log: Thread 1 Group 1 Seq 5 Reading mem 0

Mem# 0 errs 0: /oradata/plxxxydb/redo01.log

Block recovery completed at rba 5.5.16, scn 0.21643424

Fri Jul 29 14:25:07 2011

Errors in file /oracle/admin/plxxxydb/udump/plxxxydb_ora_24115.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], [31], [9], [], [], [], [], []

Error 604 happened during db open, shutting down database

USER: terminating instance due to error 604

Instance terminated by USER, pid = 24115

ORA-1092 signalled during: ALTER DATABASE OPEN...

请问我接下来该怎么处理啊?谢谢了!

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值