Topics:

• Database Fleet Backup Configuration for Recovery Appliance
• Database Fleet Backup Scheduling for Recovery Appliance
• Touchless Automated End-to-End Database Fleet Backup Management
• Recovery Appliance Protected Database Fleet Archival Backup Management
• Database Fleet Advanced Backup Configuration for Recovery Appliance Using EMCLI

Database Fleet Backup Credential Prerequisites

The database fleet backup configuration and scheduling operations require both database user and host user credentials in order to perform configuration and backup tasks at the database and operating system levels. Either Enterprise Manager named or preferred credentials can be used, and they must be configured prior to performing these operations. To manage named and preferred credentials, see Configuring and Using Target Credentials in Cloud Control Security Guide.

The specific user requirements for backup configuration and scheduling operations are as follows:

• The database user must have SYSDBA or SYSBACKUP role.
• The host (operating system) user must have write and execute permission for the database Oracle home.

To use named credentials, create the following:

• Database credentials: A database named credential with global scope (that is, applicable to all database targets) that specifies a database user meeting the above requirements for all databases in the operation.
• Host credentials: A database host named credential with global scope (that is, applicable to all database targets) that specifies an operating system user meeting the above requirements for all databases in the operation.

Alternatively, preferred credentials can be used. Since preferred credentials can be configured globally or for each individual database, they are recommended if a single credential cannot be used for all databases. To use preferred credentials, configure the following:

• Database credentials: Default and/or target (per-database) preferred credentials of credential set type SYSDBA Database Credentials
• Host credentials: Default and/or target (per-database) preferred credentials of credential set type Database Host Credentials

Use Groups for Configuring and Scheduling Fleet Backup to Recovery Appliance

The Configure Fleet Backup to Recovery Appliance wizard can be run against an Oracle Enterprise Manager group target. All databases within the group are configured to backup to the selected Recovery Appliance. This is particularly useful if the Oracle Enterprise Manager groups are already being used to group and manage the database targets. You can use the same group to schedule backups for the databases. Additionally, if the group is a dynamic group, the fleet backup configuration deployment procedure can be scheduled to run on a recurring interval, and new databases that subsequently join the group will be automatically processed and configured for backup during the next scheduled procedure implementation. Similarly, after the databases are configured, they will be automatically backed during the next scheduled implementation of the fleet backup deployment procedure. See Touchless Automated End-to-End Database Fleet Backup Management.

Group Membership Criteria:

The following image shows the group ProdGroup, a dynamic group which contains all cluster databases or single-instance databases that have their Lifecycle Status set to Production.

Group Members:

The following image shows that ProdGroup currently has 4 database members: