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
(Windows only)
Based on the existing databases, change the following fields in the OracleXX_PreConsistencyPoint.bat and OracleXX_PostConsistencyPoint.bat files:
Change the system user name in the field ORACLE_USR
at the beginning of the file.
Ensure that the Oracle user name you use has Alter
system and Alter table spaces privileges.
Change the system user password in the field ORACLE_PWD
at the beginning of the file.
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.
(Linux only) Based
on the existing databases, change the following fields in the Oracle10g_PreConsistencyPoint.sh and Oracle10g_PostConsistencyPoint.sh files:
Change the system user name in the field ORACLE_USR
at the beginning of the file.
Ensure that the Oracle user name you use has Alter
system and Alter table spaces privileges.
Change the system user password in the field OraclePass
at the beginning of the file.
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.
Define a policy by using FastBack Manager. The policy
schedules the backup of the volumes where Oracle databases are on.
Go to the Pre or Post Processes tab
and complete the following steps:
Select Pre Consistency-Point.
For the script, type OracleXX_PreConsistencyPoint.bat.
Select Pre Snapshot.
For the script, type OracleXX_PostConsistencyPoint.bat.
Select Post Snapshot. Type the
name of the script you wrote to delete all archived redo logs of the
backed up database.