Setting Up a Bucket to Store Autonomous Database Manual Backups

Hello,
We must create an Oracle Cloud Infrastructure Object Storage bucket to hold our Autonomous Database manual backups and configure your database to connect to it. In this blog post I will describe how to do it.

1- If you have not already done so, generate an auth token for the Oracle Cloud Infrastructure Object Storage user to access the bucket.
Please read my previous blog post to create an auth token

2- Open the navigation menu. Under Core Infrastructure, click Object Storage.

3-Select a compartment from the Compartment list on the left side of the page. A list of existing buckets is displayed.

4- Click Create Bucket.

5- In the Create Bucket dialog box, specify the attributes of the bucket:

Bucket Name: The system generates a default bucket name that reflects the current year, month, day, and time. If you change this default to any other bucket name, use letters, numbers, dashes, underscores, and periods. Avoid entering confidential information. For storing a manual backup. Please specify name as backup_[Your Autonomous Database Name] For example, my bucket name is backup_atp.

Storage Tier: Select the tier in which you want to store your data. Available tiers include:

Standard is the primary, default Object Storage tier for storing frequently accessed data that requires fast and immediate access.
Archive is a special tier for storing infrequently accessed data that requires long retention periods. Access to data in the Archive tier is not immediate. You must restore archived data before the data is accessible.
Object Events: Select Emit Object Events if you want to enable the bucket to emit events for object state changes.
Encryption: Buckets are encrypted with keys managed by Oracle by default, but you can optionally encrypt the data in this bucket using your own Vault encryption key. To use Vault for your encryption needs, select Encrypt Using Customer-Managed Keys. Then, select the Vault Compartment and Vault that contain the master encryption key you want to use. Also select the Master Encryption Key Compartment and Master Encryption Key

6- Finally click Create Bucket.

Now the bucket is ready to start uploading objects.

7- Using an Oracle Database client, log in to the database as the administrator set the database default_bucket property to your Oracle Cloud Infrastructure Object Storage tenancy URL. The format of the tenancy URL is https://swiftobjectstorage.region.oraclecloud.com/v1/object_storage_namespace

Please read my previous blog post to create an auth token

For example;

ALTER DATABASE PROPERTY SET default_bucket=’https://swiftobjectstorage.eu-frankfurt-1.oraclecloud.com/v1/frskjd0nbatp’;

Here My Object Storage namespace is frskjd0nbatp and my region eu-frankfurt-1

Note: To determine the Object Storage namespace string to use, click View Bucket in the actions (three dots) menu of the bucket you created in the sixth step

8-With the tenancy user and the auth token referenced in first step, create the credential for your Oracle Cloud Infrastructure Object Storage account. Use DBMS_CLOUD.CREATE_CREDENTIAL to create the credential.

BEGIN
DBMS_CLOUD.CREATE_CREDENTIAL(
credential_name => ‘CRED_NAME’,
username => ‘talip.ozturk@veridatait.com’,
password => ‘Zgkz:2lE)zw:duc}K1>8’
);
END;
/

9- Set the database property default_credential to the credential you created in the previous step.

ALTER DATABASE PROPERTY SET default_credential = ‘ADMIN.CRED_NAME’;

Now, you can take manual backups any time you want. I will write about how to take manual backup in the following post.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s