I was trying to Duplicate from 3 Node RAC to RAC, which was on 10.2.0.4
After taking backup of full db plus archivelog , It failed at below commands.
Issue ALTER SYSTEM ARCHIVELOG CURRENT before taking backup.
In my case, Node 3 was down.so the last & latest SCN was 10762406105542 in Thread 3.
After taking backup of full db plus archivelog , It failed at below commands.
Starting Duplicate Db at 11-jun-2012 20:37:28 released channel: CH1 released channel: CH2 released channel: CH3 released channel: CH4 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 06/11/2012 21:53:00 RMAN-06457: UNTIL scn (10763359915928) is ahead of last scn in archived logs (10762406105542)
Issue ALTER SYSTEM ARCHIVELOG CURRENT before taking backup.
In my case, Node 3 was down.so the last & latest SCN was 10762406105542 in Thread 3.
| INST_ID | GROUP# | THREAD# | SEQUENCE# | BYTES | MEMBERS | ARCHIVED | STATUS | FIRST_CHANGE# | FIRST_TIME |
| 1 | 1 | 1 | 250289 | 104857600 | 1 | NO | CURRENT | 10763540037583 | 6/12/2012 10:16 |
| 1 | 2 | 1 | 250288 | 104857600 | 1 | NO | ACTIVE | 10763540031076 | 6/12/2012 10:15 |
| 1 | 3 | 2 | 250801 | 104857600 | 1 | YES | ACTIVE | 10763537781815 | 6/12/2012 4:29 |
| 1 | 4 | 2 | 250800 | 104857600 | 1 | YES | INACTIVE | 10763537751836 | 6/12/2012 4:24 |
| 1 | 5 | 3 | 207631 | 104857600 | 1 | YES | INACTIVE | 10762406027308 | 6/9/2012 9:21 |
| 1 | 6 | 3 | 207630 | 104857600 | 1 | YES | INACTIVE | 10762405998196 | 6/9/2012 9:20 |
| 1 | 7 | 3 | 207632 | 104857600 | 1 | YES | INACTIVE | 10762406050430 | 6/9/2012 9:24 |
| 1 | 8 | 3 | 207633 | 104857600 | 1 | YES | ACTIVE | 10762406105541 | 6/9/2012 9:59 |
