Skip to main content
Sign Out

Welcome to Dell

My Account
  • Place orders quickly and easily
  • View orders and track your shipping status
  • Enjoy members-only rewards and discounts
  • Create and access a list of your products
  • Manage your Dell EMC sites, products, and product-level contacts using Company Administration.
Sign In Create an Account Dell Financial Services Premier Sign In Partner Program Sign In
Contact Us

Your Dell.com Carts

Dell Avamar for Oracle 19.10 User Guide

PDF

Backing up a tablespace

About this task

The following procedure uses an RMAN script to back up a tablespace to an Avamar server or a Data Domain system.

An avtar flag file for the RMAN script that is specified in this procedure contains the following entries:

--debug
--pidname=Oracle
--pidnum=3002
--logfile=install-dir/var/clientlogs/backupdb.log
--vardir=install-dir/var
--id=testuser@/clients/oraw2k864-mc2.bgl-avamar.dell.com
--password=testuser
--path=/clients/oraw2k864-mc2.bgl-avamar.dell.com
--server=avamar-1.dell.com

NOTE:To view the contents of a tablespace backup, use the list backup command. The list backup command lists all the datafiles and the control file that are part of the tablespace backup.

Steps

  1. Open a command shell.
  2. Log in to Oracle RMAN by using the Oracle user ID and password.
    The command prompt changes to an RMAN prompt.
  3. Connect to the Oracle database to back up.
  4. Back up the Oracle tablespace by typing commands similar to the following RMAN commands:

    run {
    configure controlfile autobackup on;
    set controlfile autobackup format for device type sbt to
    'CONTROLFILE.ANT.%F';
    allocate channel c0 type sbt
    PARMS="SBT_LIBRARY=c:\PROGRA~1\avs\bin\orasbt64.dll"\
    format '%d_%U';
    send '"--prefix=11g/ANT/"
    "--flagfile=c:\rman\avtar-flags.txt"
    "--taskfile=c:\rman\taskfile.txt"
    "--bindir=c:\PROGRA~1\avs\bin"';
    backup tablespace ant_ts;
    release channel c0;
    }

    In the sample script, the database name is ANT and the tablespace name is ant_ts. The script backs up the tablespace and the database control file by using the autobackup option.

Rate this content

Accurate
Useful
Easy to understand
Was this article helpful?
0/3000 characters
  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please select whether the article was helpful or not.
  Comments cannot contain these special characters: <>()\