Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

RMAN restore archive files from tape using TSM

user9541720Oct 27 2008 — edited Oct 29 2008
I am new to using RMAN and TSM with RMAN so I need some help.

Our RMAN backup scripts take a weekly incremental level 0 and daily incremental level 1 backups. This are written to tape using TSM via RMAN with the cmds:
backup recovery area;
backup recovery files;
With CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo_solstdpoyaprod.opt)';

The backup script also has the command:
backup archivelog all delete all input; so the archive files are deleted after they are written to the /fra.

Now I have a request to use logminer to look for some data from last week.

How would I go about restoring only the archived logs from say a given logseq that are on tape from last week?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 26 2008
Added on Oct 27 2008
5 comments
3,295 views