Considering moving to Rman for backup solution

[BrianinWI1]

We currently are using a shadow copy of our Oracle databases with a standard Netbackup backup to back up the shadow copy of our databases.

We are considering moving to a Rman process to perform these backups. We would be starting from scratch with this process. I am curious if anyone has recently implememented this process as a backup solution and if there are any pit falls that we could avoid during the set up process? Also, is this set up a very time consuming process ? Just looking for any kinds of heads up or horror stories that we could avoid.

We are using Netbackup version 7.5.0.3, and we would be backing up from 500 Gb to 11 Tb's of data.

Thanks for your time.

Brian

[Nicolai · Accepted solution]

The Netbackup Oracle administrative guide is always a good place to start

http://www.symantec.com/docs/DOC5175

My advise:

• Team up with a DBA that know how RMAN work
• Test the solution - both redirected restores and clones.
• Define responsibilities (OLA) between you and DBA. Who perform what tasks ?
• Do not rush - RMAN is like a axe. It's damm good at bringing trees down, but from time to time you hit your'e own leg. Lern how the axe work and behave before making use of it.
• Make sure you got a recover catalog and it's protected.

That said - I endorse the use or RMAN for backup of Oracle.