dul实验（expdp）

最新推荐文章于 2021-02-28 00:06:22 发布
最新推荐文章于 2021-02-28 00:06:22 发布
阅读量2k 收藏
点赞数
分类专栏： oracle 文章标签： character list table oracle object null
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/rgb_rgb/article/details/7984840
版权 
准备数据：

[oracle@sgpc146 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Fri Sep 16 16:48:06 2011

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning and Automatic Storage Management options

SQL> select count(1) from "000".tcyang;

  COUNT(1)
----------
    229728

Elapsed: 00:00:00.03
SQL> 

[oracle@sgpc146 ~]$ expdp userid=\"/ as sysdba\" DIRECTORY=DATA_EXP dumpfile=sgerp5_tcyang.bak logfile=sgerp5_`date +%b_%d_%H_%M_%S`.log tables="000".tcyang

Export: Release 11.2.0.3.0 - Production on Fri Sep 16 16:48:46 2011

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning and Automatic Storage Management options
Starting "SYS"."SYS_EXPORT_TABLE_01":  userid="/******** AS SYSDBA" DIRECTORY=DATA_EXP dumpfile=sgerp5_tcyang.bak logfile=sgerp5_Sep_16_16_48_46.log tables=000.tcyang 
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 25 MB
Processing object type TABLE_EXPORT/TABLE/TABLE
. . exported "000"."TCYANG"                              20.57 MB  229728 rows
Master table "SYS"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_TABLE_01 is:
  /orabak/expdp/sgerp5_tcyang.bak
Job "SYS"."SYS_EXPORT_TABLE_01" successfully completed at 16:48:56

[oracle@sgpc146 ~]$ 


dul处理数据：

[oracle@sgpc146 s01]$ ./dul 

Data UnLoader: 10.2.0.5.8 - Internal Only - on Fri Sep 16 16:52:56 2011
with 64-bit io functions

Copyright (c) 1994 2011 Bernard van Duijnen All rights reserved.

 Strictly Oracle Internal Use Only


DUL: Warning: Recreating file "dul.log"
Reading SCANNEDLOBPAGE.dat 0 entries loaded and sorted 0 entries
Reading SEG.dat 0 entries loaded
Reading EXT.dat 0 entries loaded and sorted 0 entries
Reading COMPATSEG.dat 0 entries loaded

DUL> unpump header dump file /orabak/expdp/sgerp5_tcyang.bak; 
Version is 769
check sum is 1861360017
data pump id is 6783164
master_obj_no is 15237
header blocks is 1
data pump file number is 1
block size is 4096
character set id is 852
master table block offset is 5269
(Master table is at byte offset (5269 -1) * 4096 = 21577728)
master table size is 89712

DUL> unpump scan dump file /orabak/expdp/sgerp5_tcyang.bak; 
Magic number found at offset 4096
Magic number found at offset 21577728

DUL> unpump stream header dump file /orabak/expdp/sgerp5_tcyang.bak  from 4096; 
magic number is 0xffff2424
version is 10
flags is 0x00
meta data length is 6853
relative meta data offset is 4096
table data length is 21560208
relative table data offset is 10952
granule length is 24
relative granule offset is 21571160
Table data from 15048 until 21575256
Meta data character set is 852, ZHS16GBK
<?xml version="1.0"?><ROWSET><ROW>
  <STRMTABLE_T><VERS_MAJOR>1</VERS_MAJOR><VERS_MINOR>2 </VERS_MINOR><VERS_DPAPI>3</VERS_DPAPI><ENDIANNESS>2</ENDIANNESS><CHARSET>ZHS16GBK</CHARSET><NCHARSET>AL16UTF16</NCHARSET><DBTIMEZONE>+08:00</DBTIMEZONE><FDO>0000006001240F050B0C030C0C0504050D0609070805050505050F05050505050A050505050504050607080823472347081123081141B0470083035407D00300000000000000000000000000000000000000000000000000000000000000000000000000</FDO><OBJ_NUM>15234</OBJ_NUM><OWNER_NAME>000</OWNER_NAME><NAME>TCYANG</NAME><PROPERTY>536870912</PROPERTY><COL_LIST><COL_LIST_ITEM><OBJ_NUM>15234</OBJ_NUM><COL_NUM>1</COL_NUM><INTCOL_NUM>1</INTCOL_NUM><SEGCOL_NUM>1</SEGCOL_NUM><COL_SORTKEY>1</COL_SORTKEY><BASE_INTCOL_NUM>1</BASE_INTCOL_NUM><BASE_COL_TYPE>0</BASE_COL_TYPE><PROPERTY>14336</PROPERTY><NAME>OWNER</NAME><TYPE_NUM>1</TYPE_NUM><LENGTH>30</LENGTH><NOT_NULL>0</NOT_NULL><CHARSETID>852</CHARSETID><CHARSETFORM>1</CHARSETFORM><CHARLENGTH>30</CHARLENGTH></COL_LIST_ITEM><COL_LIST_ITEM><OBJ_NUM>15234</OBJ_NUM><COL_NUM>2</COL_NUM><INTCOL_NUM>2</INTCOL_NUM><SEGCOL_NUM>2</SEGCOL_NUM><COL_SORTKEY>2</COL_SORTKEY><BASE_INTCOL_NUM>2</BASE_INTCOL_NUM><BASE_COL_TYPE>0</BASE_COL_TYPE><PROPERTY>14336</PROPERTY><NAME>OBJECT_NAME</NAME><TYPE_NUM>1</TYPE_NUM><LENGTH>128</LENGTH><NOT_NULL>0</NOT_NULL><CHARSETID>852</CHARSETID><CHARSETFORM>1</CHARSETFORM><CHARLENGTH>128</CHARLENGTH></COL_LIST_ITEM><COL_LIST_ITEM><OBJ_NUM>15234</OBJ_NUM><COL_NUM>3</COL_NUM><INTCOL_NUM>3</INTCOL_NUM><SEGCOL_NUM>3</SEGCOL_NUM><COL_SORTKEY>3</COL_SORTKEY><BASE_INTCOL_NUM>3</BASE_INTCOL_NUM><BASE_COL_TYPE>0</BASE_COL_TYPE><PROPERTY>14336</PROPERTY><NAME>SUBOBJECT_NAME</NAME><TYPE_NUM>1</TYPE_NUM><LENGTH>30</LENGTH><NOT_NULL>0</NOT_NULL><CHARSETID>852</CHARSETID><CHARSETFORM>1</CHARSETFORM><CHARLENGTH>30</CHARLENGTH></COL_LIST_ITEM><COL_LIST_ITEM><OBJ_NUM>15234</OBJ_NUM><COL_NUM>4</COL_NUM><INTCOL_NUM>4</INTCOL_NUM><SEGCOL_NUM>4</SEGCOL_NUM><COL_SORTKEY>4</COL_SORTKEY><BASE_INTCOL_NUM>4</BASE_INTCOL_NUM><BASE_COL_TYPE>0</BASE_COL_TYPE><PROPERTY>14336</PROPERTY><NAME>OBJECT_ID</NAME><TYPE_NUM>2</TYPE_NUM><LENGTH>22</LENGTH><NOT_NULL>0</NOT_NULL><CHARSETID>0</CHARSETID><CHARSETFORM>0</CHARSETFORM><CHARLENGTH>0</CHARLENGTH></COL_LIST_ITEM><COL_LIST_ITEM><OBJ_NUM>15234</OBJ_NUM><COL_NUM>5</COL_NUM><INTCOL_NUM>5</INTCOL_NUM><SEGCOL_NUM>5</SEGCOL_NUM><COL_SORTKEY>5</COL_SORTKEY><BASE_INTCOL_NUM>5</BASE_INTCOL_NUM><BASE_COL_TYPE>0</BASE_COL_TYPE><PROPERTY>14336</PROPERTY><NAME>DATA_OBJECT_ID</NAME><TYPE_NUM>2</TYPE_NUM><LENGTH>22</LENGTH><NOT_NULL>0</NOT_NULL><CHARSETID>0</CHARSETID><CHARSETFORM>0</CHARSETFORM><CHARLENGTH>0</CHARLENGTH></COL_LIST_ITEM><COL_LIST_ITEM><OBJ_NUM>15234</OBJ_NUM><COL_NUM>6</COL_NUM><INTCOL_NUM>6</INTCOL_NUM><SEGCOL_NUM>6</SEGCOL_NUM><COL_SORTKEY>6</COL_SORTKEY><BASE_INTCOL_NUM>6</BASE_INTCOL_NUM><BASE_COL_TYPE>0</BASE_COL_TYPE><PROPERTY>14336</PROPERTY><NAME>OBJECT_TYPE</NAME><TYPE_NUM>1</TYPE_NUM><LENGTH>19</LENGTH><NOT_NULL>0</NOT_NULL><CHARSETID>852</CHARSETID><CHARSETFORM>1</CHARSETFORM><CHARLENGTH>19</CHARLENGTH></COL_LIST_ITEM><COL_LIST_ITEM><OBJ_NUM>15234</OBJ_NUM><COL_NUM>7</COL_NUM><INTCOL_NUM>7</INTCOL_NUM><SEGCOL_NUM>7</SEGCOL_NUM><COL_SORTKEY>7</COL_SORTKEY><BASE_INTCOL_NUM>7</BASE_INTCOL_NUM><BASE_COL_TYPE>0</BASE_COL_TYPE><PROPERTY>14336</PROPERTY><NAME>CREATED</NAME><TYPE_NUM>12</TYPE_NUM><LENGTH>7</LENGTH><NOT_NULL>0</NOT_NULL><CHARSETID>0</CHARSETID><CHARSETFORM>0</CHARSETFORM><CHARLENGTH>0</CHARLENGTH></COL_LIST_ITEM><COL_LIST_ITEM><OBJ_NUM>15234</OBJ_NUM><COL_NUM>8</COL_NUM><INTCOL_NUM>8</INTCOL_NUM><SEGCOL_NUM>8</SEGCOL_NUM><COL_SORTKEY>8</COL_SORTKEY><BASE_INTCOL_NUM>8</BASE_INTCOL_NUM><BASE_COL_TYPE>0</BASE_COL_TYPE><PROPERTY>14336</PROPERTY><NAME>LAST_DDL_TIME</NAME><TYPE_NUM>12</TYPE_NUM><LENGTH>7</LENGTH><NOT_NULL>0</NOT_NULL><CHARSETID>0</CHARSETID><CHARSETFORM>0</CHARSETFORM><CHARLENGTH>0</CHARLENGTH></COL_LIST_ITEM><COL_LIST_ITEM><OBJ_NUM>15234</OBJ_NUM><COL_NUM>9</COL_NUM><INTCOL_NUM>9</INTCOL_NUM><SEGCOL_NUM>9</SEGCOL_NUM><COL_SORTKEY>9</COL_SORTKEY><BASE_INTCOL_NUM>9</BASE_INTCOL_NUM><BASE_COL_TYPE>0</BASE_COL_TYPE><PROPERTY>14336</PROPERTY><NAME>TIMESTAMP</NAME><TYPE_NUM>1</TYPE_NUM><LENGTH>19</LENGTH><NOT_NULL>0</NOT_NULL><CHARSETID>852</CHARSETID><CHARSETFORM>1</CHARSETFORM><CHARLENGTH>19</CHARLENGTH></COL_LIST_ITEM><COL_LIST_ITEM><OBJ_NUM>15234</OBJ_NUM><COL_NUM>10</COL_NUM><INTCOL_NUM>10</INTCOL_NUM><SEGCOL_NUM>10</SEGCOL_NUM><COL_SORTKEY>10</COL_SORTKEY><BASE_INTCOL_NUM>10</BASE_INTCOL_NUM><BASE_COL_TYPE>0</BASE_COL_TYPE><PROPERTY>14336</PROPERTY><NAME>STATUS</NAME><TYPE_NUM>1</TYPE_NUM><LENGTH>7</LENGTH><NOT_NULL>0</NOT_NULL><CHARSETID>852</CHARSETID><CHARSETFORM>1</CHARSETFORM><CHARLENGTH>7</CHARLENGTH></COL_LIST_ITEM><COL_LIST_ITEM><OBJ_NUM>15234</OBJ_NUM><COL_NUM>11</COL_NUM><INTCOL_NUM>11</INTCOL_NUM><SEGCOL_NUM>11</SEGCOL_NUM><COL_SORTKEY>11</COL_SORTKEY><BASE_INTCOL_NUM>11</BASE_INTCOL_NUM><BASE_COL_TYPE>0</BASE_COL_TYPE><PROPERTY>14336</PROPERTY><NAME>TEMPORARY</NAME><TYPE_NUM>1</TYPE_NUM><LENGTH>1</LENGTH><NOT_NULL>0</NOT_NULL><CHARSETID>852</CHARSETID><CHARSETFORM>1</CHARSETFORM><CHARLENGTH>1</CHARLENGTH></COL_LIST_ITEM><COL_LIST_ITEM><OBJ_NUM>15234</OBJ_NUM><COL_NUM>12</COL_NUM><INTCOL_NUM>12</INTCOL_NUM><SEGCOL_NUM>12</SEGCOL_NUM><COL_SORTKEY>12</COL_SORTKEY><BASE_INTCOL_NUM>12</BASE_INTCOL_NUM><BASE_COL_TYPE>0</BASE_COL_TYPE><PROPERTY>14336</PROPERTY><NAME>GENERATED</NAME><TYPE_NUM>1</TYPE_NUM><LENGTH>1</LENGTH><NOT_NULL>0</NOT_NULL><CHARSETID>852</CHARSETID><CHARSETFORM>1</CHARSETFORM><CHARLENGTH>1</CHARLENGTH></COL_LIST_ITEM><COL_LIST_ITEM><OBJ_NUM>15234</OBJ_NUM><COL_NUM>13</COL_NUM><INTCOL_NUM>13</INTCOL_NUM><SEGCOL_NUM>13</SEGCOL_NUM><COL_SORTKEY>13</COL_SORTKEY><BASE_INTCOL_NUM>13</BASE_INTCOL_NUM><BASE_COL_TYPE>0</BASE_COL_TYPE><PROPERTY>14336</PROPERTY><NAME>SECONDARY</NAME><TYPE_NUM>1</TYPE_NUM><LENGTH>1</LENGTH><NOT_NULL>0</NOT_NULL><CHARSETID>852</CHARSETID><CHARSETFORM>1</CHARSETFORM><CHARLENGTH>1</CHARLENGTH></COL_LIST_ITEM><COL_LIST_ITEM><OBJ_NUM>15234</OBJ_NUM><COL_NUM>14</COL_NUM><INTCOL_NUM>14</INTCOL_NUM><SEGCOL_NUM>14</SEGCOL_NUM><COL_SORTKEY>14</COL_SORTKEY><BASE_INTCOL_NUM>14</BASE_INTCOL_NUM><BASE_COL_TYPE>0</BASE_COL_TYPE><PROPERTY>14336</PROPERTY><NAME>NAMESPACE</NAME><TYPE_NUM>2</TYPE_NUM><LENGTH>22</LENGTH><NOT_NULL>0</NOT_NULL><CHARSETID>0</CHARSETID><CHARSETFORM>0</CHARSETFORM><CHARLENGTH>0</CHARLENGTH></COL_LIST_ITEM><COL_LIST_ITEM><OBJ_NUM>15234</OBJ_NUM><COL_NUM>15</COL_NUM><INTCOL_NUM>15</INTCOL_NUM><SEGCOL_NUM>15</SEGCOL_NUM><COL_SORTKEY>15</COL_SORTKEY><BASE_INTCOL_NUM>15</BASE_INTCOL_NUM><BASE_COL_TYPE>0</BASE_COL_TYPE><PROPERTY>14336</PROPERTY><NAME>EDITION_NAME</NAME><TYPE_NUM>1</TYPE_NUM><LENGTH>30</LENGTH><NOT_NULL>0</NOT_NULL><CHARSETID>852</CHARSETID><CHARSETFORM>1</CHARSETFORM><CHARLENGTH>30</CHARLENGTH></COL_LIST_ITEM></COL_LIST></STRMTABLE_T></ROW></ROWSET>

  DUL> unpump table "000"."TCYANG" ("OWNER" VARCHAR2(30), "OBJECT_NAME" VARCHAR2(128), "SUBOBJECT_NAME" VARCHAR2(30), "OBJECT_ID" NUMBER, "DATA_OBJECT_ID" NUMBER, "OBJECT_TYPE" VARCHAR2(19), "CREATED" DATE, "LAST_DDL_TIME" DATE, "TIMESTAMP" VARCHAR2(19), "STATUS" VARCHAR2(7), "TEMPORARY" VARCHAR2(1), "GENERATED" VARCHAR2(1), "SECONDARY" VARCHAR2(1), "NAMESPACE" NUMBER, "EDITION_NAME" VARCHAR2(30)) dump file /orabak/expdp/sgerp5_tcyang.bak from 15048 until 21575256;
229728 rows unloaded
DUL> exit

Life is DUL without it
[oracle@sgpc146 s01]$ 

验证数据：  

SQL> truncate table "000".tcyang;

Table truncated.

Elapsed: 00:00:00.03
SQL> 
[oracle@sgpc146 s01]$ sqlldr userid=\"/ as sysdba\" control=/s01/000_TCYANG.ctl log=/s01/tcyang.log
Commit point reached - logical record count 229545
Commit point reached - logical record count 229609
Commit point reached - logical record count 229673
Commit point reached - logical record count 229728
[oracle@sgpc146 s01]$ more tcyang.log

SQL*Loader: Release 11.2.0.3.0 - Production on Fri Sep 16 17:21:47 2011

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Control File:   /s01/000_TCYANG.ctl
Data File:      000_TCYANG.dat
  Bad File:     /s01/000_TCYANG.bad
  Discard File:  none specified
 
 (Allow all discards)

Number to load: ALL
Number to skip: 0
Errors allowed: 50
Bind array:     64 rows, maximum of 256000 bytes
Continuation:    none specified
Path used:      Conventional

Table "000"."TCYANG", loaded from every logical record.
Insert option in effect for this table: INSERT

   Column Name                  Position   Len  Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
"OWNER"                             FIRST    10  WHT   |  CHARACTER            
"OBJECT_NAME"                        NEXT    30  WHT   |  CHARACTER            
"SUBOBJECT_NAME"                     NEXT    27  WHT   |  CHARACTER            
"OBJECT_ID"                          NEXT     5  WHT   |  CHARACTER            
"DATA_OBJECT_ID"                     NEXT     5  WHT   |  CHARACTER            
"OBJECT_TYPE"                        NEXT    18  WHT   |  CHARACTER            
"CREATED"                            NEXT     *  WHT   |  DATE DD-MON-YYYY AD HH24:MI:SS
"LAST_DDL_TIME"                      NEXT     *  WHT   |  DATE DD-MON-YYYY AD HH24:MI:SS
"TIMESTAMP"                          NEXT    19  WHT   |  CHARACTER            
"STATUS"                             NEXT     5  WHT   |  CHARACTER            
"TEMPORARY"                          NEXT     1  WHT   |  CHARACTER            
"GENERATED"                          NEXT     1  WHT   |  CHARACTER            
"SECONDARY"                          NEXT     1  WHT   |  CHARACTER            
"NAMESPACE"                          NEXT     2  WHT   |  CHARACTER            


Table "000"."TCYANG":
  229728 Rows successfully loaded.
  0 Rows not loaded due to data errors.
  0 Rows not loaded because all WHEN clauses were failed.
  0 Rows not loaded because all fields were null.


Space allocated for bind array:                  43008 bytes(64 rows)
Read   buffer bytes: 1048576

Total logical records skipped:          0
Total logical records read:        229728
Total logical records rejected:         0
Total logical records discarded:        0

Run began on Fri Sep 16 17:21:47 2011
Run ended on Fri Sep 16 17:21:53 2011

Elapsed time was:     00:00:06.18
CPU time was:         00:00:01.66
SQL> select count(1) from "000".tcyang;

  COUNT(1)
----------
    229728

Elapsed: 00:00:00.03
SQL>


 

rgb_rgb
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
oracle恢复工具DUL
04-29
DUL数据库恢复实战步骤.DUL支持多级别安全标签(MLSLABEL) ， 支持VARRAY，OBJECT类型列，也支持嵌套表。DUL在Unload过程中不会考虑到数据库一致性，它假定所有数据文件中的数据都是已经提交了的，没有了数据一致性的...
Oracle DUL Data Unloader数据恢复工具信息汇总
热门推荐
ORACLE数据库数据恢复、性能优化、故障诊断来问问MACLEAN
09-05 1万+
Oracle DUL 是Oracle公司内部的数据库恢复工具，由在荷兰的Oracle Support，Bernard van Duijnen开发： DUL不是Oracle的一个产品 DUL不是一个受Oracle支持的产品 DUL被严格限制为Oracle Support售后支持部门内部使用 DUL的使用在国外需要经过Oracle公司的内部审批，首先你必须购买了Oracle的标准服务PS才可能用到DUL，否则甚至没有资格使用DUL DUL被严格控制的一个原因是其采用了部分Oracle源代码，所以必须被严格控制
dul 10支持oracle 11g r2
好读书，每有会意，便欣然忘食。
03-20 1099
联系：手机(13429648788) QQ(107644445) 链接：http://www.xifenfei.com/3601.html 以前一直以为dul对应的版本只能恢复最高的数据库版本一致,今天测试发现dul 10可以恢复11g最新版的数据库. 模拟环境 SQL> select * from v$version;   BANNER -
Mysql对应的dul_DUL 恢复简单表测试
weixin_35949857的博客
02-28 211
--1. 构造测试数据SQL>alterdatabasedatafile'/oracle/app/oracle/oradata/test/users01.dbf'resize100m;SQL>createtableducw.test_dultablespaceusers2as3select*fromdba_objects;SQL>select...
Life is DUL without it:DUL流程
cuidai1555的博客
01-31 84
文章在IT168门户的链接地址: http://tech.it168.com/db/2007-11-22/200711221218875.shtml ...
Oracle dmp文件损坏恢复案例
oradh的专栏
06-17 5451
前一段时间帮一个朋友的朋友恢复了一个损坏的dmp文件，大概100多个G，记录一下恢复过程并简单总结一下
最新版DUL工具
07-27
在oracle数据库崩溃了，完全打不开的情况下，可以用这个工具将数据从数据文件的数据块中抽取出来生成sql文件，然后数据可以通过这个文件再次导入到新的oracle数据库中。
oracle DUL工具
11-11
有关Oracle DUL工具的详细使用方法及操作步骤。
dul 数据恢复工具
07-28
oracle dul数据恢复工具 及使用方法 用于恢复oracle 误删数据
DUL5108.zip
04-20
Oracle数据恢复工具，本人亲试成功（重装系统导致数据丢失，已恢复），前提是DBF文件还存在，此工具还适合更复杂的数据丢失恢复，请参照使用说明
测试，ogg从归档日志中抽取数据
文档搬运工
06-06 3960
测试原理，停掉源端和目标端的OGG， 在源端进行DML操作，然后切换日志。然后开启源端和目标端的OGG。看看是否会同步数据到目标端。另外查看源端的ext进程日志，看里面的提示。结论： OGG 在停掉后，进行大批量的DML操作，然后多次切换日志后。再次开启OGG，会从OGG中断时候的归档日志开始抽取数据。测试过程如下：停掉mgr 和其他的进程GGSCI (test.us.oracle.com) 10...
DUL Oracle Data Unloader工具下载
ORACLE数据库数据恢复、性能优化、故障诊断来问问MACLEAN
11-03 3481
Oracle DUL 是Oracle公司内部的数据库恢复工具，由在荷兰的Oracle Support，Bernard van Duijnen开发： DUL不是Oracle的一个产品DUL不是一个受Oracle支持的产品DUL被严格限制为Oracle Support售后支持部门内部使用DUL的使用在国外需要经过Oracle公司的内部审批，首先你必须购买了Oracle的标准服务PS才可能用到DU
DUL 更新2016
congai5640的博客
03-23 206
Oracle恢复（DUL+ODU） 背景：经分数据集市2库准备迁移，业务人员误操作将一个表空间从数据库中直接drop掉，且此部分数据为配置表，无法通过应用来恢复，需要通过其他手段来恢复数据。数据...
正确停止expdp导出任务
HII mate , It's Frank ~
01-06 2907
今天在执行导出时磁盘剩余量不够了，想提前终止expd导出任务，于是就按ctr  + c 中进入export交互界面，然后exit退出然后查看操作系统进程发现没有expdp进程了以为就是停掉了，但发现导出的dmp文件还在一直增加，其实任务并没有停止。    如下验证结果： 1.expdp执行导出操作，然后按ctr  + c  + exit 退出 [Oracle@database ~
expdp 迁移测试
cuanshao4773的博客
09-05 106
以下操作需要数据库服务器上操作，如果需要远程操作请参阅http://blog.itpub.net/24486203/viewspace-2132814/ 1.源库创建directory目录 sqlplus / as sysd...
Multiple versions of Spark are installed but SPARK_MAJOR_VERSION is not set问题
大头皮鞋的博客
05-27 884
使用spark-submit提交应用时，出现如下问题： Multiple versions of Spark are installed but SPARK_MAJOR_VERSION is not set Spark1 will be picked by default 那么Spark存在多个版本时，默认使用Spark1.x $ spark-submit --version Multi...
oracle dul 使用及文件
cnz98144的博客
10-27 124
oracle dul.ZIP ...
ORACLE dul 工具使用说明， [ID 465478.1] Note 72554.1
Wonderful's DBA Story
07-18 1781
故事猪脚：Oracle DUL (Data unloader) Reference>Note 72554.1(因为是内部文档，故该note已经无法打开) Title：Using DUL to Recover fromDatabase Corruption  Table Of Contents ~~~~~~~~~~~~~~~~~ 1. Introduction
SQLLDR—CTL文件
weixin_33711641的博客
12-12 7788
SQLLDR 可以把一些以文本格式存放的数据顺利的导入到oracle数据库中，是一种在不同数据库之间进行数据迁移的非常方便而且通用的工具。缺点就速度比较慢，另外对blob等类型的数据不方便。 CTL 文件介绍 第一部分 1、LOAD DATA：通常以此为开头，其前可加如下参数： 2、UNRECOVERABLE：表示数据不可恢复 3、RECOVERABL...
oracle dul
最新发布
02-06
通过DUL工具可以快速、方便地将数据库中的数据备份到外部文件中，当数据库出现故障或者丢失数据时，可以通过DUL工具将备份的数据恢复到数据库中，保证数据的完整性和安全性。 总的来说，Oracle DUL是一个功能强大的...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值