You must create a profile for your database to perform any operation on that database. The profile contains information about the database and can reference only one database; however, a database can be referenced by multiple profiles. A backup that is created using one profile cannot be accessed from a different profile, even if both profiles are associated with the same database.
Before you begin
You must ensure that target database details are included in the /etc/oratab file.
About this task
These steps show how to create a profile for your database using
You can also use the
CLI if you prefer.
For information about how to create profiles using the CLI, see the SnapManager for Oracle Administration Guide for UNIX.
- From the Repositories tree, right-click the repository or the host and select Create Profile.
- On the Profile Configuration Information page, enter the custom name and password for the profile.
- On the Database Configuration Information page, enter the following information:
|In this field...
||Enter the name of the database you want to backup.
||Enter the secure ID (SID) of the database.
The database name and the database SID can be the same.
||Enter the IP address of the host where the target database resides.
You can also specify the host name if the host name is specified in the Domain Name System (DNS).
||Enter the Oracle user name of the target database.
The default value for the user is oracle.
||Enter the Oracle user group name.
The default value is dba.
- On the Database Connection Information page, select one of the following:
||If you want to...|
|Use O/S Authentication
||Use the credentials maintained by the operating system to authenticate users who access the database.
|Use Database Authentication
||Allow Oracle to authenticate an administrative user using password file authentication. Enter the appropriate database connection information.
|Use ASM Instance Authentication
|| Allow Automatic Storage Management (ASM) database instance to authenticate an administrative user. Enter the appropriate ASM instance authentication information.
- In the SYSDBA/SYSASM Privileged User Name field, enter the user name of the ASM instance administrator with administrative privileges.
- In the Password field, enter password of the administrator.
Note: You can select the ASM authentication mode only if you have an ASM instance on the database host.
- On the RMAN Configuration Information page, select one of the following:
|Do not use RMAN
||You are not using RMAN to manage backup and restore operations.
|Use RMAN via the control file
||You are managing the RMAN repository using control files.
|Use RMAN via Recovery Catalog
||You are managing the RMAN repository using recovery catalog database.
Enter the user name who has access to recovery catalog database, password, and the Oracle net service name of the database that manages the Transparent Network Substrate (TNS) connection.
- On the Snapshot Naming Information page, select the variables to specify a naming format for the Snapshot copy.
You must include the smid variable in the naming format. The smid variable creates a unique Snapshot identifier.
- On the Policy Settings page, perform the following:
- Enter the retention count and duration for each retention class.
- From the Protection Policy drop-down list, select the protection policy.
You must select either SnapManager_cDOT_Mirror or SnapManager_cDOT_Vault policies depending on whether SnapMirror or SnapVault relationship is established.
- If you want to back up archive logs separately, select the Backup Archivelogs Separately checkbox, specify the retention, and select the protection policy.
You can select a policy which is different from the policy associated for datafiles. For example, if you have selected SnapManager_cDOT_Mirror for datafiles, you can select SnapManager_cDOT_Vault for archive logs.
- On the Configure Notification Settings page, specify the email notification settings.
- On the History Configuration Information page, select one of the options to maintain the history of SnapManager operations.
- On the Perform Profile Create Operation page, verify the information and click Create.
- Click Finish to close the wizard.
If the operation fails, click Operation Details to view what caused the operation to fail.