Re: Some RMAN Guidance

"rspeaker" <rspeaker_at_yahoo.com> schrieb im Newsbeitrag news:1112231066.741787.162910_at_z14g2000cwz.googlegroups.com...
> Volker,
>
> I initially looked at using 1-2 full backups per week and incrementals
> the other nights, but when I ran my test backup, the full backup took
> less than 30 minutes using parallelism of 2. With that short of a time,
> I saw no reason not to do nightly fulls to minimize recovery time.
Yes, incremental backup is not necessarily a time saver, but it *is* a space saver and the space problem is what I thought you wanted solved.

>
> Regarding the "why", I want to be able to do both DR recovery and also
> point-in-time, if needed. My hope is that, if I restore a backupset
> from TSM to my staging area, as long as it is within the recovery
> window defined in RMAN, that I would be able to use it to
> restore/recover. Granted I may need to resync or crosscheck. I'm
> testing that now (using a 'redundancy 7' setting and deleting today's
> full backup after 2 days, then restoring). I'll also be looking into
> backing up directly into TSM.

Sounds way more complicated than incremental backups. By the way, did you look at cumulative backups? That's a compromise between full and incremental. Basically, rman needs the last full and the newest cumulative backup for a restore instead of one full and several incremental ones.

Lots of Greetings!
Volker Received on Thu Mar 31 2005 - 07:54:01 CST