The STA Restore procedure consists of loading the most recent full dump and then replaying all the binary logs immediately following that dump.
There are distinct sets of backup files on the backup server directory. Assuming the directory on your backup server is located at /data/stabackups, when listed they will look like something like this:
# cd /data/stabackups # ls -1 2011221.conf.zip.gz 2011221.fmwconfig.zip.gz 2011221.stadb-bin.000024.gz 2011221.stafullbackup.sql.gz 2011222.conf.zip.gz 2011222.fmwconfig.zip.gz 2011222.stadb-bin.000024.gz 2011222.stafullbackup.sql.gz 2011223.conf.zip.gz 2011223.fmwconfig.zip.gz 2011223.stadb-bin.000021.gz 2011223.stadb-bin.000022.gz 2011223.stadb-bin.000023.gz 2011223.stadb-bin.000024.gz 2011223.stafullbackup.sql.gz
|
The first set of numbers is the year, and second is the day of the year that the files apply to. If you took the full backup on August 11, 2011, the 223rd day of the year, then the date tag for the entire set is "2011223". All the binary logs having the same date tag will be replayed into the database after the full dump is loaded.
The following administration tasks are discussed here:
Oracle recommends copying everything to the /tmp directory. For example, assuming that STA is installed on the server sta.server.com, and you are currently logged onto the backup server.
# cd /tmp
# gunzip 2011223.*.gz
|
# STA stop
# service mysql start
|
The zip files have been created with the full directory paths to allow you to restore and/or overwrite existing files. The zip command allows you to re-crown the root of the restore path with the -d option. Additional options allow more control, such as selective replace.
For the purposes of a clean restore you want to completely replace the existing configuration directory, however, you should backup the original first.
# cd $WLSHOME
# zip -vr fmwconfig.orig.zip fmwconfig
# rm -rf fmwconfig
# cd /tmp
# unzip -X -d/ 211223.fmwconf.zip
# cd $STAHOME/common
# zip -vr conf.orig.zip conf
# rm -rf conf
# cd /tmp
# unzip -X -d/ 211223.conf.zip
|
Where:
$WLSHOME = /Oracle/Middleware/user_projects/domains/TBI/config
$STAHOME = /Oracle/StorageTek_Tape_Analytics