RMAN

Main Page | Report this Page

Computers Forum Index » Computer - Databases - Oracle » RMAN

Page 1 of 1

RMAN

Author

Message

Alex

Posted: Mon Oct 18, 2004 10:36 am

Guest

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

Jon

Posted: Tue Oct 16, 2007 8:29 pm

Guest

Quote:

Lodewicus Maas

Posted: Thu Nov 08, 2007 2:36 pm

Guest

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@tiscali.it> wrote in message
news:Q7Mcd.12116$1q2.10154@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

Page 1 of 1

All times are GMT The time now is Thu Dec 10, 2009 7:24 pm Computers Forum Index