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