ORA-01111: name for data file 975 is unknown - rename to correct file MRP0: Background Media Recovery terminated with error 1111
ORA-01111: name for data file 975 is unknown - rename to correct file MRP0: Background Media Recovery terminated with error 1111 Issue: Standby database throws below errors and stops the MRP. MRP0: Background Media Recovery terminated with error 1111 Errors in file /u01/app/oraprod/diag/diag/rdbms/sprod/SPROD1/trace/SPROD1_pr00_23061.trc: ORA-01111: name for data file 975 is unknown - rename to correct file ORA-01110: data file 975: '/u01/app/oraprod/11.2.0.4/dbs/UNNAMED00975' ORA-01157: cannot identify/lock data file 975 - see DBWR trace file ORA-01111: name for data file 975 is unknown - rename to correct file ORA-01110: data file 975: '/u01/app/oraprod/11.2.0.4/dbs/UNNAMED00975' Recovery Slave PR00 previously exited with exception 1111 Solution: - Please cancel the managed recovery by SQL>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL; - Set standby_file_management=manual SQL>ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=MANUAL; If the physical standb...