Database Software

Hi,

We have an SL500 tape library as our main backup device. We also added an SL24 to the OSB domain for testing prior to installation elsewhere. We have an RMAN-FULL-MF media family, which at some point in the past had unexpired media in both libraries.

As part of the process of decommissioning the SL24 prior to shipment, I unloaded the volumes from the SL24 and imported them into the SL500. However, I may not have run the necessary OSB commands, such that OSB has up-to-date information as to where the physical media is located.

Our DBA has tried to delete some old database backups, and this has failed because the backup pieces cannot be found. However, we have a volume in the SL500, RMAN-FULL-MF-000007 which appear to contains the backup pieces (see 'lspiece' output below), but OSB thinks the volume is still in the SL24.

When I do an inventory of the SL500 I get:

lsvol -L SL500
Inventory of library SL500:
in 1: volume OSB-CATALOG-MF-000085, barcode 000001, 408693760 kb remaining, expires 2008/10/02.07:01
in 2: volume CLIENTS-INCR-MF-000042, barcode 000000, 405070848 kb remaining, expires 2008/10/14.03:01
in 3: unlabeled, barcode 000002
in 4: volume RMAN-ARCH-MF-000006, barcode 000003, 387257344 kb remaining, content manages reuse
in 5: volume RMAN-ARCH-MF-000003, barcode 000004, 358014976 kb remaining, content manages reuse
in 6: volume RMAN-FULL-MF-000005, barcode 000005, 353155072 kb remaining, content manages reuse
in 7: volume OSB-CATALOG-MF-000087, barcode 000006, 408693760 kb remaining, expires 2008/10/04.07:01
in 8: volume RMAN-FULL-MF-000006, barcode 000007, 361881600 kb remaining, content manages reuse
in 9: volume CLIENTS-INCR-MF-000044, barcode 000010, 407601152 kb remaining, expires 2008/10/20.02:02
in 10: volume OSB-CATALOG-MF-000084, barcode 000011, 408794112 kb remaining, expired
in 11: volume CLIENTS-INCR-MF-000039, barcode 000012, 406033408 kb remaining, expires 2008/10/10.03:02
in 12: volume CLIENTS-INCR-MF-000036, barcode 000013, 405890048 kb remaining, expires 2008/10/03.03:02
in 13: volume OSB-CATALOG-MF-000086, barcode 000014, 408708096 kb remaining, expires 2008/10/03.07:02
in 14: volume CLIENTS-INCR-MF-000038, barcode 000009, 407687168 kb remaining, expires 2008/10/04.04:04
in 15: volume CLIENTS-INCR-MF-000043, barcode 000008, 407586816 kb remaining, expires 2008/10/17.03:03
in 16: volume CLIENTS-INCR-MF-000037, barcode 000015, 409627648 kb remaining, expires 2008/10/03.03:02
in 17: volume CLIENTS-FULL-MF-000028, barcode 000016, 337067008 kb remaining, expires 2008/10/05.04:18
in 18: volume CLIENTS-FULL-MF-000029, barcode 000017, 318909440 kb remaining, expires 2008/10/05.05:08
in 19: volume CLIENTS-INCR-MF-000041, barcode 000018, 408406016 kb remaining, expires 2008/10/11.05:09
in 20: unlabeled, barcode 000019
in 21: volume CLIENTS-FULL-MF-000031, barcode 000020, 312597504 kb remaining, expires 2008/10/12.05:04
in 22: volume CLIENTS-FULL-MF-000033, barcode 000021, 389140480 kb remaining, expires 2008/10/19.05:08
in 23: volume CLIENTS-FULL-MF-000034, barcode 000022, 392922112 kb remaining, expires 2008/10/19.05:08
in 24: volume CLIENTS-INCR-MF-000035, barcode 000023, 409815040 kb remaining, expires 2008/10/02.05:06
in 25: volume CLIENTS-FULL-MF-000032, barcode 000024, 356518912 kb remaining, expires 2008/10/19.02:02
in 26: volume CLIENTS-INCR-MF-000040, barcode 000025, 409699328 kb remaining, expires 2008/10/11.04:04
in 27: volume CLIENTS-FULL-MF-000030, barcode 000026, 375496704 kb remaining, expires 2008/10/12.04:18
in 28: volume CLIENTS-INCR-MF-000034, barcode 000027, 408218624 kb remaining, expired
in 29: unlabeled, barcode 000028
in 30: unlabeled, barcode 000029
in 31: volume RMAN-ARCH-MF-000004, barcode 000056, content manages reuse
in 32: unlabeled, barcode 000059
in 33: volume RMAN-ARCH-MF-000005, barcode 000055, content manages reuse
in 34: volume RMAN-FULL-MF-000007, barcode 000057, content manages reuse
in 35: unlabeled, barcode 000058
in 49: unlabeled, barcode CLNU00
in 50: unlabeled, barcode CLNU01

