Home » RDBMS Server » Backup & Recovery » Can I create a dump file from a backup?
Can I create a dump file from a backup? [message #243720] Fri, 08 June 2007 11:33 Go to next message
cbooker
Messages: 8
Registered: July 2006
Junior Member
Hi all,

We have a 10.1.0.5 (Standard One edition) database and our backup strategy consists of:
a) the Oracle-suggested daily backups, plus
b) a monthly off-line, whole database backup.

Now I have a developer who wants to see the contents of one of our tables from a couple of weeks ago.

I have been over a bunch of Oracle documentation, and it looks like one way to do it is to set up a second instance and duplicate the database from a that point in time into the second instance.

All I really want to do though is get him the contents of that single table in any format that he can read. A text file would be fine.

Is it possible to create a DMP file or something similar from our backups without going through the trouble of creating a second instance?

Open to any simple suggestions. Thanks!

Cory
Re: Can I create a dump file from a backup? [message #243721 is a reply to message #243720] Fri, 08 June 2007 11:35 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
use table level import export
Re: Can I create a dump file from a backup? [message #243724 is a reply to message #243720] Fri, 08 June 2007 11:56 Go to previous messageGo to next message
cbooker
Messages: 8
Registered: July 2006
Junior Member
That sounds like exactly what I'm looking for, assuming I can export from just the backup files. Could you point me in the direction of some documentation on that? I don't see much in the Backup and Recovery docs on that. I'll poke around on Oracle's site too, but if you happen to have a link, that would be great.

Thanks again,
Cory
Re: Can I create a dump file from a backup? [message #243729 is a reply to message #243724] Fri, 08 June 2007 12:04 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
That sounds like exactly what I'm looking for, assuming I can export from just the backup files


You cant use export import on backup files.


Read This for import and export

http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14215/whatsnew.htm
Re: Can I create a dump file from a backup? [message #243743 is a reply to message #243720] Fri, 08 June 2007 13:09 Go to previous messageGo to next message
cbooker
Messages: 8
Registered: July 2006
Junior Member
It's entirely possible I'm being stupid here, but I have now gone over a bunch of the data pump export documentation (thanks for the link), and I'm not sure how it will help me in this case. I need to get the contents of the table as they were on May 31, and I don't see an option for looking "back" through the table's history.

I may have missed something obvious--wouldn't be the first time.

As always, thanks for your help so far!
Re: Can I create a dump file from a backup? [message #243744 is a reply to message #243743] Fri, 08 June 2007 13:17 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
I need to get the contents of the table as they were on May 31, and I don't see an option for looking "back" through the table's history.


what you means by contents??


What you means not data??

[Updated on: Fri, 08 June 2007 13:19]

Report message to a moderator

Re: Can I create a dump file from a backup? [message #243747 is a reply to message #243744] Fri, 08 June 2007 14:16 Go to previous messageGo to next message
cbooker
Messages: 8
Registered: July 2006
Junior Member
Ah, I'm with you now. I guess "contents" was a bit vague--sorry.

We're looking for what records were in the table on that day. There may be a bug in the program that uses the database which deleted some records, but to know for sure we have to compare the records just after May 30 vs. the records in there today.
Re: Can I create a dump file from a backup? [message #243754 is a reply to message #243747] Fri, 08 June 2007 15:33 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
you cant compare it now.theres only one possiblity restore your backup to another machine until may 30.
and from now onward you can daily take export the tables which you want to compare in future.
Re: Can I create a dump file from a backup? [message #243762 is a reply to message #243754] Fri, 08 June 2007 16:01 Go to previous messageGo to next message
cbooker
Messages: 8
Registered: July 2006
Junior Member
Sad That's what I was afraid of. Thanks anyway.
Re: Can I create a dump file from a backup? [message #243764 is a reply to message #243762] Fri, 08 June 2007 16:11 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
NP
Hope for future you can plan some better policy.

[Updated on: Fri, 08 June 2007 16:11]

Report message to a moderator

Re: Can I create a dump file from a backup? [message #243818 is a reply to message #243762] Sat, 09 June 2007 04:54 Go to previous messageGo to next message
balaji1010
Messages: 35
Registered: March 2006
Location: London
Member


Why dont you duplicate your database (auxiliary database), as it was on may 31st (i donno wheather it makes sense just for a table)

then you can get back the contents through exp / imp.

hope this helps

bye
Re: Can I create a dump file from a backup? [message #244129 is a reply to message #243818] Mon, 11 June 2007 12:30 Go to previous messageGo to next message
cbooker
Messages: 8
Registered: July 2006
Junior Member
balaji1010 wrote on Sat, 09 June 2007 02:54

Why dont you duplicate your database (auxiliary database), as it was on may 31st (i donno wheather it makes sense just for a table)



It looks like that's exactly what I have to do. I was just hoping there was an easier way. Thanks!
Re: Can I create a dump file from a backup? [message #244344 is a reply to message #243724] Tue, 12 June 2007 07:25 Go to previous message
kandhireddy
Messages: 4
Registered: May 2007
Junior Member
Hi,
I think this can be achived only with the following option.

1) restore the backup on some other server or some other location
2) create the control file with different database name if it is on the same server or same name if on different server
3) open the database
4) chek the table data

Regards
Karunakar
Previous Topic: Live instance problem 9.2
Next Topic: SNAPSHOT CONTROL FILE & CONFIGURE CONTROLFILE BACKUP Differences:
Goto Forum:
  


Current Time: Sun Dec 11 08:28:37 CST 2016

Total time taken to generate the page: 0.08962 seconds