IBM Tivoli Storage FlashCopy Manager for UNIX and Linux, Version 4.1

Backing up Oracle databases

Tivoli® Storage FlashCopy® Manager integrates with multiple components when you back up an Oracle database.

The following table summarizes the commands that are associated with backing up an Oracle database.
Table 1. Summary of Backup Commands for Oracle
Snapshot backup (disk only) Back up to Tivoli Storage Manager
From production database (tape only) Integrated with snapshot From existing snapshot
acsora -f backup RMAN by using Data Protection for Oracle

acsora -f backup

1

fcmcli -f tape_backup

2
Note:
  1. The Tivoli Storage FlashCopy Manager profile parameter TSM_BACKUP is set to one of the following options: YES, MANDATE, or LATEST, and the offload agent (tsm4acs) is running in daemon mode on the production server.
  2. The profile parameter TSM_BACKUP is set to one of the following options: YES, MANDATE, or LATEST, and the offload agent is not running in daemon mode.

You must use the Oracle instance owner ID and go to the INSTANCE_DIR directory before you issue any backup commands. Tivoli Storage FlashCopy Manager backs up the database control file and the database profile on the production server to the Tivoli Storage FlashCopy Manager repository. These files are required by Tivoli Storage FlashCopy Manager on the backup server to start the database instance and to perform the offloaded backup to the Tivoli Storage Manager server. Furthermore, the database control file can be optionally restored during a FlashCopy restore (profile parameter DATABASE_CONTROL_FILE_RESTORE).

By default, the Tivoli Storage FlashCopy Manager software does not back up the transaction logs of the Oracle database. The database administrator is responsible for backing up the Oracle database transaction logs. After every full database online backup, back up the transaction logs to the Tivoli Storage Manager server.

The same commands can be used to back up Oracle databases that use Oracle Automatic Storage Management (ASM) and Oracle Real Application Clusters (RAC) based on Oracle ASM. An Oracle recovery database is required for Tivoli Storage FlashCopy Manager snapshot backups. This recovery database is a requirement even if a disk only backup is requested.



Feedback