HP DP [61:4039] 错误解决一例

最近的备份任务总是会出现如下的错误，恢复文件系统看不到树形目录。

[Major] From: BSM@js_app2 "FS_app2_Test_TD"  Time: 05/06/08 09:49:41
[61:4039]       Following error occurred while storing detail catalog
        information for device "app2_drv_4"
        with loaded medium "0a6414e6:44c31174:11ea:0001" [[FRD025] detail_file_system]
        to Data Protector Internal Database:

        Database internal error - see debug.log for details.

        From this point on, all objects on this medium
        will have logging switched to "No Log".

--首先怀疑是数据文件不够，查看后发现还有1.5G左右

#<[/opt/omni/sbin]./omnidbutil -extendinfo

Base file "fnames.dat":     
    Device               = /var/opt/omni/db40/datafiles/cdb     
    Number of extensions = 5     
    Maximum size         = 2097152 [kB]     
    Current size         = 2097152 [kB]
Extension file "fnames.dat1":     
    Device       = /var/opt/omni/db40/datafiles/cdb     
    Maximum size = 2096128 [kB]     
    Current size = 2096128 [kB]
Extension file "fnames.dat2":     
    Device       = /var/opt/omni/db40/datafiles/cdb     
    Maximum size = 2096128 [kB]     
    Current size = 2096128 [kB]
Extension file "fnames.dat3":     
    Device       = /var/opt/omni/db40/datafiles/cdb     
    Maximum size = 2097152 [kB]     
    Current size = 2097152 [kB]
Extension file "fnames.dat4":     
    Device       = /var/opt/omni/db40/datafiles/cdb     
    Maximum size = 2097152 [kB]     
    Current size = 2097152 [kB]
Extension file "fnames.dat5":     
    Device       = /var/opt/omni/db40/datafiles/cdb     
    Maximum size = 2097152 [kB]     
    Current size = 569600 [kB]
Maximum size with extensions = 12580864 [kB]
Current size with extensions = 11053312 [kB]

--尝试新加一个数据文件，但是故障依旧

# export SHLIB_PATH=/opt/omni/lib/
# export CATPATH=/var/opt/omni/db/catalog/
# export RDSTEMP=/var/opt/omni/tmp

#<[/opt/omni/sbin/utilns]./rdsadm

Database Administration Utility - RDM Server 3.5.473 [02-May-2002]
Copyright (c) 1992-2002 Birdstep Technology.  All Rights Reserved.

Enter RDM Server name: ob2_40
    Enter your userid: admin
    Enter your password:
Successful login

1. User
2. Device
3. Database
4. Configuration
5. Show
6. Extension Modules
7. Hot Backup
8. Shutdown Server
9. Exit
Enter selection (1-9): 3

1. Add Database
2. Initialize Database
3. Change Database
4. Delete Database
5. Change Database Access List
6. Initialize Record Totals
7. Change File
8. Rebuild Key Files
9. Exit
Enter selection (1-9): 7

1. Add Extension File
2. Set Base/Extension File Sizes
3. Move Base/Extension File to New Device
4. Exit
Enter selection (1-4): 1
Enter base file's device name (cr to exit, '?' for list): ?

    DEVICES
    catdev
    fnames1_40
    fnames2_40
    ob2cdb_40
    ob2mmdb_40
    ob2tmp_40
    rdsdll
    sysdev

Enter base file's device name (cr to exit, '?' for list): ob2cdb_40
Enter base file name: fnames.dat
File fnames.dat on device ob2cdb_40 has
    11318562816 of 12882788352 bytes allocated in 6 files.
Do you wish to add an extension file?  yes

Enter extension file's device name (cr to exit, '?' for list): ?

    DEVICES
    catdev
    fnames1_40
    fnames2_40
    ob2cdb_40
    ob2mmdb_40
    ob2tmp_40
    rdsdll
    sysdev

Enter extension file's device name (cr to exit, '?' for list): ob2cdb_40
Enter extension file name: fnames.dat6

