ADSM-L

Re: [ADSM-L] TDP for Oracle - multi channel restore

2009-01-07 10:25:50
Subject: Re: [ADSM-L] TDP for Oracle - multi channel restore
From: Richard Rhodes <rrhodes AT FIRSTENERGYCORP DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 7 Jan 2009 10:24:27 -0500
> We backup our Oracle database via two channels so the data is split onto
> two different tapes. Therefore we can use two channel restores.
>
> Four channel restore doesn't make any sense as the other two extra
> channels can't mount the tapes which are already in use by the first two
> restore sessions

Yes and no.  Isn't there a complete break between RMAN and TSM?  How
can RMAN have any knowledge of what tapes backup pieces are on when TSM
can move files arond on volumes (migration, movedata, reclamation).  Yes,
our big databases write to a tape and it is never moved, but logically it
could, and RMAN wouldn't even know.  This would be sspecially true if
a RMAN/TDPO went to a file/disk devices first, then migrated to tape.

I can understand how using 2 channels for backup and restore would not
get drive contention, but that seems to only be true if TSM
has not migrated/movedata/reclamation some of the backup to
different/same volumes.

Rick

ps:  Google is amazing!  My origional email showed up on a Google search
     I did on this subject after only about 15 min of sending the
     origional email.

-----------------------------------------
The information contained in this message is intended only for the
personal and confidential use of the recipient(s) named above. If
the reader of this message is not the intended recipient or an
agent responsible for delivering it to the intended recipient, you
are hereby notified that you have received this document in error
and that any review, dissemination, distribution, or copying of
this message is strictly prohibited. If you have received this
communication in error, please notify us immediately, and delete
the original message.