Oracle 11.2.0.3 restoring to 11.2.0.4
Without going full blown Data Guard, how can I get Oracle to restore to a fairly current (within the last hour or two) state? Moving the datafiles over takes about 12 hours, so I can't do a full blown restore in the timeframe.
So I was thinking I could move them over and keep moving the archivelogs over up into the point I want to restore and then replay all the logs since the datafiles move...BUT the logs only seem to want to replay until the point that I started the restore 12 hours earlier. What else besides copying needs to happen?
RMAN> catalog start with '/path/to/logs/';
. Maybe that is the only step you missed and it would explain why recovery can not go any further. – Balazs Papp Nov 20 '18 at 20:26