Author: Alisher Yuldashev

“Oracle RMAN 11g Backup and Recovery” book

One of the most critical skills of any Oracle DBA is the ability to prevent a system crash and to restore and recover the system in case of a disaster. The “Oracle RMAN 11g Backup and Recovery” book by Robert G. Freeman and Matthew Hart is a resource that can definitely help to acquire the skill. I recently received my early copy of it, and am honored to have contributed to Chapter 5 “Oracle Secure Backup” for it.

Read More >

Let Your Oracle Backups Be Up in the Clouds

There are a lot of discussions going on in the Internet regarding whether we can trust third parties to look after our data. I am not going to add fuel to the fire. I am going to show you how simple it is to backup an Oracle database to the Storage Cloud using the Oracle Secure Backup (OSB) Cloud Module.

Read More >

How to configure OLTP with reporting queries

In this blog, I will show how to configure a separate report database with downstream capture on an OTLP system , and how to maintain the archivelog transportation during a manual switchover.

Read More >

Oracle 11g SE Switch-Over

Recently, I tested a switchover on Oracle 11g SE1. As you know, Oracle Database Standard Edition One—as well as Standard Edition—does not have the Data Guard feature. Therefore, I had to do everything manually. The whole process took less than 15 minutes. This includes less than five minutes of full downtime to restart the database in READ-ONLY mode, and less than 10 minutes of READ-ONLY downtime. Here’s what I had.

Read More >