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 . . .
