How to fix the Oracle error ORA-12824: INSTANCES DEFAULT may not be specified here?

In this post, you’ll learn more about the Oracle ErrorORA-12824: INSTANCES DEFAULT may not be specified here with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-12824: INSTANCES DEFAULT may not be specified here

Reason for the Error ORA-12824: INSTANCES DEFAULT may not be specified here

INSTANCES DEFAULT was specified in the PARALLEL clause of an ALTER DATABASE RECOVER command

How to fix the Error ORA-12824: INSTANCES DEFAULT may not be specified here ?

You can fix this error in Oracle by following the below steps

respecify with an explicit value for INSTANCES or omit the INSTANCES option if single instance recovery is desired.