Re: Backup & Restore

Hi Brian

My backup strategy:

Initial Level 0 backup

daily level 2 backup

weekly level 1 backup

I have the clarifications below:

1. Should I take the archive log backups as part of daily and weekly backup ? My intention is to take the archive log backup separately. Is this recommended ?
2. During the rotation I feel I can remove the level 2 backup taken on 1st week during the 5th week.

The incremental backup merge in 10g can be used in my weekly backup. So that every week backup will be merged with Level 0 backup.

I'm in a little confusion of using incremental backup with merging. My DB size is close 200GB and daily 7-8 archive log of each 500MB get generated. What kind of backup strategy will you recommend.?

Please recommend your views.

Thank You.

Brian Peasland wrote:
>>> Hi
>>>
>[quoted text clipped - 18 lines]
>>
>> regards,
>
>Christian,
>
>Have you looked at Incrementally Updated Backups in 10g? With IUB, you
>only have to restore the level 0 and then *one* level 1 backup and the
>redo logs.
>
>There is more information in the RMAN docs.
>
>Cheers,
>Brian
>

-- 
Message posted via DBMonster.com
http://www.dbmonster.com/Uwe/Forums.aspx/oracle/200709/1