1. User
2. Device
3. Database
4. Configuration
5. Show
6. Extension Modules
7. Hot Backup
8. Shutdown Server
9. Exit
Enter selection (1-9): 9

Exiting Administration utility

#<[/opt/omni/sbin]./omnidbutil -extendinfo

Base file "fnames.dat":
    Device               = /var/opt/omni/db40/datafiles/cdb     
    Number of extensions = 6     
    Maximum size         = 2097152 [kB]     
    Current size         = 2097152 [kB]
Extension file "fnames.dat1":     
    Device       = /var/opt/omni/db40/datafiles/cdb     
    Maximum size = 2096128 [kB]     
    Current size = 2096128 [kB]
Extension file "fnames.dat2":     
    Device       = /var/opt/omni/db40/datafiles/cdb     
    Maximum size = 2096128 [kB]     
    Current size = 2096128 [kB]
Extension file "fnames.dat3":     
    Device       = /var/opt/omni/db40/datafiles/cdb     
    Maximum size = 2097152 [kB]     
    Current size = 2097152 [kB]
Extension file "fnames.dat4":     
    Device       = /var/opt/omni/db40/datafiles/cdb     
    Maximum size = 2097152 [kB]     
    Current size = 2097152 [kB]
Extension file "fnames.dat5":     
    Device       = /var/opt/omni/db40/datafiles/cdb     
    Maximum size = 2097152 [kB]     
    Current size = 569600 [kB]
Extension file "fnames.dat6":     
    Device       = /var/opt/omni/db40/datafiles/cdb     
    Maximum size = 2097152 [kB]     
    Current size = 0 [kB]
Maximum size with extensions = 14678016 [kB]
Current size with extensions = 11053312 [kB]

--但是添加数据文件之后故障依旧，接下来查看Detail Catalog文件，剩余空间也足够

#<[/opt/omni/sbin]./omnidbutil -list_dcdirs

Configured DC Directories:

 Allocation sequence
 |       Maximum Usage in Mb
 |       |       Maximum number of files in directory
 |       |       |       Minimum free space in Mb
 |       |       |       |       Directory
 |       |       |       |       |
===========================================================================
 0       4096    10000   100     /var/opt/omni/db40/dcbf
 1       4096    10000   100     /zhjs_data/public/lihui_test/omni_128/var/opt/omni/db40/dcbf1

#<[/opt/omni/sbin]bdf /var/opt/omni/db40/dcbf
Filesystem          kbytes    used   avail %used Mounted on
/dev/vg_fs_pub/lv_pub
                   209682432 167890504 41465480   80% /zhjs_data/public
#<[/opt/omni/sbin]bdf /zhjs_data/public/lihui_test/omni_128/var/opt/omni/db40/dcbf1
Filesystem          kbytes    used   avail %used Mounted on
/dev/vg_fs_pub/lv_pub
                   209682432 167890504 41465480   80% /zhjs_data/public

#<[/opt/omni/sbin]omnidbutil -modify_dcdir /var/opt/omni/db40/dcbf2 -maxsize 5120

DONE!

--尝试增加Maximum Usage为5120，故障依旧

--增加另一个数据文件后，故障排除

js_app2#<[/opt/omni/sbin/utilns]./rdsadm

Database Administration Utility - RDM Server 3.5.473 [02-May-2002]
Copyright (c) 1992-2002 Birdstep Technology.  All Rights Reserved.

Enter RDM Server name: ob2_40
      Enter your userid: admin
    Enter your password:
Successful login

1. User
2. Device
3. Database
4. Configuration
5. Show
6. Extension Modules
7. Hot Backup
8. Shutdown Server
9. Exit
Enter selection (1-9): 3

1. Add Database
2. Initialize Database
3. Change Database
4. Delete Database
5. Change Database Access List
6. Initialize Record Totals
7. Change File
8. Rebuild Key Files
9. Exit
Enter selection (1-9): 7

