[ASK] Recover individual data files from tape using brtools 7.0

[Former Member]

HI experts,

I want know how to recover individual data files from tape using brtools 7.0 ?

Thanks

Edy

[Former Member · Accepted solution]

sorry for typo, i meant restore individual data files from tape using brtools 7.0

[volker_borowski2 · Accepted solution]

use brrestore -m

-m takes different types of argument like tablespacenames or datafilenames, single or seperated by comma, as in

brrestore -m /oracle/PRD/undo_1/undo.data1,PSAPPRDODS

or datafilenumbers (can be taken from the heading section of the protocolfile).

brrestore -m 6,8,9

if you have no protocolfiles, you need to restore these first in a seperate run

brrestore -m all_logs

because the detail log has the tape-positions of the individual datafiles.

Hope this helps

Volker

[Former Member · Accepted solution]

Hi Volker,

The destination directory will be saved to directory /oracle/PRD/undo_1 too?

or how to change destination directory?

Thanks

Edy

[volker_borowski2 · Accepted solution]

brrestore -m /oracle/PRD/undo_1/undo.data1=/someplace/enough_space,SYSTEM=/elsewhere

use -q (query) in the first call to verify, that the different restore location will be chosen.

Search help.sap,com for the complete documentation of brrestore

Volker

[Former Member · Accepted solution]

Thank you volker for your answer