Solved

Any good Link to Oracle DUL (Disk UnLoad)

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

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 34

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 34

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

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…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
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.

708 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now