1. Add Extension File
2. Set Base/Extension File Sizes
3. Move Base/Extension File to New Device
4. Exit
Enter selection (1-4): 1
Enter base file's device name (cr to exit, '?' for list): ?

    DEVICES
    catdev
    fnames1_40
    fnames2_40
    ob2cdb_40
    ob2mmdb_40
    ob2tmp_40
    rdsdll
    sysdev

Enter base file's device name (cr to exit, '?' for list): ob2cdb_40
Enter base file name: fn1.ext
File fn1.ext on device ob2cdb_40 has
    4294959104 of 4294959104 bytes allocated in 2 files.
Do you wish to add an extension file?  y
Enter extension file's device name (cr to exit, '?' for list): ?

    DEVICES
    catdev
    fnames1_40
    fnames2_40
    ob2cdb_40
    ob2mmdb_40
    ob2tmp_40
    rdsdll
    sysdev

Enter extension file's device name (cr to exit, '?' for list): ob2cdb_40
Enter extension file name: fn1.ext2

1. User
2. Device
3. Database
4. Configuration
5. Show
6. Extension Modules
7. Hot Backup
8. Shutdown Server
9. Exit
Enter selection (1-9): 5

1. Show Devices
2. Show Users
3. Show Databases
4. Show Extension Modules
5. Show Access by User
6. Show Access by Database
7. Show Extension Files
8. Exit
Enter selection (1-8): 7
Enter base file's device name (cr to exit, '?' for list): ?

    DEVICES
    catdev
    fnames1_40
    fnames2_40
    ob2cdb_40
    ob2mmdb_40
    ob2tmp_40
    rdsdll
    sysdev

Enter base file's device name (cr to exit, '?' for list): ob2cdb_40
Enter base file name: fn1.ext
Base file fn1.ext on device ob2cdb_40 has 4294959104 bytes
   allocated out of a maximum of 6442438656 in 3 files.
Extension #0: fn1.ext on device ob2cdb_40
   maximum size  : 2147479552 bytes
   allocated size: 2147479552 bytes
Extension #1: fn1.ext1 on device ob2cdb_40
   maximum size  : 2147479552 bytes
   allocated size: 2147479552 bytes
Extension #2: fn1.ext2 on device ob2cdb_40
   maximum size  : 2147479552 bytes
   allocated size: 0 bytes

1. User
2. Device
3. Database
4. Configuration
5. Show
6. Extension Modules
7. Hot Backup
8. Shutdown Server
9. Exit
Enter selection (1-9): 3

1. Add Database
2. Initialize Database
3. Change Database
4. Delete Database
5. Change Database Access List
6. Initialize Record Totals
7. Change File
8. Rebuild Key Files
9. Exit
Enter selection (1-9): 7

1. Add Extension File
2. Set Base/Extension File Sizes
3. Move Base/Extension File to New Device
4. Exit
Enter selection (1-4): 1
Enter base file's device name (cr to exit, '?' for list): ?

    DEVICES
    catdev
    fnames1_40
    fnames2_40
    ob2cdb_40
    ob2mmdb_40
    ob2tmp_40
    rdsdll
    sysdev

Enter base file's device name (cr to exit, '?' for list): ob2cdb_40
Enter base file name: fn2.ext
File fn2.ext on device ob2cdb_40 has
    770347008 of 2147479552 bytes allocated in 1 file.
Do you wish to add an extension file?  n

1. User
2. Device
3. Database
4. Configuration
5. Show
6. Extension Modules
7. Hot Backup
8. Shutdown Server
9. Exit
Enter selection (1-9): 3

1. Add Database
2. Initialize Database
3. Change Database
4. Delete Database
5. Change Database Access List
6. Initialize Record Totals
7. Change File
8. Rebuild Key Files
9. Exit
Enter selection (1-9): 7

1. Add Extension File
2. Set Base/Extension File Sizes
3. Move Base/Extension File to New Device
4. Exit
Enter selection (1-4): 1
Enter base file's device name (cr to exit, '?' for list): ?

    DEVICES
    catdev
    fnames1_40
    fnames2_40
    ob2cdb_40
    ob2mmdb_40
    ob2tmp_40
    rdsdll
    sysdev

