A script enabled browser is required for this page to function properly.
Skip to main content
StorageTek Tape Analytics Administration Reference Guide, Version 1.0.2
E28379-03
Table of Contents Previous Next Index


Database Services Administration : STA Backup Service

STA Backup Service

The following topics are discussed here:

•
“Overview”
•
“Full Backup Process”
•
“Display the Backup Service Preference Settings”
•
“Clear Preference Settings”
•
“Verify Files Have Been Sent to the Target Server”
•
“Verify a Local Copy of the Backup Files Appears on the Server”
•
“Reset the STA Backup Service Password”

Overview

The STA Backup Service is one of several services running within the STA Services Daemon. The STA Backup Service performs automatic full and incremental backups of the STA database and key configuration directories, writing these files to a specified location on the server on which STA is installed. They can also be written in compressed form to a remote server, if you have configured one.

Note – Oracle recommends that you configure a remote backup server.

For a list of procedures required to configure the STA Backup service, see the “Configuring STA Services” chapter within the StorageTek Tape Analytics Configuration Guide.

The STA Backup Service within the STA Services daemon can be reconfigured outside of the STA application using the STA Backup Services administration utility, staservadm.

Before proceeding, check to ensure the STA Services Daemon is running. See “Check the Status of the STA Services Daemon”.

Full Backup Process

After it is configured, the STA Backup service performs the following process once every 24 hours:

1.
Initiates a high-speed dump (also referred to as a “hot backup”) of the following types of files:
•
MySQL database dump file
•
MySQL binary log files
•
STA Services daemon and STA WebLogic configuration files
•
STA Services daemon and STA Backup service administration logs
2.
Transfers the dump file to the designated backup host
3.
Deletes the previous day’s full dump file and associated incremental dump files from the STA server
4.
Writes a copy of the current day’s dump file to the following directory on the STA server: /dbdata/mysql/backups

Configuring the Backup Service

You configure the STA Backup service with the STA Backup Service Administration Utility, staservadm. See the StorageTek Tape Analytics Configuration Guide for information about using this utility to configure the STA Backup service, and for a list of preference settings you can use with the utility.

Display the Backup Service Preference Settings

Enter the following command to display the status of the current preference settings:

staservadm -Q

If the Configured field says “no,” then the Backup Service is running in an “idle” mode and is not performing any backups. You will need to supply the proper configuration settings.

See the StorageTek Tape Analytics Configuration Guide for instructions on entering settings. 

# staservadm -Q
Contacting daemon...connected.
Querying Preferences.
Current STA Backup Service Settings:
   Configured            [yes]
   File Transfer      -X [SCP]
   Full Backup        -T [02:22]
   Sleep Interval     -i [30 sec]
   Backup Hostname    -s [stabackups.mycompany.com]
   Backup Username    -u [root]
   Backup Password    -p [*******]
   Backup Directory   -d [/backups/tbivb01]
   Database Username  -U [stadba]
   Database Password  -P [********]
 =======================================

Clear Preference Settings

Enter the following command to clear the current preference settings:

staservadm -C

Notice that the Backup service is no longer configured and will return to the “idle” state when you do this. You must now provide new settings.

See the StorageTek Tape Analytics Configuration Guide for instructions on entering settings.

# staservadm -C
Contacting daemon...connected.
Clearing Preferences.
Done.
 Current STA Backup Service Settings:
   Configured            [no]
   File Transfer      -X [SCP]
   Full Backup        -T [00:00]
   Sleep Interval     -i [300 sec]
   Backup Hostname    -s []
   Backup Username    -u []
   Backup Password    -p []
   Backup Directory   -d []
   Database Username  -U []
   Database Password  -P [] =======================================

▼

Verify Files Have Been Sent to the Target Server

To verify that files have been sent successfully:

•
Check the logs on the server.
•
Log on to the target backup server and list the directory contents of the directory you specified when you configured the backup service.

Note – For Backup Service configuration information, see the “Configuring STA Services” chapter within the StorageTek Tape Analytics Configuration Guide.

Check the Server Logs

The staservd.log.0 log file registers the activities of the Backup services configuration utility ServerAdm.

1.
Change the working directory to the STA backup log directory.
 
# cd /var/log/tbi/db/backups
2.
Search the staservd.log.0 log file for the string “INFO: done. Database dump completed.” 
# grep "INFO: done. Database dump completed" staservd.log.0
 
INFO: done. Database dump completed, file located at /dbdata/mysql/backups/2011304.stafullbackup.sql
 
INFO: done. Database dump completed, file located at /dbdata/mysql/backups/2011304.stafullbackup.sql
 
INFO: done. Database dump completed, file located at /dbdata/mysql/backups/2011305.stafullbackup.sql
 
INFO: done. Database dump completed, file located at /dbdata/mysql/backups/2011306.stafullbackup.sql

Check the Target Backup Server

3.
Log on to the target backup server with your backup user id. In this example, the backup username is “stabck” and the backup password is “bckpwd1.”
 
# ssh stabck@stabackups.mycompany.com
 
Password: bckpwd1
 
Last login: Wed Nov  1…
4.
List the files. In this example, the directory /backups/tbivb01 has previously been set up to receive the backup files from the server “tbivb01.”
 
# ls -1 /backups/tbivb01
0.stadb-bin.000023.gz
0.stadb-bin.000024.gz
0.stadb-bin.000026.gz
0.stadb-bin.000027.gz
2011306.stadb-bin.000023.gz
2011306.conf.zip.gz
2011306.fmwconfig.zip.gz
2011306.stadb-bin.000025.gz
2011306.stadb-bin.000026.gz
2011306.stafullbackup.sql.gz

▼

Verify a Local Copy of the Backup Files Appears on the Server

Verify that a copy of the most recent backup files have been saved locally on the server on which STA is installed.

1.
List the files in the /dbdata/mysql/backups directory.
 
# ls -1 /dbdata/mysql/backups
2011303.conf.zip
2011306.conf.zip
2011306.fmwconfig.zip
2011306.stafullbackup.sql

Reset the STA Backup Service Password

See “Password Administration”.

Table of Contents Previous Next Index Link to documentation
Copyright © 2012 Oracle and/or its affiliates. All rights reserved. Legal Notices