FastBack Server setup

About this task

The following list provides instructions for implementing the schedule of consistent snapshots, by using scripts that are provided with Tivoli® Storage Manager FastBack and FastBack Manager:

Note: In the file names specified, XX stand for the Oracle version: 9i or 10g.

Procedure

  1. (Windows only) Based on the existing databases, change the following fields in the OracleXX_PreConsistencyPoint.bat and OracleXX_PostConsistencyPoint.bat files:
    1. Change the system user name in the field ORACLE_USR at the beginning of the file.
    2. Ensure that the Oracle user name you use has Alter system and Alter table spaces privileges.
    3. Change the system user password in the field ORACLE_PWD at the beginning of the file.
    4. Change the database path field ORACLE_DB according to your databases settings. For every Oracle database that you have, make sure that a section exists in OracleXX_PreConsistencyPoint.bat and OracleXX_PostConsistencyPoint.bat. For example, add lines to the script to implement the operation on additional databases.
  2. (Linux only) Based on the existing databases, change the following fields in the Oracle10g_PreConsistencyPoint.sh and Oracle10g_PostConsistencyPoint.sh files:
    1. Change the system user name in the field ORACLE_USR at the beginning of the file.
    2. Ensure that the Oracle user name you use has Alter system and Alter table spaces privileges.
    3. Change the system user password in the field OraclePass at the beginning of the file.
    4. Change the OracleDbNames array to list all databases to be backed up. For every Oracle database that you have, make sure that a unique array assignment exists. For example, add a second database with a line like OracleDbNames[2]="dbname" In addition, verify that a connection identifier with the same name as the database exists for each database.
  3. Define a policy by using FastBack Manager. The policy schedules the backup of the volumes where Oracle databases are on.
  4. Go to the Pre or Post Processes tab and complete the following steps:
    1. Select Pre Consistency-Point. For the script, type OracleXX_PreConsistencyPoint.bat.
    2. Select Pre Snapshot. For the script, type OracleXX_PostConsistencyPoint.bat.
    3. Select Post Snapshot. Type the name of the script you wrote to delete all archived redo logs of the backed up database.
    4. Click Apply.