OCI - Expdp utilities dumpfile to bucket object storage directly

 OCI - Expdp utilities  dumpfile to bucket object storage directly 

• Login to autonomous DB with admin user and set DBA_CREDENTIALS to schema 

 
C:\Users\varun>sqlplus admin/Cloud$123456@orcladb_medium
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Jun 17 17:42:41 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Last Successful login time: Thu Jun 17 2021 17:27:17 +05:30

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.5.0.0.0
SQL> col OWNER for a10
SQL> col CREDENTIAL_NAME for a20

SQL> SELECT OWNER, CREDENTIAL_NAME FROM DBA_CREDENTIALS;

OWNER      CREDENTIAL_NAME
---------- --------------------
ADMIN      ADMIN_CRED_NAME
TEST       ADMIN_CRED_NAME
SOE        SOE_CREDENTIAL
SOE        ADMIN_CRED_NAME


SQL> ALTER DATABASE PROPERTY SET DEFAULT_CREDENTIAL = 'SOE.ADMIN_CRED_NAME';

Database altered.

SQL> SELECT PROPERTY_VALUE FROM DATABASE_PROPERTIES WHERE PROPERTY_NAME='DEFAULT_CREDENTIAL';

PROPERTY_VALUE
--------------------------------------------------------------------------------
SOE.ADMIN_CRED_NAME

SQL>

• Take expdp backup mentioning credential name and OCI bucket URL 

 
C:\Users\varun>expdp soe/Abc#123456789@orcladb_medium \ filesize=5GB \ dumpfile=default_credential:https://objectstorage.ap-mumbai-1.oraclecloud.com/n/bmdsoh48o0kf/b/bucket-20210415-1806/o/expsoe%U.dmp \  parallel=2 \  logfile=expdosoeschema.log \ directory=staging2
Export: Release 19.0.0.0.0 - Production on Thu Jun 17 18:00:43 2021
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Starting "SOE"."SYS_EXPORT_SCHEMA_01":  soe/********@orcladb_medium filesize=5GB \ dumpfile=default_credential:https://objectstorage.ap-mumbai-1.oraclecloud.com/n/bmdsoh48o0kf/b/bucket-20210415-1806/o/expsoe%U.dmp \ parallel=2 \ logfile=expdosoeschema.log \ directory=staging2
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL_INDEX/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/BITMAP_INDEX/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . exported "SOE"."ORDER_ITEMS"                         170.4 MB 3735896 rows
Processing object type SCHEMA_EXPORT/STATISTICS/MARKER
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
. . exported "SOE"."ORDERS"                              114.9 MB 1352070 rows
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
. . exported "SOE"."INVENTORIES"                         15.27 MB  902171 rows
. . exported "SOE"."LOGON"                               9.065 MB  442208 rows
. . exported "SOE"."CUSTOMERS"                           4.983 MB   45703 rows
. . exported "SOE"."ADDRESSES"                           4.084 MB   55703 rows
. . exported "SOE"."CARD_DETAILS"                        2.402 MB   55703 rows
. . exported "SOE"."PRODUCT_DESCRIPTIONS"                224.1 KB    1000 rows
. . exported "SOE"."PRODUCT_INFORMATION"                 186.4 KB    1000 rows
. . exported "SOE"."EMP"                                 51.39 KB     879 rows
. . exported "SOE"."SALES"                               40.78 KB    1000 rows
. . exported "SOE"."WAREHOUSES"                          36.03 KB    1000 rows
. . exported "SOE"."JOB_HISTORY"                         14.60 KB     246 rows
. . exported "SOE"."JOBS"                                5.976 KB      23 rows
. . exported "SOE"."ORDERENTRY_METADATA"                 5.609 KB       4 rows
. . exported "SOE"."DEPT"                                5.632 KB       7 rows
. . exported "SOE"."V"                                       0 KB       0 rows
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/TABLE/IDENTITY_COLUMN
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/INDEX/FUNCTIONAL_INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/BITMAP_INDEX/INDEX
Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCOBJ
Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCACT_SCHEMA
ORA-39173: Encrypted data has been stored unencrypted in dump file set.
Master table "SOE"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SOE.SYS_EXPORT_SCHEMA_01 is:
  https://swiftobjectstorage.ap-mumbai-1.oraclecloud.com/v1/bmdsoh48o0kf/bucket-20210415-1806/expsoe01.dmp
  https://swiftobjectstorage.ap-mumbai-1.oraclecloud.com/v1/bmdsoh48o0kf/bucket-20210415-1806/expsoe02.dmp
Job "SOE"."SYS_EXPORT_SCHEMA_01" successfully completed at Thu Jun 17 12:31:40 2021 elapsed 0 00:00:53