Solved

Any good Link to Oracle DUL (Disk UnLoad)

Posted on 2003-11-23
5
2,515 Views
Last Modified: 2008-03-17
Hi All,
 
    Is there any good link to DownLoad the Disk UnLoad utility in oracle, Because i need it very urgent in my concern as i have lost datas and needed the scripts. Can Anyone help me out in getting me the Disk UnLoad (Oracle DUL) utility.

regards,

karthikeyan.t.
0
Comment
Question by:shankarthi_78
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 35

Expert Comment

by:Mark Geerlings
ID: 9811287
I don't recognize that utility (Disk Unload Utility) as being an Oracle product.  Is this a utility you are familiar with in another database, like maybe SQL Server, or DB2?

Or can you give us more details on what kind of data recovery you need to do?  Please tell us:
1. Which version of Oracle you have
2. You server's operating system
3. Do you have backups you can use?
4. Is the database in archivelog mode?
5. Do you have export dump files you can use?
6. What kind of data is lost (some records from one table, an entire table, multiple tables, a tablespace data file, etc.)?
0
 

Author Comment

by:shankarthi_78
ID: 9815525
Hi,

   We have Oracle 9.2i and O.S. is win2k advanced server. Yeah we do have backups and the database is in archivelogmode and i donot have the export dump and by some error one of my collegue has recreated the table using plsql developer editor which he should not have some we have lost data for one week and as ours is a very small organisation we donot have Oracle DBA as such .  I am a Oracle Developer here working in database, forms, reports and incharge of the Oracle Database and throu' my friends i have tried to recover the database using the following steps which till now yielded no result. Do guide me.

  1. Shutdown the database.

  2. Copy the backup fies to the original location.

  3. startup the database in the mount mode.

  4. issue the command "recover database until time .... (or) cancel using backup controlfile"

  5. alter database open resetlogs

but the error says that the following error.

ORA-00279: change 11315435 generated at 11/25/2003 09:18:44 needed for thread 1
ORA-00289: suggestion : D:\ORACLE\RDBMS\ARC00001.001
ORA-00280: change 11315435 for thread 1 is in sequence #1

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

if i give AUTO says

ORA-00328: archived log ends at change 3416457, need later change 11315435
ORA-00334: archived log: 'D:\ORACLE\RDBMS\ARC00001.001'

and when i tried the datafile where the tables are stored is ONLINE now.

then i issue the command
 
ALTER DATABASE OPEN RESETLOGS

if i do this then the database gets started but the datafile goes to OFFLINE automatically.

pls do guide me.

regards,

karthikeyan.t.
0
 
LVL 35

Accepted Solution

by:
Mark Geerlings earned 20 total points
ID: 9817745
The recovery steps you tried look correct to me.  Do you have all of the archived redo logs from the time of the last backup until the time of the error?  If so, the recovery should succeed.

I am surprised though that the recovery wants to start with the very first archived redo log.  Was the database in archivelog mode at the time of the problem?  Or did someone change it to archivelog mode later?  Or, maybe the "ALTER DATABASE OPEN RESETLOGS" succeeded, at least in terms of resetting the archive sequence number to zero, but without restoring the data you need.

From now on, please do regular exports as well as backups.  From an export, it is much easier to recover an individual table than it is from a backup.

Another option for you may be to create a new Oracle instance, then use it to open the backed up data files and export the table you need, then shut that down, open your main database and import that table.
0
 

Author Comment

by:shankarthi_78
ID: 9822482
Hi,

   Can you just explain me how to open a backed up datafile from a new oracle instance, i am not able to open the file. if i am able to open the backup files in the new oracle instance i will retrieve  using oracle export, but i am not able to open the datafile.

do help me

regards,

karthikeyan.t.
0
 
LVL 35

Expert Comment

by:Mark Geerlings
ID: 9824822
To do that you  will need to create a new control file for that instance.  The easiest way to do this is from your main instance.  I think you can do this even though you cannot open the database now.  Just do a "startup nomount" (or maybe it is a "startup mount") then:
alter database backup controlfile to trace;
Then you can find the resulting *.trc file in your background_dump_dest folder and edit it slightly for the new database.  You will also want a new init*.ora file (or spfile for Oracle9) for the new instance.
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question