Unsolved
This post is more than 5 years old
1 Rookie
•
11 Posts
0
768
June 3rd, 2014 14:00
Multiplexing on databases (Oracle) with Data domain
I've been reading that in DDOS 5.3 that there is:
- Enhanced Oracle RMAN support for improved performance and deduplication efficiency by inclusion of support for Oracle RMAN multiplexing
Can I take it from this that enabling multiplexing on the database wont affect dedupe ratios?
I have a customer who is one a 1:1 dedupe ratio for their database backups -
what sort of things should I look for? - contributing factors I have so far are:
database compression
multiplexing
alot of log backups
thanks
No Events found!
ble1
2 Intern
•
14.3K Posts
1
June 3rd, 2014 14:00
I always used multiplexing (Oracle side) and didn't see much of effects with and without (there are effects, but ignorable in my case). 1:1 is strange for sure. I also have lot of logs, but still manage to get overall 10x factor. While I was in testing phase from what I could see logs would give you 2-3x, DB 5-6x factors. We do not use compression on pure Oracle systems (we do with SAP systems, but the impact there is different due to internal structure). Our DBAs did test and concluded that some DBs would even grow with compression and didn't want to have mixed bag so they discarded whole concept of compression on pure Oracle databases. Bare in mind that there are two type of compression you can use and if I remember one is friendly for de-dupe while the other is not.
You didn't say how you use, but if VTL create separate pools for DB and LOG and check what compression rate do you get on volumes.