10061 events, 10061

Source: Internet
Author: User

10061 events, 10061
When the database is started, close it directly and view the alarm log:

Errors in file /opt/oracle/diag/rdbms/orcl11g/orcl11g/trace/orcl11g_mmon_3749.trc  (incident=65276):ORA-00600: internal error code, arguments: [4194], [0x000000011], [0x7F9676793990], [], [], [], [], [], [], [], [], []Incident details in: /opt/oracle/diag/rdbms/orcl11g/orcl11g/incident/incdir_65276/orcl11g_mmon_3749_i65276.trcORACLE Instance orcl11g (pid = 13) - Error 1578 encountered while recovering transaction (20, 27).Errors in file /opt/oracle/diag/rdbms/orcl11g/orcl11g/trace/orcl11g_smon_3745.trc:ORA-01578: ORACLE data block corrupted (file # 10, block # 2088)ORA-01110: data file 10: '/opt/oracle/oradata/orcl11g/undotb02.dbf'Completed: ALTER DATABASE OPENMon Nov 10 22:40:18 2014Trace dumping is performing id=[cdmp_20141110224018]Mon Nov 10 22:40:20 2014Starting background process SMCOMon Nov 10 22:40:20 2014SMCO started with pid=26, OS id=3805 Trace dumping is performing id=[cdmp_20141110224020]Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x79C8DBF3] [PC:0x2297740, kgegpa()+40] [flags: 0x0, count: 1]Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x79C8DBF3] [PC:0x229596B, kgebse()+279] [flags: 0x2, count: 2]Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x79C8DBF3] [PC:0x229596B, kgebse()+279] [flags: 0x2, count: 2]Mon Nov 10 22:40:21 2014Doing block recovery for file 10 block 3395Trace dumping is performing id=[cdmp_20141110224022]Mon Nov 10 22:40:23 2014Simulated error on redo application.Mon Nov 10 22:40:24 2014PMON (ospid: 3721): terminating the instance due to error 474Instance terminated by PMON, pid = 3721

SYS@orcl11g>select file#,name from v$datafile;     FILE# NAME---------- ------------------------------------------------------------         1 /opt/oracle/oradata/orcl11g/system01.dbf         2 /opt/oracle/oradata/orcl11g/sysaux01.dbf         3 /opt/oracle/oradata/orcl11g/undotbs01.dbf         4 /opt/oracle/oradata/orcl11g/users01.dbf         5 /opt/oracle/oradata/zbdba.dbf         7 /opt/oracle/oradata/orcl11g/test.dbf         8 /opt/oracle/oradata/orcl11g/test_size.dbf         9 /opt/oracle/oradata/orcl11g/test_size2.dbf        10 /opt/oracle/oradata/orcl11g/undotb02.dbf

Add the following to the initialization parameters:

Event = '10061 trace name context forever, level 10'
_ Smon_internal_errlimit = 1000000


Start the database again:

SYS@orcl11g>alter database open;alter database open*ERROR at line 1:ORA-00600: internal error code, arguments: [4194], [0x000000011], [0x000000000], [], [], [], [], [], [], [], [], []SYS@orcl11g>SYS@orcl11g>SYS@orcl11g>SYS@orcl11g>select open_mode from v$database;OPEN_MODE----------------------------------------READ WRITE


At this time, we need to reconstruct the undo tablespace and solve the problem.



Related Article

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.