Restore Databases

Use this task if you need to restore the application and reporting databases on your SDM system or cluster.

Login to the server as the nncentral user.
Change to the bin directory. For example:
```
cd /home/nncentral/AcmePacket/NNC8x/bin
```
Execute the shutdownnnc.sh script. By default, the shutdownnnc.sh script detects whether the existing installation is a standalone or clustered system and prompts you with the option to shut down the entire cluster if no flag options are provided.
Note:
However, You can script an option ahead of time by adding -local for single nodes and -cluster to shutdown an entire cluster.
```
./shutdownnnc.sh
Shutdown back-end server
Do you wish to shut down the entire cluster (Yes/No)? Yes
```
If you want to perform a backup of the application or reporting databases on the running SDM server (hot backup), see the Backup the Database on a Running Server section for more information, and skip to step 5.
If you want to perform a backup of the application or reporting databases on a shut down server (cold backup) see the Backup the Database on a Shutdown Server for more information, and skip to step 5.
If you need to restore the application database only (you are not using the reporting databases) on your SDM system, enter the restoredb.sh script followed by the directory in which the backup application database is stored. For example:
```
./restoredb.sh -f/home/nncentral/AcmePacket/NNC8x/bin/NNC8x_Backup_2017_04_19.tar.gz
```
If you need to restore the application database and the reporting databases on your SDM system, enter the restoredb.sh script followed by the directory in which the backup application database is stored, and specify the Oracle reporting database password and OCSDMDW reporting database password:
```
./restoredb.sh -f/home/nncentral/AcmePacket/NNC8x/bin/NNC8x_Backup_2017_04_19.tar.gz -z my_report_db_password -y my_ocsdmdw_db_password
```
If you are using Oracle Communications Report Manager and have shut down the Oracle BI Publisher database instance and Oracle Report Manager database instance (OCSDMDW), you must restart them. See the Report Manager Administrator Operations chapter in the Oracle Communications Report Manager Installation Guide for more information about starting these database instances.
Execute the startnnc.sh script. For example:
```
./startnnc.sh
```
The console displays the number of services started. After all services have started, the system is ready for use. Do not attempt to log in until the console has indicated that the web servers are up.

Next Steps

Select Tools > Health Monitor and view the Heartbeat Summary table to check SDM cluster member node processes.
Begin using SDM. Use your web browser to navigate to the server login page by entering the host name or IP address, and port number in the web browser navigation bar. For example:
```
http://example.com:8080
```
In the login page, enter the administrator login name and password that you configured in the Configure User Account Passwords section.
After the server starts (after the restoration of its databases), it attempts to synchronize all plugins installed on the local file system again. Select Tools > Plugin Management in the SDM GUI to ensure that all plugins are working properly in the Element Manager Plugins table.