We have already seen overview of snapshot standby database. But while converting snapshot standby database few things we need to consider. Corruption of log files : As we already know snapshot database accepts redo log files from primary when it is converted to snapshot mode but it does not apply redo log to snapshot standby. […]
All posts by Jagruti Jasleniya
Snapshot Standby Databases: Overview & Architecture
Snapshot Standby Database : We have already seen types of standby database in Data Guard. Oracle Dataguard In this article we are going to see Snapshot Standby Database in deep. In snapshot standby type database stays in a read,write mode that is fully update-able database. Snapshot standby database is created by converting physical standby database […]
Start transport and Application of redo in Data Guard
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 […]
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 […]