Dear Readers, Please check the below articles to get good knowledge on Oracle DataGuard Articles. SNO Article Name Article Link 1 Step By Step Configuration of Oracle DGMGRL Utility https://www.ktexperts.com/step-by-step-configuration-of-oracle-dgmgrl-utility/ 2 Oracle Physical Standby Data guard in 11g https://www.ktexperts.com/oracle-physical-standby-data-guard-in-11g/ 3 Switchover and Switchback in Oracle… Read More
Oracle 12c DataGuard Switchover and Switchback Please check my previous article on Active standby database. How to build ACTIVE STANDBY DATABASE using RMAN DUPLICATE command in 12c.(Video included) After configuring data guard, databases would be either primary and standby database role, and we can altered… Read More
UNPLANNED FAILOVER and ReInitializing the OLD Primary as the NEW Standby(Using Flashback). A failover is done when the primary database (all instances of an Oracle RAC primary database) fails or has become unreachable and one of the standby databases is transitioned to take over the primary role.… Read More
How to perform DATAPUMP operations on standby database by converting SNAPSHOT standby. Data Guard is the name for Oracle’s standby database solution, used for disaster recovery and high availability. This article contains an updated version of 12cR1 Converting physical standby into snapshot standby and… Read More
How to build ACTIVE STANDBY DATABASE using RMAN DUPLICATE command in ORACLE DATABASE 12c. Data Guard is the name for Oracle’s standby database solution, used for disaster recovery and high availability. This article contains an updated version of the 12cR1 active standby setup… Read More
Continuation to the Part 3 ORACLE – Physical Standby Database creation – Part 3 Configure the listener and tnsnames to support the database on both nodes Configure listener.ora on both servers to hold entries for both databases ON TEST1 (Primary Database… Read More
Continuation of Part 2 ORACLE – Creating a Data Guard Physical Standby environment – Part2 Standby Database Steps Create a Control File from Primary database for the Standby Database. The standby database will use a control file that is generated on… Read More
Continuation to the Data Guard Physical standby creation ORACLE – Creating a Data Guard Physical Standby environment – PART1 Enable Archiving On 10g you can enable archive log mode by mounting the database and executing the archivelog command:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 |
SQL> startup mount; ORACLE instance started. Total System Global Area 285212672 bytes Fixed Size 1218992 bytes Variable Size 75499088 bytes Database Buffers 205520896 bytes Redo Buffers 2973696 bytes Database mounted. SQL> alter database archivelog; Database altered. SQL> alter database open; Database altered. SQL> archive log list Archive Mode Database log mode Automatic archival Enabled Archive destination /test/PRIMARYDB/archdest/arch Oldest online log sequence 92 Next log sequence to archive 94 Current log sequence 94 |
Set… Read More
Creating a Data Guard Physical Standby environment Once you have your primary database up and running these are the steps to follow. Enable Forced Logging Create a Password File Configure a Standby Redo Log Enable Archiving Set Primary Database Initialization Parameters… Read More
Introduction to Oracle Data Guard Data Guard gives us the high availability, data protection and disaster recovery for the data. Configuring one or more standby databases for the production database can help in surviving the disasters and data corruptions. The Oracle Data Guard can… Read More
