Configure RMAN Settings

To setup RMAN and backup policies for hot backups in the database, preform the following:

1. Copy the folder Installers\InstallTools\SetupServer\db-backup from the AVEVA Enterprise Resource Management installation package to <OracleBase>\db-backup on the database server. For example, D:\app\oracle\db-backup.

2. Navigate to the folder <OracleBase>\db-backup in a PowerShell window

3. Run the script RmanSetup.ps1 passing the following parameters:

   OracleHome - The home of the Oracle database. For example, C:\app\oracledb\product\19.0.0\dbhome_1

   OracleSid - The SID of the database that is backed up. For example, AVEVA Enterprise Resource Management.

   SysPwd - The SYS password for database

   BackupPath - The path to the location used to store database backup files. The account running the Oracle database service requires read and write permissions for this location.

   BackupRetentionDays - The number of days to retain backup files on the disk.

   BackupDestSize - The maximum size in GB of the backup area used. If the limit is reached, the database stops to prevent the system from failing and to meet the retention period set above.

   For example,

   .\RmanSetup.ps1 -OracleHome C:\app\oracledb\product\19.0.0\dbhome_1
   -OracleSid ERM -SysPwd ERM -BackupPath C:\app\oracledb\fast_recovery_area\ERM -BackupRetentionDays 14
   -BackupDestSize 100

   Note: This script returns the DBID of the database, which is required for complete disaster recovery. Note it and store safely.