Saturday, September 28, 2024

RMAN-06617: UNTIL TIME


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

Popular Posts - All Times