Forum Discussion

blanco_adalbert's avatar
11 years ago
Solved

Restore RMAN-06025: no backup of archived log

Hello Everyone

 

I Need to restore an archive log when I try to find it out using RMAN i got someting like this

 BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
7386620 4.39G      SBT_TAPE    00:04:17     31-JUL-14
        BP Key: 7386631   Status: AVAILABLE  Compressed: NO  Tag: TAG20140731T170013
        Handle: hepepnp0_1_1   Media: CS0650

  List of Archived Logs in backup set 7386620
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    6636    199103405748 31-JUL-14 199109231888 31-JUL-14

 

 

When I run the restore using rman i got this

RMAN-06025: no backup of archived log for thread 2 with sequence 4437 and starting SCN of 199093424179 found to restore

 

Does anybody has faced whit this problem.

 

Best Regards

  • Could you output the following command? RMAN> crosscheck archivelog sequence 4437 thread 2; RMAN> crosscheck backup of archivelog sequence 4437 thread 2; Thanks
  • What is the retention period in NBU?
    What is Client name in NBU policy for this particular Oracle client?
    Is the date/time on the client the same as on the master and rman catalog?

    Please run this command from the Master server:

    bplist -client <client-name> -t 4 -s 07/31/2014 -e 08/01/2014 

    Above will show us valid, unexpired Oracle backups for this client between 31 Jul and 1 Aug.

    Please be sure that the client name used in the command corresponds with client name in the Oracle policy.

    You may also want to check the CLIENT_NAME in bp.conf on the client to ensure that it corresponds with the name in the policy.

  • Could you output the following command? RMAN> crosscheck archivelog sequence 4437 thread 2; RMAN> crosscheck backup of archivelog sequence 4437 thread 2; Thanks