Stop auxiliary database proxies
|
|
|
1 |
Stop the database proxy on each auxiliary database station.
Note: In a geo-redundant auxiliary database, you must stop the proxy on the standby auxiliary database stations first.
-
Log in as the root user on the station.
-
Enter the following:
# systemctl stop nspos-auxdbproxy.service ↵
-
Verify that the proxy is stopped; enter the following:
# systemctl status nspos-auxdbproxy ↵
|
2 |
If the NSP deployment does not include the NFM-P, go to
Step 5.
|
Stop NFM-P main and auxiliary servers
|
|
|
3 |
If the NFM-P system is redundant, stop the standby main server and the associated auxiliary servers.
-
Perform
How do I stop an auxiliary server? to stop each Preferred and Reserved auxiliary server of the standby main server.
-
Log in to the standby main server as the nsp user.
-
Open a console window.
-
Enter the following:
bash$ cd /opt/nsp/nfmp/server/nms/bin ↵
-
Enter the following to stop the main server:
bash$ ./nmsserver.bash stop ↵
-
Enter the following to display the main server status:
bash$ ./nmsserver.bash appserver_status ↵
The server status is displayed; the server is fully stopped if the status is the following:
Application Server is stopped
If the server is not fully stopped, wait five minutes and then repeat this step. Do not perform the next step until the server is fully stopped.
|
4 |
Stop the standalone or primary main server and the associated auxiliary servers.
-
Perform
How do I stop an auxiliary server? to stop each Preferred and Reserved auxiliary server of the primary or standalone main server.
-
Log in to the main server station as the nsp user.
-
Open a console window.
-
Enter the following:
bash$ cd /opt/nsp/nfmp/server/nms/bin ↵
-
Enter the following to stop the main server:
bash$ ./nmsserver.bash stop ↵
-
Enter the following to display the main server status:
bash$ ./nmsserver.bash appserver_status ↵
The server status is displayed; the server is fully stopped if the status is the following:
Application Server is stopped
If the server is not fully stopped, wait five minutes and then repeat this step. Do not perform the next step until the server is fully stopped.
|
Prepare auxiliary database stations
|
|
|
5 |
If the auxiliary database is geo-redundant, you must identify which auxiliary database cluster is currently primary.
If you do not know which cluster is currently the primary cluster, perform
How do I check the auxiliary database status?.
|
6 |
Stop the standalone or primary auxiliary database.
Note: In a geo-redundant auxiliary database, you must ensure that each auxiliary database cluster is stopped before you attempt to perform a restore operation.
-
Log in as the root user on any station in the standalone or primary auxiliary database cluster.
-
Enter the following:
# /opt/nsp/nfmp/auxdb/install/bin/auxdbAdmin.sh stop ↵
You are prompted to enter the database user password.
-
Enter the password. The auxiliary database stops.
|
7 |
If the backup files to restore are not in the original backup location on each auxiliary database station, perform the following steps.
-
If you know the original backup location, go to substep
6.
-
Open the following file for viewing:
path/AuxDbBackUp/samAuxDbBackup_restore.conf
where path is the current location of the backup file set
-
Locate the [Mapping] section, which contains one line like the following for each auxiliary server station:
v_name_node0001 = IP_address:path/AuxDbBackUp
The path is the original backup location.
-
Record the original backup location.
-
Close the samAuxDbBackup_restore.conf file.
-
Copy the AuxDbBackUp directory contents from the current backup location to the AuxDbBackUp directory in the original backup location on each auxiliary database station.
-
As the root user, enter the following command on each auxiliary database station:
# chown -R samauxdb path ↵
where path is the absolute path of the original backup location
|
8 |
If the backup is being restored on any stations that have different internal IP addresses, perform the following steps on each auxiliary database station.
-
Open the following file using a plain-text editor such as vi:
path/AuxDbBackUp/samAuxDbBackup_restore.conf
where path is the location of the backup file set
-
Add the following internal mapping section to the end of the file; the example below is for an auxiliary database of three stations:
[NodeMapping]
v_name_node0001 = IP_address_1
v_name_node0002 = IP_address_2
v_name_node0003 = IP_address_3
where
v_name_node000n is the station name shown in the [Mapping] section of the file
IP_address_n is the new internal IP address of the station
-
Save and close the samAuxDbBackup_restore.conf file.
|
Perform auxiliary database restore operation
|
|
|
9 |
Perform one of the following on one auxiliary database station.
-
Restore the latest backup; enter the following:
# /opt/nsp/nfmp/auxdb/install/bin/auxdbAdmin.sh restore path/AuxDbBackUp/samAuxDbBackup_restore.conf ↵
where path is the original backup directory
-
Restore a backup other than the latest; perform the following steps.
-
Enter the following:
# ls path/AuxDbBackUp/.auxdb_backup_history ↵
where path is the original backup directory
The directory contents are listed; the following files are present for each previous backup:
where
datestamp is the backup date, in the form YYYYMMDD
timestamp is the backup time, in the form hhmmss
ID is a unique numerical identifier
-
Based on the date and time of the backup that you want to restore, identify and record the ID, datestamp, and timestamp values.
-
Enter the following:
# /opt/nsp/nfmp/auxdb/install/bin/auxdbAdmin.sh restore path/AuxDbBackUp/.auxdb_backup_history/AuxDbBackUpID_datestamp_timestamp_samAuxDbBackup_restore.conf ↵
where
path is the original backup directory
ID is the recorded ID value
datestamp is the recorded datestamp value
timestamp is the recorded timestamp value
The restore operation begins. The following messages and progress indicators are displayed:
Starting full restore of database db_name.
Participating nodes: node_1, node_2, ... node_n.
Restoring from restore point: AuxDbBackUpID_datestamp_timestamp
Determining what data to restore from backup.
[==============================================] 100%
Approximate bytes to copy: nnnnnnnn of nnnnnnnnn total.
Syncing data from backup to cluster nodes.
When the restore is complete, the second progress indicator reaches 100%, and the following message is displayed:
[==============================================] 100%
Restoring catalog. Restore complete!
|
Restore database user passwords
|
|
|
10 |
If a database user password has changed since the creation of the database backup, the NSP components cannot authenticate with the restored auxiliary database.
In such a scenario, you must perform the following steps to update each affected database user password to the value that the NSP components recognize.
-
Enter the following on the current auxiliary database station to connect to the auxiliary database:
# vsql ↵
You are prompted for credentials.
-
Enter the following:
-
Enter the following once for each user whose password has changed since the backup creation:
ALTER USER user IDENTIFIED BY 'password';
where
user is the database user name
password is the newer password recognized by the NSP
-
Verify the success of the password change by:
|
Start auxiliary database proxies
|
|
|
11 |
Start the auxiliary database proxy on each auxiliary database station.
Note: In a geo-redundant auxiliary database, you must start the proxy on the stations of the restored auxiliary database cluster first.
-
Log in as the root user on the station.
-
Enter the following:
# systemctl start nspos-auxdbproxy.service ↵
|
12 |
If the NSP deployment does not include the NFM-P, go to
Step 15.
|
Start NFM-P servers
|
|
|
13 |
Start the standalone or primary main server and associated auxiliary servers.
-
Log in to the main server station as the nsp user.
-
Open a console window.
-
Enter the following:
bash$ cd /opt/nsp/nfmp/server/nms/bin ↵
-
Enter the following to start the main server:
bash$ ./nmsserver.bash start ↵
-
Enter the following:
bash$ ./nmsserver.bash appserver_status ↵
The server status is displayed; the server is fully initialized if the status is the following:
Application Server process is running. See nms_status for more detail.
If the server is not fully initialized, wait five minutes and then repeat this step. Do not perform the next step until the server is fully initialized.
-
Perform
How do I start an auxiliary server? to start each Preferred and Reserved auxiliary server of the primary or standalone main server.
|
14 |
If the NFM-P system is redundant, start the standby main server and associated auxiliary servers.
-
Log in to the standby main server as the nsp user.
-
Open a console window.
-
Enter the following:
bash$ cd /opt/nsp/nfmp/server/nms/bin ↵
-
Enter the following to start the main server:
bash$ ./nmsserver.bash start ↵
-
Enter the following to display the main server status:
bash$ ./nmsserver.bash appserver_status ↵
The server status is displayed; the server is fully initialized if the status is the following:
Application Server process is running. See nms_status for more detail.
If the server is not fully initialized, wait five minutes and then repeat this step. Do not perform the next step until the server is fully initialized.
-
Perform
How do I start an auxiliary server? to start each Preferred and Reserved auxiliary server of the standby main server.
|
15 |
Close the open console windows.
End of steps |