I recently mastered to pass the 10g oca examination and, as a proud member of the certified community, I obediently followed the instructions given to download the related logo for personal use. Targeting my browser to http://www.oracle.com/education/10goca, I experienced a behavior that i found strange at first, funny than, and disappointing at least. The story is, that the “passwort protected” procedure, as being described with the instructions, is’nt worth being called protected or ever secure, as will be shown below.
the following information is something one hardly finds on the net or in printed material. that is, this information is not really tricky to examine or even secret. it is just difficult to describe and to express because it depends on such a multitude of other information, mainly system power and configuration, that no rule of thumb can be established.
the information is: how long does it take to fully restore and recover my database (did you ever try?).
i’m not going to discuss performance optimizations here. i’ll only show up with a test lab report that someone else may or may not reuse for a personal examination or comparison.
this is what i had:
- dell pe6850, 4 xeon 7130 (dual core, 3.2 ghz), 8 gb ram, win 2003 enterprise r2 sp2
- oracle 10.2.0.3 enterprise
- 400 gb online database size
- 110 gb compressed backup set size (85 gb level 0 backup, 20 gb level 1 backup, 5 gb archivelog backup)
- 3 active rman channels to disk
- nearly no secondary load on the system
this is what i achived:
- 5 hours