数据库能够进入到mount状态,alter database open提示如下错误:
ora-00600:internal error code,arguments:[4194],[7],[2],[],[] ,[],[] ,[],[] ,[],[] ,[]
进程ID:584
回话ID:211 序列号:3
oracle support 参考文档【 文档 ID 281429.1】上的解释:
A mismatch has been detected between Redo records and rollback (Undo)
records.
ARGUMENTS:
Arg [a] Maximum Undo record number in Undo block
Arg [b] Undo record number from Redo block
意思是undo和redo的记录号不一致,一般在数据库有没提交事务的情况下突然宕机导致undo里面的事务没办法回退。
解决办法:
step1,sql> startup mount; mount数据库;
step2, sql> create pfile from spfile; 默认为INITsidname.ora;
step3, sql> shutdown immediate;
step4, 将INITsidname.ora文件里面的 undo_management = manual; 改为手动。
step5, sql> startup pfile=INITsidname.ora; 用pfile启动数据库。
step6, sql> create undo tablespace undotbs2 datafile '/opt/oracle/oradata/conner/undotbs2.dbf' size 10M;
step7, 将INITsidname.ora里面更改为undo_tablespace='UNDOTBS2';
step8,重新用pfile启动;
step9,create spfile from pfile;
step10,关闭数据库后重新启动。
step11,Drop tablespace including contents and datafiles 如果删除不了,则需要将状态非offline的回退段在initsidname文件里面隐藏掉 *._offline_rollback_segments=(_SYSSMU10_1695440836$)
然后用pfile启动数据库,再drop rollback segment "_SYSSMU10_1695440836$";现在可以成功执行 step11了。
ora-00600:internal error code,arguments:[4194],[7],[2],[],[] ,[],[] ,[],[] ,[],[] ,[]
进程ID:584
回话ID:211 序列号:3
oracle support 参考文档【 文档 ID 281429.1】上的解释:
A mismatch has been detected between Redo records and rollback (Undo)
records.
ARGUMENTS:
Arg [a] Maximum Undo record number in Undo block
Arg [b] Undo record number from Redo block
意思是undo和redo的记录号不一致,一般在数据库有没提交事务的情况下突然宕机导致undo里面的事务没办法回退。
解决办法:
step1,sql> startup mount; mount数据库;
step2, sql> create pfile from spfile; 默认为INITsidname.ora;
step3, sql> shutdown immediate;
step4, 将INITsidname.ora文件里面的 undo_management = manual; 改为手动。
step5, sql> startup pfile=INITsidname.ora; 用pfile启动数据库。
step6, sql> create undo tablespace undotbs2 datafile '/opt/oracle/oradata/conner/undotbs2.dbf' size 10M;
step7, 将INITsidname.ora里面更改为undo_tablespace='UNDOTBS2';
step8,重新用pfile启动;
step9,create spfile from pfile;
step10,关闭数据库后重新启动。
step11,Drop tablespace including contents and datafiles 如果删除不了,则需要将状态非offline的回退段在initsidname文件里面隐藏掉 *._offline_rollback_segments=(_SYSSMU10_1695440836$)
然后用pfile启动数据库,再drop rollback segment "_SYSSMU10_1695440836$";现在可以成功执行 step11了。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8109090/viewspace-2123335/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/8109090/viewspace-2123335/