www.cnblogs.com/ruiyqinrui

开源、架构、Linux C/C++/python AI BI 运维开发自动化运维。 春风桃李花 秋雨梧桐叶。“力尽不知热 但惜夏日长”。夏不惜,秋不获。@ruiY--秦瑞

python爬虫,C编程,嵌入式开发.hadoop大数据,桉树,onenebula云计算架构.linux运维及驱动开发.

  博客园  :: 首页  :: 新随笔  :: 联系 :: 订阅 订阅  :: 管理

 

 

机器断电以后,重新启动报如下错误:

在cmd命令窗口下,输入sqlplus / as sysdba

sqlplus / as sysdba


SQL*Plus: Release 11.2.0.3.0 Production on Wed May 1 11:28:49 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup


ORACLE instance started.

Total System Global Area  276197376 bytes
Fixed Size                  1344400 bytes
Variable Size             171969648 bytes
Database Buffers           96468992 bytes
Redo Buffers                6414336 bytes
Database mounted.
ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr], [], [], [],[], [], [], [], [], [], [], []

 

在alert日志中有如下报错信息:Wed May 01 08:21:09 2013
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
:
Aborting crash recovery due to error 600
Errors in file /u01/app/oracle/diag/rdbms/asmdb/ASMDB/trace/ASMDB_ora_5210.trc:
ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr], [], [], [], [], [], [], [], [], [], [], []
Errors in file /u01/app/oracle/diag/rdbms/asmdb/ASMDB/trace/ASMDB_ora_5210.trc:
ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr], [], [], [], [], [], [], [], [], [], [], []
ORA-600 signalled during: ALTER DATABASE OPEN /* db agent *//* {0:0:2} */...

 

在ASMDB_ora_5210.trc文件中有如下的信息:

..................

17755E0 03C10222 096F780B 36380113 6029D938  ["....xo...868.)`]
17755F0 D843E0FF 7CAA8000 02C1B000 88DC0248  [..C....|....H...]
Reading datafile '+ZHUXGASM/asmdb/datafile/undotbs1.258.813246367' for corruption at rdba: 0x00c00858 (file 3, block 2136)
Reread (file 3, block 2136) found same corrupt data (logically corrupt)
******** WRITE VERIFICATION FAILED ********

由此我们知道是因为数据库宕机之后,出现了逻辑坏块 (logically corrupt),因此需要进行介质恢复。

 

SQL> shutdown immediate;

 

ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
(数据库未打开)

 

SQL> startup mount;

ORACLE instance started.
Total System Global Area  276197376 bytes
Fixed Size                  1344400 bytes
Variable Size             171969648 bytes
Database Buffers           96468992 bytes
Redo Buffers                6414336 bytes
Database mounted.

SQL> recover database;


Media recovery complete.

(恢复介质)

SQL> alter database open;


Database altered.
介质恢复之后,再打开数据库就好了。同时也可以用PL\SQL连接数据库了,good.

 

 

 

 

 

 

posted on 2020-05-12 09:22  秦瑞It行程实录  阅读(416)  评论(0编辑  收藏  举报
www.cnblogs.com/ruiyqinrui