Oracle ASM profile example

Edit online

The profile file provides parameters that customize how IBM® Storage Protect Snapshot works within a particular environment. Use this example to verify that the configuration of the profile is correct for your Oracle with ASM environment.

The following example shows a sample IBM Storage Protect Snapshot Oracle ASM profile:

>>> CLIENT A10
ORACLE_SID A10
APPLICATION_TYPE ORACLE          #
TARGET_DATABASE_SUSPEND YES      # YES | NO | OFFLINE
TSM_BACKUP YES                   # YES | NO
# MAX_VERSIONS ADAPTIVE          # num | ADAPTIVE
# LVM_FREEZE_THAW AUTO           # AUTO | YES | NO
# NEGATIVE_LIST NO_CHECK         # NO_CHECK | WARN | ERROR | <path to negative list file>
DEVICE_CLASS DC_SVC01            #
ORACLE_SECTION_NAME A10          # Name of corresponding ORACLE section
OFFLOAD_SECTION_NAME V122        # Name of corresponding OFFLOAD section
VOLUME_MGR ASM               # ASM|LVM
<<<
>>> OFFLOAD A10
BACKUP_METHOD ORACLE             #
# OVERWRITE_DATABASE_PARAMETER_FILE YES    # YES | NO
# DATABASE_BACKUP_INCREMENTAL_LEVEL 0      #
#ASM_INSTANCE_USER AUTO                    # User name | AUTO
#ASM_INSTANCE_ID +ASM            # ASM instance SID | +ASM
#ASM_ROLE SYSDBA                 # SYSDBA or SYSASM | SYSDBA

<<<
>>> ORACLE V122
ORACLE_HOME /oracle/ora12cR2/app/product/12.2.0/dbhome_1
CATALOG_DATABASE_CONNECT_STRING cat_db     # *mandatory parameter*
CATALOG_DATABASE_USERNAME rman             # *mandatory parameter*
DATABASE_BACKUP_SCRIPT_FILE /oracle/A10/acs/tsm_backup.scr      
						 # *mandatory parameter*
DATABASE_CONTROL_FILE_RESTORE NO           # YES | NO
#ASM_INSTANCE_USER AUTO                    # User name | AUTO
#ASM_INSTANCE_ID +ASM                      # ASM instance SID | +ASM
#ASM_ROLE SYSDBA                           # SYSDBA or SYSASM | SYSDBA
<<<
>>> ACSD
ACS_REPOSITORY /oracle/A10/acs/acsrepository    # *mandatory parameter*
<<<
>>> DEVICE_CLASS DC_SVC01
COPYSERVICES_HARDWARE_TYPE SVCDTA          # *mandatory parameter* SVC | DS8000 | XIV
COPYSERVICES_HARDWARE_TYPE GENERIC
COPYSERVICES_ADAPTERNAME svc/SvcAdapter.jar
COPYSERVICES_SERVERNAME svc01.ibm.com
COPYSERVICES_USERNAME superuser
SVC_SSHKEY_FULLPATH /home/A10/.ssh/id_rsa
FLASHCOPY_TYPE COPY
BACKUP_HOST_NAME  backhost
<<<

The ASM_INSTANCE_USER, ASM_INSTANCE_ID, and ASM_ROLE SYSDBA parameters in the OFFLOAD section contain values for the backup server. They can be commented out if the same parameters in the ORACLE section are also valid for the backup server.