[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-00333 ORA-00340 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-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-27072 oracle dul Oracle recover oracle异常恢复 Oracle 恢复 ORACLE恢复
WP Cumulus Flash tag cloud by 惜分飞 requires Flash Player 9 or better.
QQ咨询
-
最近发表
- rm -rf误删Oracle数据库恢复
- 分布式存储故障导致数据库无法启动故障处理
- read_me_recover_tn勒索恢复
- WINDOWS 下用dg broker搭建ADG(单机to单机)
- 存储故障后oracle报—ORA-01122/ORA-01207故障处理
- Oracle 23ai rm redo*.log恢复
- Oracle 发布计划—包含Oracle 23ai版本
- Oracle 23ai 变化之—-默认数据文件变为bigfile
- PostgreSQL解析wal日志之—walminer
- Oracle 19c/21c最新patch信息-202404
- PostgreSQL恢复系列:pg_filedump批量处理
- PostgreSQL部分主要字典信息
- PostgreSQL恢复系列:pg_filedump恢复字典构造
- PostgreSQL 16 源码安装
- ORA-00742 ORA-00312 恢复
- 数据库open成功后报ORA-00353 ORA-00354错误引起的一系列问题(本质ntfs文件系统异常)
- ORA-600 ktsiseginfo1故障
- ORA-00600: internal error code, arguments: [16703], [1403], [4] 原因
- 最近遇到几起ORA-600 16703故障(tab$被清空),请引起重视
- ORA-600 2662快速恢复之Patch scn工具
- TNS-12518: TNS:listener could not hand off client connection
- ora.storage无法启动报ORA-12514故障处理
- 断电引起文件scn异常数据库恢复
- ORA-16188: LOG_ARCHIVE_CONFIG settings inconsistent with previously started instance
- .[hudsonL@cock.li].mkp勒索加密数据库完美恢复
- 模拟带库实现rman远程备份
- 又一例:ORA-600 kclchkblk_4和2662故障
- Oracle误删除数据文件恢复
- Oracle 19C 备库DML重定向—DML Redirection
- ORA-01595/ORA-600 4194处理
- 从ORA-00283 ORA-16433报错开始恢复
- 近期又遇到ORA-600 16703和ORA-702故障
- RECOVER_YOUR_DATA勒索恢复
- ORA-01033: ORACLE initialization or shutdown in progress 故障处理
- Oracle 19c/21c最新patch信息-202401
- 存储故障,强制拉库报ORA-600 kcbzib_kcrsds_1处理
- ORA-600 kcrf_resilver_log_1故障处理
- ORA-00600: internal error code, arguments: [4193], [35191], [35263]
- mysql数据库被黑恢复—应用层面delete删除
- ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], []
- 记录一次ORA-01200完美恢复
- 如何拯救一个10多年的老库
- kfed修复ORA-15196
- 在线mv方式迁移数据文件导致数据库无法正常启动
- resetlogs失败故障恢复-ORA-01555
- ORA-01113 ORA-01110错误不一定都要Oracle Recovery Tools解决
- ssd trim导致fdisk格式化磁盘之后无法恢复
- kettle导致MySQL数据丢失恢复
- ORA-600 3020/ORA-600 2662故障
- MySQL数据库文件丢失恢复
Contributors