?
Solved

Any good Link to Oracle DUL (Disk UnLoad)

Posted on 2003-11-23
5
Medium Priority
?
2,532 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 80 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
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.
Suggested Courses

764 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