Oracle® Communications EAGLE Database Administration - System Management User's Guide Release 46.6 E93319 Revision 1 |
|
Previous |
Next |
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:
rept-stat-db
command. rept-stat-db
command shows the current operational status of the EAGLE’s distributed databases. 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.