RMAN DUPLICATE/Clone database.
Dear Experts, Our database version 12.1.0.2 Run { SET UNTIL SEQUENCE ## THREAD #; DUPLICATE TARGET DATABASE TO "APPSTRDE" device type disk; } ##end script## here the sequence has to be picked very carefully, in the below backup logfile review the highlighted sequences and time stamps. Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- -------------------- ---------- --------- 1 1362 10162976618798 27-JUN-2012 19:11:00 10162976838904 27-JUN-2012 20:03:08 1 1363 10162976838904 27-JUN-2012 20:03:08 10162976839270 27-JUN-2012 20:03:17 1 1364 10162976839270 27-JUN-2012 20:03:17 10162977148308 27-JUN-2012 21:04:04 1 1365 10162977148308 27-JUN-2012 21:04:04 10162977149494 27-JUN-2012 21:04:31 1 1366 10162977149494 27-JUN-2012 21:04:31 10162977180003 27-JUN-2012 21:13:13 1 1367 10162977180003 27-JUN-2012 21:13:13 10162977280169 27-JUN-2012 21:40:29----- 1 1368 10162977280169 27-JUN-2012 21:40:29 10162977280458 27-JUN-2012 21:40:36----- 2 1102 10162976618794 27-JUN-2012 19:11:00 10162976838969 27-JUN-2012 20:03:10 2 1103 10162976838969 27-JUN-2012 20:03:10 10162976839265 27-JUN-2012 20:03:16 2 1104 10162976839265 27-JUN-2012 20:03:16 10162977148305 27-JUN-2012 21:04:04 2 1105 10162977148305 27-JUN-2012 21:04:04 10162977149491 27-JUN-2012
0