OraFAQ Forum: Backup & Recovery » Can I create a dump file from a backup?

Home » RDBMS Server » Backup & Recovery » Can I create a dump file from a backup?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Re: Can I create a dump file from a backup? [message #243721 is a reply to message #243720]

Fri, 08 June 2007 11:35

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

use table level import export

Report message to a moderator

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

Report message to a moderator

Re: Can I create a dump file from a backup? [message #243729 is a reply to message #243724]

Fri, 08 June 2007 12:04

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

Report message to a moderator

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!

Report message to a moderator

Re: Can I create a dump file from a backup? [message #243744 is a reply to message #243743]

Fri, 08 June 2007 13:17

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

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.

Report message to a moderator

Re: Can I create a dump file from a backup? [message #243754 is a reply to message #243747]

Fri, 08 June 2007 15:33

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.

Report message to a moderator

Re: Can I create a dump file from a backup? [message #243762 is a reply to message #243754]

Fri, 08 June 2007 16:01

cbooker
Messages: 8
Registered: July 2006

Junior Member

That's what I was afraid of. Thanks anyway.

Report message to a moderator

Re: Can I create a dump file from a backup? [message #243764 is a reply to message #243762]

Fri, 08 June 2007 16:11

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

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

Report message to a moderator

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!

Report message to a moderator

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 06:08:38 CDT 2025