Logical Standby database Logical standby database is a feature introduced in Version 9iR2. In this configuration, redo data is first converted into SQL statements and then applied to the standby database. This process is called SQL Apply. This method makes it possible to access the standby database permanently and allows read/write while the replication of … Read more
Oracle Data Guard Configuration ensures high availability, data protection, and disaster recovery for enterprise data. Data Guard provides a comprehensive set of services thatcreate, maintain, manage, and monitor one or more standby databases to enable production Oracle databases to survive disasters and data corruptions. Data Guardmaintains these standby databases as transitionally consistent copies of the … Read more
Creating a Snapshot Standby database The Snapshot Standby database concept was introduced from the 11g Version, which allows the use of a physical standby database in the read-write mode for a short period of time. You can convert a physical standby to a snapshot standby by using either traditional SQL *Plus or using the Data Guard … Read more