This shows the relevant volume. However, when I do an 'lsvol' by media family, I get:

lsvol -f RMAN-FULL-MF
VOID OOID Seq Volume ID Barcode Family Created Attributes
166 166 1 RMAN-FULL-MF-000005 000005 RMAN-FULL-MF 07/06.03:20 never closes; content manages reuse
167 167 1 RMAN-FULL-MF-000006 000007 RMAN-FULL-MF 07/06.03:23 never closes; content manages reuse
324 324 1 RMAN-FULL-MF-000007 000057 RMAN-FULL-MF 08/31.02:27 never closes; content manages reuse
288 288 1 RMAN-FULL-MF-000007 000057L3 RMAN-FULL-MF 08/31.02:27 never closes; content manages reuse

The volume RMAN-FULL-MF-000007 appears twice! The long version of this command gives:

lsvol -lf RMAN-FULL-MF
Volume OID: 166
Volume ID: RMAN-FULL-MF-000005
Barcode: 000005
Volume sequence: 1
Media family: RMAN-FULL-MF
Current location: SL500
Label host: ldvbspa01
Created: 2008/07/06.03:20
Closes: never
Expires: never; content manages reuse
Space remaining: 336.8 GB
Original OID: 166
Volume OID: 167
Volume ID: RMAN-FULL-MF-000006
Barcode: 000007
Volume sequence: 1
Media family: RMAN-FULL-MF
Current location: SL500
Label host: ldvbspa01
Created: 2008/07/06.03:23
Closes: never
Expires: never; content manages reuse
Space remaining: 345.1 GB
Original OID: 167
Volume OID: 324
Volume ID: RMAN-FULL-MF-000007
Barcode: 000057
Volume sequence: 1
Media family: RMAN-FULL-MF
Current location: SL500
Label host: ldvbsm01
Created: 2008/08/31.02:27
Closes: never
Expires: never; content manages reuse
Original OID: 324
Volume OID: 288
Volume ID: RMAN-FULL-MF-000007
Barcode: 000057L3
Volume sequence: 1
Media family: RMAN-FULL-MF
Label host: ldvbsm01
Created: 2008/08/31.02:27
Closes: never
Expires: never; content manages reuse
Space remaining: 390.1 GB
Original OID: 288


I ran the 'lspiece' command to get information about the specific backup pieces in question and I get:

lspiece -l -S 7ujpclm8_1_2
Error: can't read location SL24(DELETED) - UUID not found
Warning: can't obtain section and volume data for piece OID 2058 - UUID not found
Backup piece OID: 2058
Database: ukldmoms
Database ID: 3307807331
Content: full
Copy number: 0
Created: 2008/08/31.02:27
Host: ldvbsm01
Piece name: 7ujpclm8_1_2
BSOID: 3378
Volume ID: RMAN-FULL-MF-000007
File: 1
Sect: 1

lspiece -l -S 7vjpcn5b_1_2
Error: can't read location SL24(DELETED) - UUID not found
Warning: can't obtain section and volume data for piece OID 2059 - UUID not found
Backup piece OID: 2059
Database: ukldmoms
Database ID: 3307807331
Content: full
Copy number: 0
Created: 2008/08/31.02:31
Host: ldvbsm01
Piece name: 7vjpcn5b_1_2
BSOID: 3379
Volume ID: RMAN-FULL-MF-000007
File: 2
Sect: 1

This appears to indicate that OSB still thinks the volume is in the SL24, which has now been removed from the domain.

Does anyone know what I can do to get OSB to recognise that the volume is now in the SL500? Do I need to run the 'obtar' command with the -G option to re-catalogue the tape?

Ultimately I like to see some documentation on how to transfer tapes between libraries in the same domain, and also between domains, with specifc commands to run.

Thanks.