понедельник, 15 сентября 2014 г.

transfer archive log to standby manually with rman

Sometimes for resolve gap in oracle standby you need to copy some archivelog from primary database. And the simplest way to do it - rman which is connected to both databases
So we have situation which oracle can't resolve gap automatically. In alert log a lot of messages like this:
Fetching gap sequence in thread 2, gap sequence 3886-3888

We just connecting with rman to primary and standby:
rman target 'sys/'@primary auxiliary 'sys/'@standby

and then run:
backup as copy archivelog sequence between 3886 and 3889 thread 2 auxiliary format '+DATA';

That's all. :)