In a previous post, I gave some Career Advice for the New Oracle DBA. We talked about building an environment where you can test. This is the second part of that series and it will be more of a hands on guide where we will step through installing Oracle Virtualbox.
Category: Database Administration
When you are running Real Application Clusters, the distinction between the instance and the database becomes very clear. You now have an instance running on each server in the cluster that accesses a common database on shared storage. If you run oraenv with a newly installed RAC database, you will notice that you still have to make adjustments to environment variables to access your instance. We are going to continue the theme from my last post (using Oracle’s oraenv), and take a look at using Oracle oraenv with RAC.
When you install an Oracle code tree on a non-windows platform, Oracle includes a utility that allows you to change the OS environment and access different databases running on the machine. Let’s investigate using Oracle’s oraenv utility.
You’re a developer and its 10:30 am and you have just sat down from getting your second cup of coffee. Your boss comes out of her office and says that she needs to see you. Your mind goes to a bunch of possibilities, most of them are bad. She tells you that the DBA has quit and she needs you to step up and become the new DBA. Now what do you do? What you need is some advice for the new Oracle DBA!
Here is one of my posts from last year’s IOUG Tip Booklet titled 10 Questions (and answers) about RMAN Stored Scripts. Enjoy!
Today, most Oracle shops are using RMAN for backups. Why? Because it powerful, resilient and not very difficult to learn. It is an excellent tool to have in your DBA toolbox. Let’s add an additional tool to that toolbox that will help to make your job as a DBA a bit easier, RMAN stored scripts.
A part of your job as a DBA is maintaining database availability to match your service level agreements (SLA) with your customers. But keep in mind that this SLA can also impact any required downtime for maintenance. Throughout the years, Oracle has introduced many tools and features to reduce this maintenance downtime. Today we are going to take a look at a cool feature that will help you when you have to perform maintenance on a large table, online table redefinition.
Let’s take a look at one of my early articles in the IOUG Tip Booklet. It is still relevant today…
In Oracle 9i, the spfile was introduced as a new method to store the initialization parameters. The use of the spfile helped to simplify the remote startup of a database and added options for the busy DBA. In this article, we will look at the spfile and how it is managed on UNIX/Linux and Windows.
As a DBA, you have a constant struggle between availability and maintenance. Oracle has added features over the years to give DBAs additional options for online maintenance. Oracle 12c has added a feature that is really cool and I have been waiting to have for a while. Online datafile moves!
RSS - Posts