How do I recreate an auxiliary database?
Purpose
If an NSP auxiliary database is not functioning and cannot return to operational status, you may need to recreate the database. Depending on the severity of the failure, however, Nokia support may be able to repair the database.
Perform this procedure only if all attempts to repair the auxiliary database fail, and Nokia support directs you to recreate the database.
Steps
1 |
If possible, back up the auxiliary database to preserve it for potential data recovery. If data recovery is not required, you can skip this step. Note: The auxiliary database must be running in order for a backup to be successful. If the auxiliary database cannot be started, you cannot create a database backup. |
2 |
In order to back up an auxiliary database, all members of the local auxiliary database cluster must be operational and available, or the backup fails. Perform How do I check the auxiliary database status? to verify that each local cluster member is operational. |
3 |
Perform the following steps on each auxiliary database station to collect the auxiliary database log files. Note: You cannot specify /tmp, or any directory below /tmp, as the output directory.
|
4 |
On one auxiliary database station, open the /opt/nsp/nfmp/auxdb/install/config/install.config file using a plain-text editor such as vi. |
5 |
Ensure that the internal and external IP addresses in the following lines are correctly assigned to the auxiliary database stations: hosts=internal_IP1,internal_IP2...internal_IPn export_hosts=internal_IP1[export_IP1],internal_IP2[export_IP2]...internal_IPn[export_IPn] |
6 |
If you intend to reuse existing auxiliary database stations, uninstall the auxiliary database as described in the NSP Installation and Upgrade Guide. |
7 |
Install the auxiliary database as described in the NSP Installation and Upgrade Guide. Note: If you are performing this procedure to recover from a failed upgrade, you must use the new auxiliary database installation files, and not the installation files from before the upgrade. |
8 |
If the NSP deployment does not include the NFM-P, go to Step 14. |
9 |
When the auxiliary database is fully initialized, perform the following steps on each NFM-P main server station to start the main server, if the server is not started. Note: In a redundant system, you must start the primary main server first.
The main server detects the auxiliary database reinstallation, raises a Critical alarm against the auxiliary database, and begins recreating the auxiliary database schema. Note: If the main server fails to recreate the schema, the server retries periodically until all schema elements are created. When the schema recreation is complete, the reinstallation alarm clears, and the NFM-P raises a Major alarm that you must clear manually. |
10 |
If the auxiliary database includes custom data tables, perform the following steps to recreate and repopulate the tables.
|
11 |
If you use the Analytics dynamic inventory reporting function, you must recreate the custom inventory tables and dynamic Analytics managed-object definitions.
|
12 |
If you have created dynamic aggregations, recreate the aggregations. Note: Any previous aggregation data is lost during the auxiliary database schema recreation earlier in the procedure.
|
13 |
If you use periodic accounting tables, enter the following on the main server station to create the tables: Note: Any previous periodic accounting data is lost during the auxiliary database schema recreation earlier in the procedure. bash$ ./nmsserver.bash accountingPeriodic create per_acc_XML_file ↵ where per_acc_XML_file is the absolute path and name of the saved XML file that defines the periodic accounting configuration |
14 |
Close the open console windows. End of steps |