could anyone give me a rough idea of the cost of an Rman licence - we are running Enterprise edition of 9i.
We would be using it to back up 3 databases on 2 servers.
Guess I also need the rman agent?
I meant the licence fees - we intend to do rman backups to disk then let veritas image copy the files etc, so it does not need to know that they came from rman - We could incorporate rman into the veritas backup and have it hive it off to tape straight away, but feel disk copy is faster and easier to manage from my point of view.
We have been told that rman would cost us upwards of £50,000 - is that not true then?
We were thinking of disk copying the files, so no cost then?
You don't happen to know if Veritas insist on rman do you - if not then we could just do ordinary cold backups anyway (db not that big - 20gig or so).
Old dba mentioned that veritas were not going to support us unless we used rman - but that may have been using their routines to take it straight to tape using their agent etc. ... we currently use thir oracle agent and do hot backups - but we can quite happily shut doen at night so culd do cold ones instead and not use veritas to perfiorm the database backups, just copy over the files produced from it instead? - does this sound like a reasonable approach to you?
If you are disk copying the files yes no liscence required.
Well your approach sounds good to me.
If you can afford a shutdown yep then shutdown the database and copy the files to disk and then takes these copied files over to veritas on to the tape.
I am not sure what your dba is trying to say.
But you can also take a RMAN hot backup to the disk and then from the disk copy it over to tape using veritas.You dont have to pay liscence fees in thsi case too since you are not integrating rman and veritas.But teh catch is if you wnat to restore then you shoudl first restore it to the place through veritas where rman had backed it up.
Bottomline if you dont integrate ramn with veritas agent you dont need to pay liscence fees.
yep, so copy the files produced from rman, but exclude the datafiles/logfiles/control file etc from the veritas folders (we had problems before when we were backing those up and the control file was locked and terminating the instance)
p.s. Why do you say cold backup is a bad idea?
Have to be a bit careful about saying, "Don't do cold backups!"
It really depends on what type of system you run. I always work on OLTP systems, so using archiving and hot backups is the best option, but that may not be the case in warehousing situations.
There was a thread on the dizwell forum some time ago, where a number of waerhousing guys said they run in noarchivelog mode and do cold backups after dataloads once a week. In that scenario, running in archivelog mode and doing hot backups may not be all it's cracked up to be...