In a previous post, we have seen various methods to create Physical Standby Database. Create Standby Database using duplicate database for standby RMAN command In this post, we will see how archive logs are transferred and recovered from a standby database and concern processes for redo transport and recovery. There are main two processes in […]
Monthly Archives: May 2018
Create Physical Standby Database using RMAN Backup Restore
We have seen preparing Primary Database for Dataguard and creating Oracle network service on both sides. In this article, we will see Physical Standby database creation and configuration using RMAN backup and restore. Step 1: Connect to the Primary database and check if recovery area has enough space configured or not. SQL> show parameter db_recovery NAME […]
Create Standby Database using duplicate database for standby RMAN command
We have seen preparing Primary Database for Dataguard and creating Oracle network service on both sides. In this article, we will see Physical Standby creation using RMAN duplicate database for standby command. Note: For this process, we need to copy password file from primary side to standby side under $ORACLE_HOME/dbs Database Detail : Connect to Primary Database […]
Create Standby Database DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE RMAN command.
We have seen preparing Primary Database for Dataguard and creating Oracle network service on both sides. In this article we will see RMAN duplicate target database for standby using active database command to prepare auxiliary database. Note: For this process, we need to copy password file from primary side to standby side under $ORACLE_HOME/dbs Database Detail […]
Oracle Net Configuration for Data Guard
In Previous article we have seen Primary Database Preparation for Data Guard Configuration. Setting the parameter on primary database for physical standby database. In this article we will see Oracle Net Configuration on Primary and Standby. Step 1 : Configure tnsnames.ora file at Production. [oracle@test1 ~]$ cat $ORACLE_HOME/network/admin/tnsnames.ora # tnsnames.ora Network Configuration File: /u01/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora # […]
Setting the parameter on primary database for physical standby database.
In the previous article, we have seen basics about the Architecture of Oracle Dataguard. Oracle Dataguard Architecture We can configure DataGuard with main three stages. Preparing Primary Database. Setting up net services between primary and standby database. Creating Standby Database. In this article, we will set the parameters on the primary database. We will see […]
Automatic Gap Detection and Resolution
Archive Gap: It means set of Archive Logs are not transmitted from Primary Database to Standby Database for some reason. The main reason could be your Network Connectivity. When network connectivity resumes data guard resumes redo data transmission from the Primary to Standby site. Causes of Archive Gaps : Network Disconnection. Standby database outage. I/O issues […]
ORA-01144: File size (4194304 blocks) exceeds maximum of 4194303 blocks
You may get this error while creating a tablespace in your environment. SQL> create tablespace test extent management local datafile size 40 G uniform size 256 K; create tablespace test extent management local datafile size 40 G uniform size 256 K * ERROR at line 1: ORA-01144: File size (5242880 blocks) exceeds maximum of 4194303 […]
Logical Standby Database : SQL Apply Architecture
Oracle DataGuard supports logical and physical standby databases. Logical Standby: When primary database generates any redo entries it is transferred to standby database and then redo data are converted into SQL statements and then those SQL statements are applied to standby database. To read more about Physical Standby Database Physical Standby Database: Redo Apply Architecture […]
Benefits of using Dataguard
In the previous article, we have seen basics about the architecture of Oracle Dataguard. Oracle Dataguard Architecture The main benefit of any DR server is we can say to protect Production Server’s critical data from any natural and unnatural disasters. We keep our Production Server in one place while our DR server can set up […]