Re: backing-up with rman and expdump

From: <sybrandb_at_hccnet.nl>
Date: Thu, 10 May 2007 06:59:00 +0200
Message-ID: <jg9543pm61h25ork9mii8umhjqqabvi78s@4ax.com>

On 9 May 2007 20:12:40 -0700, Joe <joe1977_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.

expdmp is a logical backup. Nothing more than a series of insert statements. So importing doesn't guarantee all records return to their original locations. Consequently you won't be able to recover the database (= apply (archived) redologs) after impdmp. You don't make an expdmp every 2 minutes, do you?

-- 

Sybrand Bakker
Senior Oracle DBA

Received on Wed May 09 2007 - 23:59:00 CDT