Using the Command Line Interface › tapecopy - Tape Copy Tool Command › tapecopy - Database Query Options

tapecopy - Database Query Options

The database query options let you select source sessions based on specific attributes. When you specify a database option, the database is queried and all of the sessions that meet the search criteria become source sessions for tapecopy. One or more of these switches can be used to specify a complex query.

By default, the tapecopy operation copies all sessions that the query finds to one tape in the destination group. The tapecopy looks for a blank tape in the destination group and formats it with the tape name as mm/dd/yyyy-hh:mm.

The tapecopy command includes the following query options:

tapecopy  

[-qType <Backup Session Type>]
[-qMethod <Backup Session Method>]
[-qNode <Backup Session Node>]
[-qOnOrBefore <MM/DD/YYYY> [<hh:mm>]]
[-qOnOrAfter <MM/DD/YYYY> [<hh:mm>]]
[-qMID <Master Job Number>]
[-qJobNo <Job No Query>]
[-qMediaPool <Media Pool Name>]
[-qPreview (View Query Details)]
[-qIgnoreRep (Ignore Replication Flag)]
[-qExclude <Exclude List File Name>]
[-qPastTime <Number of Days>]
[-qCA_RHAType <Type of CA RHA Session>](Used only with -qType CA_RHA)

• -qType <Backup Session Type>

  Queries the CA ARCserve Backup database to include only selected type of sessions for copy.

  You can query multiple session types at the same time, by specifying the session types separated by comma.

  For example:

  tapecopy –d PGROUP0 –qType   SQL,WindowsNT
  

  Available session types include:

  NetWare, MSNetDrive, UNIX, BABDatabase, OracleLog, DBAGENT, SYBASE, LotusNotes, Informix, TAR, CPIO, UNIXImage, WindowsNT (Includes WinNT/2000/XP), Windows98 (Includes Win95/98/ME), NTSAP, UNIXSAP, ORACLE, ORACLE8, ORACLE9I, NTOracle, UNIXRAW, UNIXSYBASE, UNIXORACLERMAN. WINORACLERMAN, DRTAR, CA_RHA, DBAEXDB, DBAEXDBVSS, DBAEXSIS, SQL, ASDBSQL, SQLDR, ASDBSQLE, and SPA2007.

• -qMethod <Backup Session Method>

  Queries the CA ARCserve Backup database to include only those sessions that were backed up using the specified backup method.

  Available session methods include:

  FULL, DIFF, and INCR.

  (Where FULL = full backup, DIFF = differential backup, and INCR = incremental backup

• -qNode <Backup Session Node>

  Queries the CA ARCserve Backup database to include sessions backed up from the specified node only.

• -qOnOrBefore <MM/DD/YYYY> [<hh:mm>]

  Queries the CA ARCserve Backup database to include sessions that were backed up on or before the specified date and time. It is optional to specify the time. Date and time should be separated by a space.

• -qOnOrAfter <MM/DD/YYYY> [<hh:mm>]

  Queries the CA ARCserve Backup database to include sessions that were backed up on or after the specified date and time. It is optional to specify the time. Date and time should be separated by a space.

• -qMID <Master Job Number>

  Queries the CA ARCserve Backup database to include all sessions subordinate to the Master Job Number.

  This option is used for consolidating multistreaming sessions. It queries the CA ARCserve Backup database for all sessions subordinate to the master job number of a multistreaming job. The Master Job Number represents the job number of the parent multistreaming job.

• -qJobNo <Job No Query>

  Queries the CA ARCserve Backup database to include all sessions subordinate to the specified job number. Will search for sessions which belong to the specified job number and copy them to the destination media. For rotation jobs, this command will query the database for all sessions related to each job ID for the specified job number and then copy all sessions to the destination media.

  This switch can also be used in conjunction with other query switches to further limit the sessions to be copied.

• -qMediaPool <Media Pool Name>

  Queries the CA ARCserve Backup database to include tapes belonging to the specified Media Pool. It supports searches based on wildcard characters like * and ?.

• -qPreview (View Query Details)

  Puts tapecopy in Preview mode so that tapecopy only displays a list of sessions that satisfy the query criteria. The actual tapecopy operation is not performed.

  This option gives a more in-depth view of the query result set. Use this with the database query options so that you do not commit to executing a copy routine. Instead, you will view the query result set in detail.

• -qIgnoreRep (Ignore Replication Flag)

  Used to ignore the replication flag so that sessions that were already copied by tapecopy are included. If you ignore the flag, the previously copied sessions are ignored by tapecopy.

• -qExclude <Exclude List File Name>

  Queries the CA ARCserve Backup database to exclude the specified list of file host names stored in a file located in the config directory under the CA ARCserve Backup home directory.

• -qPastTime <Number of Days>

  Queries the CA ARCserve Backup database to include sessions that were backed up during the last specified number of days. Days are counted in duration of 24 hours starting from the time the tapecopy operation is run. The difference in number of days in each month is taken into consideration.

  Cannot be used in conjunction with the -qOnOrBefore or -qOnOrAfter options.

• -qCA_RHAType <Type of CA RHA Session>

  Note: Used only with -qType CA_RHA.

  Queries the CA ARCserve Backup database to include only the specified type of CA_RHA sessions for copy. Available CA_RHA sessions are FileSystem, MSSQL, and Exchange.

  If you do not specify the type of CA_RHA session to be queried, by default all CA_RHA sessions will be included.