Using SnapManager for Oracle to create the database profile for a local backup

Contributors Download PDF of this page

The database administrators use SnapManager to create a database profile that will be used to initiate a backup to local storage on a primary storage system. The entire profile creation and backup creation processes are performed entirely in SnapManager; they do not involve Protection Manager.

A profile contains the information about the database being managed, including its credentials, backup settings, and protection settings for backups. By creating a profile, you do not need to specify database details each time you perform an operation on that database, instead just provide the profile name. A profile can reference only one database. That same database can be referenced by more than one profile.

  1. Go to the SnapManager for Oracle client.

  2. From the SnapManager Repositories tree, right-click the host you want associated with this profile, and select Create Profile.

  3. In the Profile Configuration Information page, enter the following information and click Next.

    • Profile name: payroll_prod

    • Profile password: payroll123

    • Comment: Production Payroll database

  4. In the Database Configuration Information page, enter the following information and click Next.

    • Database name: PAYDB

    • Database SID: payrolldb

    • Database host: Accept the default

      Because you are creating a profile from a host in the repository tree, SnapManager displays the host name.

  5. In the second Database Configuration Information page, accept the following database information and click Next:

    • Host Account, representing the Oracle user account: oracle

    • Host Group, representing the Oracle group: dba

  6. In the Database Connection Information page, select Use database Authentication to allow users to authenticate using database information.

    For this example, enter the following information and click Next.

    • SYSDBA Privileged User Name, representing the system database administrator who has administrative privileges: sys

    • Password (SYSDBA password): oracle

    • Port to connect to database host: 1521

  7. In the RMAN Configuration Information page, select Do not use RMAN and click Next.

    Oracle Recovery Manager (RMAN) is an Oracle tool that helps you back up and recover Oracle databases using block-level detection.

  8. In the Snapshot Naming Information page, specify a naming convention for the Snapshots associated with this profile by selecting variables. The only variable that is required is the smid variable, which creates a unique snapshot identifier.

    For this example, do the following:

    1. In the Variable Token list, select the {usertext} variable and click Add.

    2. Enter "payroll.techco.com_" as the host name and click OK.

    3. Click Left until the host name appears just after "smo" in the Format box.

    4. Click Next.

    The Snapshot naming convention of smo_hostname_smoprofile_dbsid_scope_mode_smid becomes "smo_payroll.techco.com_payroll_prod2_payrolldb_f_a_x" (where the "f" indicates a full backup, the "a" indicates the automatic mode, and the "x" represents the unique SMID).

  9. On the Perform Operation page, verify the information and click Create.

  10. Click Operation Details to see information about the profile create operation and volume-based restore eligibility information.