ORA-00704-ORA-01555

Source: Internet
Author: User
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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.