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 log backups that would be restored and used as recovery using this time/scn based recovery.
You can use following commands while connected to the destination database (DB is mounted after controlfile restore), to find out the NEXT SCN of the highest redo log sequence number registered with the control file. In my case maximum SCN available is 3376486 which I can see under "Next Time" column for thread 2 sequence number 57 right at the bottom of the following output. First execute “list backupset” to list all backupsets and then check contents of the last backupset (number 13 in my case) of archived redo logs file.
RMAN> 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