cancel
Showing results for 
Search instead for 
Did you mean: 

Restore RMAN-06025: no backup of archived log

blanco_adalbert
Level 5
Partner Accredited Certified

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

1 ACCEPTED SOLUTION

Accepted Solutions

Walker_Yang1
Level 5
Employee
Could you output the following command? RMAN> crosscheck archivelog sequence 4437 thread 2; RMAN> crosscheck backup of archivelog sequence 4437 thread 2; Thanks

View solution in original post

2 REPLIES 2

Marianne
Level 6
Partner    VIP    Accredited Certified

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.

Walker_Yang1
Level 5
Employee
Could you output the following command? RMAN> crosscheck archivelog sequence 4437 thread 2; RMAN> crosscheck backup of archivelog sequence 4437 thread 2; Thanks