Go to primary content
Oracle® Communications EAGLE Database Administration - System Management User's Guide
Release 46.6
E93319 Revision 1
Go To Table Of Contents
Contents

Previous
Previous
Next
Next

Verifying the Database

Verifying the database means to check the operational status of the database. The rept-stat-db command is used to check the operational status of the database. The rept-stat-db command has three optional parameters that can be used with it, display, loc, and db.

The display parameter can use four values: brief (the default value), except, all, and version. The value for the loc parameter is the card location of the card, based on the GPL assigned to the card, whose database you wish to verify. These card locations are shown in Hardware Reference . The db parameter specifies which database to display: stp (the EAGLE databases), mps (the MPS databases) and all (both STP and MPS databases).

The operational status of the database is shown by the indicatorC. This indicator shows whether the database is coherent. Coherency is an indication of whether the update to the database was successful. Each database has a coherency indicator. When an update is attempted, the coherency indicator is set to “incoherent” before the actual update is executed. When the update has been successfully completed, the coherency indicator is changed to coherent. If the update is not successful, the coherency indicator is not changed. If the coherency indicator is incoherent, this could be an indication of possible internal coherency problems when a restart is executed (for example, an index table was updated, but the corresponding data storage table was not modified).

For more information about the rept-stat-db command, refer to the rept-stat-db command description in Commands User's Guide.

Checking the Status of the Database

To check the operational status of the database:

  1. At the prompt, enter the rept-stat-db command.
  2. The output of the rept-stat-db command shows the current operational status of the EAGLE’s distributed databases.
  3. If the database is coherent, the database has no problems. The procedure is completed.

If any MPS/ELAP/EPAP database is not coherent, find the conditions shown in the output of the rept-stat-db command. Then refer to either ELAP Administration and LNP Feature Activation Guide or EPAP Administration Guide, and perform the database recovery procedures described in the RTDB / Maintenance menus.

