470,638 Members | 1,577 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,638 developers. It's quick & easy.

RMAN

Hi all

Is possible with RMAN recover only one table of my db?
Where can i find some infromation about this?
If is not possible , where can i find products to make this?
Is possible to restore one datafile with a different name?

Thanks to all
Alex
Jul 19 '05 #1
2 3162
Jon
Take a look at the Flashback feature... they
claim that you can restore a table to point
in time but I haven't played with it.... I used
to get this question a lot.

Jon
"Alex" <as***@tiscali.itwrote in message
news:Q7*******************@tornado.fastwebnet.it.. .
Hi all

Is possible with RMAN recover only one table of my db?
Where can i find some infromation about this?
If is not possible , where can i find products to make this?
Is possible to restore one datafile with a different name?

Thanks to all
Alex


Oct 16 '07 #2
Jon wrote:
Take a look at the Flashback feature... they
claim that you can restore a table to point
in time but I haven't played with it.... I used
to get this question a lot.

Jon
"Alex" <as***@tiscali.itwrote in message
news:Q7*******************@tornado.fastwebnet.it.. .
>Hi all

Is possible with RMAN recover only one table of my db?
Where can i find some infromation about this?
If is not possible , where can i find products to make this?
Is possible to restore one datafile with a different name?

Thanks to all
Alex


Yes it's possible - enable the database flashback feature. Depending on
the amount of space you have. Using this, you can flashback a table to
i.e 3 days back in time, and then export the table at that historical
point. Database must be in archivelog mode, and this feature must
already be enabled to the time you want to go back into the past

Lodewicus
Nov 8 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by sunilwarrier | last post: by
1 post views Thread by steve | last post: by
1 post views Thread by RYAN | last post: by
2 posts views Thread by Tho Nguyen | last post: by
reply views Thread by TX-DBA | last post: by
reply views Thread by gohel | last post: by
reply views Thread by gunsbong | last post: by
1 post views Thread by Korara | last post: by
???
1 post views Thread by Stoney L | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.