Re: RMAN frustration

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Wed, 29 Jan 2003 17:23:12 +0100
Message-ID: <3E37FFF0.40804@science-computing.de>

Hartmut Inerle wrote:
> Rogbaker wrote:
>

>> run {
>> allocate channel disk1 type disk format
>> 'c:\rmanbakup\backup_012803';
>> backup database;
>> sql 'ALTER SYSTEM ARCHIVE LOG CURRENT':
>> }

>
>
> You are doing here a full backup solution. For a Point-in- time recovery
> is a incremental backup solution necessary.
>
> And I didn't see and archivelogs in the backup. Have a look in the
> documentation for the prerequesites for the point in time recovery.
>
> regards
> Hartmut Inerle
>

Could you please explain this a bit further? It's my understanding that after a full backup I can restore to virtually any point in time after the backup, since basically all I need are the rman backupset and the archivelogs.

Incremental backups in RMan terms are only to save space on the backup device, since only changed blocks since the last successful backup of the same or higher level are backed up. (In this context, level 0 is considered as the highest level).

And archivelogs don't *HAVE* to be in the backup set, they just have to be in place when trying to restore. Especially since most of the needed archive logs not even exist at the time of backup...

So I tend to believe you're plain wrong in what you state, or at least have not fully understood what the original poster was trying to achieve.

Additions and corrections welcome!

Regards,

Holger Received on Wed Jan 29 2003 - 10:23:12 CST