Solved

Any good Link to Oracle DUL (Disk UnLoad)

Posted on 2003-11-23
5
2,495 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
  • 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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

786 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