[bin.liu@enmoteam3 ~]$ expdp travel/aa DUMPFILE=AWR_DIR:dmp1,D_TEST:dmp2 parallel=2 Export: Release 11.2.0.4.0 - Production on Fri Sep 5 13:37:38 2014 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options FLASHBACK automatically enabled to preserve database integrity. Starting "TRAVEL"."SYS_EXPORT_SCHEMA_01": travel/******** DUMPFILE=AWR_DIR:dmp1,D_TEST:dmp2 parallel=2 Estimate in progress using BLOCKS method... Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA Total estimation using BLOCKS method: 232.6 MB Processing object type SCHEMA_EXPORT/USER Processing object type SCHEMA_EXPORT/SYSTEM_GRANT Processing object type SCHEMA_EXPORT/ROLE_GRANT Processing object type SCHEMA_EXPORT/DEFAULT_ROLE . . exported "TRAVEL"."TESTTABLE" 199.2 MB 1988400 rows . . exported "TRAVEL"."REDO" 484.8 KB 23387 rows . . exported "TRAVEL"."TEST2" 5.421 KB 1 rows . . exported "TRAVEL"."REDO_LOG" 0 KB 0 rows . . exported "TRAVEL"."TEST":"TEST_PART01" 0 KB 0 rows . . exported "TRAVEL"."TEST":"TEST_PART02" 0 KB 0 rows . . exported "TRAVEL"."TEST":"TEST_PART03" 0 KB 0 rows . . exported "TRAVEL"."TEST1" 0 KB 0 rows Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA Processing object type SCHEMA_EXPORT/DB_LINK Processing object type SCHEMA_EXPORT/TABLE/TABLE Processing object type SCHEMA_EXPORT/TABLE/COMMENT Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS Master table "TRAVEL"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded ****************************************************************************** Dump file set for TRAVEL.SYS_EXPORT_SCHEMA_01 is: /tmp/dmp1.dmp /home/oracle/dmp2.dmp Job "TRAVEL"."SYS_EXPORT_SCHEMA_01" successfully completed at Fri Sep 5 13:38:52 2014 elapsed 0 00:01:11 [bin.liu@enmoteam3 ~]$ su - oracle Password: [oracle@enmoteam3 ~]$ [oracle@enmoteam3 ~]$ ls -l dmp2.dmp -rw-r----- 1 oracle oinstall 209633280 Sep 5 13:38 dmp2.dmp [oracle@enmoteam3 ~]$ ls -l /tmp/dmp1.dmp -rw-r----- 1 oracle oinstall 28672 Sep 5 13:38 /tmp/dmp1.dmp [oracle@enmoteam3 ~]$ |
-
3D Cloud
12.1.0.2 asm asm恢复 bbed dmp损坏 dul i_obj4 ORA-00202 ORA-00312 ORA-00313 ORA-00353 ORA-00354 ORA-00600 ORA-00604 ORA-00607 ORA-00704 ORA-01110 ORA-01115 ORA-01157 ORA-01190 ORA-01194 ORA-01207 ORA-01555 ORA-01578 ORA-01595 ORA-03113 ORA-08102 ORA-08103 ORA-600 2662 ORA-600 2663 ORA-600 4000 ORA-600 4137 ORA-600[2662] ORA-600[3020] ORA-600[4194] ORA-600[17182] ORA-15042 ORA-19502 ORA-19909 ORA-27072 oracle dul Oracle recover oracle异常恢复 Oracle 恢复 ORACLE恢复
WP Cumulus Flash tag cloud by 惜分飞 requires Flash Player 9 or better.
QQ咨询
-
最近发表
- ORA-600 krse_arc_complete.4
- Oracle 19c 202410补丁(RUs+OJVM)
- ntfs MFT损坏(ntfs文件系统故障)导致oracle异常恢复
- .mkp扩展名oracle数据文件加密恢复
- 清空redo,导致ORA-27048: skgfifi: file header information is invalid
- A_H_README_TO_RECOVER勒索恢复
- 通过alert日志分析客户自行对一个数据库恢复的来龙去脉和点评
- ORA-12514: TNS: 监听进程不能解析在连接描述符中给出的SERVICE_NAME
- ORA-01092 ORA-00604 ORA-01558故障处理
- ORA-65088: database open should be retried
- Oracle 19c异常恢复—ORA-01209/ORA-65088
- ORA-600 16703故障再现
- 数据库启动报ORA-27102 OSD-00026 O/S-Error: (OS 1455)
- .[metro777@cock.li].Elbie勒索病毒加密数据库恢复
- 应用连接错误,初始化mysql数据库恢复
- RAC默认服务配置优先节点
- Oracle 19c RAC 替换私网操作
- 监听报TNS-12541 TNS-12560 TNS-00511错误
- drop tablespace xxx including contents恢复
- Linux 8 修改网卡名称
- 如何修改集群的公网信息(包括 VIP) (Doc ID 1674442.1)
- 如何在 oracle 集群环境下修改私网信息 (Doc ID 2103317.1)
- ORA-600 [kcvfdb_pdb_set_clean_scn: cleanckpt] 相关bug
- ORA-600 krhpfh_03-1210故障处理
- 19c库启动报ORA-600 kcbzib_kcrsds_1
- DBMS_SESSION.set_context提示ORA-01031问题解决
- redo写丢失导致ORA-600 kcrf_resilver_log_1故障
- 硬件故障导致ORA-01242 ORA-01122等错误
- 200T 数据库非归档无备份恢复
- 利用flashback快速恢复failover 的备库
- [comingback2022@cock.li].eking和[tsai.shen@mailfence.com].faust扩展名勒索病毒数据库可以完美恢复
- opatch auto 出现unable to get oracle owner for 错误
- Oracle 23ai 表和视图的列最多支持到4096个
- 断电引起redo和数据文件不一致故障恢复
- ORA-03113: 通信通道的文件结尾
- Oracle 23ai True Cache搭建和基本测试
- Oracle 支持GB18030-2022
- 手工对multipath设备进行授权导致asm 磁盘组mount报ORA-15032-ORA-15131
- Oracle23ai新特性—sqlplus errordetails功能
- Oracle23ai新特性—SCHEMA级授权( grant select any table on schema)
- 存储宕机导致Oracle异常故障处理
- Oracle 23ai依旧支持bbed
- oracle 23ai(23.5.0.24.07)完整功能版安装体验
- win平台安装oracle遭遇INS-30131处理
- 配置win环境ssh和sftp并实现免密登录
- 11.2.0.4最新psu-202407
- Oracle 19c 2024.07补丁(RUs+OJVM)
- ORA-00756 ORA-10567故障处理
- ORA-01092 ORA-00604 ORA-08103故障处理
- 数据库启动报ORA-600 6711故障分析处理
Contributors