Skip to main content
SnapManager for SAP

Details of the target database

Contributors
PDFs

This example of integrated database protection describes the protection of a payroll database. The following data is used in the example.

The database administrator (DBA) at TechCo, a 3000-person company headquartered in Atlanta, must create a consistent backup of the production payroll database, PAYDB. The protection strategy for backing up to primary and secondary storage requires that the DBA and the storage administrator work together to back up the Oracle database both locally on primary storage and also remotely, to secondary storage at a remote location.

  • Profile information

    When creating a profile in SnapManager, you need the following data:

    • Database name: P01

    • Host name: prod01.sample.com

    • Database ID: P01

    • Profile name: P01_BACKUP

    • Connection mode: Database authentication

    • Snapshot naming scheme: smsap_hostname_dbsid_smsapprofile_scope_mode_smid (which translates to "smsap_prod01.sample.com_p01_p01_backup_f_h_x")

    • Repository user: <sid>rep, which translates to p01rep.