If any STP database is not coherent, find the conditions shown in the output of the rept-stat-db command in this list and execute the appropriate command.

  • If the current partition of both fixed disks are coherent and the backup partition of the either fixed disk is not coherent, as shown in this output example, use the chg-db:action=backup:dest=fixed command. For more information, refer to Making a Backup of the Database on the Fixed Disk.

    rlghncxa03w 09-03-01 16:07:48 GMT  EAGLE5 40.1.0
    DATABASE STATUS: >> NOT OK <<
            TDM 1114 ( STDBY)                 TDM 1116 ( ACTV )
            C  LEVEL     TIME LAST BACKUP     C  LEVEL     TIME LAST BACKUP
             - -------- ---------------------  - -------- ---------------------
    FD BKUP  Y       35 DIFF LEVEL             N       45 INCOHERENT
    FD CRNT  Y      106                        Y      106           
            MDAL 1117
             - --------
    RD BKUP  -    -         -        -
    

    If the E5-MASP is being used, this is an example of the rept-stat-db output.

    rlghncxa03w 09-03-01 16:07:48 GMT  EAGLE5 40.1.0
    DATABASE STATUS: >> NOT OK <<
            TDM 1114 ( STDBY)                 TDM 1116 ( ACTV )
            C   LEVEL    TIME LAST BACKUP     C   LEVEL    TIME LAST BACKUP
            - -------- ---------------------- - -------- ----------------------
    FD BKUP Y       36 DIFF LEVEL             N       45 INCOHERENT
    FD CRNT Y      106                        Y       106
            MCAP 1113                         MCAP 1115
            - --------                        - --------
    RD BKUP Y       36 09-02-19 09:27:17 GMT  Y       36 09-02-19 09:27:17 GMT
    USB BKP -    -         -        -         Y        3 09-02-07 01:11:22 GMT
    

    The chg-db:action=backup:dest=fixed command is also used to backup the current database on both fixed disks to the backup partition of both fixed disks.

  • If the current partition of the active fixed disk is coherent and the database on the removable cartridge is not coherent, as shown in this output example, use the chg-db:action=backup:dest=remove command. For more information, refer to Making a Backup of the Database to the Removable Media.

    rlghncxa03w 09-03-01 16:07:48 GMT  EAGLE5 40.1.0
    DATABASE STATUS: >> NOT OK <<
            TDM 1114 ( STDBY)                 TDM 1116 ( ACTV )
             C  LEVEL     TIME LAST BACKUP     C  LEVEL     TIME LAST BACKUP
             - -------- ---------------------  - -------- ---------------------
    FD BKUP  Y       35 09-02-01 10:19:18 GMT  Y       35 09-02-01 10:19:18 GMT
    FD CRNT  Y      106                        Y      106 
            MDAL 1117
             - --------
    RD BKUP  N      106 INCOHERENT
    

    If the E5-MASP is being used, this is an example of the rept-stat-db output.

    rlghncxa03w 09-03-01 16:07:48 GMT  EAGLE5 40.1.0
    DATABASE STATUS: >> NOT OK <<
            TDM 1114 ( STDBY)                 TDM 1116 ( ACTV )
            C   LEVEL    TIME LAST BACKUP     C   LEVEL    TIME LAST BACKUP
            - -------- ---------------------- - -------- ----------------------
    FD BKUP Y       35 09-02-01 10:19:18 GMT  Y       35 09-02-01 10:19:18 GMT
    FD CRNT Y      106                        Y       106
            MCAP 1113                         MCAP 1115
            - --------                        - --------
    RD BKUP N      106 INCOHERENT             N      106 INCOHERENT
    USB BKP -    -         -        -         Y        3 09-02-01 01:11:22 GMT
    

    The chg-db:action=backup:dest=remove command is also used to backup the current database on both fixed disks to the removable cartridge.

  • If the backup partition of both fixed disks are coherent and the current partition of both fixed disks are not coherent, use the chg-db:action=restore:src=fixed command. For more information, refer to Restoring the Database from the Backup Partition of the Fixed Disk. This condition is shown in this example output of the rept-stat-db command.

    rlghncxa03w 09-03-01 16:07:48 GMT  EAGLE5 40.1.0
    DATABASE STATUS: >> NOT OK <<
            TDM 1114 ( STDBY)                 TDM 1116 ( ACTV )
             C  LEVEL     TIME LAST BACKUP     C  LEVEL     TIME LAST BACKUP
             - -------- ---------------------  - -------- ---------------------
    FD BKUP  Y       35 09-02-01 10:19:18 GMT  Y       35 09-02-01 10:19:18 GMT
    FD CRNT  Y       35 DIFF LEVEL             N       68 INCOHERENT
             MDAL 1117
             - --------
    RD BKUP  -    -         -        -
    

    If the E5-MASP is being used, this is an example of the rept-stat-db output.

    rlghncxa03w 09-03-01 16:07:48 GMT  EAGLE5 40.1.0
    DATABASE STATUS: >> NOT OK <<
            TDM 1114 ( STDBY)                 TDM 1116 ( ACTV )
            C   LEVEL    TIME LAST BACKUP     C   LEVEL    TIME LAST BACKUP
            - -------- ---------------------- - -------- ----------------------
    FD BKUP  Y       35 09-02-01 10:19:18 GMT  Y       35 09-02-01 10:19:18 GMT
    FD CRNT  Y       35 DIFF LEVEL             N       68 INCOHERENT
            MCAP 1113                         MCAP 1115
            - --------                        - --------
    RD BKUP Y       36 09-02-01 09:27:17 GMT  Y       36 09-02-01 09:27:17 GMT
    USB BKP -    -         -        -         Y        3 09-02-01 01:11:22 GMT
    
  • If the database on the removable cartridge is coherent and the current partition of the both fixed disks are not coherent, use the chg-db:action=restore:src=remove command. For more information, refer to Restoring the Database from the Removable Media. This condition is shown in this example output of the rept-stat-db command.

    rlghncxa03w 09-03-01 16:07:48 GMT  EAGLE5 40.1.0
    DATABASE STATUS: >> NOT OK <<
            TDM 1114 ( STDBY)                 TDM 1116 ( ACTV )
             C  LEVEL     TIME LAST BACKUP     C  LEVEL     TIME LAST BACKUP
             - -------- ---------------------  - -------- ---------------------
    FD BKUP  Y       35 009-02-01 10:19:18 GMT  Y       35 09-02-01 10:19:18 GMT
    FD CRNT  Y      106 DIFF LEVEL             N       93 INCOHERENT
             MDAL 1117
             - --------
    RD BKUP  Y      106 09-01-31 14:29:03 GMT
    

    If the E5-MASP is being used, this is an example of the rept-stat-db output.

    rlghncxa03w 09-03-01 16:07:48 GMT  EAGLE5 40.1.0
    DATABASE STATUS: >> NOT OK <<
            TDM 1114 ( STDBY)                 TDM 1116 ( ACTV )
            C   LEVEL    TIME LAST BACKUP     C   LEVEL    TIME LAST BACKUP
            - -------- ---------------------- - -------- ----------------------
    FD BKUP  Y       35 09-02-01 10:19:18 GMT  Y       35 09-02-01 10:19:18 GMT
    FD CRNT  Y      106 DIFF LEVEL             N       93 INCOHERENT
            MCAP 1113                         MCAP 1115
            - --------                        - --------
    RD BKUP Y      106 09-01-31 14:29:03 GMT  Y      106 09-01-31 14:29:03 GMT
    USB BKP -    -         -        -         Y        3 09-01-15 01:11:22 GMT
    
  • If the backup and current partitions on the active fixed disks are coherent and the backup and current partitions on the standby fixed disks are not coherent, use the chg-db:action=repair command. For more information, refer to Repairing the Database. This condition is shown in this example output of the rept-stat-db command.

    rlghncxa03w 09-03-01 16:07:48 GMT  EAGLE5 40.1.0
    DATABASE STATUS: >> NOT OK <<
            TDM 1114 ( STDBY)                 TDM 1116 ( ACTV )
             C  LEVEL     TIME LAST BACKUP     C  LEVEL     TIME LAST BACKUP
             - -------- ---------------------  - -------- ---------------------
    FD BKUP  N       35 INCOHERENT             Y       55 DIFF LEVEL           
    FD CRNT  N      106 INCOHERENT             Y       55 DIFF LEVEL           
             MDAL 1117
             - --------
    RD BKUP  -    -         -        -
    

    If the E5-MASP is being used, this is an example of the rept-stat-db output.

    rlghncxa03w 09-03-01 16:07:48 GMT  EAGLE5 40.1.0
    DATABASE STATUS: >> NOT OK <<
            TDM 1114 ( STDBY)                 TDM 1116 ( ACTV )
            C   LEVEL    TIME LAST BACKUP     C   LEVEL    TIME LAST BACKUP
            - -------- ---------------------- - -------- ----------------------
    FD BKUP  N       35 INCOHERENT             Y       55 DIFF LEVEL           
    FD CRNT  N      106 INCOHERENT             Y       55 DIFF LEVEL 
            MCAP 1113                         MCAP 1115
            - --------                        - --------
    RD BKUP Y      106 09-01-31 14:29:03 GMT  Y      106 09-01-31 14:29:03 GMT
    USB BKP -    -         -        -         Y        3 09-01-15 01:11:22 GMT
    

If, after executing the appropriate change database command, the database is still not coherent, contact the Customer Care Center. Refer to My Oracle Support (MOS) for the contact information.