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
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 ?#