ora-01190,ora-01110,ORA-00600: internal error code, arguments: [4097]
来源:互联网 发布:js移动全景图代码 编辑:程序博客网 时间:2024/06/05 10:44
使用rman做同平台,同版本数据库的数据同步,在源数据库rman备份后,在目标数据库进行不完全恢复
SQL> ALTER DATABASE RECOVER database using backup controlfile until cancel
SQL> alter database open resetlogs;
查看alert日志,出现下面的错误,于是,
SQL>alter system set "_allow_resetlogs_corruption"=true scope=spfile;
强制打开数据库,alert日志
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01190: control file or data file 3 is from before the last RESETLOGSORA-01110: data file 3: '/oracle/app/oracle/oradata/bios/undotbs01.dbf'
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [4097], [12], [14], [11670], [], [], [], [], [], [], [
], []
opiodr aborting process unknown ospid (14106) as a result of ORA-603
ORA-00600: internal error code, arguments: [kdddgb:clsviol_kcbgcur_9], [0], [4272919], [1], [4294
967250], [524288], [], [], [], [], [], []
Incident details in: /oracle/app/oracle/diag/rdbms/bios/bios/incident/incdir_117626/bios_w000_141
12_i117626.trc
Errors in file /oracle/app/oracle/diag/rdbms/bios/bios/trace/bios_w000_14112.trc:
ORA-00600: internal error code, arguments: [kdddgb:clsviol_kcbgcur_9], [0], [4272919], [1], [4294
967250], [524288], [], [], [], [], [], []
先解决undo表空间文件,重建表空间
SQL>create undo tablespace undotbs01 datafile '/oracle/oradata/undotbs01.dbf' size 100M;
SQL>alter system set undo_tablespace=undotbs01;
SQL>drop tablespace undotbs1;
SQL> alter system set "_allow_resetlogs_corruption"=false scope=spfile;
SQL> shutdown immediate
SQL> startup
再去看alert日志,发现已经没有错误,这个还没明白,应该是undo表空间导致一系列的错误。
- ora-01190,ora-01110,ORA-00600: internal error code, arguments: [4097]
- ORA-00600: internal error code, arguments: [4097], [], [], [], [], [], [], []
- ORA-00600 internal error code, arguments
- ORA-00600: internal error code, arguments: [ksuinfos_modact1], [], [], [], [], [], [], []
- ora-00600 internal error code arguments: [kcratrl_lastbwr],[],[],[],[],[],[],[]
- ORA-00600: internal error code, arguments: [19004]
- ORA-00600 internal error code,arguments
- ORA-00600: internal error code, arguments: [1265]
- ORA-00600: internal error code, arguments: [17182]
- ORA-00600: internal error code, arguments: [keltnf
- ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []
- ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [], [], [], []
- ORA-00600 internal error code,arguments: 问题
- ORA-00600: internal error code, arguments: [kdsgrp1]
- ORA-00600 internal error code,arguments
- ORA-00600: internal error code, arguments: [ktrgcm_3]
- ORA-00600: internal error code, arguments: [ktprhtnew6], [], [], [], [], [], [], []
- ORA-00600: internal error code, arguments: [kkxmexcs3], [], [], [], [], [], [], []
- 前程无忧模拟登陆代码
- 14443-A 与14443-B区别
- Fragment应用的介绍
- cpp sting int转换
- 自己制作Windows记事本的回想
- ora-01190,ora-01110,ORA-00600: internal error code, arguments: [4097]
- Java中的匿名内部类总结
- 第6周作业1-闰年之循环判断
- 手机数据丢失怎么才能恢复
- [设计模式学习]单例模式
- php汉字转拼音,得到首字母
- JavaScript处理四舍五入
- Hadoop使用java查询HDFS 错误:Wrong FS: hdfs://localhost:9000/user/hadoop, expected: file:///
- 介入现有项目笔记(1)