Snapshot Standby Database
STEPS TO CREATE SNAPSHOT STANDBY DATABASE PRIMARY: SQL> select name, open_mode, database_role from v$database; NAME OPEN_MODE DATABASE_ROLE ——— ——————– —————- GPROD READ WRITE PRIMARY SQL> STANDBY SQL> select…
Read MoreLogical Standby Database
LOGICAL STANDBY PRIMARY SQL> select name, open_mode, database_role from v$database; NAME OPEN_MODE DATABASE_ROLE ——— ——————– —————- GPROD READ WRITE PRIMARY SQL> STANDBY SQL> select name, open_mode, database_role from v$database;…
Read MoreRedo Transport Attributes required for setting in different protection mode
In this post let us see what attributes we can use under different protection mode. Redo Transport Attributes required for setting different protection mode 1. SYNC, ASYNC , AFFIRM ,…
Read MoreDatabase upgrade 12c to 19c using DBUA
STEPS TO UPGRADE A DATABASE FROM 12C TO 19C DBUA UPGRADE 12C TO 19C TAKE A RMAN FULL BACKUP. STOPPING THE LISTENER RUN THE PREUPGRADE FIXUPS RUN THE PREUPGARDE…
Read MoreOracle Dataguard Protection modes
Oracle Dataguard Protection modes There are three types of Protection Modes in Oracle Dataguard . Maximum Availability It provides highest level of protection of data without compromising availability of database. In…
Read MoreOracle Dataguard Architecture & Background processes
In this post let us understand the Oracle dataguard Architecture and processes with the help of diagrams. Oracle Dataguard Architecture: how data flows when standby is configured LNS process…
Read MoreRMAN Clonning Active duplication
RMAN CLONNING WITH ACTIVEDUPLICATION: Steps in source database: STEP1:verify whether the database is up with pfile or spfile if started with spfile create a pfile from spfile and transfer the…
Read MoreIntroduction to Oracle Dataguard
In the following posts we will discuss about Oracle Dataguard concepts and implementation. Introduction to Oracle Dataguard 1. Oracle Data Guard ensures high availability, data protection,and disaster recovery for enterprise…
Read MoreTransportable Database from Linux to Windows
Transportable Database from Linux to Windows Overview : – TDB requires that data files be converted to the target platform format. The data file conversion can occur on either the…
Read More[Infographic] What Makes Oracle Storage the Best Choice for Oracle Database?
The solutions provided by Oracle Storage, which is co-engineered with Oracle Database, rise above the offerings supplied by traditional storage and help to make the application and database run quicker.…
Read More