RMAN-06457

Issue :

Rman active duplicate failed with below error.

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of Duplicate Db command at 08/22/2017 11:04:54

RMAN-05501: aborting duplication of target database

RMAN-06457: UNTIL SCN (11106466738406) is ahead of last SCN in archived logs (11106466667595)

script used for duplicate is :

run

{

SET UNTIL SCN 11106466738406;

DUPLICATE DATABASE TO <target_db_SID>

FROM ACTIVE DATABASE

NOFILENAMECHECK;

}

Solution:

Active Database Duplication cannot be used to duplicate a database until a point in time. One has to rely on the backup-based database duplication method if one wants to create a duplicate database until a specific point in time ( a specific time, log sequence or SCN). Furthermore, active duplicate copies data only until the last archived log file in the source database. The contents of the online redologs will not be copied to the duplicate database.