Multiple Standby Databases Dataguard Oracle

We will create 2 standby databases from a single RAC primary database. 11gR2 allows upto 30 standby databases.  The most important part is to consider the dataguard parameters, the rest is a normal dataguard creation. The important parameters are as below : db_file_name_convert log_archive_config log_archive_dest_1 log_archive_dest_2 log_archive_dest_3 LOG_ARCHIVE_DEST_STATE_1 LOG_ARCHIVE_DEST_STATE_2 LOG_ARCHIVE_DEST_STATE_3 log_file_name_convert remote_login_passwordfile STANDBY_FILE_MANAGEMENT fal_client fal_server … Continue reading Multiple Standby Databases Dataguard Oracle

RAC to Single Instance Standby Database Setup (Oracle 11gR2 Physical Standby)

Primary is a 2 node-rac cluster with instances swx1 and swx2 running on ASM. A service called swxscan is created for client sides. We will use this service name for the tnsnames.ora. The standby instance will be called swxstandby and it will be running single instance on ASM as well. This is a standard dataguard … Continue reading RAC to Single Instance Standby Database Setup (Oracle 11gR2 Physical Standby)

2 Node RAC to Single Instance Dataguard Switchover (Oracle 11gR2 Physical Standby )

Many a times to save cost in building a DR solution for a certain application; you have to create a single instance database for your RAC primary. So you have gone ahead and build the 2-node to single instance setup and now comes the time to test it. Well it is not much different than … Continue reading 2 Node RAC to Single Instance Dataguard Switchover (Oracle 11gR2 Physical Standby )

ORA-10567: Redo is inconsistent with data block

Recovery interrupted! Recovered data files to a consistent state at change 13507372 Fri May 11 20:11:09  2012 Errors in file e:\oracle\product\10.2.0\admin\ecc\bdump\eccstandby_mrp0_2724.trc: ORA-12801: error signaled in parallel query server P011 ORA-00600: internal error code, arguments: [3020], [1], [56204], [4250508], [], [], [], [] ORA-10567: Redo is inconsistent with data block (file# 1, block# 56204) ORA-10564: I … Continue reading ORA-10567: Redo is inconsistent with data block

RMAN database restore until time

I had a block corruption of my primary database, though we had a standby build we wanted to recover the Primary instead of failover to the Standby. This recovery is possible when you have say a full backup made of the database till 9th May and all archivelogs from 9th May till 12th MAY are … Continue reading RMAN database restore until time

Resync Standby Database when Archivelogs at Primary are deleted.

In this scenario,the standby database lost contact(connection) with primary database for few days and hundreds of redo log was switched and unfortunately archivelogs were deleted from primary database, network problem is resolved , and now you want to resync standby db with minimun time / no downtime. server 1 (primary database) os: linux 64bit db: … Continue reading Resync Standby Database when Archivelogs at Primary are deleted.

Oracle 11gR2 Dataguard using Duplicate Active Standby

In this activity we will create Oracle 11gR2 Datagaurd using active duplication. In active duplication, we don't need to take rman backup and copy the backup to the Standby Server. The database can be duplicated over the network. Its an amazing feature which saves you much time and effort. The only thing you have to … Continue reading Oracle 11gR2 Dataguard using Duplicate Active Standby

Oracle 11g Snapshot Standby Database (Read- Write mode for standby db)

Oracle 11g Dataguard introduced powerful new features viz. Active Data Guard and Snapshot Standby Database. Snapshot standby database specially is an amazing feature. Where you can convert your standby database into read-write mode while the log shipping is happening. Once you finish your testing (feel free to drop tables, run rogue update statements or anything … Continue reading Oracle 11g Snapshot Standby Database (Read- Write mode for standby db)

Apple’s Oracle Dataguard 11g architecture

Apple use's Oracle Active Dataguard 11g for its AppStore.  In Oracle 11g data guard you can have upto 30 active data guard instances. What Apple most likely does is, cascade its Production DB into many Standby instances and uses different applications to interface with each standby database.   For more details read on : http://www.oracledatabase12g.com/archives/oracle-active-data-guard-technical-overview.html

Defer Log Shipping Oracle Data Guard

Sometimes it becomes necessary to stop the log shipping procedure without doing a shutdown of the standby database or server. For eg: IF there is a network related activity in you organization and there will be a network outage. You can defer the log shipping. Or if you are relocating your standby database server. Please … Continue reading Defer Log Shipping Oracle Data Guard