Busy Week At Work
Sorry I have not kept on pace as I would have liked with the OCP 10g. I have a couple of posts in the works but not published as they aren’t finished. The next section will be on loading and unloading of data. Work has been extremely busy. I am actually installing Oracle 10gR2 RAC on AIX with CRS and ASM. I have been taking notes on my setup including the gotchas. This is my groups first install of RAC on AIX. We have done 4 RAC installations on Red Hat Linux which I will also blog about later. I have also implemented partitioning and I have a post in the works on that. I also setup a wallet for transparent data encryption as well as TDE. Ahhhh another blog post I am working on : ). I am also finally building the actual RMAN scripts with Veritas and will talk about my script, why I set it up the way I did and how it works. It will be with the Flash Recovery Area on a different diskgroup on ASM. A level 0 initially and then the level 1 with block changing file and the merging of the level 1 with the existing level 0 to make a whole new level 0. Then when that is done, you ship it off to tape. I am really working with it and might actually have to have a slick unix script run it or just have separate scripts in cron. One for 6 days of the week and one for the one day I want to issue the backup validate database command to check for the block corruption that a full backup gives you. So many benefits to this and it’s really slick.
I also will be renaming a database so I will walk through the process of doing that : ).
Also, this week I will be in Orlando attending Microsoft’s Tech-Ed conference. Yes, I am an Oracle DBA but I am also a SQL Server one as well : )… Oracle is what I am passionate about though. So much great stuff, so powerful — they really let you get under the hood and tweak so many things. Nontheless, I plan on attending many good sessions and I will blog about any cool Oracle / Microsoft things that I see there : ).
I’m working on my AIX install tonight so hopefully I will get that blog post finished and posted!
Tom