Blog Aggregator - Amardeep Sidhu

Recovering an Oracle database is a wonderfully complex task. Data files, log files, control files, full
backups, hot backups and point-in-time recoveries all combine to make many administrators lie awake
nights wondering if their databases can be easily recovered. Oracle10G contains numerous
enhancments to the RMAN backup utility. As a result, a thorough testing of 10G RMAN is warranted.

In part 1 of this 2 part series, I’ll provide you with a few backup and recovery tips, tricks and techniques
that I think will help both beginners and experts alike. Since we are RMAN aficionados here at Giant Eagle, I’ll finish the blog with an
introduction to RMAN. In part 2, I’ll highlight a few of the 10G RMAN new features we are interested in
and provide you with Giant Eagle’s detailed 10G RMAN test plan.

After spending 20 hours testing Enterprise Manager, I’m happy to report that everything works as advertised. The tool is rock-solid. I thought for sure the product would have at least a few problems that I could report on. So instead of a bug discussion, this blog contains some of the tips and tricks I learned during the execution of my Enterprise Manager test plan.

This is the first release of Oracle that has forced me to spend more time learning how to use the tool to administer the database than I have spent testing the new features the database provides. Now that our 10G OEM testing is finally complete, I’ll provide you with two blogs in quick succession. In this first blog, I’ll provide you with a high-level over of what we found during our installation and in-depth testing. In the second I’ll finish my discussion on OEM with a bulleted list of notes that I compiled during my 20 hours of putting 10G OEM through its paces.

We have been testing Oracle10G for some time now. So, I thought I’d spend 5 minutes giving you a quick update on a few new features we are interested in.

We now have several 10G analysis projects underway. I thought I’d give you a quick update on our accomplishments (or lack thereof) on one of them. This will hopefully prevent others from experiencing the same issues that we just have.