cancel
Showing results for 
Search instead for 
Did you mean: 

restore corrupt blocks of datafile from bplist

aherrera1976
Level 2
I have a data file with corrupted blocks, when I run from rman a

BLOCKRECOVER DATAFILE 21 BLOCK 1233748;

recover.jpg 

Can't find backup to restore

 

I launch a bplist from the master

 

How do I get these copies of bplist to be active in rman to perform blockrecover with these backups?
Thank you
 

bplist.jpg

2 REPLIES 2

Michal_Mikulik1
Moderator
Moderator
Partner    VIP    Accredited Certified

Hello,

rman catalog must know which backup copy to use. Try the validation if it works:

run {
allocate channel t0 type 'sbt_tape';
restore datafile 21 validate;
}

If not you must most likely adjust NB_ORA_CLIENT to fit.

Regards

M.

Nicolai
Moderator
Moderator
Partner    VIP   

You may also want to run a RMAN cross check from the recover catalogue.If RMAN doesn't know what backup Netbackup holds, a restore will fail.

See : https://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta015.htm#RCMRF119

Please team up with your DBA.