Restore one table with Oracle 9.2? 2

[jouell]

Hi. Am I correct in saying you can't directly restore one table with Oracle 9.2 using RMAN?

I know you can do tablespaces, but I see no evidence of just on table.

Thanks!
-John

 

[LKBrwnDBA]

You can only restore tablespaces, files, controlfile, spfile and archive logs (if you backed them up).


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[SantaMufasa]

John,

The easy way to restore (not recover) just one table is by importing a recent exported dump file of the table. It won't have in it data that changed since the export occurred.

But, without an export dump file that contains that single table, if you must rely on trying to restore/recover using your backups and archive redo log files, it is technically feasible, but it is a real "Pain in the Pahtoot"...Here's what you must do:

1) Clone your Oracle database/instance onto another target server by copying over the last full backup of your source database/instance, along with your applicable archived redo log files and parameter (init.ora) file.

2) Startup and recover the clone to the point in time prior to the demise of your missing table.

3) On the clone database, export the table.

4) On the original database, import the exported dump file of the single table.

Let us know what you end up doing and the satisfaction it brings you.

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.

 

[jouell]

You both rock!

I knew about the cloning (i have it scripted out pretty well), so we are going to use an export file, import to a temp table, then export with a where clause. Nice, huh?


I plan on hanging out here->

http://www.orafaq.com/faqiexp.htm#SUBSET

for a while.....

Thanks again!
-John

 

[carp]

You might also be able to use the FLASHBACK option.