dbTalk Databases Forums  

RMAN

comp.databases.oracle comp.databases.oracle


Discuss RMAN in the comp.databases.oracle forum.



Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old   
Alex
 
Posts: n/a

Default RMAN - 10-18-2004 , 05:35 AM






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



Reply With Quote
  #2  
Old   
Jon
 
Posts: n/a

Default Re: RMAN - 10-16-2007 , 11:29 AM






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" <asoul (AT) tiscali (DOT) it> wrote

Quote:
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





Reply With Quote
  #3  
Old   
Lodewicus Maas
 
Posts: n/a

Default Re: RMAN - 11-08-2007 , 03:36 AM



Jon wrote:
Quote:
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" <asoul (AT) tiscali (DOT) it> wrote in message
news:Q7Mcd.12116$1q2.10154 (AT) tornado (DOT) 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


Reply With Quote
Reply




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.