Move Dump File Set from Autonomous Database to Your Cloud Object Store
To move the dump file set to your Cloud Object Store, upload the files from the database directory to your Cloud Object Store.
- Connect to your database.
- Store your object store credentials using the procedure
DBMS_CLOUD.CREATE_CREDENTIAL
.For example:
BEGIN
DBMS_CLOUD.CREATE_CREDENTIAL
( credential_name => 'DEF_CRED_NAME', username => 'adb_user@example.com', password => 'password' ); END; /This operation stores the credentials in the database in an encrypted format. You can use any name for the credential name. Note that this step is required only once unless your object store credentials change. Once you store the credentials you can then use the same credential name.
See CREATE_CREDENTIAL Procedure for information about the
username
andpassword
parameters for different object storage services. - Move the dump files from the database to your Cloud Object Store by calling
DBMS_CLOUD.PUT_OBJECT
.For example:
BEGIN
DBMS_CLOUD.PUT_OBJECT
(credential_name => 'DEF_CRED_NAME', object_uri => 'https://objectstorage.us-phoenix-1.oraclecloud.com/n/namespace-string/b/bucketname/o/exp01.dmp', directory_name => 'DATA_PUMP_DIR', file_name => 'exp01.dmp');DBMS_CLOUD.PUT_OBJECT
(credential_name => 'DEF_CRED_NAME', object_uri => 'https://objectstorage.us-phoenix-1.oraclecloud.com/n/namespace-string/b/bucketname/o/exp02.dmp', directory_name => 'DATA_PUMP_DIR', file_name => 'exp02.dmp');DBMS_CLOUD.PUT_OBJECT
(credential_name => 'DEF_CRED_NAME', object_uri => 'https://objectstorage.us-phoenix-1.oraclecloud.com/n/namespace-string/b/bucketname/o/exp03.dmp', directory_name => 'DATA_PUMP_DIR', file_name => 'exp03.dmp');DBMS_CLOUD.PUT_OBJECT
(credential_name => 'DEF_CRED_NAME', object_uri => 'https://objectstorage.us-phoenix-1.oraclecloud.com/n/namespace-string/b/bucketname/o/exp04.dmp', directory_name => 'DATA_PUMP_DIR', file_name => 'exp04.dmp'); END; /In this example,
namespace-string
is the Oracle Cloud Infrastructure object storage namespace andbucketname
is the bucket name. See Understanding Object Storage Namespaces for more information.See PUT_OBJECT Procedure for information on
PUT_OBJECT
. - Perform the required steps to use Oracle Data Pump import and clean up. See Download Dump Files, Run Data Pump Import, and Clean Up Object Store for more details.