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 Database Restoration : Point-in-Time Restorations

Point-in-Time Restorations

Another restoration method is "point-in-time," where binary logs can be replayed from a specific start point to a specific end point in time.

For example, after examining the contents of a binary log, it was discovered that an erroneous operation that resulted in dropping several tables occurred immediately following log entry # 6817916.

Therefore, after restoring the database from the full dump occurring the day before, and before restarting all the STA services, you can replay the most recent binary log from its initial log entry number "176" through entry number "6817916" with the commands shown in this procedure.

▼

Restore from a Range of Log Numbers
1.
Make sure all the STA processes are shut down and only the MySQL server is running:
 
# STA stop
# service mysql start
2.
As the MySQL root user, extract the valid operations:
 
# mysqlbinlog --start-position=176 --stop-position=6817916
/var/log/tbi/db/stadb-bin.000007 > ./recover.sql
3.
Apply them to the database:
 
# mysql -uroot -p -e 'source ./recover.sql'
Password:
4.
As the Linux system root user, restart the STA application and STA Services Daemon:
 
# STA start

For more information on point-in-time or incremental recovery operations refer to the MySQL Manual:

http://dev.mysql.com/doc/refman/5.5/en/point-in-time-recovery.html

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