How to fix the Oracle error ORA-01670: new datafile string needed for standby database recovery?

In this post, you’ll learn more about the Oracle ErrorORA-01670: new datafile string needed for standby database recovery with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-01670: new datafile string needed for standby database recovery

Reason for the Error ORA-01670: new datafile string needed for standby database recovery

Standby database recovery noticed that a file was added to the primary database, but is not available on the standby.

How to fix the Error ORA-01670: new datafile string needed for standby database recovery ?

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

Either copy the file from the primary database or do an ALTER DATABASE CREATE DATAFILE command on the standby to create a file to recover.