| Can I create a dump file from a backup? [message #243720] |
Fri, 08 June 2007 11:33  |
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 #243724 is a reply to message #243720] |
Fri, 08 June 2007 11:56  |
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 #243743 is a reply to message #243720] |
Fri, 08 June 2007 13:09 |
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 #243747 is a reply to message #243744] |
Fri, 08 June 2007 14:16 |
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 #244129 is a reply to message #243818] |
Mon, 11 June 2007 12:30 |
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 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
That's what I was afraid of. Thanks anyway.