Automating Oracle database backups

A fully automated backup uses the RMAN backup script to fully automate online backups of Oracle databases.

Synchronous and asynchronous offloaded backups are different. Synchronous means that the backup on the backup host starts as soon as a snapshot is started. In this case, the offload agent, tsm4acs, is already started as a daemon by the init process. Asynchronous means that offloaded backups are triggered manually or triggered by another scheduler by starting the fcmcli -f tape_backup command. This type of backup is useful if the backup must be delayed until the required resources are available. When configure the product on the production server, you specify when to run the offloaded backups.

Table 1. Files used during a fully automated backup
File name Description Default Location
serverscript.smp.oracle Sample server script /usr/tivoli/tsm/client/tdphdw/oracle/bin
orbackup User server script /usr/tivoli/tsm/server/bin
profile IBM® Storage Protect Snapshot profile ACS_DIR/profile
orcsetup User profile /usr/tivoli/tsm/client/tdphdw/oracle/bin