Thursday, August 7, 2014

RMAN-05541: no archived logs found in target database

Problem:
You are getting  RMAN-05541 error when duplicating database from a consistent (cold) RMAN backup.

Error Message:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 07/08/2014 18:12:40
RMAN-05501: aborting duplication of target database
RMAN-05541: no archived logs found in target database


Solution:
The error should be resolved by using NOREDO clause for your duplicate command.

Example:
run {
 set until time "to_date('08-OCT-2014 10:15:00','DD-MON-YYYY HH24:MI:SS')";
 DUPLICATE DATABASE TO targetDB
 BACKUP LOCATION '/backup_Location' NOREDO;
   }


I hope this helps.

Please feel free to leave your questions or suggest improvements to this section.
Posted by at
Labels: ,

15 comments:

  1. UnknownDecember 22, 2014 at 6:22 AM

    Thanks , its helped on time...:)

    ReplyDelete
  2. Peter panMarch 2, 2015 at 7:50 AM

    Thanks this help me!!!

    ReplyDelete
  3. UnknownOctober 13, 2015 at 10:54 AM

    Awesome solved my error, thanks bruh

    ReplyDelete
  4. JonathanFebruary 16, 2016 at 3:48 PM

    FYI. I have a difference scenario.
    [Attempt-1] I got the same error as yours, so I added "NOREDO". It gave me the following errors.
    "RMAN-06136: ORACLE error from auxiliary database: ORA-01194: file 1 needs more recovery to be consistent
    ORA-01110: data file 1: '+DATA/xxx/DATAFILE/system.1849.903967925' "
    [Attempt-2] I found it's because necessary archived logs were not in backup location, so I copied them to that location. I ran duplicate database without NOREDO. Then it works.

    ReplyDelete
  5. AnonymousApril 22, 2016 at 7:57 AM

    Thanks, this solved my problem. Greetings from Bs.As.

    ReplyDelete
  6. UnknownAugust 25, 2016 at 12:32 PM

    Thanks.Issue solved.

    ReplyDelete
  7. Sandeep KahalsinghSeptember 8, 2016 at 7:45 AM

    Thanks Buddy. It helped me.

    ReplyDelete
  8. Bashir AhamadSeptember 28, 2016 at 9:45 PM

    Thanks Man ..!!

    ReplyDelete
  9. UnknownJanuary 4, 2017 at 7:40 AM

    Many thanks!

    ReplyDelete
  10. AnonymousFebruary 1, 2017 at 11:08 PM

    Thanks man, you saved my life.

    ReplyDelete
  11. AnonymousFebruary 16, 2017 at 11:40 AM

    Thanks!!

    ReplyDelete
  12. YashSeptember 15, 2017 at 1:39 AM

    Thanks...helped me as well!

    ReplyDelete
  13. UnknownFebruary 28, 2018 at 5:59 PM

    Thanks!! it worked.

    ReplyDelete
  14. lmuJanuary 7, 2019 at 1:39 PM

    I found my issue, I forgot to change the year in my duplicate command. It worked when I used the correct date to restore.

    ReplyDelete
  15. UnknownApril 20, 2021 at 8:13 AM

    This helped ! Thank you very much !

    ReplyDelete

Subscribe to: Post Comments (Atom)