[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恢复 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-08102 ORA-08103 ORA-600 2662 ORA-600 2663 ORA-600 4000 ORA-600 4137 ORA-600 4198 ORA-600[2662] ORA-600[3020] ORA-600[4194] 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咨询
-
最近发表
- obet快速修改scn/resetlogs恢复数据库(缺少归档,ORA-00308)
- 使用DBMS_PDB.RECOVER抢救单个pdb
- aix环境写入大文件设置combehin提高效率
- 记录一次国产数据库被rm -rf /*删除的救援过程
- 数据库启动报 maximum number of processes () exceeded分析
- ORA-600 [ksunfy : too few sessions]
- 由于数据块scn大于数据库scn导致ORA-600 kcbzib_kcrsds_1错误
- ORA-600 ktbair2: illegal inheritance恢复
- 一键恢复ORA-00704 ORA-00702故障—202512
- Into the Black Box: The Hidden Secrets of Oracle’s Cost-Based Optimizer That Will Change How You Think About SQL
- Oracle AWR报告指标全解析(优化排版)
- PostgreSQL查询一个表相关的所有oid
- PostgreSQL oid文件替换实现数据访问
- The High Cost of Redundancy: A Forensic Analysis of Oracle ASM Design Flaws
- 仲家帝国的军事解剖:袁术阵营军制与战斗力虚弱之深层研究报告
- 模拟sql server故障备份完成恢复实现数据0丢失
- Oracle Database Global Installation Base & Regional Market Analysis Report 2024-2025
- sql server 事务日志备份异常恢复案例
- win平台挂起Oracle数据库启动进程
- linux异常磁盘lvm恢复操作演示
- open数据库报ora-600 kdsgrp1故障处理
- 历史abc
- expdp dmp 导出不完整导入ORA-39059 ORA-39246 故障抢救数据
- mysql drop database 恢复思路
- PRVG-11975 : The I/O scheduler parameter of device “/dev/sdm” did not match the expected value on nodes
- obet(Oracle Block Editor Tool)第二版发布
- Oracle数据块编辑工具( Oracle Block Editor Tool)-obet
- Oracle坏块修复工具:Patch_blk
- ORA-01172 ORA-01151故障处理
- C_OBJ#_INTCOL#坏块导致数据库无法open故障处理
- ORA-600 kkkicreatecgmap:!efn3
- Oracle 19c 202510补丁(RUs+OJVM)-19.29
- 记录一次raid恢复之后数据库故障处理(ora-01200,ORA-26101,ORA-600)
- nbu备份文件img格式直接rman恢复
- ORA-600 kokasgi1故障处理(sys被重命名)
- Patch_SCN for Linux 功能完善
- ORA-600 2662错误处理-202510
- system表空间丢失部分文件恢复
- arm环境vg损坏mysql数据库恢复
- redhat系列7/8进入单用户模式
- Failed to open EFIredhatgrubx64.efi – Not Found 故障处理
- 11.2.0.4升级到19c详细操作过程
- Postgres数据库truncate表无有效备份恢复
- 一次幸运的ORA-07445 kdxlin故障恢复
- ORA-704 ORA-604 ORA-1426故障分析处理
- ORA-600 4194引起SMON encountered 100 out of maximum 100 non-fatal internal errors故障
- docker回收和mysql备份导入导致数据丢失恢复
- 服务器断电一起的一例ORA-01207故障处理
- RMAN SBT_TAPE备份通过小程序修改实现直接DISK通道还原
- 删除数据库文件并部分覆盖情况下Oracle恢复
Contributors

