5.
Select a designated backup location.
database and restore it with the data in the backup files.
To recover the database files:
1. Ensure that a full backup set is stored locally on the server. File names can be found in the table on page 182. Make sure all files were created during the same backup run so they are synchronized.
2. Stop all “BoxTone” services on the application server.
3. Set your working directory to the directory which contains the recovery files:<%BoxTone InstallDirectory>\utilities\BT-DB-BR\recovery.
4. Run the following command to start the recovery process: imp_boxtone.bat <BACKUPLOCATION> BoxTone _DP_MD<DATE>.DMP BoxTone _DP_DATA_<DATE>.DMP <BoxTone ORACLE USER PASSWORD>
5. Where <BACKUPLOCATION> is replaced with the directory that contains the backed up data and <DATE> is replaced with the date contained within the backup files. For example:imp_BoxTone .bat E:\BoxTone Data BoxTone _DP_MD09_01_2008.DMPBoxTone _DP_DATA_09_01_2008.DMP BoxTone The recovery time may take up to three hours depending on the amount of data being restored. Upon completion, a success message will open.
6. Restart the BoxTone services.
2. Tune.exe is installed on Good MSM and can be found by navigating to the following location (in dual server configurations, it can be found on the Application Server) \BoxTone\utilities\tuning
3. Based on the Database server’s total RAM, choose from 8G_DB.ini, 16G_DB.ini, 32G_DB.ini,64G_ DB.ini, or 128G_DB.ini and edit as necessary.
!
Note: The tuning files contain the recommended base settings. Modifications to any parameter without consulting Good Support may result in an inoperative system. Please contact Good Support for additional assistance.4. Open a CMD window using the “Run as Administrator” option and CD to \BoxTone\utilities\tuning
5. Execute the following:
6. Tune.bat <config>.ini (where <config> is 8G_DB or 16G_DB, etc)
!
Note: Running Tune.exe will shut down all MSM application services, make the necessary configuration changes and then restart the MSM application services.7. Copy db.sql to a temporary location on the MSM Database server
8. Copy extendDBF.SQL to the \BoxTone\database directory on the Good MSM Database server. You may overwrite the existing file.
9. Right-Click on \BoxTone\Utilities\BTServices\BoxToneServices.exe and “Run as administrator”
10. Click the “Stop BoxTone Services” button
11. Login to the Good MSM database server using the service account
12. Open a CMD window using the “Run as administrator” option and CD to the temporary location containing db.sql
13. Enter the following commands: 1. SET ORACLE_SID=boxtone 2. Sqlplus /nolog 3. Connect / as sysdba 4. @db.sql; 5. Sqlplus /nolog 6. Connect / as sysdba 7. Startup; 8. Exit
14. From the same CMD window, change directory (CD) to the \BoxTone\database directory
15. Run ExtendDBF.bat
GetBTLogs is used to collect the log and config files for the major components of BoxTone.
To use GetBTLogs to collect log files:
1. Navigate to the \\boxtone\utilities\GetBTLogs directory
2. Run the GetBTLogs.exe as administrator
3. Select All Logs or Latest Logs
Note:If Latest Logs is selected, log files will only be collected for the number of days that you specify.
Note: If All Logs is selected, only 30 days worth of entries for the Application and System event logs will be collected (if so chosen)
4. Select whether you want to include Config Files
5. Select the components you would like to collect logs for
6. Supply an Output Location (or use the browse button)
Note The utility requires 5g of free disk space in the location you specify for the output
Note: If you select all logs for all days, 10g of free disk space will be required for the utility to run.
7. Select Auto FTP to have the created zip file automatically uploaded to the BoxTone FTP site Note: ZIP file must be under 500mb for this option to work. You must provide an Email address to use the Auto FTP option.
8. Select Get Logs
9. The log files will be collected to the location specified and compressed once complete Note: If 7zip does not exist in the expected location, the collected files will be left in the directory
!
!
!
!
2. Uncheck the Include Config Files checkbox
3. Select the checkboxes for the components that you want to clear the logs for
4. Click the Clear Logs button.
You will be warned that all logs for the specified module will be permanently deleted .You will also be instructed to stop services before proceeding. Once logs are cleared, you will be prompted to start ALL BoxTone and Oracle services.
BTCertificates is used to create keys and CSRs for APNs, USS, Enrollment, and Core. CSRs and keys are used to get signed certs from third party signing authorities or an internal signing authority. In addition the utility can be used to convert a PEM file to a P12 file as is needed for the APNs certificate.
To begin using the BT Certificates utility perform the following:
1. Navigate to the \BTCertificates directory
2. Run BTCertificates.exe as administrator
To create a CSR file perform the following:
3. Choose the radio button for the type of CSR you are looking to create (APNs, Enrollment, USS, or Core)
4. Fill out the appropriate fields
5. Enter a location to output the CSR
6. Click the Create button
To convert a PEM file to a P12 file perform the following:
1. Enter the location for the PEM file
2. Enter the location for the APNs Key file
3. Enter the password for the P12 file
4. Confirm the password for the P12 file
5. Click the Convert button.
Note: P12 files will be created in the same directory where the PEM file is located