启动数据库报错误如下:
Errors in file /oracle/PRD/920_64/rdbms/log/prd_ora_23948.trc:
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4193], [60015], [60091], [], [], [], [], []
Error 607 happened during db open, shutting down database
USER: terminating instance due to error 607
Instance terminated by USER, pid = 23948
ORA-1092 signalled during: alter database open noresetlogs...
原因:undo与redo信息不一致
解决办法:
alter system set "_allow_resetlogs_corruption"=true scope=spfile;
alter system set undo_management='manual' scope=spfile;
SQL> startup force
SQL> create undo tablespace undotbs2 datafile '/oracle/PRD/sapdata2/undo_2/undotbs02.dbf' size 100m;
SQL> alter system set undo_tablespace=undotbs2 scope=spfile;
SQL> drop tablespace psapundo including contents and datafiles;
drop tablespace psapundo including contents and datafiles
*
ERROR at line 1:
ORA-01548: active rollback segment '_SYSSMU18$' found, terminate dropping
tablespace
SQL> alter system set "_corrupted_rollback_segments"='_SYSSMU18$';
SQL> startup force
SQL> drop tablespace psapundo including contents and datafiles;
Errors in file /oracle/PRD/920_64/rdbms/log/prd_ora_23948.trc:
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4193], [60015], [60091], [], [], [], [], []
Error 607 happened during db open, shutting down database
USER: terminating instance due to error 607
Instance terminated by USER, pid = 23948
ORA-1092 signalled during: alter database open noresetlogs...
原因:undo与redo信息不一致
解决办法:
alter system set "_allow_resetlogs_corruption"=true scope=spfile;
alter system set undo_management='manual' scope=spfile;
SQL> startup force
SQL> create undo tablespace undotbs2 datafile '/oracle/PRD/sapdata2/undo_2/undotbs02.dbf' size 100m;
SQL> alter system set undo_tablespace=undotbs2 scope=spfile;
SQL> drop tablespace psapundo including contents and datafiles;
drop tablespace psapundo including contents and datafiles
*
ERROR at line 1:
ORA-01548: active rollback segment '_SYSSMU18$' found, terminate dropping
tablespace
SQL> alter system set "_corrupted_rollback_segments"='_SYSSMU18$';
SQL> startup force
SQL> drop tablespace psapundo including contents and datafiles;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25702/viewspace-697157/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/25702/viewspace-697157/