Is there any way to determine from the RMAN catalog what MML was used to
create a backup set? We are in the process of switching from TDPO to Net
Backup and have both sets of libraries installed. Some of my DBID's have
changed over time due to RMAN duplications and this has caused some
backup sets to be abandoned in the catalog. I'd like to come up with a
way to correctly determine which libobk library I should be using to
delete a particular backup set. TIA

On Fri, 20 Jun 2008 14:06:11 GMT, Chuck <chuckh1958_nospam (AT) gmai (DOT) .com>
wrote:

First of all, you should always (I mean: ALWAYS) include a 4 digit
version number, as Oracle happens to change with every release.
If you post a question without version number, you either force
someone to include answers for various versions, or you don't get
accurate responses, or you get no response at all.

That said, as far as I know in 9i and 8i, Oracle only distinguishes
between disk and sbt_tape. Whether that has changed in 10g and 11g I
don't know, but I don't think it is very likely, as the very reason to
do this using libobk is to make the process transparent.

--
Sybrand Bakker
Senior Oracle DBA

On Fri, 20 Jun 2008 14:06:11 GMT, Chuck <chuckh1958_nospam (AT) gmai (DOT) .com>
wrote:

First of all, you should always (I mean: ALWAYS) include a 4 digit
version number, as Oracle happens to change with every release.
If you post a question without version number, you either force
someone to include answers for various versions, or you don't get
accurate responses, or you get no response at all.

That said, as far as I know in 9i and 8i, Oracle only distinguishes
between disk and sbt_tape. Whether that has changed in 10g and 11g I
don't know, but I don't think it is very likely, as the very reason to
do this using libobk is to make the process transparent.

--
Sybrand Bakker
Senior Oracle DBA

On Fri, 20 Jun 2008 14:06:11 GMT, Chuck <chuckh1958_nospam (AT) gmai (DOT) .com>
wrote:

First of all, you should always (I mean: ALWAYS) include a 4 digit
version number, as Oracle happens to change with every release.
If you post a question without version number, you either force
someone to include answers for various versions, or you don't get
accurate responses, or you get no response at all.

That said, as far as I know in 9i and 8i, Oracle only distinguishes
between disk and sbt_tape. Whether that has changed in 10g and 11g I
don't know, but I don't think it is very likely, as the very reason to
do this using libobk is to make the process transparent.

--
Sybrand Bakker
Senior Oracle DBA

On Fri, 20 Jun 2008 14:06:11 GMT, Chuck <chuckh1958_nospam (AT) gmai (DOT) .com>
wrote:

First of all, you should always (I mean: ALWAYS) include a 4 digit
version number, as Oracle happens to change with every release.
If you post a question without version number, you either force
someone to include answers for various versions, or you don't get
accurate responses, or you get no response at all.

That said, as far as I know in 9i and 8i, Oracle only distinguishes
between disk and sbt_tape. Whether that has changed in 10g and 11g I
don't know, but I don't think it is very likely, as the very reason to
do this using libobk is to make the process transparent.

--
Sybrand Bakker
Senior Oracle DBA

On Fri, 20 Jun 2008 14:06:11 GMT, Chuck <chuckh1958_nospam (AT) gmai (DOT) .com>
wrote:

First of all, you should always (I mean: ALWAYS) include a 4 digit
version number, as Oracle happens to change with every release.
If you post a question without version number, you either force
someone to include answers for various versions, or you don't get
accurate responses, or you get no response at all.

That said, as far as I know in 9i and 8i, Oracle only distinguishes
between disk and sbt_tape. Whether that has changed in 10g and 11g I
don't know, but I don't think it is very likely, as the very reason to
do this using libobk is to make the process transparent.

--
Sybrand Bakker
Senior Oracle DBA

On Fri, 20 Jun 2008 14:06:11 GMT, Chuck <chuckh1958_nospam (AT) gmai (DOT) .com>
wrote:

First of all, you should always (I mean: ALWAYS) include a 4 digit
version number, as Oracle happens to change with every release.
If you post a question without version number, you either force
someone to include answers for various versions, or you don't get
accurate responses, or you get no response at all.

That said, as far as I know in 9i and 8i, Oracle only distinguishes
between disk and sbt_tape. Whether that has changed in 10g and 11g I
don't know, but I don't think it is very likely, as the very reason to
do this using libobk is to make the process transparent.

--
Sybrand Bakker
Senior Oracle DBA

On Fri, 20 Jun 2008 14:06:11 GMT, Chuck <chuckh1958_nospam (AT) gmai (DOT) .com>
wrote:

First of all, you should always (I mean: ALWAYS) include a 4 digit
version number, as Oracle happens to change with every release.
If you post a question without version number, you either force
someone to include answers for various versions, or you don't get
accurate responses, or you get no response at all.

That said, as far as I know in 9i and 8i, Oracle only distinguishes
between disk and sbt_tape. Whether that has changed in 10g and 11g I
don't know, but I don't think it is very likely, as the very reason to
do this using libobk is to make the process transparent.

--
Sybrand Bakker
Senior Oracle DBA

On Jun 20, 10:06 am, Chuck <chuckh1958_nospam (AT) gmai (DOT) .com> wrote:
Hi Chuck,

Try:

select distinct media,media_pool from gv$backup_piece;

That is a logical mapping as far as I know, at least in TSM's case.
Check with your storage guys with whatever the above returns, and
maybe they can shed some light.

HTH,

Steve

On Jun 20, 10:06 am, Chuck <chuckh1958_nospam (AT) gmai (DOT) .com> wrote:
Hi Chuck,

Try:

select distinct media,media_pool from gv$backup_piece;

That is a logical mapping as far as I know, at least in TSM's case.
Check with your storage guys with whatever the above returns, and
maybe they can shed some light.

HTH,

Steve