Find in this Blog

Friday, January 10, 2020

ORA-04024: self-deadlock detected while trying to mutex pin cursor 0xC1F2B19A8, ORA-01092: ORACLE instance terminated. Disconnection forced

Restoring Issue: Generated below error


ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-04024: self-deadlock detected while trying to mutex pin cursor 0xC272AF8B8
Process ID: 5473
Session ID: 384 Serial number: 35520


Reason:

It is a know  bug in Release 12.1.0.2.0. 

To clear this please apply below "_fix_control" parameter in SP file  and start restore again with new file , because once  you applied the logs,  recreating log file sequence will be changed , it will prompt the non generated archive file, avoid that restore your file from scratch and create control file again and try to recover.

SQL> alter system set “_fix_control”=’9550277:ON’;

This is the required Fix control parameter  but apply along with below Fix control parameter.

ALTER SYSTEM SET "_fix_control"=
"20107874:OFF",
"20355502:8",
"22540411:ON",
"7324224:OFF",
"7168184:OFF",
"8937971:ON",
"13077335:ON",
"13627489:ON",
"14255600:ON",
"14595273:ON",
"18405517:2",
"5099019:ON",
"5705630:ON",
"6055658:OFF",
"6120483:OFF",
"6399597:ON",
"6430500:ON",
"6440977:ON",
"6626018:ON",
"6972291:ON",
"7658097:ON",
"9196440:ON",
"9495669:ON",

"9550277:ON" scope=spfile;


Thanks
Yoonus



No comments:

Post a Comment

Ask Your Questions ?#