This content has been marked as final. Show 3 replies
Can you run this on the Standby database and post the results ?
And can you check the Standby for any recent ORA-01111 errors and post them?
SELECT * FROM V$RECOVER_FILE WHERE ERROR LIKE '%MISSING%';
Now, I do not have the access to the databases, I will share the same ASAP.
Could you please refer the links that I have shared. I am flustered over the fact that which is the right method.
The problem with the second link is there's no date on it. I'm uncertain of the oracle version too. So it's that vs an Oracle document.
Here's a couple of DG OTN's links that deal with the issue. They seem to provide a 3rd option.
Re: ORA-01111 name for data file 10 is unknown
Re: Lost datafile on Standby Oracle 10g