Re: backing-up with rman and expdump

On May 9, 11:12 pm, Joe <joe1..._at_tlen.pl> wrote:
> Why would one need to backup entire database: sysaux, system, etc with
> rman, if all I got is tables, functions, indexes, triggers and
> sequences?
> I do not see any difference between restoring db from full rman
> backup, and from expdmp.

The difference is you are not "restoring a database " with expdmp, you are recreating objects and running inserts.

expdmp is not "restoring the database" it is recreating objects within a "new" database. RMAN is a true file level "Database" restore. It also checks for block corruption during backup. It can be optimized on multiple levels, works directly with tape storage and keeps track of backups whether in catalog or in controlfile. It has no problem with XLM types or lobs and can backup and restore to an audit based point-in-time. Try backing up an xmldb with expdmp.

EscVector
Databases are forever, instances are ephemeral.... :) Received on Thu May 10 2007 - 11:13:07 CDT