Oracle 220.127.116.11 restoring to 18.104.22.168
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?