It was a long journey of hard work and team work that now has finished, as a result you will find my book Oracle Database 12c Backup and Recovery Survival Guide that I wrote with the help of my good friend Aman Sharma. I would also take this opportunity to recognize the great work done…
Category: White Papers
Why use OVM for Oracle Databases
Some time ago I made a benchmark exercise to compare the performance of an Oracle Database running in a bare metal environment versus a virtualized environment to clear some of the main questions our team and clients in Revera have, such as: Does an Oracle Database performs well on a virtualized environment? What virtualization technology…
Playing with VirtualBox, Oracle 12c (12.1.0.1) and OEL 6.4 – Part 1
Now that 12c was released it’s time to install in on OEL 6.4 64 bits OS. Let’s start playing with this. Before we start with the creation of the VM we will need to download some software first, such as: The VirtualBox for Windows: https://www.virtualbox.org/wiki/Downloads The OEL 6.4 OS: https://edelivery.oracle.com/linux The Oracle Database 12c Release…
What was new for Oracle Backup and Recovery at 11g?
Oracle 12c is around the corner and due that I have received many questions from fellow DBAs about what was new about Backup and Recovery at 11g I have decided to write a small white paper about it. Hope you will enjoy reading it as much I enjoyed writing it. What_is_new_at_11g Cheers, Francisco Munoz Alvarez
Back to Basics – USER MANAGED BACKUPs part 1
In the past few weeks I have received many questions regarding user managed backups, and due to this, I decided to write a little regarding this topic. User managed backups are basically all backups you can make without the use of RMAN and no automatic metadata record of the backup is generated anywhere in the…
Playing with Oracle 11gR2, OEL 5.6 and VirtualBox 4.0.2 (1st Part)
Project Name 11gR2/2011 Author Francisco Munoz Alvarez Software Used Oracle Enterprise Linux 5.6 Oracle VirtualBox 4.0.2 Oracle 11.2.0.2 Database and Infrastructure Software Date 02/02/2011 The idea of this tutorial is to show you how you can create an Oracle Database 11gR2 using Oracle VirtualBox and OEL. This installation should never be used for Production or…
Installing Grid Control – Part I
By Francisco Munoz Alvarez Before you start with an installation of Grid Control, I’ll recommend you to go thru the documentation to understand all the minimum requirements and the installation process. For reference purpose, I’ll resume some important points of it here. Let’s start taking a close look in the components of the Grid Control …
LOGGING or NOLOGGING, that is the question – Part VI
By Francisco Munoz Alvarez TIPS USING NOLOGGING MODE DIRECT PATH INSERT To use Direct Path Insert use the /*+ APPEND */ hint as follow: INSERT /*+ APPEND */ into … SELECT … When direct path insert is used oracle does the following: Format the data to be inserted as oracle blocks. Insert the blocks above…
Logging or Not Logging:That is the Question v1.7
What is a Redo? Let’s conduct a brief summary about the redo process. When Oracle blocks are changed, including undo blocks, oracle records the changes in a form of vector changes which are referred to as redo entries or redo records. The changes are written by the server process to the redo log buffer in…