expdp备份集直接导出到asm磁盘组

denglj · 发表于 2022-10-10 20:59:48

文档课题：expdp备份集直接导出到asm磁盘组.

系统：rhel 8.464位

数据库：oracle 19.1264位 + asm + 单实例 + 多租户

操作过程：

ASMCMD>pwd

+data/orclcdb

ASMCMD>mkdir rmanbak

ASMCMD>ls -l

Type Redund Striped Time Sys Name

Y 86B637B62FE07A65E053F706E80A27CA/

Y ARCHIVELOG/

Y AUTOBACKUP/

Y BACKUPSET/

Y CBB453E60EF1A77FE0537885A8C04607/

Y CBB47E352F7AAEA7E0537885A8C03007/

Y CONTROLFILE/

Y DATAFILE/

Y ONLINELOG/

Y PARAMETERFILE/

Y TEMPFILE/

N rmanbak/

SQL>create directory expdp_dir as '+data/orclcdb/rmanbak';

Directorycreated.

SQL>grant read,write on directory expdp_dir to ora1;

Grantsucceeded.

SQL>create directory expdp_log_dir as '/home/oracle/';

Directorycreated.

SQL>grant read,write on directory expdp_log_dir to ora1;

Grantsucceeded.

[oracle@dbserver~]$ expdp ora1/ora1@orclpdb directory=expdp_dir dumpfile=ora1.dmplogfile=expdp_log_dir:ora1.log

Export:Release 19.0.0.0.0 - Production on Mon Oct 10 20:50:41 2022

Version19.12.0.0.0

