In the previous post, we convert Physical Standby to Snapshot Standby . In this post, we can convert Snapshot Standby to Physical Standby. Prerequisites : Snapshot database is already exists Primary Database Snapshot Standby database mgr mgr Step 1 : Check Primary Database Information : SQL> select name,open_mode,database_role from v$database; NAME OPEN_MODE DATABASE_ROLE ——— ——————– […]
Articles Tagged: Snapshot Standby
Converting a Physical Standby Database to a Snapshot Standby Database
In the previous post, we can read about Snapshot Standby Overview. In this post, we can convert to Snapshot Standby. Prerequisites : Physical Standby Database is already created and synchronized with Primary Database . Database Details : Step 1: Check Primary database : [oracle@localhost admin]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Fri […]
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 […]
Convert Physical Standby To Snapshot Standby Database
What is snapshot standby: Snapshot standby is a feature in Oracle 11g that allows doing a read-write operation on the standby database. i. e we can convert the physical standby database to snapshot standby. On that, we can do all types of testing or can be used as a development database (which is an exact […]