Originally posted by samdba
Hi Marist,

I have been told that with RMAN, you do not have to worry about what to restore/recover. RMAN does it itself once you tell it what to recover.

I thought, RMAN simplifies Recovery process for the DBAs.
Yes, RMAN does simplify the recovery process. The problems I see with novice DBAs is they don't realize how many pieces are needed when doing a restore from a series of incremental backups.
I am taking Incremental, Differential (Default) backup at level 0 and 1. Level 0 on each Fri and 1 on other days.

So, if I need to recover till Wed, first I need to restore level 0 from Fri and then level 1 from Mon,Tue and Wed. Am I right?

Sort of yes, sort of no. RMAN will know which pieces to apply, you won't have to worry about that part. However, if you have a backup piece missing between Friday (the last full) and the failure point, you might not get your data back to the failure point.

With a series of full backups, you have a greater chance of a complete recovery.