You can use Cloud Backup to back up Oracle databases that are deployed on Elastic Compute Service (ECS) instances or on your on-premises servers. You can also restore these databases based on your business requirements. This topic describes the preparations that you must make before you back up data.
Step 1: Obtain the username and password
Install Cloud Assistant for the ECS instance that hosts the database. This step is required if the database that you want to back up is deployed on an ECS instance.
An Cloud Backup backup client for ECS must be used together with Cloud Assistant.
If you purchased the ECS instance before December 1, 2017, you must manually install the Cloud Assistant client. For more information, see Install the Cloud Assistant client.
If you purchased the ECS instance on or after December 1, 2017, the Cloud Assistant client is pre-installed.
Obtain the username and password of the Oracle database.
The username and password are used to log on to the Oracle database.
Step 2: Create a backup account and configure permissions
If you do not have a username and password for database backup, we recommend that you contact the administrator to create a backup account. The backup account must have the permissions of the sysdba role, and the resource and connect permissions. For example, you can perform the following steps to create a backup account named backupadmin and grant permissions to the account.
Log on to the server where the Oracle database resides and run the SQL PLUS tool as sysdba.
sqlplus / as sysdba;
Create a backup account named backupadmin.
create user backupadmin identified by your_password;
Assign the sysdba role to the backupadmin account.
grant sysdba to backupadmin;
Grant the resource and connect permissions to the backupadmin account.
grant connect,resource to backupadmin identified by your_password;
After you complete the preceding operations, you can use the created username and password to register the Oracle database instance for subsequent backup jobs.
What to do next
Register an ECS-hosted Oracle database or Register an on-premises Oracle database