What is redo? Let’s look briefly at the redo process. When Oracle blocks (the smallest unit of storage in a database) are changed, including UNDO blocks, Oracle records the changes in vector changes, which are referred to as redo entries or redo records. The changes are written by the server process to the redo log…
Category: 11gR2
11gR2
Back-to-Basics: Understanding Backup and Recovery plus High Availability(Part I)
The constant evolution of IT has, among other things, affected the role of a database administrator (DBA). Today the DBA is not merely a Database Administrator anymore but is morphing more into the Database Architect role. If you want to become a successful DBA and be more competitive in the market, you should have a…
Playing with Oracle Database Security Assessment Tool (DBSAT)
The Database Security Assessment Tool (DBSAT) is an incredible free command line tool provided by Oracle Corporation as a utility to help you verify your database for common database security issues(including security policies and controls in place), as well as helping to identify possible sensible data stored with the database. To be able to use it you need to…
Playing with Oracle Cloud – Creating a Hybrid DR Deployment
On this article, we will create a Hybrid Disaster Recovery (DR by using Data Guard) Oracle Database Cloud Service database deployment with a primary database on-premises and a standby database in the cloud. This can be used to implement an improve the high availability of your Database by taking advantage of the Cloud, and even to migrate your…
Playing with Oracle Database Cloud – Migrating to Cloud using an Oracle Cloud Backup
The idea for this scenario is to learn how to migrate an Oracle Database from on-premises to Oracle Cloud DBaaS by using a previously done backup using Oracle Cloud Backup Services. First, we will create an Oracle Database Cloud Services database deployment (DBaaS) whose database is instantiated from a cloud backup created by using Oracle Database Backup…
Playing with Oracle Database Cloud Backup Service
This article will show you how easy is to make use of Oracle Cloud to securely store all our on-premises Oracle Database Backups. Note that backups stored in Oracle Cloud can also be used to create new Oracle Database Instances (DBaaS). Requirements: To perform the steps in this tutorial, you will need: An understanding of…
Playing with CrashSimulator
Hi everyone, Today I will show you how CrashSimulator (Shell Script – current version 1.04) works in detail. When unzipping the zip file you will find the following files within it: CrashSimulator.sh.x – For high-resolution ssh emulator screens, it shows all 3 menu columns on one screen. CrashSimulator_Low.sh.x – For low-resolution ssh emulator screens, it shows…
My Latin American Tour in March
At March I will be presenting my very successful seminar “Mastering Backup and Recovery” in some countries of Latin America for the very first time. Thank you Panama, Chile and Brazil OUGs for inviting me to your amazing countries! Please, use the following links for registration and also to find more information about the seminar:…
Join me at the next OTN Virtual Developer Day
Hi All, On February 4, 2014 at 9:30 am PT I will be talking on the next OTN Virtual Developer Day about Oracle VM and Oracle Database. Come and discover the answers for the following questions: Does an Oracle Database perform well on a virtualized environment? What virtualization technology is more stable and…
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