Partially restore the STA database from a range of incremental backups. This restores the database from the last full dump and then applies just the incremental backups that fall within the start and end points specified.

1. On the STA server, open a terminal session. Log in as the Oracle user.
2. Stop all STA processes:

   $ STA stop all
   

3. Restart the MySQL server:

   $ STA start mysql
   

4. Extract the valid operations from the binary logs. For example:

   $ mysqlbinlog ––start–position=176 ––stop–position=6817916 /var/log/tbi/db/stadb–bin.000007 > ./recover.sql 
   Password:
   

   where:

   • --start-position is the first log entry you want to extract.

   • --stop-position is the last log entry you want to extract. In this example, entries 176 to 6817916 are extracted.

   • /var/log/tbi/db/stadb-bin.00007 is the binary log file you want to extract from.

   • ./recover.sql is the file you want to write the entries to.

5. Apply the selected operations to the database. For example:

   $ mysql –u root –p –e 'source ./recover.sql'
   Password:
   

   where:

   • -u root specifies the STA database root username.

   • -p indicates to prompt for the user password.

   • -e indicates to execute the following MySQL statement and then quit the mysql command. The statement must be enclosed in quotes.

     • 'source ./recover.sql'—Applies the entries in the specified file to the database.

6. Restart STA and all associated processes. See Restart the STA Application.