requested media id is not assigned to this host in the EMM database

[adityakm]

Hello,

I need some on help to fix issue in the media related. In the scratch pool haveI have enough tapes loaded and most of tapes shows below mesg.

"requested media id is not assigned to this host in the EMM database"

I have tried below procedure:

1.

root@riuxadmin # nbemmcmd -listmedia -mediaid YS0469
NBEMMCMD, Version:6.5.3
====================================================================
Media GUID:                     9187b0d8-a16f-11dc-8000-f67b30235b73
Media ID:                       YS0469
Partner:                        -
Media Type:                     HCART3
Volume Group:                   000_00001_TLD
Application:                    Netbackup
Media Flags:                    1
Description:                    Scratch Tapes
Barcode:                        YS0469
Partner Barcode:                --------
Last Write Host:                NONE
Created:                        10/22/2007 11:25
Time Assigned:                  -
First Mount:                    11/07/2007 09:00
Last Mount:                     02/09/2014 20:37
Volume Expiration:              -
Data Expiration:                -
Last Written:                   -
Last Read:                      -
Robot Type:                     TLD
Robot Control Host:             riuxerpbkp
Robot Number:                   1
Slot:                           48
Side/Face:                      -
Cleanings Remaining:            -
Number of Mounts:               363
Maximum Mounts Allowed:         0
Media Status:                   ACTIVE
Kilobytes:                      0
Images:                         0
Valid Images:                   0
Retention Period:               -
Number of Restores:             0
Optical Header Size Bytes:      0
Optical Sector Size Bytes:      0
Optical Partition Size Bytes:   0
Last Header Offset:             0
Adamm Guid:                     00000000-0000-0000-0000-000000000000
Rsm Guid:                       00000000-0000-0000-0000-000000000000
Origin Host:                    riuxadmin.pitts.us.respironics.com
Master Host:                    riuxadmin.pitts.us.respironics.com
Server Group:
Upgrade Conflicts Flag:
Pool Number:                    13
Volume Pool:                    RespoScratch
Previous Pool Name:             -
Vault Flags:                    -
Vault Container:                -
Vault Name:                     -
Vault Slot:                     -
Session ID:                     -
Date Vaulted:                   -
Return Date:                    -
====================================================================
Command completed successfully.

2. Expired the tape by using following command:

root@riuxadmin # bpexpdate -m YS0469 -d 0 -force -host riuxadmin.pitts.us.respironics.com
requested media id is not assigned to this host in the EMM database
 

Suggest how I can use those tapes for backups which already there in scrtachpool.

[mph999 · Accepted solution]

What you see is normal - tapes in scratch should have no assign time (as seen above) and should not be in the media DB, hence the message you see.

When a tape is used for backup, pretty much the first thing that happens (if it is previously empty) is it is put in the media DB and given an assign time.  The media DB basically tracks numbers of images on tapes (+ other things).  When the images expire the image count drops to 0 and then the tape is deassigned from the media DB when one of the cleanup jobs run.  A command that looks in the media db is bpmedialist.

The other DB involved with tapes is the volume DB - this tracks physical aspects, such as location, if a tape appears in nbemmcmd -listmedia or the media part of the GUI or vmqery -a then it is in the volume DB and is known to NB.  A tape will always be in the volume DB unless it is deleted.

So in summary.

volume DB is physical  

media DB is 'image related' and only contains a tape when it has valid images

In summary you don't have an issue, or if you do, this isn't the cause.

[mph999]

Forgot to mention:

A tape should automatically be picked from scratch, you don't do anything

You cannot bpexpdate a tape in scratch, it's already been 'expired' (or has never been used).

[Marianne]

Can you check that pool name RespoScrach is indeed marked as 'scratch pool'? Check with 'vmpool -listscratch'. Tape is hcart3 and is in robot 1. If Storage Unit with these attributes is selected in policy, this will be one of the tapes that may be selected. Reasons why this tape may not be selected right away: There may be other tapes already assigned that can be appended to; there are other unassigned tapes with less mounts. This tape has lots of mounts. When an unassigned tape is requested, the one with least number of mounts will be chosen. PS: PLEASE upgrade your environment. NBU 6.5 ran out of support in 2012.

[mph999]

This command will show which pool is set as scratch:

vmpool -list_scratch

The command is in the.../volmgr/bin directory.

[Marianne]

Thanks Martin! 

I did not have access to commands manual when I posted above...

[mph999]

NP ...  ;0)  - I also had to look it up, can never remember that one ... :0(