Originally posted by ocp8
I am looking at implementing RMAN at my shop and have had numerous questions about the MTTR of our systems. I am facing a lot of resistance by people who are saying using RMAN will cause our downtown to be a lot longer than normal. On our HR system, for example, we would lay the hot backup files down and roll it forward. If I was to use RMAN with a weekly level 0 and incrementals during the week how much longer would it take to restore?? I do not have any practical experience with RMAN and I need to know this info if I plan on using it.
You're comparing apples and oranges. If you are doing a full backup of your database via a hot backup, you should compare against a full database backup every day. If you are backing up to the same media (for example, DLT or AIT on both) there should be no significant difference in backup/restore times. However, RMAN has a unified interface (same across all platforms) so your DBAs don't have to know Legato for Unix, FooBackup for WindozNT, and EnterpriseFooBackup for W2K. Also, RMAN is supported by Oracle whereas your home-grown scripts are supported by you.