Oracle Solution for Error ora-01274

Solution for Oracle Error ORA-01274

ORA-01274: cannot add datafile 'string' - file could not be created

What triggered the Error:

Automated standby file management was disabled, so an added file could not automatically be created on the standby. The error from the creation attempt is displayed in another message. The control file file entry for the file is 'UNNAMEDnnnnn'.

What should we do to fix it:

Use the ALTER DATABASE CREATE DATAFILE statement to create the file, or set STANDBY_FILE_MANAGEMENT to AUTO and restart standby recovery.