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
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)
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 )
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: , , , , , , ,  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
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
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.
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