First touches: Oracle 11g Release 2
October 22nd, 2009 by TheBonsai
At the beginning of the week we lost a 10gR2 test server (some mass data application – sizes similar to warehousing) due to the complete loss of a RAID6 (don’t ask!).
Well, test server is test server: We (me as DBA, and a collegue as the responsible application developer) finally decided to step into the Oracle 11 world: The new system will be 11gR2
After some reading in I had no problems to understand the new separated architecture with its HA daemon (keyword: Grid Infrastructure) and install the whole software and create a database. And, very important, there was no, not one damn small, problem when importing 10gR2 datapump files (from the productive system). I heard some weird stories before, and I was a bit afraid about that. But nothing, all data was pumped in like a charm.
The first thing I changed, for me as DBA one of the most interesting features on those large databases, I really parallelized RMAN for backup. I hope I can reduce the backup time to a useful amount with that. This was one of the biggest discrepance in 10g: You can create very large datafiles, but you can’t backup them in a true parallel manner. I’ll check my logfiles today and hope…
Well, so far so good, I will see what 11g (especially R2 here) brings to me and, more important, the applications. It will take some time to really explore the pros.
For all of you still at 10g and loose a test system by accident (and have a developer that really wants it…): Try it 
This entry was posted on Thursday, October 22nd, 2009 at 6:36 am and is filed under Oracle, Work. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.
October 28th, 2009 at 5:46 pm
Have you been able to check whether the de facto 2TB limit for ASM disks in 10gR2 and 11gR1 is gone in 11gR2 now? The bugs referencing this issue still state “to be fixed in 11gR2″. Would be really interesting to know…!
Thanks
Martin Klier
October 28th, 2009 at 6:21 pm
According to ORACLE 11.2 documentation the limit for an ASM disk is still 2TB (without using Exadata).
Sucks, somehow…
November 3rd, 2009 at 12:00 pm
Yes, it does suck. Indeed. Do you have a link to the docs for me? I seem to be blind today…
Thanks
Usn
November 4th, 2009 at 10:49 am
I have a link:
http://download.oracle.com/docs/cd/E11882_01/server.112/e10500/asmdiskgrps.htm#CHDCGGED
Interesting, too: The differences between ASM and ASM/Exadata
July 1st, 2010 at 10:35 am
> I really parallelized RMAN for backup
Would be nice if data pump export would spread the extracted data more evenly.
I just worked with PARALLEL=4 and four files on a DB with several huge segments, and dozends of small ones. I’m ending up with two files of 20GB and two files with 10GB.
Here it’s not datafiles that can’t be split like in RMAN 10g, here’s a segement as it looks like.
Sad
Usn
July 1st, 2010 at 5:28 pm
Yes, I think the DP workers are balanced using segments. And since one worker pumps his data into one file, you end up like this.