We will create 2 standby databases from a single RAC primary database. 11gR2 allows upto 30 standby databases. The most…
Tag Data Guard
Primary is a 2 node-rac cluster with instances swx1 and swx2 running on ASM. A service called swxscan is created…
Many a times to save cost in building a DR solution for a certain application; you have to create a…
Recovery interrupted! Recovered data files to a consistent state at change 13507372 Fri May 11 20:11:09 2012 Errors in file…
I had a block corruption of my primary database, though we had a standby build we wanted to recover the…
In this scenario,the standby database lost contact(connection) with primary database for few days and hundreds of redo log was switched…
In this activity we will create Oracle 11gR2 Datagaurd using active duplication. In active duplication, we don’t need to take…
Oracle 11g Dataguard introduced powerful new features viz. Active Data Guard and Snapshot Standby Database. Snapshot standby database specially is…
Apple use’s Oracle Active Dataguard 11g for its AppStore. In Oracle 11g data guard you can have upto 30 active…
Sometimes it becomes necessary to stop the log shipping procedure without doing a shutdown of the standby database or server.…
To use real-time apply where before log shipping the LGWR process writes to a standbylog file simultaneously along with the…
A physical standby database is created from an existing other database. This other database will then be the primary database.…
Before creating a Dataguard setup, one of the prerequisite is to calculate the additional network bandwidth required for shipping the…
By Uwe Hesse Link to original post: http://uhesse.wordpress.com/oracle-database-ha-architecture/ A very popular topic in many of my courses is Oracle Database…
The Complex Oracle Data Guard in less than 15 easy steps. Create a physical standby database in less than an…