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 MoreIn 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 MoreSTEPS 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 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 MoreIn 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 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 MoreIn 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 Overview : – TDB requires that data files be converted to the target platform format. The data file conversion can occur on either the…
Read MoreThe 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 MoreMIGRATION FROM WINDOWS TO LINUX(12.1.0.1 TO 19.0.0) INSTALLED A DATABASE IN WINDOWS AND CHECKED THE PLATFORM NAME AND ENDIAN FORMAT CREATED A USER AND CREATED A TABLE IN…
Read More