Re: backing-up with rman and expdump

On May 10, 10:03 am, Joe <joe1..._at_tlen.pl> wrote:
> On May 10, 12:59 am, sybra..._at_hccnet.nl wrote:
>
> > 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?
>
> I do expdmp 2 times a day, noon and evening, after 6pm.
> I know I wont be able to use redologs.
> Why would my records not get to the right place, just like they were
> before?
> i do not have stored procedure in db.

By taking to exports you have two images at certain points in time, but nothing in between or afterwards. So, if you exported at 6pm and your database crashes at 10pm you will only be able to recover an image as of 6pm (all changes to the database after 6pm are lost for good).

In short:
Exp/imp (data pump) = snapshots/images at a specific times RMAN + archive logs = snapshots + everything that "happened" in between (changes on data, objects, etc) Received on Thu May 10 2007 - 09:14:28 CDT