RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 06/26/2024 05:32:00 RMAN-05501: aborting duplication of target database RMAN-06617: UNTIL TIME (20-JUN-24) is ahead of last NEXT TIME in archived logs (20-JUN-24) |
For a time based or SCN based recovery, make sure that you are specifying "set until scn" or "set until time" which is not ahead of NEXT TIME of the archived redo logs that are available for restoration during the recovery.
You can use following commands when connected to the destination database (DB is in mount state after controlfile restore), to find out the next SCN of the highest sequence number of archived redo log files. In my case, maximum SCN available is 3376486 which you can see under "Next Time" column for thread 2 sequence number 57. If you set NLS_DATE_FORMAT environment variable appropriately, before logging into RMAN, you can see the hours, minuets and seconds for this SCN as well.
RRMAN> list backupset 13;
List of Backup Sets ===================
BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ --------------- 13 84.57M DISK 00:00:02 20-JUN-24 BP Key: 13 Status: AVAILABLE Compressed: YES Tag: TAG20240620T073848 Piece Name: /u02/app/oracle/salman_backup/db_0d2tqi49_13_1_1.bak
List of Archived Logs in backup set 13 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 155 3375856 20-JUN-24 3375914 20-JUN-24 1 156 3375914 20-JUN-24 3375985 20-JUN-24 1 157 3375985 20-JUN-24 3376043 20-JUN-24 1 158 3376043 20-JUN-24 3376103 20-JUN-24 1 159 3376103 20-JUN-24 3376156 20-JUN-24 1 160 3376156 20-JUN-24 3376221 20-JUN-24 1 161 3376221 20-JUN-24 3376489 20-JUN-24 2 55 3375852 20-JUN-24 3376046 20-JUN-24 2 56 3376046 20-JUN-24 3376228 20-JUN-24 2 57 3376228 20-JUN-24 3376486 20-JUN-24 |
No comments:
Post a Comment