Friend database due to storage changes, resulting in the database instantaneous hang live, and then directly crash, after the normal start, request technical support.
Database report ora-00600[2131] Error
Cannot mount, can be resolved by rebuilding the control file
Mon Nov 30 20:35:38 2015
ALTER DATABASE Mount
Mon Nov 30 20:35:38 2015
note:loaded Library:system
Mon Nov 30 20:35:38 2015
Success:diskgroup DATADG was mounted
Mon Nov 30 20:35:38 2015
Note:dependency between database Xifenfei and DiskGroup resource Ora. DATADG.DG is established
Errors in File/u01/app/oracle/diag/rdbms/xifenfei/xifenfei1/trace/xifenfei1_ora_26450.trc (incident=3032256):
Ora-00600:internal error code, arguments: [2131], [33], [32], [], [], [], [], [], [], [], [], []
ORA-600 signalled During:alter database mount ...
Try recover Database
Mon Nov 30 20:45:53 2015
ALTER Database RECOVER Database
Media Recovery Start
Started Logmerger process
Parallel Media Recovery started with slaves
Mon Nov 30 20:45:56 2015
Recovery of Online Redo log:thread 2 Group one Seq 617 Reading Mem 0
mem# 0: +datadg/xifenfei/redo011.log
Recovery of Online Redo log:thread 1 Group 4 Seq 5410 Reading Mem 0
mem# 0: +datadg/xifenfei/redo04.log
Recovery of Online Redo log:thread 1 Group 5 Seq 5411 Reading Mem 0
mem# 0: +datadg/xifenfei/redo05.log
Mon Nov 30 20:46:07 2015
Recovery of Online Redo log:thread 1 Group 6 Seq 5412 Reading Mem 0
mem# 0: +datadg/xifenfei/redo06.log
Mon Nov 30 20:46:13 2015
Exception [TYPE:SIGSEGV, address does mapped to object] [addr:0xc] [pc:0x95fb502, Kdxlin () +4088] [flags:0x0, Count:1]
Errors in File/u01/app/oracle/diag/rdbms/xifenfei/xifenfei1/trace/xifenfei1_pr13_30480.trc (incident=3032568):
ORA-07445: Abnormal error: Core dump [Kdxlin () +4088] [SIGSEGV] [addr:0xc] [pc:0x95fb502] [Address not mapped to object] []
Mon Nov 30 20:46:17 2015
Sweep [inc][3032568]: Completed
Sweep [inc2][3032568]: Completed
Mon Nov 30 20:46:31 2015
Slave exiting with ORA-10562 exception
Errors in FILE/U01/APP/ORACLE/DIAG/RDBMS/XIFENFEI/XIFENFEI1/TRACE/XIFENFEI1_PR13_30480.TRC:
Ora-10562:error occurred while applying redo to data block (file# 2, block# 165054)
Ora-10564:tablespace Sysaux
ORA-01110: Data file 2: ' +datadg/xifenfei/datafile/sysaux.265.861925867 '
Ora-10561:block type ' TRANSACTION MANAGED INDEX block ', data object# 271
ORA-00607: An internal error occurred while changing the data block
ORA-00602: Internal Programming exception error
ORA-07445: Abnormal error: Core dump [Kdxlin () +4088] [SIGSEGV] [addr:0xc] [pc:0x95fb502] [Address not mapped to object] []
Mon Nov 30 20:46:31 2015
Recovery Slave PR13 previously exited with exception 10562
Mon Nov 30 20:46:33 2015
Checker Run found new persistent data failures
Mon Nov 30 20:46:35 2015
Media Recovery failed with error 448
Errors in FILE/U01/APP/ORACLE/DIAG/RDBMS/XIFENFEI/XIFENFEI1/TRACE/XIFENFEI1_PR00_30400.TRC:
ORA-00283: Recovery session canceled due to error
ORA-00448: Background process ends normally
ORA-10562 signalled during:alter database RECOVER database ...
As you can see here, the database recover failed because of some reason redo data could not apply to file 2 block 165054 at the time of the recover operation.
Recover operations by Data file
sql> recover datafile 1;
Media recovery complete.
sql> recover datafile 3,4,5,6,7;
Media recovery complete.
sql> recover datafile 8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28;
Media recovery complete.
sql> recover datafile 2;
Ora-00283:recovery session canceled due to errors
Ora-10562:error occurred while applying redo to data block (file# 2, block#
165054)
Ora-10564:tablespace Sysaux
Ora-01110:data file 2: ' +datadg/xifenfei/datafile/sysaux.265.861925867 '
Ora-10561:block type ' TRANSACTION MANAGED INDEX block ', data object# 271
Ora-00607:internal error occurred while making a change to a data block
Ora-00602:internal Programming exception
Ora-07445:exception Encountered:core Dump [Kdxlin () +4088] [SIGSEGV]
[ADDR:0XC] [pc:0x95fb502] [address isn't mapped to object] []
Error tip Like recover database, we can only allow recovery to skip the block to resume because it is empirically judged that data object# 271 is not a system core object and does not affect database startup
Skip the bad blocks and continue to recover.
sql> recover datafile 2 allow 1 corruption;
Ora-00283:recovery session canceled due to errors
Ora-00600:internal error code, arguments: [3020], [2], [69793], [8458401], [],
[], [], [], [], [], [], []
Ora-10567:redo is inconsistent with data block (file# 2, block# 69793, file
Offset is 571744256 bytes)
Ora-10564:tablespace Sysaux
Ora-01110:data file 2: ' +datadg/xifenfei/datafile/sysaux.265.861925867 '
Ora-10561:block type ' TRANSACTION MANAGED INDEX block ', data object# 272
sql> recover datafile 2 allow 1 corruption;
Media recovery complete.
sql> ALTER DATABASE open;
Database altered.
ORA-600[3020] continues to skip the bad blocks, then the database goes smoothly open, don't forget to add tempfile
Handling Exception objects
Sql> Select Object_name,object_type from Dba_objects where data_object_id in (272,271);
object_name
--------------------------------------------------------------------------------
Object_type
-------------------
Smon_scn_time_tim_idx
INDEX
Smon_scn_time_scn_idx
INDEX
Sql> Select Index_name from dba_indexes where table_name= ' smon_scn_time ';
Index_name
------------------------------
Smon_scn_time_tim_idx
Smon_scn_time_scn_idx
Sql> Set pages 1000
Sql> Set Long 1000
sql> Select dbms_metadata.get_ddl (' TABLE ', ' smon_scn_time ', ' SYS ') from DUAL;
Dbms_metadata. GET_DDL (' TABLE ', ' smon_scn_time ', ' SYS ')
--------------------------------------------------------------------------------
CREATE TABLE "SYS". Smon_scn_time "
("THREAD" number,
"TIME_MP" number,
"TIME_DP" DATE,
"SCN_WRP" number,
"Scn_bas" number,
"Num_mappings" number,
"Tim_scn_map" RAW (1200),
"SCN" number DEFAULT 0,
"Orig_thread" number DEFAULT 0/* for downgrade * *
) CLUSTER "SYS". Smon_scn_to_time_aux "(" THREAD ")
sql> Analyze table Smon_scn_time validate structure online;
Analyze table Smon_scn_time Validate structure Cascade online
*
ERROR at line 1:
Ora-01578:oracle data Block corrupted (file # 2, Block # 165054)
Ora-01110:data file 2: ' +datadg/xifenfei/datafile/sysaux.265.861925867 '
sql> truncate CLUSTER "SYS". " Smon_scn_to_time_aux ";
Cluster truncated.
About Smon_scn_time part of processing, you can refer to: Some questions about Smon_scn_time. This database is basically back to completion, and the luck is very good, the recovery is perfect, data implementation 0 lost.
Contact: Mobile Phone (13429648788) QQ (107644445) QQ Advisory Cherish Division fly
Title: http://www.xifenfei.com/2015/12/ora-10562-Fault Recovery-allow-1-corruption.html