ORA-00600:[Kcratr1_lastbwr] During Database Startup after a Crash (Doc ID 393984.1)
来源:互联网 发布:通信协议和网络协议 编辑:程序博客网 时间:2024/05/16 10:50
这几天在做虚拟化的迁移,一些备库都是在线迁移,虚拟机很多都是直接断电重启,导致有些机器上面的oracle数据库在崩溃后做前滚,回滚出现一些问题。
这不,今天又遇到一个,数据库无法open,报ORA-00600:[Kcratr1_lastbwr]
关于这个问题,metalink上有详细的介绍,doc id 393984.1
CHANGES
There was a disk problem that caused the database to crash.
CAUSE
Oracle is unable to perform instance recover but it works when is invoked manually.
SOLUTION
Mount the database and issue a recover statement
SQL> startup mount;
SQL> recover database;
SQL> alter database open;
SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-12801: error signaled in parallel query server P002
ORA-10562: Error occurred while applying redo to data block (file# 1, block#
4568)
ORA-10564: tablespace SYSTEM
ORA-01110: data file 1: '/opt/oracle/oradata/orcl/system01.dbf'
ORA-10561: block type 'TRANSACTION MANAGED INDEX BLOCK', data object# 576
Errors in file /opt/oracle/admin/orcl/bdump/orcl_p002_7917.trc:
ORA-10562: Error occurred while applying redo to data block (file# 1, block# 4568)
网络上给的解释是:当前在线日志损坏,导致undo回滚段出现问题,又由于系统突然掉电,系统表空间在重启实例后要进行实例恢复,当前在线日志损坏,系统表空间无法进行recover
SQL>startup mount
SQL>recover database using backup controlfile until cancel;
SQL>alter database open resetlogs;
SQL> startup mount
SQL> alter system set “_allow_resetlogs_corruption”=true scope=spfile;
SQL>shutdown immediate
SQL> startup mount
SQL> alter database open resetlogs;
SQL> startup
- ORA-00600:[Kcratr1_lastbwr] During Database Startup after a Crash (Doc ID 393984.1)
- STARTUP Database failed ORA-38760 to turn on Flashback Database (Doc ID 1554596.1)
- 【ORA-600】[kcratr_nab_less_than_odr] 异常宕机后的实例恢复during Instance Recovery after Database Crash
- Adding a standby database to a dataguard configuration fails with ORA-1017 (Doc ID 1072022.1)
- Troubleshooting Database Startup/Shutdown Problems (Doc ID 851057.1)
- Cannot drop a database link after changing the global_name ORA-02024 [ID 382994.1]
- Resolving ORA-752 or ORA-600 [3020] During Standby Recovery (Doc ID 1265884.1)
- Master Note: Overview of Database Startup and Shutdown (Doc ID 1505155.1)
- ORA-00227, ORA-00202: BRING UP INSTANCE AFTER MACHINE CRASH [ID 1072762.6]
- Creating a Physical Standby Database (Doc ID 1475344.1)
- ORA-15077 PROC-26 CRSD Fails During CRS Startup on 11gR2 [ID 1152583.1]
- ORA-15077 PROC-26 CRSD Fails During CRS Startup on 11gR2 [ID 1152583.1]
- How to Restore the Database Using AMDU after Diskgroup Corruption (Doc ID 1597581.1)
- Unable to connect to read only database, Getting error ORA-00604 ORA-16000 (Doc ID 461653.1)
- Troubleshooting ORA-29740 in a RAC Environment (Doc ID 219361.1)
- ORA-00600: 内部错误代码, 参数: [kcratr1_lastbwr]
- ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [], [], [], []
- ORA-00600: 内部错误代码, 参数: [kcratr1_lastbwr]
- python numpy教程
- python大小写转换函数备忘
- UVA 11149-Power of Matrix (等比矩阵求和)
- android学习
- Qt浅谈之二十三QGraphicsItem旋转动画
- ORA-00600:[Kcratr1_lastbwr] During Database Startup after a Crash (Doc ID 393984.1)
- unicond编码
- cat and tr << <<-
- C#委托的介绍(delegate、Action、Func、predicate)
- HDU 2492 Ping pong 树状数组+离散化
- 【无中生有】---3---数据库设计-2
- Fibonacci数列(蓝桥杯BEGIN-4)
- 使用flask-ASQLchemy时,Error:No such table
- c#为chart控件添加MouseMove事件