ca_restore - Restore Manager Command › ca_restore - Database Options › ca_restore - Oracle Database Options

ca_restore - Oracle Database Options

The ca_restore command includes the following Oracle database options:

ca_restore 

[-oracle_controlfile] (for UNIX Oracle agent only) 
[-oracle_overwritelog] (for UNIX Oracle agent only) 
[-oracle_multistream] (for UNIX Oracle agent only)
[-oracle_recover] (for UNIX Oracle agent only) 

Note: The ca_restore 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_restore 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_controlfile

Specifies that the control file should be restored. (for UNIX Oracle agent only)

-oracle_overwritelog

Specifies to overwrite existing logs during the restore. (for UNIX Oracle agent only)

-oracle_multistream

Specifies to restore Oracle using multiple streams. (for UNIX Oracle agent only)

-oracle_recover

Specifies to take a restored copy of the datafile and apply to it any changes that were recorded in the database redo logs. To recover a whole database is to perform recovery on each of its datafiles. (for UNIX Oracle agent only)

Examples:

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

• Use the following command to restore a single tablespace (SYSAUX):

  ca_restore -source [<hostname> [<hostIP>]] "dbora7@instance\DIRECT_ONLINE\2007_07_16-06:31 [40]\SYSAUX" -dest [<hostname>] <-orglocation> -database ORACLE [dbase name] [dbase options]
  

  ca_restore -source [<hostname> [<hostIP>]] "dbora7@instance\OFFLINE\2007_07_17-08:20 [44]\SYSAUX" -dest [<hostname>] <-orglocation> -database ORACLE [dbase name] [dbase options]
  

• Use the following command to restore multiple tablespaces (SYSAUX and USERS):

  ca_restore -source [<hostname> [<hostIP>]] " dbora7@instance\DIRECT_ONLINE\2007_07_16-06:31 [40]\SYSAUX" " dbora7@instance\DIRECT_ONLINE\2007_07_16-06:31 [40]\USERS" -dest [<hostname>] <-orglocation> -database ORACLE [dbase name] [dbase options]
  

• Use the following command to restore a control file:

  ca_restore -source [<hostname> [<hostIP>]] " dbora7@instance\DIRECT_ONLINE\2007_07_16-06:30 [37]\CONTROL FILE" -dest [<hostname>] <-orglocation> -database ORACLE [dbase name] [dbase options]
  

• Use the following command to restore an archive log:

  ca_restore -source [<hostname>[<hostIP>]] " dbora7@instance\DIRECT_ONLINE\2007_07_16-06:30 [37]\ARCHIVE LOG" -dest [<hostname>] <-orglocation> -database ORACLE [dbase name] [dbase options]
  

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

  ca_restore -source [<hostname>[<hostIP>]] " dbora7@instance\DIRECT_ONLINE\2007_07_16-06:30 [37]\tbs1" " dbora7@instance\DIRECT_ONLINE\2007_07_16-06:30 [37]\tbs2" " dbora7@instance\DIRECT_ONLINE\2007_07_16-06:30 [37]\tbs3" " dbora7@instance\DIRECT_ONLINE\2007_07_16-06:30 [37]\tbs4" " dbora7@instance\DIRECT_ONLINE\2007_07_16-06:30 [37]\tbs5" " dbora7@instance\DIRECT_ONLINE\2007_07_16-06:30 [37]\ARCHIVE LOG" " dbora7@instance\DIRECT_ONLINE\2007_07_16-06:30 [37]\CONTROL FILE" -dest [<hostname>] <-orglocation> -database <dbase type> [dbase name] [dbase options]
  

More information:

ca_restore - Examples

ca_restore - Database Options