Posted by Alisher Yuldashev on Apr 23, 2010
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.
My acquaintance with Robert G. Freeman began last summer when I found the “Merge me baby!!” contest for a new book on his blog. I have always loved to solve puzzles and that one seemed interesting to me. As it turns out, I won the contest. When I knew that Robert was looking for someone who could help him with the chapter about Oracle Secure Backup (OSB) for his new book, I immediately offered him my help and experience in OSB.
I highly recommend the book. It has not been published yet but can be pre-ordered on Amazon.com or on McGraw-Hill Professional Books.
Product Details:
* Paperback: 688 pages
* Publisher: McGraw-Hill Osborne Media; 1 edition (May 17, 2010)
* Language: English
* ISBN-10: 0071628606
* ISBN-13: 978-0071628600
Posted by Alisher Yuldashev on Feb 10, 2010
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.
First, you need to sign up for an Amazon S3 account and get an Access Key ID and a Secret Access Key. Check AWS pricing first.
Next, download the OSB Cloud Module and unzip it. Read the rest of this entry . . .
Posted by Alisher Yuldashev on Oct 5, 2009
If you have an extremely busy OLTP system with a physical standby ready for a manual role transition, and you want to run very heavy reporting queries without affecting the system, consider using a separate report database with downstream capture configuration. Yes, it is very easy to configure, and it will have no performance impact on the OLTP system whatsoever.
In this blog, I will show how to do this, and how to maintain the archivelog transportation during a manual switchover.
Below is the configuration of the three databases I have for testing:
Read the rest of this entry . . .
Posted by Alisher Yuldashev on Jul 2, 2009
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.
Of course, it depends on the size of Redo logs and the network speed to move Redo logs from the primary server to standby.
Here is what I had. The primary database and one physical standby database:
- OS – SUSE Linux ES10 (SP2) x86_64
- Oracle – Release 11.1.0.7.0 64bit SE1
First of all, I switched the standby database to the primary role.
Read the rest of this entry . . .
