ORA-1248 signalled during: alter database open resetlogs...
Thu May 10 21:58:55 2012
Signalling error 1152 for datafile 2!
Signalling error 1152 for datafile 4!
Signalling error 1152 for datafile 5!
数据恢复还原的过程后、
alter database open resetlogs 出现这个???
怎么可以强制打开数据库呢 ?
我也觉得是这个原因
SQL> select checkpoint_change# from v$database;
CHECKPOINT_CHANGE#
------------------
6379578275
SQL> select checkpoint_change# from v$datafile;
CHECKPOINT_CHANGE#
------------------
6379588752
6379592704
6379580499
6379592704
6379588752
6379580498
6379598221
6384233457
6384234456
6384234456
6384234456
CHECKPOINT_CHANGE#
------------------
6384279350
6379580498
6379588752
6379588752
6379592704
6379592704
6379592704
6379598221
6379598221
6379598221
6379580499
CHECKPOINT_CHANGE#
------------------
6379580499
6379580499
6379598221
6384233457
6384233457
QL> alter database open ;
alter database open
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00600: internal error code, arguments: [2663], [1], [2100959228], [1], [2113204336], [], [], [], [], [], [], []
Process ID: 25554
Session ID: 198 Serial number: 3
日志文件
ORA-00600: internal error code, arguments: [2663], [1], [2100959228], [1], [2113204336], [], [], [], [], [], [], []
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /opt/oracle11g/app/oracle/diag/rdbms/progathe/progather/trace/progather_ora_25554.trc:
ORA-00600: internal error code, arguments: [2663], [1], [2100959228], [1], [2113204336], [], [], [], [], [], [], []
Errors in file /opt/oracle11g/app/oracle/diag/rdbms/progathe/progather/trace/progather_ora_25554.trc:
ORA-00600: internal error code, arguments: [2663], [1], [2100959228], [1], [2113204336], [], [], [], [], [], [], []
Error 600 happened during db open, shutting down database
USER (ospid: 25554): terminating the instance due to error 600
Instance terminated by USER, pid = 25554
ORA-1092 signalled during: alter database open ...
opiodr aborting process unknown ospid (25554) as a result of ORA-1092
Fri May 11 10:03:33 2012
ORA-1092 : opitsk aborting process |