Hello All,
We are trying to make a Physical Standby DR (with manual mode - transferring and applying archive log manually).
But it looks for older archive log, which is not there in primary and the query also not showing it.
Here is the steps we did:
1) Make the primary down. and copy the physical files into DR location.
2) Enabled Archive log in primary.
3) Created standby controlfile and copied to DR location.
4) Made pfile from spfile.
5) changed the parameters accordingly in DR db and made it in mount mode.
6) Copying archive logs manually in to DR.
7) Trying to apply archive logs, but below are the error message.
SQL> recover standby database;
ORA-00279: change 57652339202 generated at 09/23/2018 00:39:16 needed for
thread 1
ORA-00289: suggestion :
J:\ORACLE\ORA12C\DPMHIST\ARCHS\DPMHIST49191_0873978123.0001.ARC
ORA-00280: change 57652339202 for thread 1 is in sequence #49191
But when we are trying to fetch that particular Archive log file in primary it is not showing result.
select * from v$archived_log
order by next_time desc
987842436 J:\ORACLE\ORA12C\DPMHIST\ARCHP\DPMHIST49203_0873978123.0001.ARC 1 1 49203 2233668 3/10/2015 11:42:03 AM
987842235 J:\ORACLE\ORA12C\DPMHIST\ARCHP\DPMHIST49202_0873978123.0001.ARC 1 1 49202 2233668 3/10/2015 11:42:03 AM
978375803 J:\ORACLE\ORA12C\DPMHIST\ARCHP\DPMHISTARCH43142_0873978123_0001.ARC 1 1 43142 2233668 3/10/2015 11:42:03 AM
978374414 J:\ORACLE\ORA12C\DPMHIST\ARCHP\DPMHISTARCH43141_0873978123_0001.ARC 1 1 43141 2233668 3/10/2015 11:42:03 AM
In short, the archive log to be applied to DR is missing. what could be the solution.
Kindly help me.
Regards
M.krish