标签：ORA1 rows expdp KB 备份 EXPORT exported asm SCHEMA
文档课题：expdp备份集直接导出到asm磁盘组.
系统：rhel 8.4 64位
数据库：oracle 19.12 64位 + 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> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 ORCLPDB READ WRITE NO
SQL> conn sys/oracle@orclpdb as sysdba
Connected.
SQL> create directory expdp_dir as '+data/orclcdb/rmanbak';
Directory created.
SQL> grant read,write on directory expdp_dir to ora1;
Grant succeeded.
SQL> create directory expdp_log_dir as '/home/oracle/';
Directory created.
SQL> grant read,write on directory expdp_log_dir to ora1;
Grant succeeded.
[oracle@dbserver ~]$ expdp ora1/ora1@orclpdb directory=expdp_dir dumpfile=ora1.dmp logfile=expdp_log_dir:ora1.log
Export: Release 19.0.0.0.0 - Production on Mon Oct 10 20:50:41 2022
Version 19.12.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 "ORA1"."SYS_EXPORT_SCHEMA_01": ora1/********@orclpdb directory=expdp_dir dumpfile=ora1.dmp logfile=expdp_log_dir:ora1.log
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
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/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/STATISTICS/MARKER
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
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/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
Master table "ORA1"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for ORA1.SYS_EXPORT_SCHEMA_01 is:
+DATA/orclcdb/rmanbak/ora1.dmp
Job "ORA1"."SYS_EXPORT_SCHEMA_01" successfully completed at Mon Oct 10 20:51:53 2022 elapsed 0 00:01:12
ASMCMD> pwd
+data/orclcdb/rmanbak
ASMCMD> ls
ora1.dmp
结论：expdp成功导出到磁盘组.
标签：ORA1,
rows,
expdp,
KB,
备份,
EXPORT,
exported,
asm,
SCHEMA
From： https://blog.51cto.com/u_12991611/5745305