How to fix the Oracle error ORA-01784: RECOVERABLE cannot be specified with database media recovery disabled?

In this post, you’ll learn more about the Oracle ErrorORA-01784: RECOVERABLE cannot be specified with database media recovery disabled with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-01784: RECOVERABLE cannot be specified with database media recovery disabled

Reason for the Error ORA-01784: RECOVERABLE cannot be specified with database media recovery disabled

A CREATE TABLE or CREATE INDEX statement specified RECOVERABLE when the database was running in NOARCHIVELOG mode. Since logs are not being archived, they will be overwritten and the object being created cannot be recovered from a backup taken before the object was created.

How to fix the Error ORA-01784: RECOVERABLE cannot be specified with database media recovery disabled ?

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

Do not specify RECOVERABLE, or restart the database with media recovery enabled.