Pages

Sunday, May 10, 2020

ORA-01111 - name for data file 72 is unknown - rename to correct file


Error : 

Managed Standby Recovery not using Real Time Apply
Media Recovery failed with error 1111
Slave exiting with ORA-283 exception
Errors in file /oracle/ABC/saptrace/diag/rdbms/abcdr/ABCDR/trace/ABCDR_pr00_9668.trc:
ORA-00283: recovery session canceled due to errors
ORA-01111: name for data file 72 is unknown - rename to correct file
ORA-01110: data file 72: '/oracle/ABC/112_64/dbs/UNNAMED00072'
ORA-01157: cannot identify/lock data file 72 - see DBWR trace file
ORA-01111: name for data file 72 is unknown - rename to correct file
ORA-01110: data file 72: '/oracle/ABC/112_64/dbs/UNNAMED00072'

Recovery Slave PR00 previously exited with exception 283

Procedure :

                  Primary
                  a.  select FILE#,NAME from v$datafile where file#=72;             


                  Standby 
                  a.  select * from v$recover_file where error like '%FILE%';
                  b.  alter system set standby_file_management='MANUAL';
                  c.  alter database create datafile '/oracle/ABC/112_64/dbs/UNNAMED00072' as '/oracle/ABC/sapdata<n>/sr3_59/sr3.data62';
                 d.   alter system set standby_file_management='AUTO';
                 e.   alter database recover managed standby database disconnect from session;


No comments:

Post a Comment