Errors in file /u01/oracle/diag/rdbms/mussaib_stdby_2/mussaib/trace/mussaib_mrp0_525556.trc:ORA-01111: name for data file 133 is unknown - rename to correct fileORA-01110: data file 133:'/u01/oracle/product/19.3.0/db_2/dbs/UNNAMED00133'
ORA-01157: cannot identify/lock data file 133 - see DBWR trace file
ORA-01111: name for data file 133 is unknown - rename to correct fileORA-01110: data file 133: '/u01/oracle/product/19.3.0/db_2/dbs/UNNAMED00133'2024-08-T08:19:15.196925-04:00Background Media Recovery process shutdown (mussaib)
STANDBY::
select * from v$recover_file where error like ‘%FILE%’;
select name from v$datafile where name like ‘%UNNAMED%’;
PRIMARY:
Select file#, name from v$datafile where file#=133;
STANDBY:
show parameter standby
alter system set standby_file_management='MANUAL';
alter database create datafile '/u01/oracle/product/19.3.0/db_2/dbs/UNNAMED00133' as '/u09/oradata/mussaib/data/undotbs03.dbf' size 31G;
alter system set standby_file_management='AUTO';
START MRP:
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;