Hi Marist,

Thanks for your help.

I can't understand why people insist on doing incremental backups when they backup to disk.
.

We are doing RMAN backup to Disk temporarily until NETBACKUP is setup. Afterwards, we will backup directly on to the Tape. What other method do you suggest in place of Incremental and why Incremental is lengthy and difficult?

Otherwise, if you insist on keeping your archived redo logs around, you can delete them after the next successful full hot backup (provided you have backed them up).50G database? I'd run a hot backup every night and take archive log backups a couple of times a day and forget about it.
Currently, we do not take any HOT or COLD database backup. I would like to get your advise on this. Do we need to take HOT backup of the database besides the RMAN incremental level 0 and 1 backup?


BTW, using export/import is just sucking your CPU to death for no real benefit.
We take EXPORT on every Saturday night when noone is working on the system.

I am new to RMAN things and currently trying to learn. So, pl. feel free to give your advise.

I also want to know that when I take level 0 incremental backup on every Friday and then level 1 incremental backup on every day, if I need to restore database upto say last WED, do I need to first restore it from last level 0 and then only level 1 of WED?

I am also not clear that level 0 incremental is equal to full database backup.

Pl. help me to understand the above.

Thanks a lot.