Connectedto: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Starting"ORA1"."SYS_EXPORT_SCHEMA_01": ora1/********@orclpdb directory=expdp_dirdumpfile=ora1.dmp logfile=expdp_log_dir:ora1.log

Processingobject type SCHEMA_EXPORT/TABLE/TABLE_DATA

Processingobject type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

Processingobject typeSCHEMA_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL_INDEX/INDEX_STATISTICS

Processingobject type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

Processingobject type SCHEMA_EXPORT/STATISTICS/MARKER

Processingobject type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA

Processingobject type SCHEMA_EXPORT/SEQUENCE/SEQUENCE

Processingobject type SCHEMA_EXPORT/TABLE/TABLE

Processingobject type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT

Processingobject type SCHEMA_EXPORT/TABLE/COMMENT

Processingobject type SCHEMA_EXPORT/PROCEDURE/PROCEDURE

Processingobject type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE

Processingobject type SCHEMA_EXPORT/VIEW/VIEW

Processingobject type SCHEMA_EXPORT/TABLE/INDEX/INDEX

Processingobject type SCHEMA_EXPORT/TABLE/INDEX/FUNCTIONAL_INDEX/INDEX

Processingobject type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

Processingobject type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT

Processingobject type SCHEMA_EXPORT/TABLE/TRIGGER

. .exported "ORA1"."EMPL7" 11.51 KB 20 rows

. .exported "ORA1"."EMPL6" 10.12 KB 2 rows

. .exported "ORA1"."EMP" 10.92 KB 20 rows

. .exported "ORA1"."EMPLOYEES" 10.92 KB 20 rows

. .exported "ORA1"."EMP_TEST" 10.93 KB 20 rows

. .exported "ORA1"."TEST1" 10.92 KB 20 rows

. .exported "ORA1"."EMPLOYEES3" 10.93 KB 20 rows

. .exported "ORA1"."EMPLOYEES03" 10.92 KB 20 rows

. .exported "ORA1"."EMP3" 10.91 KB 20 rows

. .exported "ORA1"."EMP_COPY" 10.01 KB 7 rows

. .exported "ORA1"."RETIRED_EMPLOYEES" 9.406 KB 15 rows

. .exported "ORA1"."LOC" 8.492 KB 26 rows

. .exported "ORA1"."LOCATIONS" 8.437 KB 23 rows

. .exported "ORA1"."SALES_SOURCE_DATA" 7.648 KB 2 rows

. .exported "ORA1"."JOB_HISTORY" 7.367 KB 15 rows

. .exported "ORA1"."LOC1" 7.25 KB 1 rows

. .exported "ORA1"."JOBS" 7.109 KB 19 rows

. .exported "ORA1"."DEPT2" 7.148 KB 11 rows

. .exported "ORA1"."COPY_EMP03" 6.835 KB 20 rows

. .exported "ORA1"."COPY_EMP3" 6.835 KB 20 rows

. .exported "ORA1"."DEPARTMENTS" 6.765 KB 13 rows

. .exported "ORA1"."DEPT01" 6.718 KB 11 rows

. .exported "ORA1"."DEPT80" 6.539 KB 6 rows

. .exported "ORA1"."DEPT_TEST" 6.601 KB 7 rows

. .exported "ORA1"."DEPTM3" 6.492 KB 1 rows

. .exported "ORA1"."DEPTM4" 6.5 KB 1 rows

. .exported "ORA1"."COUNTRIES" 6.367 KB 25 rows

. .exported "ORA1"."EMP_HISTORY01" 6.281 KB 15 rows

. .exported "ORA1"."EMP_HISTORY" 6.281 KB 15 rows

. .exported "ORA1"."SAL_HISTORY" 6.148 KB 8 rows

. .exported "ORA1"."SAL_HIGH" 6.148 KB 8 rows

. .exported "ORA1"."MGR_HISTORY" 6.164 KB 8 rows

. .exported "ORA1"."SAL_LOW" 6.101 KB 6 rows

. .exported "ORA1"."SAL_MID" 6.093 KB 6 rows

. .exported "ORA1"."FLIGHTS" 6.023 KB 3 rows

. .exported "ORA1"."SAL_HISTORY1" 6.078 KB 4 rows

. .exported "ORA1"."JOB_GRADES" 6.085 KB 6 rows

. .exported "ORA1"."SALES_INFO" 6.101 KB 15 rows

. .exported "ORA1"."SALES_INFO01" 5.960 KB 5 rows

. .exported "ORA1"."MGR_HISTORY1" 6.101 KB 4 rows

. .exported "ORA1"."EMP_SALES" 6.101 KB 4 rows

. .exported "ORA1"."EMP_SALES01" 6.109 KB 4 rows

. .exported "ORA1"."DEPT1" 5.703 KB 11 rows

. .exported "ORA1"."REGIONS" 5.546 KB 4 rows

. .exported "ORA1"."WARR" 5.593 KB 6 rows

. .exported "ORA1"."T2" 5.523 KB 3 rows

. .exported "ORA1"."T1" 5.5 KB 3 rows

. .exported "ORA1"."EMP5" 5.507 KB 3 rows

. .exported "ORA1"."WARR01" 5.554 KB 3 rows

. .exported "ORA1"."WEB_ORDERS" 5.546 KB 1 rows

. .exported "ORA1"."WEB_ORDERS01" 5.546 KB 1 rows

. .exported "ORA1"."A" 5.492 KB 3 rows

. .exported "ORA1"."B" 5.492 KB 3 rows

. .exported "ORA1"."EMP01" 5.476 KB 1 rows

. .exported "ORA1"."LAB" 5.187 KB 6 rows

. .exported "ORA1"."LAB01" 5.164 KB 4 rows

. .exported "ORA1"."EMP1" 0 KB 0 rows

. .exported "ORA1"."EMP_LIB" 0 KB 0 rows

. .exported "ORA1"."EMP_UNNAMED_INDEX" 0 KB 0 rows

. .exported "ORA1"."NEW_EMP" 0 KB 0 rows

. .exported "ORA1"."NEW_EMP2" 0 KB 0 rows

. .exported "ORA1"."SALES_SOURCE_DATA01" 7.625 KB 1 rows

. .exported "ORA1"."SALE_REPS" 0 KB 0 rows

. .exported"ORA1"."TEST_128_ABCDEFGHIJKLMNOPQRSTUVWXYZ_ABCDEFGHIJKLMNOPQRSTUVWXYZ_ABCDEFGHIJKLMNOPQRSTUVWXYZ_ABCDEFGHIJKLMNOPQRSTUVWXYZ_ABCDEFGHIJK" 0 KB 0 rows

Mastertable "ORA1"."SYS_EXPORT_SCHEMA_01" successfullyloaded/unloaded

******************************************************************************

Dump fileset for ORA1.SYS_EXPORT_SCHEMA_01 is:

+DATA/orclcdb/rmanbak/ora1.dmp

Job"ORA1"."SYS_EXPORT_SCHEMA_01" successfully completed at MonOct 10 20:51:53 2022 elapsed 0 00:01:12

ASMCMD>pwd

+data/orclcdb/rmanbak

ASMCMD>ls

ora1.dmp

结论：expdp成功导出到磁盘组.

帐号		自动登录	找回密码
密码			注册

[Oracle] expdp备份集直接导出到asm磁盘组