How to fix the Oracle error ORA-19965: ALTER DATABASE RECOVER STANDBY TABLESPACE has been deprecated?

In this post, you’ll learn more about the Oracle ErrorORA-19965: ALTER DATABASE RECOVER STANDBY TABLESPACE has been deprecated with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-19965: ALTER DATABASE RECOVER STANDBY TABLESPACE has been deprecated

Reason for the Error ORA-19965: ALTER DATABASE RECOVER STANDBY TABLESPACE has been deprecated

The STANDBY TABLESPACE clause of the ALTER DATABASE RECOVER statement (partial_database_recovery clause) has been deprecated.

How to fix the Error ORA-19965: ALTER DATABASE RECOVER STANDBY TABLESPACE has been deprecated ?

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

If you want to recover the standby database to a consistent point, but no further, use the statement ALTER DATABASE RECOVER MANAGED STANDBY DATABASE UNTIL CONSISTENT.