Using the Command Line Interface › ca_backup - Backup Manager Command › ca_backup - Database Options › ca_backup - Oracle Database Options

ca_backup - Oracle Database Options

The ca_backup command includes the following Oracle database options:

[-oracle_sid <Oracle SID>]
[-oracle_offline] (for UNIX Oracle agent only)
[-oracle_purgelog] (for UNIX Oracle agent only)
[-oracle_timefinder] (for UNIX Oracle agent only)

Note: The ca_backup database options are described in a separate topic titled "Database Options" and can be viewed from the actual CLI by entering the following command: ca_backup allusage.

Note: When using the Arcserve Backup CLI (command line interface) to back up or restore an Oracle object with a DBCS (double-byte character set) or a MBCS (multi-byte character set) in the name, you must ensure the Arcserve Backup server and the agent box have the same language setting.

-oracle_sid <Oracle SID>

Specifies the Oracle SID (system identifier) of the Oracle database to back up.

-oracle_offline

Specifies to back up the Oracle database in off-line mode (only supports full database backups).

-oracle_purgelog

Specifies to purge the log after it has been backed up.

-oracle_timefinder

Specifies that you want to use the Symmetrix Timefinder technology option for database backups. This option creates a temporary mirror image of the database, which the agent then backs up.

Examples:

The following are examples of syntax for the ca_backup ORACLE database command:

• Use the following command to back up a single tablespace tbs1:

  ca_backup -source [<hostname>[<hostIP>][<hosttype>]] -database ORACLE <instance name> "tbs1" [dbase options]
  

• Use the following command to back up multiple tablespaces tbs1, tbs2, and tbs3:

  ca_backup -source [<hostname>[<hostIP>][<hosttype>]] -database ORACLE <instance name> "tbs1" "tbs2" "tbs3" [dbase options]
  

• Use the following command to back up a single file of a tablespace:

  ca_backup -source [<hostname> [<hostIP>][<hosttype>]]unix -database ORACLE <instance name> -table SYSAUX "|u01|app|oracle|product|10.1.0|db_1|oradata|dborcl|sysaux01.dbf" -dbusername system -dbpassword manager -username root -password caworld
  

• Use the following command to back up a control file:

  ca_backup -source [<hostname>[<hostIP>][<hosttype>]] -database ORACLE <instance name> "CONTROL FILE" [dbase options]
  

• Use the following command to back up an archive log:

  ca_backup -source [<hostname>[<hostIP>][<hosttype>]] -database ORACLE <instance name> "ARCHIVE LOG" [dbase options]
  

• Use the following command to back up a control file and an archive log:

  ca_backup -source [<hostname>[<hostIP>][<hosttype>]] -database ORACLE <instance name> "CONTROL FILE" "ARCHIVE LOG” -dbusername system -dbpassword system -username root -password caworld
  

• Use the following command to back up full database. Assume the database has 5 tablespaces (tbs1, tbs2, tbs3, tbs4, and tbs5) to back up the full database and you want to back up all tablespaces, the archive log, and the control file:

  ca_backup -source [<hostname>[<hostIP>][<hosttype>]] -database ORACLE <instance name> "tbs1" "tbs2" "tbs3" "tbs4" "tbs5" "CONTROL FILE" "ARCHIVE LOG” [dbase options]
  

More information:

ca_backup - Database Options

ca_backup - Examples