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

STA Database Restoration

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:

Copy Backup Files to the Server

1.

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.

# scp 2011223.* sta.server.com:/tmp/.
Password:
2.
# cd /tmp
# gunzip 2011223.*.gz

Restore the Configuration Directory Files

1.
# STA stop
# service mysql start
2.

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


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