Enter base file's device name (cr to exit, '?' for list): ob2cdb_40
Enter base file name: fn1.ext
File fn1.ext on device ob2cdb_40 has
    4294959104 of 6442438656 bytes allocated in 3 files.
Do you wish to add an extension file?  y
Enter extension file's device name (cr to exit, '?' for list): ?

    DEVICES
    catdev
    fnames1_40
    fnames2_40
    ob2cdb_40
    ob2mmdb_40
    ob2tmp_40
    rdsdll
    sysdev

Enter extension file's device name (cr to exit, '?' for list): ob2cdb_40
Enter extension file name: fn1.ext3

1. User
2. Device
3. Database
4. Configuration
5. Show
6. Extension Modules
7. Hot Backup
8. Shutdown Server
9. Exit
Enter selection (1-9): 5

1. Show Devices
2. Show Users
3. Show Databases
4. Show Extension Modules
5. Show Access by User
6. Show Access by Database
7. Show Extension Files
8. Exit
Enter selection (1-8): 7
Enter base file's device name (cr to exit, '?' for list): ?

    DEVICES
    catdev
    fnames1_40
    fnames2_40
    ob2cdb_40
    ob2mmdb_40
    ob2tmp_40
    rdsdll
    sysdev

Enter base file's device name (cr to exit, '?' for list): ob2cdb_40
Enter base file name: fn1.ext
Base file fn1.ext on device ob2cdb_40 has 4294959104 bytes
   allocated out of a maximum of 8589918208 in 4 files.
Extension #0: fn1.ext on device ob2cdb_40
   maximum size  : 2147479552 bytes
   allocated size: 2147479552 bytes
Extension #1: fn1.ext1 on device ob2cdb_40
   maximum size  : 2147479552 bytes
   allocated size: 2147479552 bytes
Extension #2: fn1.ext2 on device ob2cdb_40
   maximum size  : 2147479552 bytes
   allocated size: 0 bytes
Extension #3: fn1.ext3 on device ob2cdb_40
   maximum size  : 2147479552 bytes
   allocated size: 0 bytes

1. User
2. Device
3. Database
4. Configuration
5. Show
6. Extension Modules
7. Hot Backup
8. Shutdown Server
9. Exit
Enter selection (1-9): 9

Exiting Administration utility

--最后把修改后的综合信息列出来，以备查看
--其实看了这个命令我才知道自己走了不少的弯路，都是新手惹的祸，^_^

#<[/opt/omni/sbin]./omnidbutil -info

Media Management database space usage:

Space used by         Diskspace usage      Records used    Records total
============================================================================
Devices                           96                12               48
Libraries                         96                 1                8
Cartridges                       512               376              696
Compounds                         32                 0               16
Pools                             64                23               56
Media                            128               361              368

Catalog database space usage:

Space used by         Diskspace usage      Records used    Records total
============================================================================
Sessions                        1600              2360             2527
Objects                        12384             23474            51119
Object versions                27168             29461            55614
Positions                      30848            191983           305120
Filenames                   23759840         244621542        244621608

Detail catalog binary files usage:

Diskspace usage Size limit     DC Directory
============================================================================
3906            4096           /var/opt/omni/db40/dcbf
2085            5120           /zhjs_data/public/lihui_test/omni_128/var/opt/omni/db40/dcbf1
----------------------------------------------------------------------------
5990            9216

Session messages binary files usage:

Diskspace usage Num. of files  SMBFs Directory
============================================================================
27              2232           /var/opt/omni/db40/msg

Serverless integrations binary files usage:

Diskspace usage Num. of files  SIBFs Directory
============================================================================
0               0              /var/opt/omni/db40/meta

--结论

这里关键是extendinfo的时候没有显示fn1.ext这个base文件的信息从而误导了我，延长了解决问题的时间；网上查找了一些资料也没有发现有用的信息，如果哪位知道，告诉我一声，^_^