Database startup error ORA-00600: [kccpb_sanity_check_2] ORA-00600: internalerrorcode, arguments: [kccpb_sanity_check_2], [1292931], [1188440], [0x000000000], [], [], [], [] SUCCESS: diskgroupRACDBwasdismounted the error indicates the control file
Database startup error ORA-00600: [kccpb_sanity_check_2] ORA-00600: internal error code, arguments: [kccpb_sanity_check_2], [1292931], [1188440], [0x000000000], [], [], [], [] SUCCESS: diskgroup RACDB was dismounted. This error indicates the control file.
Database startup error ORA-00600: [kccpb_sanity_check_2]
ORA-00600: internal error code, arguments: [kccpb_sanity_check_2], [1292931], [1188440], [0x000000000], [], [], [], []SUCCESS: diskgroup RACDB was dismounted
This error indicates that the control file is consistent. Because there is no backup control file, you can only create it manually.
When the creation is complete, the following error is reported in open data:
ORA-00704: bootstrap process failureORA-00704: bootstrap process failureORA-00604: error occurred at recursive SQL level 1ORA-01555: snapshot too old: rollback segment number 10 with name "_SYSSMU10$" too smallError 704 happened during db open, shutting down database
If this error occurs, we recommend that you view the file header scn.
Modify the scn with the data file header scn + 100000
SQL> SELECT 2482746156+100000 FROM dual; 2482746156+100000----------------- 2482846156 SQL> SELECT to_char('2482846156','xxxxxxxxxxxxxxx') FROM dual; TO_CHAR('2482846156','XXXXXXXXXXXXXXX')------------------------------------------ 93fd39cc oradebug setmypidoradebug dumpvar sga kcsgscn_oradebug poke 0x38000F3D0 8 0x93fd39cc
But at startup it still reports ORA-01555: snapshot too old: rollback segment number 10 with name "_ SYSSMU10 $" too small
Observe the data blocks read at startup through 10046
PARSING IN CURSOR #5 len=52 dep=1 uid=0 oct=3 lid=0 tim=401202814297 hv=429618617 ad='a89b23a8'SELECT ctime, mtime, stime FROM obj$ WHERE obj# = :1END OF STMTEXEC #5:c=0,e=2126,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=401202816808WAIT #5: nam='db file sequential read' ela= 716 file#=1 block#=218 blocks=1 obj#=-1 tim=401202817826WAIT #5: nam='db file sequential read' ela= 10885 file#=1 block#=219 blocks=1 obj#=-1 tim=401202828940WAIT #5: nam='db file sequential read' ela= 7552 file#=1 block#=122 blocks=1 obj#=-1 tim=401202836649
It is found that the last read here is file 1 block 122, so you can go to dump this block to view the scn of this block,
ALTER system dump datafile '+ xxxxxxx/system.256.720013083 'block 122; the scn of this block is 0x94a4c467 oradebug poke 0x38000F3D0 8 0x95a4c467
The database is successfully opened after modification.
Address: ORA-00704-ORA-01555, thanks to the original author to share.