Re: RMAN frustration

"Hartmut Inerle" <hinerle_at_aol.com> wrote in message news:3E38F27A.4030107_at_aol.com...
>
> Hello,
>
> Further explanation.
>
> What is oracle doing during a full backup.
> It copies are used database blocks into a backup set. Full Backup
> creates something like a database snapshot. There is no information to
> rollback the database beyond this point in time. To reach an other point
> in time you need the archive log files are created after the full
> backup. This means you can have two ways to do a point in time recovery.
>
> Full backup + archive log = reaching a point after the full backup.
>
> Incremental backup + archive log = reaching a point after the initial
> incremental level 0 backup.

Well, all of the above makes a sort of sense, but it isn't what you first wrote (which was "You are doing here a full backup solution. For a Point-in- time recovery is a incremental backup solution necessary.") From which I think we both thought that you were saying 'you can't do point-in-time recoveries *unless* you do incremental RMAN backups, which is of course not right.

That interpretation arose, incidentally, at least in part because the original poster is quite clearly NOT doing incremental backups, and yet failing to achieve a successful recovery.

But, as has been posted elsewhere, his particular issue has nothing to do with the level of his backup, but the fact that RMAN only timestamps the backup at its completion, and since this was his very first backup, and he had no others from previous times, he can't recover to a point before the backup completion time.

> BTW:
>
> BACKUP DATABASE FULL is not equal BACKUP DATABASE INCREMENTAL LEVEL 0.
> The result is the same, but a incremental backup strategie can only
> start with a backup level 0.

All perfectly true, but not relevant to the original poster. (Incidentally, it's more involved than that: if you do a level 0 backup on Monday, followed by a full backup on Tuesday, followed by a level 1 backup on Wednesday, the level 1 backup will totally ignore Tuesday's full backup when determining what to include in its backup set. The Wednesday backup will thus include all blocks changed since Monday. But none of that is relevant for our original poster either).

Regards
HJR Received on Thu Jan 30 2003 - 13:12:01 CST