Tuesday, June 12, 2012

RMAN-06457: UNTIL scn

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.

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_IDGROUP#THREAD#SEQUENCE#BYTESMEMBERSARCHIVEDSTATUSFIRST_CHANGE#FIRST_TIME             
1112502891048576001NOCURRENT107635400375836/12/2012 10:16
1212502881048576001NOACTIVE107635400310766/12/2012 10:15
1322508011048576001YESACTIVE107635377818156/12/2012 4:29
1422508001048576001YESINACTIVE107635377518366/12/2012 4:24
1532076311048576001YESINACTIVE107624060273086/9/2012 9:21
1632076301048576001YESINACTIVE107624059981966/9/2012 9:20
1732076321048576001YESINACTIVE107624060504306/9/2012 9:24
1832076331048576001YESACTIVE10762406105541   6/9/2012 9:59




No comments:

Post a Comment