| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Question About RMAN
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:breno_at_mercantilsoares.com.br
Mercantil de Alimentos Soares
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Breno A. K. Magnago
INET: breno_at_mercantilsoares.com.br
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: ListGuru_at_fatcity.com (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).
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: ListGuru_at_fatcity.com (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). Received on Wed Feb 12 2003 - 08:54:40 CST
 |
 |