OraFAQ Forum: Backup & Recovery » who can tell me how to use the DUL

Home » RDBMS Server » Backup & Recovery » who can tell me how to use the DUL

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

who can tell me how to use the DUL [message #150479]

Thu, 08 December 2005 02:06

lazycat
Messages: 57
Registered: November 2005

Member

i want to use DUL to read the data
from the datafile

how to

Report message to a moderator

Re: who can tell me how to use the DUL [message #150728 is a reply to message #150479]

Fri, 09 December 2005 06:08

Frank Naude
Messages: 4579
Registered: April 1998

Senior Member

DUL is a complicated utility that is not sutable for new DBA's. Start by reading the supplied documentation. If you don't you will never manage to get it to work.

In short:

If you can unload dictionary tables (SYSTEM tablespace is available):

1. Create a init.dul file as per the config guide.
2. Create a control.dul file as per the config guide.
3. Unload dictionary tables with:

$ dul dictv??.ddl

4. Unload the data:

dul> UNLOAD TABLE ...;
dul> quit

If not, follow these steps:

1. Create a init.dul file as per the config guide.
2. Create a control.dul file as per the config guide.
3. Scan the DB for segment headers and extents:

dul> scan database;
dul> quit

4. Gather row statistics:

dul> scan tables;
dul> quit

5. Indentify the lost tables from output of step 4.
6. Unload the data:

dul> UNLOAD TABLE ...;
dul> quit

Best regards.

Frank

Report message to a moderator

Re: who can tell me how to use the DUL [message #150851 is a reply to message #150479]

Sun, 11 December 2005 03:20

lazycat
Messages: 57
Registered: November 2005

Member

can you send me the the detail docoument
thank you

Report message to a moderator

Re: who can tell me how to use the DUL [message #150856 is a reply to message #150479]

Sun, 11 December 2005 04:05

lazycat
Messages: 57
Registered: November 2005

Member

dictv8.ddl how to make the file
DUL: FATAL Error: Could not fopen("dictv8.ddl","r")
OS error 2: No such file or directory

Report message to a moderator

Re: who can tell me how to use the DUL [message #150897 is a reply to message #150479]

Sun, 11 December 2005 21:10

lazycat
Messages: 57
Registered: November 2005

Member

after scan database

i have recive the
DUL> unload user tzdgm
2 ;
About to unload TZDGM's tables ...
. unloading table DGM_3
DUL: Error: Block Type 35, not a segment header type
DUL: Error: While processing block ts#=9, file#=37, block#=311699
0 rows unloaded
. unloading table DGM_2
DUL: Error: Block Type 35, not a segment header type
DUL: Error: While processing block ts#=9, file#=37, block#=238899
0 rows unloaded
. unloading table DGM_4
DUL: Error: Block Type 35, not a segment header type
DUL: Error: While processing block ts#=9, file#=37, block#=344491
0 rows unloaded
. unloading table DGM_1
DUL: Error: Block Type 35, not a segment header type
DUL: Error: While processing block ts#=9, file#=16, block#=153051
0 rows unloaded
. unloading table SYS_DATA_PROM_1123
DUL: Error: Block Type 35, not a segment header type
DUL: Error: While processing block ts#=9, file#=25, block#=169171
0 rows unloaded
. unloading table SYS_DATA_PROM
DUL: Error: Block Type 35, not a segment header type
DUL: Error: While processing block ts#=9, file#=36, block#=275803
0 rows unloaded
. unloading table DGM_5
DUL: Error: Block Type 35, not a segment header type
DUL: Error: While processing block ts#=9, file#=37, block#=367411
0 rows unloaded
. unloading table DGM_6
DUL: Error: Block Type 35, not a segment header type
DUL: Error: While processing block ts#=9, file#=37, block#=370083
0 rows unloaded
. unloading table SYS_RIGHT
DUL: Error: Block Type 35, not a segment header type
DUL: Error: While processing block ts#=9, file#=59, block#=631755
0 rows unloaded
. unloading table SYS_OPER
DUL: Error: Block Type 35, not a segment header type
DUL: Error: While processing block ts#=9, file#=59, block#=631779
0 rows unloaded
. unloading table ZPH_0822_01
DUL: Error: Block Type 35, not a segment header type
DUL: Error: While processing block ts#=9, file#=70, block#=879011
0 rows unloaded
. unloading table ZPH_0809_A1
DUL: Error: Block Type 35, not a segment header type
DUL: Error: While processing block ts#=9, file#=70, block#=879003
0 rows unloaded
. unloading table ZPH_0809_A2
DUL: Error: Block Type 35, not a segment header type
DUL: Error: While processing block ts#=9, file#=70, block#=879019
0 rows unloaded

ALTER SESSION SET USE_SCANNED_EXTENT_MAP = TRUE;
DUL> unload user tzdgm;
About to unload TZDGM's tables ...
. unloading table DGM_3 0 rows unloaded
. unloading table DGM_2 0 rows unloaded
. unloading table DGM_4 0 rows unloaded
. unloading table DGM_1 0 rows unloaded
. unloading table SYS_DATA_PROM_1123 0 rows unloaded
. unloading table SYS_DATA_PROM 0 rows unloaded
. unloading table DGM_5 0 rows unloaded
. unloading table DGM_6 0 rows unloaded
. unloading table SYS_RIGHT 0 rows unloaded
. unloading table SYS_OPER 0 rows unloaded
. unloading table ZPH_0822_01 0 rows unloaded
. unloading table ZPH_0809_A1

Report message to a moderator

Re: who can tell me how to use the DUL [message #150899 is a reply to message #150479]

Sun, 11 December 2005 21:28

lazycat
Messages: 57
Registered: November 2005

Member

why all the table is o rows
in fact it have many rows

Report message to a moderator

Previous Topic:	who can help me
Next Topic:	how to find out export and import utilities version?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 23:31:03 CDT 2024