dbTalk Databases Forums  

Identifying the MML used for a particular backup set

comp.databases.oracle.server comp.databases.oracle.server


Discuss Identifying the MML used for a particular backup set in the comp.databases.oracle.server forum.



Reply
 
Thread Tools Display Modes
  #11  
Old   
Steve Howard
 
Posts: n/a

Default Re: Identifying the MML used for a particular backup set - 06-23-2008 , 10:19 AM






On Jun 20, 10:06 am, Chuck <chuckh1958_nospam (AT) gmai (DOT) .com> wrote:
Quote:
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
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


Reply With Quote
  #12  
Old   
Steve Howard
 
Posts: n/a

Default Re: Identifying the MML used for a particular backup set - 06-23-2008 , 10:19 AM






On Jun 20, 10:06 am, Chuck <chuckh1958_nospam (AT) gmai (DOT) .com> wrote:
Quote:
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
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


Reply With Quote
  #13  
Old   
Steve Howard
 
Posts: n/a

Default Re: Identifying the MML used for a particular backup set - 06-23-2008 , 10:19 AM



On Jun 20, 10:06 am, Chuck <chuckh1958_nospam (AT) gmai (DOT) .com> wrote:
Quote:
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
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


Reply With Quote
  #14  
Old   
Steve Howard
 
Posts: n/a

Default Re: Identifying the MML used for a particular backup set - 06-23-2008 , 10:19 AM



On Jun 20, 10:06 am, Chuck <chuckh1958_nospam (AT) gmai (DOT) .com> wrote:
Quote:
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
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


Reply With Quote
  #15  
Old   
Steve Howard
 
Posts: n/a

Default Re: Identifying the MML used for a particular backup set - 06-23-2008 , 10:19 AM



On Jun 20, 10:06 am, Chuck <chuckh1958_nospam (AT) gmai (DOT) .com> wrote:
Quote:
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
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


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.