RMAN and export are two different animals. RMAN, in general, should not be though of as a logical backup facility. That is to say, you should not backup your database with the though of just recovering one table. RMAN really isn't meant for that. However, that being said, it is very possible to recover a lost table using an RMAN backup. You could do this either by using tablespace point in time recovery, if the table is in it's own tablespace by itself, or you could recover your database to a temporary database and then export the table.
The primary difference between a logical backup and recovery with exp/imp and a database recovery with RMAN is in terms of consistency. With a logical backup, you have little promice of consistency of the data you recover, and of course you don't have point in time recovery either. With RMAN, you will have consistency in your data, and point in time recovery. HTH, RF Robert G. Freeman TUSC - The Oracle Experts - www.tusc.com Author of Oracle Press Books Oracle9i RMAN Backup and Recovery Oracle9i New Features -----Original Message----- To: Multiple recipients of list ORACLE-L Sent: 2/12/2003 6:13 AM Hi, I'm planning work with this aplication(RMAN). I think that everybody agree with me after many questions in this group. Today, my database are in Archive mode and I make manually the copy of datafiles. And I run the export utility too. About RMAN. If I want to recover only a table ? Can I do it ? It�s very easy to do using a export file. And about using RMAN application ? Thanks -- Breno A. K. Magnago mailto:[EMAIL PROTECTED] Mercantil de Alimentos Soares -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Breno A. K. Magnago INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
